Job Title: Database Administrator
Location: Raleigh NC (Hybrid In-Person Interview Required)
Duration: 12 Months
Job Description:
We are seeking a skilled and detail-oriented Database Administrator (DBA) for a 12-month hybrid contract position based in Raleigh NC. The successful candidate will have extensive experience in managing relational databases specifically DB2 and SQL Server and will play a key role in data modeling ETL processes and data quality assurance.
Key Responsibilities:
- Design and maintain logical and physical data models to ensure data accuracy consistency and integrity.
- Implement effective data indexing strategies to optimize query performance.
- Work with DB2 and SQL Server database management systems to support development testing and production environments.
- Participate in ETL processes including data extraction transformation and loading from various sources.
- Use data cleansing tools to identify and resolve data quality issues.
- Develop document and execute test cases to validate data integrity and transformations.
- Analyze and troubleshoot data issues and provide resolutions efficiently.
- Collaborate with cross-functional teams to communicate database solutions and requirements clearly to technical and non-technical stakeholders.
- Handle multiple projects simultaneously while meeting tight deadlines.
- Apply analytical skills to dissect complex problems and derive actionable insights from large datasets.
Required Skills:
- Strong understanding of data structures schemas and relational databases.
- Experience creating logical and physical data models.
- Proficiency in DB2 and SQL Server DBMS.
- Knowledge of ETL concepts and tools.
- Experience using at least one data cleansing tool (e.g. Informatica Data Quality Trifacta Talend etc..
- Ability to create and execute test cases for data validation.
- Proven problem-solving and data analysis skills.
- Strong verbal and written communication skills.
- Ability to manage multiple tasks and meet deadlines in a fast-paced environment.