Database Administrator

Fundamental Mission:

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.
• General knowledge of infrastructure fundamentals.
• Ability to provide after-hours support.

Technical Skills:

• Database – Oracle and Microsoft SQL Server
• Operating Systems – AIX, Linux and Windows
• Languages/Tools - SQL, PL/SQL, pgSQL, UNIX shell scripting, crontab, TOAD, Designer tool.

Supervisory Responsibilities:

• This position has no supervisory responsibilities.