Sr. Database Engineer

Experience: 5+ Years

Job Location: Remote

No. of Positions: Multiple

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

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

Functional Area: DatabaseDevelopment

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.
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.

- 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.

Originally posted on Himalayas