Job Description :
Job Description: Oracle Database (Build) Admin
Responsibilities:
The Oracle Database Administrator is a highly skilled technical position that involves intricate knowledge of the Oracle database internals. May also requires on call responsibilities.
Database configuration, tuning, maintenance, patching, and problem diagnosis and resolution are all critical functions that the database administrator performs.

1. Manage all aspects of the physical database including schema’s, DDL, users, security, etc. in development, UAT and production environments
2. Identify and resolve problems occurring in all database environments including performance related issues (i.e. database & SQL tuning
3. Perform database software installs, configurations, patches, and upgrades.
4. Support DBA utilities, reorgs, index builds, etc. and DBA tools, Oracle Enterprise Manager, etc.

Mandatory Technical / Functional Skills:

8+ years of hands-on experience as an Oracle Database Administrator. Working directly with Oracle 10g, 11g and 12c.
Database configuration, tuning, maintenance, patching, and problem diagnosis and resolution are all critical functions that the database administrator performs.

1. Install configure and troubleshoot Oracle and Grid Infrastructure on multi node RAC cluster with 11GR2 (11.2.0.4)
2. Rolling upgrade of Oracle and Grid Infrastructure on multi node RAC cluster with 11gR2 – Precisely from 11.2.0.3 to 11.2.0.4
3. Strong hands-on experience in managing RAC/RAC1 databases.
4. Need to apply the latest patch in a rolling fashion for both the Clusterware home and Database home to confirm compliance to various versions of oracle databases.
5. Install configure and troubleshoot 12c OEM.
6. Expertise on SQL Plan Management (SPM) and DB profiles.
7. Monitor database performance, diagnose performance problems, and tune the database as necessary. Investigate, gather diagnostic data for, and report to Oracle Support Services any critical database errors.
8. Configure and manage memory allocation and adjust as needed. Calculate optimum values for database parameters such as amount of computer memory to be used by database.
9. Troubleshoot and monitor database integrity and performance using EM12c.
10. Hands-on experience with of Oracle Data Guard replication setup, maintenance and troubleshooting for high Availability.
11. Manage all aspects of the physical database including schema’s, DDL, users, security, etc. in development, UAT and production environments
12. Support DBA utilities, reorgs, index builds, etc. and DBA tools, Oracle Enterprise Manager, etc.
13. Uni-directional and Bi-directional replication with Oracle Golden Gate is a plus
14. Migrate a Non -RAC database to RAC with RMAN and Logical backup.
15. Proven ability in UNIX shell scripting, PL/SQL coding and Perl.
16. Experience in Disaster Recovery activities
17. Coordinate the implementation of technical controls to support and enforce defined security policies
18. Experience with IBM AIX, Linux, SUN Solaris UNIX operating systems.
19. Experience with Oracle Streams implementation and troubleshooting
20. Manage all aspects of physical database administration including schema management (DDL), security setup and enforcement, ID creation, installations, upgrades, patching, troubleshooting and instance tuning.
21. Support several application and support teams with numerous on-going projects
22. Maintain over 200+ Oracle production databases along with their corresponding development and test databases.
23. Be part of a large DBA team establishing database standards, monitors and automating support solutions
24. Manage regularly scheduled backups using Oracle’s RMAN and occasionally a database recovery