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. pply 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 DDM (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) 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.