Sr. Database Engineer

Sr. Database Engineer

We are seeking a seasoned Sr. Database Engineer with 5+ years of experience to join our team. The ideal candidate will have deep expertise in MySQL, SQL Server, and PostgreSQL, with a proven track record in designing scalable database architectures, developing high-performance queries, and ensuring optimal database security, reliability, and availability. The role also requires hands-on experience in building and managing modern data pipelines using Azure Data Factory and Databricks.

Key Responsibilities

• Design and maintain database schemas based on business and technical requirements.
• Develop and optimize stored procedures, SQL queries, and scripts to enhance application performance.
• Design, build, and maintain end-to-end data pipelines for structured and semi-structured data.
• Reverse-engineer SSIS packages to analyze and improve data flows and transformations.
• Lead data migration projects, including transitions from SSIS/Informatica to cloud-native data pipeline frameworks.
• Develop and manage Azure Data Factory pipelines for data ingestion, orchestration, and scheduling.
• Utilize Databricks for data processing, transformation, and integration with relational databases and data lakes.
• Work with standard data models (e.g., OMOP, PCORnet) to build compliant and efficient solutions.
• Administer SQL Server databases, ensuring high availability, security, and performance.
• Utilize DBaaS solutions (Azure, AWS) for scalable database management.
• Implement and manage backup, restore, and disaster recovery strategies.
• Monitor and troubleshoot database and pipeline performance, resolving bottlenecks proactively.
• Perform DBA tasks including configuration, patching, and migrations.
• Collaborate with development, operations, analytics, and data engineering teams to meet project deadlines.
• Automate the creation, publishing, and scheduling of application reports.

Skills, Knowledge, and Experience

• 5+ years of professional experience in database design, development, and administration.
• Strong expertise in SQL Server and PostgreSQL, with working knowledge of MySQL.
• Advanced SQL scripting and query optimization skills.
• Hands-on experience with data pipelines, including design, orchestration, and monitoring.
• Proficiency in SSIS (SQL Server Integration Services).
• Experience with Azure Data Factory for building and managing ETL/ELT workflows.
• Working experience with Databricks for large-scale data processing and transformation.
• Experience with NoSQL databases (e.g., MongoDB) is a plus.
• Understanding of Data Lake / Lakehouse architectures is an advantage.
• Familiarity with healthcare data standards is a plus.
• Strong problem-solving and analytical skills with high attention to detail.
• Experience working with international clients (USA/Europe) preferred.
• Strong interpersonal, organizational, and communication skills to work effectively in cross-functional, virtual teams.
• Excellent written and verbal communication skills.