12 Nov
|
Zensar Technologies
|
Chennai
12 Nov
Zensar Technologies
Chennai
Core Database Administration (Oracle & PostgreSQL)
Manage, configure, and maintain high-availability Oracle (19c) and PostgreSQL settings.
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.
Cloud Infrastructure (GCP)
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.
Generative AI & Innovation
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.
📌 Senior Database Engineer Cloud & Ai Chennai
🏢 Zensar Technologies
📍 Chennai