Database Engineer

The Joint Commission
Villa Park, IL, United States
1 day ago
Apply on www.techcareers.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
2 years minimum
Compensation
$89,000.0 - $114,000.0
Working hours
Shift work

Tech stack

Java (Programming Language) .NET Framework Microsoft Azure Backup Devices C Sharp (Programming Language) Computer Programming Databases Continuous Delivery Data Architecture Information Engineering Data Governance Data Integration
+43 more
Data Integrity Data Warehousing Relational Databases Database Security Database Storage Structures DevOps Disaster Recovery Entity Framework Github Python (Programming Language) Meta-Data Management Microsoft Visual Studio Microsoft SQL Server SQL Azure Operational Databases Performance Tuning Windows PowerShell Cloud Services Sqlprofiler Software Engineering SQL Databases Transact-SQL TypeScript Software Vulnerability Management Enterprise Data Management Azure Automation Scripting Enterprise Software Applications Cloud Platform System Microsoft Power Automate Azure Data Factory System Availability Software Troubleshooting Database Performance Data Lakes Information Technology Performance Monitor Integration Frameworks Data Management SQL Server Management Studio (SSMS) Azure Synapse Analytics Data Pipelines Database Tools and Utilities

Job description

  • Demonstrate strong expertise in relational database technologies, including T-SQL coding, and hands-on experience supporting Microsoft SQL Server and Azure SQL platforms.
  • Design, implement, and maintain database structures that align with business requirements, application needs, and enterprise data standards.
  • Proactively 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.
  • Create and maintain comprehensive documentation covering database architecture, configurations, operational procedures, and performance metrics.
  • Apply strong analytical and troubleshooting skills to efficiently identify, isolate, and resolve database-related issues.
  • Partner closely with application development teams to design, optimize, and support database-driven applications and data integration solutions.
  • Design, build, and maintain robust data pipelines to ingest, process, and transform data from multiple sources, while managing data models and schemas that support analytics and reporting.
  • Collaborate with data scientists and analysts to understand business requirements and translate them into scalable, high-quality technical solutions.
  • Ensure data quality, security, and integrity through effective validation, testing, and monitoring practices.
  • Work with IT and infrastructure teams to manage and monitor database platforms, cloud services, and related data processing frameworks.
  • Demonstrate a solid understanding of relational database concepts, data modeling principles, and best practices in database management.
  • Execute production and non-production database deployments and change promotions in accordance with established service level agreements (SLAs).
  • Stay current with emerging database technologies, industry trends, and best practices in database and data engineering.
  • Perform additional duties and responsibilities as required to support team and business objectives.

Requirements

A self-motivated individual responsible for database object design, development, maintenance for the enterprise application data model and database administration in the Azure Cloud. Ensure enterprise database procedures, methodologies and standards are maintained across the application teams. Performs database promotions to all servers per Service Level Agreements. Provides necessary production problem resolution to support departmental server up time goals. Assists with SQL Server upgrades to Enterprise., * 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 in 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 development and database tools such as Visual Studio 2022 or later, SQL Server Management Studio (SSMS), and Visual Studio Code.
  • Must be available to participate in a rotating 24x7 on-call schedule to support production systems.

Preferred

  • 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 are preferred.
  • 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.

Benefits & conditions

We offer a comprehensive benefit package. For a complete overview of our benefits package, please visit our Joint Commission Career Page (https://www.jointcommission.org/careers/#434f5b531a144a35906939ce76ce893c_cf7b457e1e9842329663d569f5c839cb)

We are an Equal Opportunity Employer. All qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other status protected by law.

Joint Commission offers a comprehensive benefits package. For an overview of our benefits package, please visit our Joint Commission Career Page (https://www.jointcommission.org/en-us/careers#434f5b531a144a35906939ce76ce893c_cf7b457e1e9842329663d569f5c839cb)

This job description is intended to describe the general nature and level of work performed by an employee assigned to this position. The description is not an exhaustive list of all duties, responsibilities, knowledge, skills and abilities, and working conditions associated with this position. All requirements are subject to possible modification due to business needs and/or reasonable accommodations for individuals with disabilities.

MIN

$89,000.00

MAX

$114,000.00

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.techcareers.com
Prepare application

Good distractions

Loading talks and stories from around this role…