Sr. Database Engineer

Experience: 5+ YearsJob Location: RemoteNo. of Positions: MultipleQualifications: BE/B Tech,ME/MTech, MCA or HigherWork Timings: 1:30 PM IST to 10:30 PM ISTFunctional Area: DatabaseDevelopmentWe 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 ResponsibilitiesDesign 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 Experience5+ 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.Originally posted on Himalayas