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


OMNISTARR Solutions
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- AWS Aurora PostgreSQL
- Snowflake
- Java APIs
- Talend
- SQL
- Python
- AWS RDS
- ETL/ELT
- Database Tuning
- Replication
- OLTP
- AWS EMR
- Cloud Migration
Summary
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.
- Dice Id: 91159609
- Position Id: 9136013
- Posted 54 minutes ago
Company Info
At OMNISTAR, we believe in the power of human potential. With over two decades of experience in the talent acquisition industry, we have honed our skills to help companies navigate through complex challenges and achieve their goals. We firmly believe in the pillars of efficiency, quality, and reliability. With every placement, we strive to exceed expectations.
OMNISTAR’s mission is to provide onshore, offshore, and nearshore talent solutions across multiple industries, such as finance, healthcare, life sciences, retail, banking & manufacturing. We aim to be a comprehensive partner for our clients, understanding their unique needs and offering diverse expertise and tailored services.
OMNISTAR’s vision is to leverage its talent solutions to help its clients thrive in today’s competitive landscape and achieve a sustainable, clean-energy future. We aspire to be a global leader in the talent solutions industry, delivering excellence and innovation.
