Database Engineer

NGI Ventures; United States; Remote; USD 120,000 - 160,000; Full time

Job summary

NGI Ventures is seeking a seasoned Sr. Database Engineer with 5+ years of experience to join a remote team.

The role focuses on MySQL, SQL Server, and PostgreSQL, with responsibilities spanning schema design, query optimization, data pipeline development, and data migration to cloud-native frameworks. The candidate will work with Databricks, DL/Lakehouse architectures, and healthcare data standards while supporting international clients (USA/Europe).

Qualifications

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

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

SQL Server

PostgreSQL

MySQL

SSIS

Azure Data Factory

Databricks

MongoDB

Data Lake / Lakehouse

ETL/ELT

Data Pipelines

Cloud DBaaS

Education

BE/B Tech

ME/MTech

MCA or Higher

Tools

Azure

AWS

SSIS

Informatica

Job description

About the job 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: Database Development

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.