Senior Oracle Database Administrator

ABBTECH Professional Resources, Inc.; Omaha (NE); On-site; USD 140,000 - 160,000; Full time

Job summary

ABBTECH Professional Resources, Inc. is seeking a Senior Oracle Database Administrator for an Offutt AFB, NE assignment. Responsibilities include installation, configuration, maintenance, and optimization of Oracle databases to ensure high performance, security, and availability.

Candidate must hold a Top Secret clearance with SCI eligibility and have extensive Oracle experience. The role requires designing schemas, monitoring health, performing backups, and ensuring compliance with security

Qualifications

• Must have an active Top Secret Security Clearance with SCI eligibility.
• 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.
• Strong understanding of data and databases, Python, and translating customer requirements 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: 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.

Responsibilities

• Architects, designs, engineers, and documents Oracle databases and infrastructure to meet mission requirements and security mandates.
• Investigates hardware and software problems related to database-hosting infrastructure and performs corrective actions.
• Implements robust backup, restoration, and disaster recovery strategies.
• Monitors, fine-tunes, and optimizes database performance for minimal downtime and maximum efficiency.
• Establishes and enforces stringent database security protocols and access controls.
• Collaborates 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.
• Performs performance tuning: AWR, ASH, statspack, SQL tuning, optimizer statistics, execution plans.
• Data replication and migration: Oracle GoldenGate, Data Pump, and Data Guard.
• Leads scalability and HA for Azure SQL, Synapse Analytics, and cloud-based databases while managing cloud resources.
• Maintains documentation of configurations, procedures, and best practices.
• Generates performance and usage reports for informed decisions.
• Drives root-cause analysis across the tech stack.
• Participates in resolution of availability, capacity, and performance issues.

Skills

Oracle Database Administration

SQL Performance Tuning

Python scripting

Security compliance

Communication

Education

B.S. in related field

Tools

Oracle RAC

RMAN

Oracle Data Guard

Oracle Enterprise Manager (OEM)

Azure/Cloud platforms

Job description

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