Senior Database Administrator
The senior database administrator will be responsible for maintaining the United States Sentencing Commission’s (USSC) Oracle database systems including online transaction processing and data warehouse systems. Responsibilities will include installation, upgrades, patching, back-up, performance tuning and monitoring critical events of all USSC databases. Duties include, but may not be limited to performing the following, under supervision of the information systems manager: Maintaining the health of the Oracle server environment which includes clustered servers and Data Guard solution. Maintaining databases by patch applications and enhancements/upgrades of environments. Automating routine maintenance tasks. Monitoring RMAN backups. Performing recoveries using RMAN. Managing and maintaining Oracle Enterprise Manager and Grid Control agents. System Performance monitoring and troubleshooting. Performing export/import using Data Pump. Creating database objects as needed. Work closely with developers on application. development and performance tuning. Maintaining the data load process from the source system to the data warehouse using Oracle Data Integrator.
MANDATORY QUALIFICATION REQUIREMENTS Applicants must have a minimum of ten years of hands-on database administration, support, and performance tuning experience. Applicants must also posses experience or skills in the following areas: Working experience in Linux environments. Extensive experience with Oracle RAC, ASM, and Data Guard. Experience with database support, administration, performance tuning, and database monitoring. Experience with extraction, transformation, loading tools. PREFERRED QUALIFICATION REQUIREMENTS A Master’s degree in engineering, computer sciences, information systems, or a computer related field from an accredited university or college is preferred.
Other InformationCONDITIONS OF EMPLOYMENT This position is in the excepted service and does not carry the tenure rights of positions in the competitive Civil Service. All information is subject to verification. Applicants are advised that false answers or omissions of information on application materials or inability to meet the following conditions may be grounds for non-selection, withdrawal of an offer of employment, or dismissal after being employed. Selection for this position is contingent upon completion of OF-306, Declaration for Federal Employment during the pre-employment process and proof of U.S. citizenship or, for noncitizens, proof of authorization to work in the United States and proof of entitlement to receive compensation. Additional information on the employment of non-citizens can be found at: https://help.usajobs.gov/index.php/Employment_of_Non-citizens. For a list of documents that may be used to provide proof of citizenship or authorization to work in the United States, please refer to http://www.uscis.gov/files/form/i-9.pdf. A background security investigation is required for all selectees. Appointment will be subject to a selectee’s successful completion of a background security investigation and favorable adjudication. Failure to successfully meet these requirements may be grounds for appropriate personnel action. A background security reinvestigation or supplemental investigation may be required at a later time. All new Commission employees must identify a financial institution for direct deposit of pay before appointment, mandated by the Federal Compensation Act. All new Commission employees, those converted from a temporary appointment to a permanent appointment, and all rehired former Commission employees are required to serve a one year probationary period.The probationary period begins on the effective date of the employee’s appointment, conversion, or rehire. If appointed to a temporary position, management may have the discretion of converting the position to permanent depending upon funding and staffing allocation.