Database Administrator

Job Duties :

Maintain database security compliance and best practices. Support Multi node Real Application Cluster Environment. Support database on platforms RHEL/SOLARIS. Setup Oracle database security environment. Manage databases running on Oracle RAC and Standalone Environments. Responsible for migration of oracle databases from Solaris to Oracle Exadata. Support Golden Gate and Dataguard Management in replicating data. Implement and configure Dataguard (Active Dataguard) Physical standby and logical standby and Oracle database replication using GoldenGate. Apply Patches on Standalone, Standby databases based on the requirements and Bugs. Maintain production databases with optimal performance. Perform proactive and reactive performance analysis of production databases. Work independently and collaboratively with development support teams to resolve complex issues. Work with Architectural team to ensure performance, availability, integrity and security for all databases. Develop UNIX Shell Scripts for daily and weekly backup jobs. Manage memory structure and storage allocation. Resolve issues with Golden Gate components such as EXTRACT, REPLICAT, TRAIL FILES and Tranlog options. Create user accounts, roles and privileges for Database operations and security maintenance. Optimize and tune SQL queries using TRACE FILE, TKPROF and EXPLAIN PLAN. Use Data Pump and RMAN as the backup utilities for export and import. Implement scripts for backup of databases and maintenance of archive logs for databases. Monitor databases activities, collect database statistics, create users, groups and profiles for users.

Work location:

various unanticipated work locations throughout the United States; relocation may be required. Must be willing to relocate.

Minimum Requirements:

Education:

Master – Computer Science