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