All Jobs Vacancy

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

Posted 1 week ago by OMNISTARR Solutions

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.

Rate:
Not specified
Location:
Denver
IR35 Status:
Outside
Remote Status:
Remote
Industry:
Data & Analytics
Seniority Level:
Senior

Take-Home Pay

Not Available

Visit calculators for additional details

Share job