Database Administrator 3

Job Description

POSITION RESPONSIBILITIES

Note : All official drafts, documents, and recommendations, as listed below, must be reviewed, finalized, and approved / accepted by appropriate BPA manager or other federal personnel with the authority to do so.

• Research, test, document, and develop standardized technical procedures for the deployment / troubleshooting of server hardware (or virtual machines), the associated operating systems and application software.
• Perform system vulnerability assessments using vendor native (Oracle Enterprise Manager) and third-party tools (Nessus), recommending mitigation options based on risk of exploitation after consideration of environmental factors.
• Serve as a service response escalation point, working with teams of varying technical ability in response to service availability and / or performance related incidents / problems.
• Provide recommendations for process / procedural changes that may become necessary due to environmental changes, upgrades.
• Support the design and implementation of highly available database solutions appropriate for workloads based on customer requirements.
• Support disaster recovery and continuity of operations through continuous verification of availability mechanisms and management of data protection activities (including backup and restore testing).
• Serve as a technical advisor for project and service response and related tasks.
• Operate a production Oracle Database environment using Oracle Enterprise Manager (OEM) 13c Grid Control.
• Provide recommendations for process improvements and technical solutions that can be integrated into existing environments surrounding performance, operational efficiency, and capacity.
• Apply the processes / procedures in support of the following technologies :

o Microsoft Windows Server 2016 / 2019 / 2022 (as it pertains to Oracle DB)

o Red Hat Enterprise Linux / Oracle Enterprise Linux (as it pertains to Oracle DB)

o Oracle ASM (Automatic Storage Management)

o ADDM (Automatic Database Diagnostic Monitor) and AWR (Automatic Workload Repository)

o Oracle Enterprise Manager 13c

o Recovery Manager (RMAN)

Mark documents and maintain filing system(s), files, emails, and records in accordance with compliance requirements. Share and disperse documents only to appropriate personnel (those with a Lawful Government Purpose (LGP) to know).

Mark and maintain all official records in accordance with the Information Security (INFOSEC) and Information Governance & Lifecycle Management (IGLM) standards and procedures.

Validate official records are accurately maintained for auditing purposes.

REQUIREMENTS

Education & Corresponding Experience (required on matrix)

A bachelor's degree in information technology (or closely related technical discipline) is preferred.

o 10+ years of experience is required with an applicable bachelor's degree.

o 15+ years of experience is required without a degree or applicable degree.

Experience should include directly related IT infrastructure administration.

Required Technical Skills & Experience (required on matrix)

• 10+ years of knowledge and experience sufficient to administer Oracle 19c / 23ai on a Linux platform.
• 5+ years of knowledge and experience sufficient to successfully troubleshoot Linux and Windows operating systems using text-based logs, Windows event logs, and various utilities as it pertains to support of Oracle Database services.
• 5+ years knowledge of and experience building tools for other administrators to use and automating operations with scripting tools such as shell scripting and PowerShell.
• 5+ years of knowledge of and experience with TCP / IP and related services.
• Direct experience supporting production workloads using Oracle RAC.

Preferred Skills & Experience (optional on matrix)

• Direct experience managing Oracle ExaData operations including patch management.
• Direct experience working with an enterprise scheduling system.
• Experience with Perl is highly preferred.
• Experience configuring and managing systems using Puppet Enterprise.
• Expert level knowledge / certification for SQL and / or Real Application Clusters .

Additional Requirements (not required on matrix)

Valid U.S. Driver's License is required.