Sr. Database Engineer

NextGen Invent Corporation; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

NextGen Invent Corporation in the United States seeks a seasoned Senior Database Engineer with 5+ years of experience to design scalable database architectures and optimize performance across SQL Server, PostgreSQL, and MySQL. You will lead data pipelines, security, and reliability for enterprise applications.

You will collaborate with cross-functional teams to deliver robust data solutions, migrate data using modern ETL tools, and ensure high availability in cloud and on-prem environments.

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

SQL scripting

Data pipelines

Databricks

Azure Data Factory

NoSQL MongoDB

Education

BE/B Tech / ME/MTech / MCA or Higher

Tools

SSIS

Azure

Informatica

Job description

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 packagesto analyze and improve data flows and transformations.
• Lead data migration projects, including transitions from SSIS/Informatica to cloud-native data pipeline frameworks.
• Utilize Databricksfor 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 Serverdatabases, ensuring high availability, security, and performance.
• Utilize DBaaS solutions (Azure, AWS) for scalable database management.
• Implement and manage backup, restore, and disaster recoverystrategies.
• 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.