Database Developer

Title:Database Developer
Start Date: 05/01/2025
Position Type: contract
Location: Atlanta, Georgia 30334
Agency Interview Type: Either Web Cam or In Person
Work Arrangement: Hybrid

Short 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.

Complete Description:
Job Summary: 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 support applications with24/7 availability and 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.

Additional Notes:

- The
client is allowing telecommuting for this position for the immediate
future. However, candidates must reside within commuting distance from the
client site as urgent on-site meetings or full-time on-site work could be
required at any time. Candidates outside Atlanta willing to relocate can
apply. No travel reimbursements will be made for on-site meetings.

- Engagement
extensions are possible.

Skills: Skill Required / Desired Amount of Experience Expertise Rating Move Data Modelling Required Years Data Warehousing and Business Intelligence Required Years Microsoft SQL Server, T-SQL, PL/SQL Required Years SQL Server Integration Services Required Years zure Data Factory, Azure Data Studio, Azure Analytics Studio Required Years O Auth2.0, JWT Required Years Python, PySpark, Spark SQL and Azure Cloud Required Years SQL, Procedures. Triggers, Functions Required Years

Agency Interview Type:
Either Web Cam or In Person

Work Arrangement:
Hybrid