Job Description
Rate: DOE. Contract to hire 90-100k plus benefits
Visa: GC or USC
Location: Monroe, LA
Duration: Long term
Lead in the team effort to design, develop, implement or maintain databases to accommodate user needs. Consult and collaborate with multiple teams to design database solutions, convert logical design into physical database, perform problem determination and resolution, and perform database design process and reviews.
* Bachelor degree or equivalent education and relevant experience required.
* 7 + years related experience. Required skills:
* Both Oracle and SQL Server experience.
* Basic development DBA experience.
* Hands-on development DBA experience in the DWBI space.
* Experience implementing DWBI large scale databases (2-10 TB or larger): ETL, DW Data Staging, DW Marts, and BI Tools/Analytics.
* Experience with both Relational and Dimensional Data Modeling/Star schema and storage requirements based on the size of the data.
* Experience defining and supporting table partitioning/sub partitioning options to support both business query performance and data roll off/archiving.
* Experience implementing and supporting Oracle RAC 11g.
* Experience administering 10g and 11g Enterprise Manager Grid Control environment.
* Experience with PL/SQL and shell scripting.
* Experience creating and reviewing project deliverables.
* Proven SQL tuning skills.
* Desired experience supporting databases on Oracle Exadata.
* Desired experience with Informatica products (PowerCenter, Enterprise Grid, Change Data Capture, Metadata Manager).
Additional Information
Apply today!
Skills Required
- Bachelor degree or equivalent education and relevant experience
- 7+ years related experience
- Both Oracle and SQL Server experience
- Basic development DBA experience
- Hands-on development DBA experience in the DWBI space
- Experience implementing DWBI large scale databases (2-10 TB or larger): ETL, DW Data Staging, DW Marts, BI Tools/Analytics
- Experience with Relational and Dimensional Data Modeling/Star schema
- Experience defining and supporting table partitioning/sub partitioning
- Experience implementing and supporting Oracle RAC 11g
- Experience administering 10g and 11g Enterprise Manager Grid Control environment
- Experience with PL/SQL and shell scripting
- Proven SQL tuning skills
- Experience creating and reviewing project deliverables
- Must be Green Card holder or US Citizen
- Experience supporting databases on Oracle Exadata
- Experience with Informatica products (PowerCenter, Enterprise Grid, Change Data Capture, Metadata Manager)
What We Do
Atria Group LLC, also operating as Atria IT, is a specialized IT staffing and consulting firm headquartered in Plano, Texas. The company provides comprehensive workforce solutions, including staffing, consulting, software development, and training services, specializing in enterprise solutions for small to medium-sized businesses. Their primary objective is to assist these enterprises in maximizing their IT resources to meet evolving technological challenges.
