ORACLE Database Administrator

Responsibilities: 

• Provide support on all the stages of database implementation and/or database related deployments 

• Participate in project meetings, as necessary, to understand application and database requirements 

• Ability to work independently and to resolve complex Oracle issues 

• Run diagnostic tools to identify database performance bottlenecks, and take appropriate corrective actions to improve database performance. Work with development teams to tune SQL queries. 

• Proactive monitoring of the databases 

• Troubleshoot Oracle performance and non-performance related issues either independently or in conjunction with other DBAs 

• Manage backup/recovery for Oracle instances 

• Management of database and resource capacity planning. 

• Implement and enforce database security based upon best practice, SOX regulations, and company policies 

• Installation of new Oracle instances and upgrades 

• Provide after-hours support as required 

• Setting up and resolving issues with Oracle Data Guard environments 

• Experience in task automation 

• Scripting language (ksh, perl) 

Skills/Experience Required: 

• Min. experience of 10+ yr. Oracle DBA required 

• Proficient and experience with Oracle RAC (design, configuration, installations and tuning), including version Oracle 12c. 

• Proficient and experienced with ASM, RMAN and Active Data Guard database technologies. 

• Strong production support experience within a large financial organization & customer service skills 

• Oracle 11G and 12c Database Administration and Management on HP/Solaris and Linux environments 

• Oracle internals 

• Proven track record in supporting large number of db simultaneously 

• Oracle Database Tuning and Performance - usage of statspack, AWR, ADDM, ASH and UNIX native commands 

• Storage considerations for Oracle Database Performance 

• Oracle backup and recovery configuration and procedures 

• Oracle Enterprise Manager/Grid Control for environment standardization 

• Knowledge of enterprise data architecture principles 

• Ability to develop data requirements and configure database parameters accordingly 

• Takes the initiative to act on issues