Key Responsibilities:
Collaborate closely with development teams to design efficient, scalable, and maintainable database schemas
Participate early in application design to ensure optimal data modeling and query patterns
Optimize SQL queries, stored procedures, and data access patterns during development lifecycle
Design and review normalized and denormalized table structures
Define indexing strategies and data partitioning aligned with application use cases
Define and enforce database coding standards and performance guidelines
Analyze query execution plans and performance issues identified during development, testing, and client UAT and production
Ensuring compliance with industry standards and regulatory requirements
Contribute to database security design (roles, privileges, masking strategies)
Actively participate in backup and restore process design
Analyze Oracle AWR reports
Extensive experience with Oracle Database 19c
Strong experience in data modeling and schema design for complex applications
Proficient in optimizing complex queries and store procedures, optimized indexing
Experience analyzing execution plans and tuning queries in development phases, or to unlock production incidents
Hands-on experience working with developers in Agile environments
Database design skills
Knowledge of Oracle Recovery Manager (RMAN) for backup –understanding of production database concepts (HA, backup, recovery) as context for design decisions
Understanding of database security and practices
Proficiency in shell scripting
Proficiency in Docker
Familiarity with Linux
Experience with Oracle SQL Developer
Knowledge of cloud database solutions such as Oracle cloud, Amazon RDS for Oracle, MS Azure
What you bring:
Added bonus:
Java knowledge
Report generation
Basic understanding of Kubernetes
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.