Oracle DBA Engineer

Note:

Location : Minneapolis, MN (Onsite) Local and Non-local candidates willing to relocate at their own expenses only

C2C: Yes

Duration: 6-12+ months

Visa: No OPT and CPT

Note: preferred local candidates in Minnesota for an onsite Oracle DBA Engineer role supporting 50+ critical applications.

Requirements:

Hands-on experience with Oracle 12c and 19c

Experience with AWS RDS and Oracle Exadata databases

Proven expertise in migrating data from on-premises to the cloud

Experience migrating read-only APIs from on-premises to the cloud

Familiarity with Agile methodology

Strong communication skills

Oracle golden gate experience

Note: This position is focused on engineering and project work. The hiring manager is not considering candidates with a background limited to operational support. And junior profiles

Qualifications:

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 Delta 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 at Delta and as such there will almost certainly be opportunities to work with more junior team members and mentor and support them. Because Delta 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. Delta 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 Delta 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 Delta’s 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