Job Description

Role

Oracle Database Administrator

Qualification

B.E. / B. Tech / M. Tech / M.Sc. / MCA in Computers (preferred).

Location

Bengaluru - BCP

Experience

15+ years of experience as an Oracle DBA and architecture. Hands-on experience with Oracle 19c database versions.



#

1. Database Installation & Configuration:

+ Install and configure Oracle and DB2 database software.
+ Perform database upgrades and apply patches.
+ Set up and configure database instances, users, and permissions.

2. Database Design & Implementation:

+ Design, create, and manage database structures (tables, indexes, views, etc.).
+ Implement and optimize database schemas and data models to support applications.

3. Database Performance Monitoring & Tuning:

+ Monitor database performance and implement tuning as necessary (SQL tuning, memory optimization, indexing).
+ Proactively identify and resolve database performance issues.

4. Backup & Recovery:

+ Plan, implement, and test database backup and recovery solutions as per NSDL policy.
+ Ensure disaster recovery procedures are in place and quarterly tested.

5. Security & Compliance:

+ Implement database security measures (encryption, access control, auditing).
+ Ensure compliance with internal and external security policies and regulations.

6. Troubleshooting & Support:

+ Provide support for database-related issues, resolving incidents and problems.
+ Work with developers to optimize queries and troubleshoot database-related application issues.

7. Automation & Scripting:

Automate routine database maintenance tasks using scripts or Oracle tools.Write and maintain scripts for database administration and operations.

8. Capacity Planning & Scaling:

Plan for database growth and scaling to ensure capacity is sufficient for business needs.Evaluate and recommend improvements in database infrastructure.

9. Documentation & Reporting:

Maintain up-to-date documentation on database configurations, procedures, and policies.Generate and provide reports on database performance, incidents, and usage.

Additional Requirements:

Critical databases architecture designing and implementation. Experience with high-availability environments, including RAC, Data Guard, and GoldenGate. Skills: Proficiency in Oracle Database Administration (installation, configuration, and tuning). Strong SQL, PL/SQL, and scripting skills. Familiarity with database security practices, including auditing and encryption. Knowledge of backup, recovery, and disaster recovery solutions (RMAN, Data Pump, etc.). Understanding of database clustering, RAC, replication, and high-availability architectures.

Certifications:

Oracle Certified Professional (OCP) in Oracle Database Administration is highly preferred. * DB2 certification will be an added advantage.