Database Administrator

Job Details:

Job Title: Database Administrator

Duration: Long-Term Contract

Location: Minneapolis, MN 55437 || Atlanta, GA || Hybrid

Need Local Candidates In-Person Final Round

Client Notes

• Responsible for OnPrem and Oracle.
• There are 15 mission critical applications.
• Candidate will be responsible for Oracle 12 and Oracle 19c.
• Oracle RDS on AWS. Candidate will be involved in Migrating data from onprem to the cloud.
• Primary POC to coordinate effort with onshore DBA and offshore.
• This person won't be on the on-call rotation however they will be involved in calls after work occasionally.
• 100% environment is onprem but they are actively moving towards the cloud. All API components need to be migrated by the summer.
• Need someone who has a project engineering type background. (Not looking for someone who's background is in operational support.)

Job Description:

Qualifications:

• We are looking for 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 Client 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 CLient is 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.
• Client maintains two primary Information Technology Hubs in the US one in Atlanta, Georgia and the other in Minneapolis, Minnesota.
• 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 Client 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 Client 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