Database developer (MySQL, Python, SSIS)

Job Title: Database developer

Projected Start Date: 05-01-2025

Projected End Date: 04-30-2026

W2 Rate: 54/Hr

End client: Georgia Department of Education /GaDOE

Position Type :Contract

Location: Atlanta, GA

Branch

Primary Skills

MySQL,Python

Notes

Required Skills

Job Description

The ideal candidate must demonstrate in-depth knowledge and understanding of database concepts and be experienced in writing SQL and T-SQL. They need to have experience handling large volumes of data in Oracle, SQL Server, and Azure SQL platforms.

Essential Duties And Responsibilities

• Collaborate with internal customers, prospects, and stakeholders to understand and translate business use cases and requirements into data analysis and data mapping.
• Develop data integration routines that involve moving, cleansing, and transforming large amounts of data between multiple systems.
• Identify data sources, provide data flow diagrams, and document source-to-target mapping and processes.
• Work with the Data Architect to recommend optimal data models for data ingestion and collaborate with the BI developer for analytic reports.
• Provide technical enablement to team members developing database applications on a cloud platform.
• Lead small teams of 1-2 junior developers in data integration efforts, utilizing ETL design patterns, error handling, and configurations.
• Design, implement, and maintain database objects (tables, views, indexes, etc.) and database security.
• Utilize Azure database tools and technologies, including Azure Data Studio and Azure Analytics Studio,to develop, maintain, and optimize database applications and solutions1.
• Collaborate with data stewards, data owners, and domain experts to adopt best practices in reporting and analysis, ensuring data integrity, test design, validation, and documentation.
• Optimize batch processing through parallelization and performance tuning to maintain data warehouse performance.
• Establish processes for governing the identification, collection, and use of educational metadata to ensure accuracy and validity in business intelligence environments.
• Ensure data quality through audit controls, proactive monitoring, and data cleansing techniques.
• Troubleshoot performance and reliability issues and investigate anomalous behavior in the Azure environment.
• Perform scheduled data process integrity checks, deployments, and coordinate releases.
• Utilize source version control software like GitHub and CICD pipelines.
• Provide on-call support after hours as needed.
  
  

Requirements

• 7 years of experience in data warehousing and business intelligence.
• 5 years in BI development leveraging Microsoft SQL Server, with expertise in T-SQL.
• 5 years in SSIS and use of stored procedures.
• 3-5 years in Azure Data Factory, SQL VMs, and ETL development.
• Experience in ingesting and aggregating data from internal and external sources to build a data lake.
• Strong understanding of data modeling (conceptual, logical, and physical model design) and experience with operational data stores, enterprise data warehouses, and data marts.
• Deep understanding of relational database design concepts and SQL programming.
• Experience in guiding and mentoring developers with less experience.
• Strong analytical, conceptual, and problem-solving abilities.
• Experience with business intelligence and data warehousing design principles and industry best practices.
  
  

Good To Have

• 1-2 years in Azure Data Warehouse (Synapse).
• 1-2 years of experience utilizing Python, PySpark, and SparkSQL on Azure Cloud.
  
  

Qualifications

• Bachelor's degree from an accredited college or university with coursework in computer science or management information systems AND 5 years of related experience.
  
  

I am receiving alot of submissions, kindly mention the subject as [Apply_Database Developer_Your Name] for an email to john@sidramtech.com along with the following details.

[Note: This is exclusive W2 requisition, with max rate at $54/hr. on W2 for Hybrid at Atlanta, GA]

Full Name

Phone Number:

Visa Status

Current Address (City, State, Zip Code):