Senior Database Engineer (cloud & AI)

Job Title

Core Database Administration (Oracle & PostgreSQL)

Cloud Infrastructure (GCP)

Generative AI & Innovation

Job Description

Manage, configure, and maintain high-availability Oracle (19c) and PostgreSQL environments.

Optimize database performance through advanced indexing, query tuning, and partitioning strategies—critical for high-frequency credit card transaction processing.

Execute seamless data migrations from on-premise Oracle instances to GCP Cloud SQL or AlloyDB.

Implement rigorous security protocols, including encryption at rest/transit and fine-grained access control (FGAC) to ensure PCI-DSS compliance.

Deploy and manage scalable database clusters using GCP Cloud SQL, Spanner, or BigTable.

Utilize Terraform or Infrastructure as Code (IaC) to automate database provisioning and scaling.

Monitor system health using GCP Cloud Monitoring and Logging, ensuring 99.99% uptime for payment gateways.

Collaborate with Data Science teams to implement Vector Search (via pgvector) for similarity searches in fraud detection.

Develop and maintain LLM-driven automation scripts to convert natural language into optimized SQL queries.

Explore and implement GenAI tools for automated database documentation, synthetic data generation for testing, and proactive anomaly detection.

Responsibilities

Required Technical Profile

Experience: 4–6 years of hands-on experience in Database Administration or Engineering.

Legacy Mastery: Deep expertise in Oracle DBA (RAC, Data Guard, RMAN, Performance Tuning).

Modern Data: Proven experience with PostgreSQL in a production environment.

Cloud Proficiency: Practical experience with Google Cloud Platform (GCP); certifications (Professional Cloud Database Engineer) are a plus.

GenAI Knowledge: Understanding of Vector Databases, Embeddings, and how to integrate LLMs (like Gemini or GPT) with structured data.

Scripting: Strong proficiency in Python (for AI/Automation) and Shell scripting.

Qualifications

Soft Skills & Industry Knowledge

Financial Domain: Understanding of the credit card lifecycle (authorization, clearing, settlement) and security standards like PCI-DSS.

Problem Solver: Ability to troubleshoot complex performance bottlenecks in a high-concurrency environment.

Communication: Able to bridge the gap between traditional infrastructure teams and modern AI/Cloud developers.

About Us

At Zensar, we're "experience-led everything". We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus. Part of the $4.8 billion RPG Group, we're a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself. We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.

Job Info

Job Identification 145690

Locations INNOV8, Millenia Business Park, Chennai, Tamil Nadu, 600096, IN

Work from Anywhere Yes

Minimum Experience (In Years) 6

Maximum Experience (In Years) 9