Oracle Database Administrator

5 - 7 Years
- 1 Opening
- Trivandrum

**Role description**:
Job Loc: Bangalore,Trivandrum,Hyderabad

Notice Period: Immediate

Exp : 5-11 Years

**Key Responsibilities**:
**Database Administration**
- Install, configure, and upgrade Oracle database software (**11g**, **12c**, **19c**, or later).
- Manage database instances, schemas, tablespaces, and objects such as tables, indexes, and views.
- Plan and execute seamless database migrations and upgrades.
- Monitor and improve database performance using tools like **Oracle Enterprise Manager (OEM)** and **SQL*Plus**.
- Optimize SQL queries, indexes, and system configurations to enhance performance.
- Configure and maintain high-availability solutions, including **Oracle RAC** and **Data Guard**.
- Utilize **Oracle GoldenGate** for replication and data integration tasks.
- Implement and test robust backup and recovery strategies using **RMAN**.

**Performance and Security**
- Diagnose and resolve database issues related to connectivity, performance, and data integrity.
- Identify and resolve bottlenecks related to storage, memory, and CPU utilization.
- Implement database security measures, including access controls, encryption, and auditing.
- Ensure compliance with organizational security policies and regulatory requirements.

**Collaboration and Automation**
- Collaborate with developers to design and optimize database structures and PL/SQL code.
- Support the development of stored procedures, triggers, and views.
- Automate database maintenance tasks using shell scripts or tools like **Ansible**.
- Conduct disaster recovery tests to validate recovery objectives.
- Maintain detailed documentation of configurations, processes, and best practices.
- Generate regular reports on database health, performance, and capacity planning.

**Qualifications and Skills**:
**Required Skills**:

- Expertise in **Oracle Database Administration**, including **RAC**, **ASM**, and **Data Guard**.
- Proficiency in tools like **RMAN**, **OEM**, and **SQL*Plus**.
- Strong knowledge of **PL/SQL programming** and SQL query optimization.
- Experience with backup, recovery, and disaster recovery planning.
- Familiarity with partitioning, materialized views, and indexing strategies.
- Knowledge of database security practices, including encryption and auditing.

**Preferred Skills**
- Experience with **Oracle Exadata** and **Oracle Cloud Infrastructure (OCI)**.
- Proficiency in scripting languages like **Bash** or **Python** for automation.
- Understanding of Unix/Linux operating systems and shell scripting.

**Education and Experience**:

- Bachelor’s degree in **Computer Science**, **Information Technology**, or a related field.
- **5-11 years** of experience as an Oracle DBA in a production environment.
- Relevant certifications, such as **Oracle Database Administrator Certified Professional**, are highly desirabl

**Skills**:
Mandate skills : Oracle DBA, RAC,ASM,Dataguard

Good to have : Oracle Exadata,oracle cloud infrastructure,Bash,Python

**About UST**:
UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world’s best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients’ organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact—touching billions of lives in the process.