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