Oracle - Senior Database Administrator

Open San Consulting LLC

Offutt AFB, NE

JOB DETAILS
SKILLS
Access Control, Air Force, Analysis Skills, Architectural Design, Cloud Computing, Communication Skills, Corrective Action, Cost Control, Cost Effectiveness Analysis, Cross-Functional, Data Migration, Data Recovery, Database Administration, Database Architecture, Database Clustering, Database Design, Database Management Software/Systems (DBMS), Database Optimization, Database Replication, Database Technology, Decision Support, Disaster Recovery, Enterprise Architecture, Failover, Federal Contracts, High Availability, ITIL (IT Infrastructure Library), Identify Issues, Incident Response, Industry Standards, Information Technology & Information Systems, Information/Data Security (InfoSec), Internet Security, Maintain Compliance, Microsoft Windows Azure, Microsoft Windows Operating System, Network Systems, OEM (Original Equipment Manufacturer), On Call, On Site Support, Operating Systems, Operations, Oracle, Oracle Applications, Oracle DBA (Database Administrator), Oracle Database, Oracle Enterprise Manager, Oracle RAC (Real Application Clusters), Performance Analysis, Performance Management, Performance Tuning/Optimization, Presentation/Verbal Skills, Problem Solving Skills, Pumps, Python Programming/Scripting Language, Query Optimization, RMAN, Resource Management, Root Cause Analysis, SQL (Structured Query Language), Security Patches, Security Protocols, Small Business, Software Design, Software Development, Software Patches, Statistics, Systems Administration/Management, Team Player, Technical Support, Technical/Engineering Design, Testing, United States Department of Defense (DoD), Vehicle Fleets, Vendor/Supplier Evaluation, Virtual Hosting, Writing Skills
LOCATION
Offutt AFB, NE
POSTED
30+ days ago

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

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.

OSC Edge delivers a total rewards package that we know will attract, engage and retain top talent. Key elements of our package include a competitive base pay and a comprehensive benefits package:

We offer eligible employees with an opportunity to enroll in a variety of benefits offerings. Here are just some of our benefits for our US based positions:

Medical/ Dental/ Vision Life insurance and AD&D Flexible Spending Accident, Critical Illness and Hospital Indemnity coverage 401(k) and ROTH retirement options and company match Pet Insurance Identify Theft and Fraud Protection coverage

About OSC Edge:

Founded in 2008, what started as a small business has grown into a diverse and innovative global team owned by Cook Inlet Region, Inc. an Alaska Native Regional Corporation. As a US Federal contractor, we are a dedicated IT Service Provider supporting the Departments of the Army, Navy, Air Force, DoD Educational Institutions, and large corporate entities. Our expertise is in Cloud Computing, Cyber Security, Compliance Management, Enterprise Architecture, IT Support, and CSfC. If you are passionate about making a difference and thrive in a dynamic and collaborative environment, we invite you to apply to join our team.

Equal Opportunity Employer/Veterans/Disabled

About the Company

O

Open San Consulting LLC