Database Lead with Java APIs

Database Lead with Java APIs

Job Description:

• 8+ years of experience with AWS Aurora PostgreSQL (RDS) or equivalent relational cloud database platforms, including database design, development, performance tuning to millisecond response, high availability, and replication for OLTP DB application.
• 4+ years of hands‑on experience in building enterprise analytics platforms using Snowflake or equivalent cloud data warehouse technologies.
• Strong experience in cloud migration, database modernization, and distributed database architectures.
• Experience building scalable ELT/ETL pipelines using Python, Talend, AWS EMR, or similar technologies.
• Strong SQL, data modeling, database optimization, and analytical skills.
• Experience with observability and operational tools including Splunk, Dynatrace, ServiceNow, Jira, and Confluence.
• Strong understanding of production support, incident management, monitoring, and root cause analysis.
• Proven leadership experience in mentoring teams, driving technical strategy, and delivering enterprise‑scale solutions.
• Strong experience with API development, integration, and troubleshooting.
• Hands‑on experience with Talend, including job design, pipeline development, orchestration, and production support.
• Understanding of metadata management, data cataloging, and lineage.
• Experience working with ETL/ELT processes and data integration patterns.
• Ability to lead technical discussions with business and technology stakeholders.
• Strong documentation skills, including creating and maintaining data catalog artifacts, technical specifications, and process documentation.

Pi-square technologies is a Michigan (USA) Headquartered Automotive Embedded Engineering Services company, Synergy Partner for major OEMs and Tier 1s and their implementation partners in Automotive Embedded Product Development, Projects, Requirements Analysis, Software Design, Software Implementation, Efficient Build, Release Process, and turnkey software V & V Services. We have more than 20+ years of industry expertise with specialization in the latest cutting‑edge automotive technologies such as Infotainment, connected vehicles, Cyber security, OTA, and Advanced Safety/ Body electronics.