DOE Database Developer ()

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 :

Good to Have :

Qualifications :

Additional Notes :

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