Job Description

Position Overview

Oracle Database Administrator is responsible for ensuring the availability, integrity, accessibility and performance of all corporate databases

Key Responsibilities

• Develops strategic and tactical plans for developing and maintaining corporate databases

• Develops baseline and system models to monitor DBMS and processing performance
• Coordinates enhancements and upgrades with other IT groups

• Develops capacity planning standards, monitors capacity metrics and balances present and future capacity requirements

• Keeps abreast of latest technologies and trends and makes recommendations for incorporation when appropriate

• Conduct regular Performance Tuning and Query Optimization using monitoring and troubleshooting tools

• Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc. along with detect and troubleshoot CPU, memory, I/O, disk space and other resource contention problems

• Implement operational automation

• Documents database processes and procedures (such as creating KBs, runbooks, topology, etc.)

• Conduct SQL Development – ability to write and troubleshoot SQL Code (stored procs, functions, tables, views, triggers, indexes, constraints and other scripting languages)

• Weekly and monthly status reports to higher management

• Participate in business meetings with various stake holders

• Take corrective actions based on surveys and incidences

• Ensures problem resolution by initializing and tracking problem assignments and initiates escalation as appropriate to the next level of support personnel or vendors 

Required Skills

• 6+ years of experience required as a database administrator

• Experience required in reporting, forecasting, capacity planning, and implementing database solutions across multiple platforms

• Experience required in backups, restores, clustering, mirroring, replication, indexing and performance tuning

• Experience working on third party DBA tools and applications

• Analytical, troubleshooting, and problem-solving skills

• Logical, efficient & proactive

• Keen attention to detail

• Ability to effectively communicate ideas

• Experience working in a team-oriented, collaborative environment

• Comfortable with ambiguity and possess an ability to adapt quickly and easily. Ability to analyze complex problems and move them to resolution

• Background and style that elicits respect in the organization through style of engagement, technical depth, customer service and results

• Positive attitude and ability to build strong relationships within the company and with external partners.

• Very strong communication (written and verbal)