Job Description

We are looking for an experienced Oracle Database Administrator (DBA). Person should have at least 10 years of experience in managing Oracle databases. The Oracle DBA is responsible for the day-to-day management, performance, security, availability, and reliability of MTSP Oracle database environments.

Responsibilities

• Manage nonproduction databases (dev and UAT) which are 30TB+ in size.

• Create and maintain database instances, tablespaces, schemas, tables, indexes, and views

• Installation of HPS patches in non-production environment. Understand the dependencies and create documentation.
• Debug performance issues and work with HPS to fix them.
• Troubleshoot database issues and perform root-cause analysis.
• Knowledge of database partitioning.
• Importing DB tables from dmp files
• AWR analysis
• Performance improvement analysis

Skills

• Good knowledge of writing SQL queries.
• Experience of deployment and support of Azure services
• Experience in the Linux environment and a good understanding of its fundamentals and internals: filesystems and modern memory management, threads and processes, the user/kernel-space divide, etc.
• Oracle RMAN Backup & Recovery
• Work with enterprise team to copy and restore production database to non-production environment.
• Good to have Oracle Certified Professional (OCP) certification.

Special needs – Majority of the work will be during usual business hours on weekdays. However additional effort may be required during data maintenance activities which will be done during non-business hours. Also, DBA will need to support monthly production deployment which is done on a weekend. Working during weekend or off hours can be compensated against the normal working hours.

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.