The Database Administrator (DBA) will oversee the day-to-day monitoring, troubleshooting and issue resolution for various production, development and test environments. The DBA will be responsible for installing, configuring, tuning Oracle, Microsoft and other database instances as needed. As part of this role, the DBA is required to monitor and troubleshoot all environments. The DBA will a global role in the Enterprise Technologies team.
Essential Duties and Responsibilities include the following:
Experience in installing, configuring and administration of Oracle, Microsoft and other database technologies.
Responsible for Production/Test/Development database maintenance and 24x7 support.
Implement Data Recovery (DR) and High Availability solutions using Oracle Database.
Perform the upgrades on the databases to the current versions.
Perform Database Tuning
Monitor system performance using various tooling.
Responsible for supporting relevant infrastructure pertaining to the global role in the Enterprise Technologies team.
Competency:
To perform the job successfully, an individual should demonstrate the following competencies:
Problem solving / Analytical Mindset
Collaboration / Teamwork
Adaptability / Flexibility
Decision Making / Critical Thinking
Attention to Detail / Prioritizing Tasks
Integrity / Respect
Time Management / Independent
Ownership / Responsibility
Education/Experience:
Bachelor's degree or 8 years of equivalent experience in database administration is required. Preferred major in computer science or computer information systems.
Minimum of 3 years Oracle experience is required.
Minimum of 3 years Microsoft SQL Server experience is required.
Skills and Knowledge:
Excellent relational database design and management skills including the ability to manage clustered environments and write complex SQL procedures & triggers.
Ability to operate and resolve issues within UNIX, Linux and Windows environments including operating system performance, monitoring and patching.
Extensive knowledge in database administration activities such as architecture, database installation, upgrades, migration, patching, cloning, backup & recovery, capacity planning, shell scripting, maintenance plans and documentation.
Experience with implementing and using Recovery Manager (RMAN) database backups/recovery using logical backups (export/import), physical backups (cold/hot).
Skilled in performance tuning using multiple methods of tooling.
Experience in monitoring and application tuning of databases using various diagnostic utilities.
Expertise includes management of schemas, objects, partitioning tables & indexes.
Knowledge with logical and physical database modeling and design tools.
Familiar with network and database communications.