Database Engineer

Joint Commission•Oak Brook, IL

22h•$89,000 - $114,000

About The Position

The Database Engineer designs, develops, and maintains database objects for the enterprise application data model and administers databases in Azure Cloud. The role ensures enterprise database procedures, methodologies, and standards are maintained across application teams; performs database promotions to servers in accordance with service level agreements; resolves production issues to support departmental server uptime goals; and assists with SQL Server upgrades to Enterprise. The position supports Microsoft SQL Server and Azure SQL platforms, database performance and security, backups and disaster recovery, documentation, and data integrity. It partners with application development, data science, analytics, IT, and infrastructure teams to support database-driven applications, data integrations, data pipelines, analytics, and reporting. The engineer also performs production and non-production deployments, participates in a rotating 24x7 on-call schedule, and carries out additional duties as needed to support team and business objectives.

Requirements

Three to five years of hands-on experience working with relational database management systems.
Two or more years of experience with Microsoft Azure services, including Azure SQL, Managed Instances, Azure Automation, Logic Apps, Azure Synapse, and Azure Data Factory.
Two or more years of experience in SQL and T-SQL development, performance tuning, transactional replication, and audit and compliance vulnerability remediation.
Two or more years of experience designing, building, maintaining, optimizing, and troubleshooting data pipelines.
Two or more years of experience across data management disciplines, including data integration, data modeling, data optimization, data quality, archiving, and data purging.
Experience implementing CI/CD pipelines in cloud environments using DevOps tools such as Git and GitHub.
Proficiency with database diagnostic and performance tools, including SQL Profiler and SQL Dynamic Management Views (DMVs).
Experience creating logical and physical data models using industry-standard data modeling tools.
Proficiency with Visual Studio 2022 or later, SQL Server Management Studio (SSMS), and Visual Studio Code.
Availability to participate in a rotating 24x7 on-call schedule to support production systems.

Nice To Haves

Proficiency in two or more programming or scripting languages, such as Python, Java, C#, TypeScript, PowerShell, or Scala.
Knowledge of modern data architecture, including data warehousing, data lakes, and medallion architecture.
Familiarity with enterprise data management processes, including data governance, master data management, and metadata management.
Working knowledge of application development frameworks, such as .NET Framework and Entity Framework.
Demonstrated expertise in database troubleshooting and performance optimization.
Microsoft certifications such as Azure Data Engineer Associate or Azure Data Fundamentals.
Bachelor’s degree in computer science or a related field, or equivalent practical experience.
Strong problem-solving and analytical skills with the ability to troubleshoot complex technical issues.
Effective written and verbal communication and collaboration skills, with the ability to work across IT teams and business stakeholders.

Responsibilities

Design, implement, and maintain database structures aligned with business requirements, application needs, and enterprise data standards.
Monitor database performance, diagnose and resolve issues, and ensure high availability, reliability, and data integrity.
Implement and enforce database security controls to protect sensitive data and prevent unauthorized access or security threats.
Perform routine database backups and develop, test, and maintain disaster recovery and data restoration strategies.
Document database architecture, configurations, operational procedures, and performance metrics.
Partner with application development teams to design, optimize, and support database-driven applications and data integration solutions.
Design, build, and maintain data pipelines for ingesting, processing, and transforming data from multiple sources, and manage data models and schemas for analytics and reporting.
Collaborate with data scientists and analysts to translate business requirements into scalable technical solutions.
Ensure data quality, security, and integrity through validation, testing, and monitoring.
Work with IT and infrastructure teams to manage and monitor database platforms, cloud services, and related data processing frameworks.
Execute production and non-production database deployments and change promotions in accordance with established service level agreements.
Perform database promotions to servers per service level agreements and provide production problem resolution to support uptime goals.
Assist with SQL Server upgrades to Enterprise.
Stay current with database technologies, industry trends, and database and data engineering best practices.
Perform additional duties and responsibilities as required to support team and business objectives.