Senior Oracle Database Administrator

Senior Oracle Database Administrator

Clearance- Top Secret

Location- Offutt AFB, NE

Salary- $140k-$160k/yr

The above salary range represents the range expected for the position; however, final salary offers are based on a number of factors such as the position’s responsibilities; the candidate’s experience, education, and skills; location; travel required; and current market conditions.

This program requires US Citizenship

The Senior Database Administrator will be responsible for the installation, configuration, maintenance, and optimization of Oracle database systems to ensure high performance, security, and availability. In this role, the Senior Database Administrator will design and implement database schemas, monitors database health, and performs routine backups and recovery operations to safeguard mission-critical data. Additionally, the Senior Database Administrator will troubleshoot database-related issues, manage user access and permissions, and optimize queries to enhance system performance. In this role, the individual will ensure compliance with organizational policies and industry standards while staying current on updates, patches, and advancements in Oracle technologies. The Database Admin will build, support, administer, and sustain a clustered-server database platform hosted in an enterprise IT environment. The Database Administrator will provide technical support for incident response, service degradations, outages, and other service interruptions. Investigate hardware and software problems related to the database-hosting infrastructure and perform corrective actions.

Responsibilities:

• Architects, designs, engineers, and document Oracle databases and associated infrastructure in clustered, stand-alone, and/or appliance-hosted configurations, which fulfill mission requirements, service specifications, and cyber security mandates

• Investigates hardware and software problems related to the database-hosting infrastructure and perform corrective actions

• Implements robust backup, restoration, and disaster recovery strategies

• Monitors, fine-tune, and optimize database performance for minimal downtime and maximum efficiency

• Establishes and enforces stringent database security protocols and access controls

• Collaborate closely with application development teams to design and optimize Oracle databases.

• Oracle RAC: Grid Infrastructure/ASM administration, installation, patching, configuration, and troubleshooting

• Develops, executes and oversees data migration initiatives when required

• Performance Tuning: AWR, ASH, statspack analysis, SQL tuning, optimizer statistics, and execution plan analysis

• Data replication and migration: Oracle GoldenGate, Data Pump (expdp/impdp), and Data Guard

• Spearheads scalability and high availability efforts for Azure SQL, Synapse Analytics, and other cloud-based databases while managing cloud resources and optimizing cost-effectiveness

• Maintains comprehensive documentation detailing database configurations, procedures, and best practices

• Regularly generates performance and usage reports to support informed decision-making

• Drives problem resolution and root cause analysis across the technology stack

• Participates in the resolution of database availability, capacity, and performance issues.

• Participates in infrastructure and organizational initiatives across multiple IT disciplines.

• Sustains fleet of physical and virtual database-hosting servers running a mix of operating systems (Open Systems and Windows Systems) in multiple network environments

• Performs daily operations, onsite support, and on-call support for all aspects of database architecture, database platforms, and database management software

• Works with original equipment manufacturers and/or third-party vendors to resolve performance degradations and outages

• Supports and participates in projects relating to the move of systems and services to modernized hosting environments and Cloud capabilities

• Provides expert advice on configuring database systems to meet the environment and boundary requirements and customize services to meet new performance goals.

• Works with original equipment manufacturers and/or third-party vendors to resolve performance degradations and outages.

• Supports and participates in projects relating to the move of systems and services to modernized hosting environments and Cloud capabilities

• Provides expert advice on configuring database systems to meet the environment and boundary requirements and customize services to meet new performance goals.

Required Qualifications/Education and Experience:

• Must have an active Top Secret Security Clearance with SCI eligibility

• Possesses a B.S. in a related field and 10+ years of database administration experience including experience with Oracle databases.

• ITIL v4 Certification or Sec + Oracle Database Administration (12c-21c): Installation, configuration, patching, and troubleshooting.

• A strong understanding of data and databases, Python, the ability to translate customer requirements, collaborating with cross-functional stakeholders

• Strong oral and written communication skills.

• Multitenant: Installation, configuration, patching, troubleshooting.

• RMAN: Backup and recovery and recovery catalog management.

• Automation & scripting: Shell (Bash), Ansible, and/or Perl.

• Oracle Data Guard: Physical/logical standby implementation and failover/failback procedures.

• Monitoring: Oracle Enterprise Manager (OEM) management, patching, and configuration.

• Security & Compliance: TDE, auditing, and STIGs.

• Oracle Apex: Installation, configuration, patching, and security.

• ORDS: Installation, configuration, and patching.

• OS: Linux navigation, vi, awk, sed, sudo/ksu, cron, top, sar, and parameter configurations for Oracle implementations.

ABBTECH is an EOE/Minorities/Women/Disabled Individuals/Veterans