
ESaaS - DBA - Sys Admin
Zensar · India
- IT Services & Consulting
- 10,001+ employees
- Pune, Maharashtra
Strong hiring record · median 10 days open
- First seen
- 29 September 2026
- Reposted
- 3× since September 2026
- Last checked
- Today · still on the employer's board
All reasons
- This role has been posted 4 times
In its favour
- Posted today
- Still listed on the employer's own board
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
What you bring
- 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
Added bonus
- Java knowledge
- Report generation
- Basic understanding of Kubernetes
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
What you bring
- 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
Added bonus
- Java knowledge
- Report generation
- Basic understanding of Kubernetes
Skills
- SQL
- Oracle Database
- Shell
- Docker
- Linux
- Oracle Cloud
- RDS
- Azure
- Java
- Kubernetes
More jobs at Zensar
All 109Similar roles
- ESaaS - SFDC - MuleSoft Integration ArchitectZensar · India1mo ago
- ESaaS - Oracle - Functional - Cloud CRMZensar · Pune, Maharashtra, Indiatoday
- ESaaS - SFDC - Business Function Analysis & Business ArchitectureZensar Technologies · India10d ago
- ESaaS - DBA - Sys AdminZensar Technologies · India22d ago
- ESaaS - Oracle - DBA - AppsZensar · India24d ago