Back to Jobs
Recently postedTechnology

Database Technical Lead – AWS Aurora PostgreSQL, Snowflake & Java APIs

OMNISTARR SolutionsDenver, CO🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationDenver, CO, United States
Stakeholder ManagementSQLAWSETLSnowflakeSplunkConfluenceEMRJavaPythonRoot Cause AnalysisSchedulingServiceNowPostgreSQLJiraCI/CD

Job description

  • ain, and optimize scalable ETL/ELT pipelines using Talend, Python, AWS EMR, and related technologies.

  • Develop, integrate, troubleshoot, and optimize enterprise APIs, including Java-based APIs.

  • Perform advanced SQL development, data modeling, query optimization, and performance troubleshooting.

  • Support Talend job design, pipeline orchestration, scheduling, monitoring, and production troubleshooting.

  • Implement metadata management, data cataloging, and data lineage practices.

  • Monitor and resolve production issues using Splunk, Dynatrace, ServiceNow, and other operational tools.

  • Lead root cause analysis, incident resolution, and continuous performance improvements.

  • Mentor developers, conduct technical reviews, and drive database architecture and engineering best practices.

  • Collaborate with business, application development, cloud infrastructure, and DevOps teams.

Required Technical Skills

  • 14+ years of overall IT experience, including database engineering and technical leadership.

  • 8+ years of experience with AWS Aurora PostgreSQL/RDS or comparable relational cloud database platforms.

  • 4+ years of hands-on experience with Snowflake or equivalent enterprise cloud data warehousing technologies.

  • Strong expertise in PostgreSQL, advanced SQL, database design, data modeling, and performance optimization.

  • Extensive experience with OLTP systems, high availability, replication, and cloud database modernization.

  • Strong experience with API development, integrations, and troubleshooting, including Java APIs.

  • Hands-on expertise in Talend ETL, job design, orchestration, and production support.

  • Experience building scalable ETL/ELT pipelines using Python, AWS EMR, Talend, or equivalent tools.

  • Strong understanding of metadata management, data catalogs, and data lineage.

  • Experience supporting production systems, incident management, monitoring, and root cause analysis.

  • Familiarity with Splunk, Dynatrace, ServiceNow, Jira, and Confluence.

  • Proven technical leadership, mentoring, stakeholder management, and communication skills.

Preferred Qualifications

  • AWS and/or Snowflake certifications.

  • Experience with DevOps, CI/CD, and cloud-native architectures.

  • Experience supporting high-volume, mission-critical enterprise applications.

  • Experience with distributed database systems and large-scale modernization projects.

Candidate Submission Details

Interested candidates are requested to share their updated resumes along with:

  • Full Name:

  • Current Location:

  • Total IT Experience:

  • AWS Aurora PostgreSQL / RDS Experience:

  • Snowflake Experience:

  • Java API Development / Integration Experience:

  • Talend Experience:

  • Cloud Migration / Database Modernization Experience:

  • Work Authorization: & GC

  • Expected C2C Rate:

  • Availability / Notice Period:

  • Willingness to work in Denver, CO:

Please apply only if you have strong hands-on cloud database engineering, performance tuning, API integration, and technical leadership experience.

Similar jobs