Sr. Database Administrator

Senior Database Administrator

The Senior Database Administrator is a generalist who is responsible for all aspects of data analysis and database management. Database Administrators typically are responsible for a combination of back-end systems management tasks such as provisioning, software installation, patching, and creation of new (or decommissioning of old) databases; capacity and performance analysis, tuning and forecasting; incident and problem management; and support of software development lifecycle tasks such as deploying new database objects. In addition to this the Database Administrator will also have responsibility for managing and supporting tools for monitoring databases, backup and recovery, and DevOps enablement functions such as refreshes or data cloning. Database Administrators will be expected to interface with vendor support organizations and manage cases as needed. The Database Administrator will frequently work with other infrastructure teams as well as application development teams, and strong communication skills both written and oral are a must. The ability to work on multiple projects or initiatives concurrently, and to self-prioritize these tasks and work independently are all critical skills. The Database Administrator is a senior technical role and as such there will almost certainly be opportunities to work with more junior team members and mentor and support them. Because we are a 24x7 business there is an expectation that the Database Administrator will be able to work a flexible schedule which may frequently include off-hours work. There is no expectation for mandatory travel as a part of this position. An applicant for the Database Administrator role will be expected to work the majority of their time on-site at one of these locations. There is some degree of flexibility, but this is not intended as a hybrid or entirely remote working opportunity.

Qualifications:

• Minimum 8 years of experience creating and managing Oracle databases and technologies
• Experience with versions 12.2 and newer, both standalone and multi-instance Real Application Clusters
• Demonstrated strong expertise in diagnosing and resolving database performance or reliability issues
• Strong background and hands-on experience administering Oracle Enterprise Manager ecosystem including agents, repositories and management servers in a highly-available, load-balanced configuration
• Familiarity with RedHat Linux OS versions 6 and newer
• Proven track record of implementing and administering Oracle DataGuard for replication
• Able to work independently and balance multiple concurrent projects with mid to long-term deliverables
• Hands on development and maintenance of UNIX Korn or Bash shell scripting
• Ability to provide technical direction to others, including application developers
• Comfortable in high-pressure situations, able to communicate well with both technical peers and leadership
• 4-year degree (BA or BS) or equivalent work experience in a related field of study

Responsibilities:

• Work with Oracle Engineers and our service providers to deliver a highly available, resilient and performant database environment;
• Build new, or upgrade / patch existing databases and associated software in accordance with vendor best practices;
• Deliver required database functionality that meets project requirements on or before defined due date;
• Ensure the detailed physical design of data structures and database complies with enterprise build and configuration standards and processes;
• Install, configure, and maintain Oracle database and Enterprise Manager software on database and application servers as required;
• Provide consultation to application development teams on Oracle database technical issues and techniques;
• Conduct database performance testing and tuning, user configuration, security and support processes including gather stats, database backup/recovery, partition administration, etc;
• Ensure Oracle database environment is secure, provide recommendations for improving database security and implementing approved security remediations;
• Coordinate downtime with application teams and system engineers to implement approved changes;
• Interface with vendors and managed service partners to resolve operational issues or questions;
• Follow established IT / DBA policies and procedures

Top Skills:

• Oracle database systems administration including RAC and ASM 19c (10+ years)
• Oracle database performance optimization (10+ years)
• Oracle database VLDB structures and partitioning management (10+ years)
• AWS RDS database administration, security, automation, CFTs, etc. (2+ years)
• Managing Oracle databases on Exadata platform (5+ years)