Post Job Free
Sign in

SQL DBA - Mostly Remote

Company:
msysinc
Location:
Dover, DE
Posted:
August 14, 2024
Apply

Description:

Title: SQL DBA - Mostly Remote

Location: Dover, DE, United States

Length: Long term

Restriction: W2 or C2C

Description:

Interview: Online Very Long term contract Usually the project goes for 4+ years with this customer *** 37.5 hours per week *** *** Mostly Remote *** 1 inperson meeting a month in Dover, Delaware

*** Prefers candidates to be in Eastern Time Zone ***

Job Description:

The candidate will provide expert level guidance in data conversion, data mapping and analysis. The candidate will be responsible for extract, transformation and load (ETL) of data from multiple data sources into a new integrated data system currently being implemented. The candidate will demonstrate expert data cleaning, management and analysis skills. This hybrid remote position requires regular work hours 37.5 hours/week 8:00 am – 4:30 pm with occasional flexibility for regularly scheduled meetings (no overtime). This project is expected to run until completion of the database implementation project (currently expected June 30th, 2025). Upon completion of the project and with exemplary work performance, there may be the opportunity to extend the work assignment for other data modernization activities.

Essential Functions:

Highly skilled at data/database conversions including data mapping, extract, transformation and load (ETL) of data following technical specifications documents and in accordance with State of Delaware policies

Experience and knowledge in supporting application system development life cycle

Proficiency in developing and maintaining data models, data warehouses, data dictionaries/codebooks and data integration processes

Strong analytical and problem solving skills to identify and resolve data related issues

Expertise in iterative troubleshooting of errors and data cleaning issues

High level of accuracy and attention to detail in all data handling activities

Knowledgeable in data analysis and database management techniques

Assist in coordinating software releases

Execution of all responsibilities with little direct supervision of Team Lead

Determine time estimates and schedule for own work and resolve issues in a timely manner

Ability to manage multiple tasks and projects simultaneously, ensuring deadlines and quality standards are met

Communicate accurate and useful status updates

1Manage and report time spent on all work activities

Excellent verbal and written communication skills for effective documentation and collaboration with team members

Ability to communicate with both technical and non technical audiences

Anticipate and resolve issues specific to the project and team

Job requirements:

5 or more years of experience in database administration, including at least 2 years at a Database Administrator 2 level or equivalent.

Strong experience in writing and optimizing Structured Query Language (SQL) queries, and using .NET, C#, or other programming languages for data manipulation.

Proficiency in SQL Server Integration Services (SSIS) and other Extract, Transform, Load (ETL) tools for data conversion projects

Extensive experience managing and maintaining SQL Server, MySQL, or other database management systems

Understanding of data privacy laws and regulations, such as the Health Insurance Portability and Accountability Act (HIPAA)

One or more of the following:

Relevant certifications such as Microsoft Certified: Azure Data Engineer Associate, Certified Data Management Professional (CDMP), or certifications in specific ETL tools

Experience with cloud data platforms (e.g., Amazon Web Services (AWS), Azure, Google Cloud)

Experience with Agile methodologies or other project management frameworks

Knowledge of the essential functions of public health

Knowledge of public health informatics in including methods of collecting, compiling and presenting health data

Knowledge of public health surveillance including collecting, analyzing and interpreting heath data

Knowledge of public health data modernization including enhancing or replacing legacy data systems

Apply