Oracle DBA

The Oracle DBA will provide support in transitioning clusters over to a cloud platform.

Job Duties:

• Assessment of database architecture with recommended strategies, refinements, modifications, and support according to industry standards.
• Assessment and recommendation of Oracle database environments for upgrades and maintenance plans.
• Lead the database upgrade process based on the major version release schedule.
• Recommendations for updates to the detailed design specifications for storage and network configurations required to support several database environments
• Lead in installation/upgrade, mentoring and configuration of Oracle Database, Real Application Cluster Software, Active Data Guard and Advanced Compression for several applications
• Install, Configure and administer Oracle Enterprise Manager.
• Monitor database activities such as Backup, Error Logs, Space, Object, Performance, User and Session monitoring for proper capacity and availability.
• Provide non-production and production support and Lead in trouble shooting production issues and application performance issues.
• Review and assess the backup and recovery strategy currently implement for production and non-production databases and come up with recommendations and Lead in implementing the recommendations.
• Work with a development team and leading in tuning applications for better performance.

Candidate Requirements:

• Extensive work experience in Oracle RAC Database Administration.
• Comprehensive background in administration of Oracle Enterprise Manager and physical DBA support in a complex environment.
• Database skills must include Installation/Patching/Upgrade of the OEM, database software on Linux platform, RMAN backup and recovery of the Oracle Database, performance tuning, migration, data guard replication, configuration and security administration.
• Experience in setting up Active Data guard.
• Good understanding of the Linux/UNIX environments.
• Work experience with OLTP, OLAP, Staging, and Data warehouse configuration.
• Strong fundamentals in all aspects of DBA responsibilities.
• Excellent communication skills, customer service and client management skills.
• Experience managing Databases in the Cloud is a strong plus.

Required Experience:

• 6 years experience as a Oracle database administrator.
• 5 years of experience as an Oracle database administrator using AIX (version 7.x or higher) operating system environment.
• 6 years of experience in setting up/building and configuring Oracle RAC.
• 2 year of experience in Active Data Guard (ADG) and data guard broker.
• 8 years experience in database performance tuning and application SQL tuning out of which at least 3 years of experience in Oracle RAC environment.
• 7 plus years experience and knowledge in supporting applications system development life cycle.
• 7 plus years of experience in performing database upgrade/patches out of which 3 years of experience in Oracle or RAC (primarily in place upgrade/patches Release updates).
• 3 years experience in data modeling and application database design.
• 3 years experience in writing PL/SQL code.
• 3 years experience working within an Linux operating system environment or higher.
• Must be able to use Microsoft Project, Word, PowerPoint and other Microsoft office tool suite.