Sr. Database Engineer

Experience: 5+ Years

Job Location: Remote

No. of Positions: Multiple

Qualifications: BE/B Tech, ME/MTech, BCA/MCA or Higher

Work Timings: 1:30 PM IST to 10:30 PM IST

Functional Area: Database Development

We are seeking a seasoned Senior Database / Data Engineer (Azure) with 5+ years of experience to join our team. The ideal candidate will have strong expertise in relational databases along with hands-on experience in cloud-based data engineering. This role involves designing scalable database architectures, building reliable data pipelines, optimizing performance, and ensuring data security, availability, and quality across Azure-based platforms.

Key Responsibilities

• Design and maintain relational database schemas based on business and technical requirements.
• Develop, optimize, and maintain SQL queries, stored procedures, and scripts to improve performance and scalability.
• Design, build, and maintain end-to-end data pipelines for structured and semi-structured data.
• Develop and manage Azure Data Factory (ADF) pipelines for data ingestion, orchestration, scheduling, and monitoring.
• Ensure data quality, reliability, and observability across databases and pipelines.
• Monitor and troubleshoot database and pipeline performance; proactively resolve bottlenecks.
• Administer databases (SQL Server / PostgreSQL), ensuring high availability, security, and performance.
• Implement and manage backup, restore, and disaster recovery strategies.
• Perform core DBA activities including configuration, patching, migrations, and access controls.
• Lead or support modernization initiatives, including migration from SSIS or other legacy ETL tools to cloud-native solutions.
• Utilize DBaaS solutions on Azure (AWS exposure is a plus).
• Work with Databricks for data processing, transformations, and integration with relational databases and data lakes (nice to have).
• Collaborate with application, analytics, and data engineering teams to meet project timelines.
• Assist in automating report generation, publishing, and scheduling where required.

Skills, Knowledge, and Experience

Must-Have

• 5+ years of professional experience in database development and data engineering.
• Strong expertise in SQL Server or PostgreSQL (working knowledge of MySQL is a plus).
• Advanced SQL scripting and query optimization skills.
• Hands-on experience with data pipelines, including:
• Data ingestion from multiple sources
• Orchestration and dependency management
• Monitoring, error handling, and performance tuning
• Strong practical experience with Azure Data Factory (ADF), including:
• Pipeline design and orchestration
• Linked services, datasets, and triggers
• Parameterization and scheduling
• Solid understanding of database security, reliability, availability, and performance optimization.
• Strong problem-solving and analytical skills with attention to detail.
• Excellent written and verbal communication skills.

Good-to-Have

• Experience with Databricks, including Spark-based data transformations.
• Exposure to SSIS and/or Informatica.
• Experience with NoSQL databases (e.g., MongoDB).
• Understanding of Data Lake / Lakehouse architectures.
• Familiarity with healthcare data standards such as OMOP and PCORnet.
• Experience working with international clients (USA / Europe).