Duties
Applies experience and a comprehensive technical knowledge to Structured Query Language (SQL) and/or Oracle Database management. Installs, configures, applies maintenance and debugs database issues and application (if requested by Middle-Tier Team) problems. Coordinates system testing with the application teams and end users. Writes and updates work instructions following ITIL best practices when documenting in preparation for system releases and installations.
Develops and uses specialized evaluation techniques to monitor performance of SQL and Oracle databases. Has working knowledge of Oracle Enterprise Manager (OEM) alerts and alarms and how to take corrective action. Typical assignments may include, but not limited to; installing SQL/Oracle databases, adding storage to a clustered environment, setting up physical stand-by DR sites, setting up dblinks, working daily with the Operating System Administrators, collecting, recording and analyzing capacity and performance data/information; identifying problems; performing investigation and inspection activities; and initiating compliance and enforcement actions (security checklists). Demonstrates independence in planning time and using assigned resources to accomplish assignments and projects.
Knowledge of and has hands on experience Oracle Automated Storage Management (ASM), Cluster Ready Services (CRS), Recovery Manager (RMAN), eBusiness Suite Application DBA (EBS Apps DBA), Oracle Enterprise Manager (OEM) and Oracle Engineered Systems such as Exadata and ZFS based database cloning. Experience with Microsoft products such as Windows and SQL Server. Conceptual understanding (how it works) of Netapp arrays (Network Attached Storage and Storage Area Network), DNS, stateful firewalls, multi-factor authentication (MFA) and Secure Socket Layer (SSL) based database authentication.
Contacts/Customers are internal/external to the organization. Communication with the customer is typically intended to share information, coordinate outages, upgrades and/or apply maintenance to the database(s), recommend solutions and/or database best practices along with conveying the Enterprise Service Center (ESC) standards to the customer. Communication with the customer will also entail providing data and/or written analyses (technical and operational support documentation) when requested.
Follows policies/procedures, ITIL best practices and ISO 9001 and 20K disciplines. Assignments typically require solutions to be derived by interpreting and extrapolating from situation faced in the past. May provide recommendations to improve work processes. Occasionally refers difficult problems and work issues to a manager when guidelines are not available or applicable.
Provides guidance to lower-level technical staff on how to solve difficult technical issues. Resolves all but unique technical problems without the intervention of management and/or vendor support. Work is reviewed periodically at major milestones and at completion, for technical compliance and alignment with the requirements of the project or other work activity.
Requirements
Conditions of employment
- US Citizenship is required.
- Selective Service Registration is required for males born after 12/31/1959.
- Must submit an SF50 (See Required Documents).
- A one-year probationary period may be required.
- Successful completion of a security investigation may be required.
- Please review Required Documents & Additional Information.
Qualifications
To qualify for this position at the FV-J (FG/GS-14) level, you must demonstrate in your application that you possess at least one year of specialized experience equivalent to FV-I (FG/GS-13) level. Specialized experience is experience that has equipped you with the particular knowledge, skills, and abilities to perform successfully the duties of the position.
Specialized Experience includes: Experience leading large (multiple systems and interfaces) projects, integrations, OR major database upgrades/releases, implementing security practices that protect ESC assets/customer systems, and troubleshooting problems/outages encountered during or after major system upgrades.
Applicants should include examples of Specialized Experience in their work history.
AND
Individuals must have IT-related experience demonstrating each of the four competencies listed below. The experience may be demonstrated by paid or unpaid experience and/or completion of specific, intensive training (for example, IT certification), as appropriate.
1. Attention to Detail - Is thorough when performing work and conscientious about attending to detail.
2. Customer Service - Works with clients and customers (that is, any individuals who use or receive the services or products that your work unit produces, including the general public, individuals who work in the agency, other agencies, or organizations outside the Government) to assess their needs, provide information or assistance, resolve their problems, or satisfy their expectations; knows about available products and services; is committed to providing quality products and services.
3. Oral Communication - Expresses information (for example, ideas or facts) to individuals or groups effectively, taking into account the audience and nature of the information (for example, technical, sensitive, controversial); makes clear and convincing oral presentations; listens to others, attends to nonverbal cues, and responds appropriately.
4. Problem Solving - Identifies problems; determines accuracy and relevance of information; uses sound judgment to generate and evaluate alternatives, and to make recommendations.
ALSO
Quality Ranking Factor (QRF): Well-qualified candidates will have documented experience leading large (multiple systems and interfaces) projects, integrations, OR major database upgrades/releases, implementing security practices that protect ESC assets/customer systems, and troubleshooting problems/outages encountered during or after major system upgrades.
Education
See qualifications required.
KSA Information
As a part of the Federal-Wide Hiring Reform Initiative (streamlining the hiring process), the FAA is committed to eliminating the use of the Knowledge, Skills and Ability (KSA) narratives from the initial application in the hiring process for all announcements. Therefore, as an applicant for this announcement, you are NOT required to provide a narrative response in the text box listed below each KSA.
In lieu of providing a KSA narrative response in the text box listed below each Knowledge Skills and Abilities (KSAs), in your work history, please include information that provides specific examples of how you meet the response level or answer you chose for each KSA. Your work history examples should be specific and clearly reflect the highest level of ability. Your KSA answers will be evaluated further to validate whether the level that you selected is appropriate based on the work history and experience you provided. Your answers may be adjusted by a Human Resource Specialist as appropriate.
Eligible applicants meeting the minimum qualification requirements and selective factor(s), if applicable, may be further evaluated on the KSAs and Other Factors listed in the announcement. Based on this evaluation, applicants will be placed in one of the following categories: score order, category grouping, or alphabetical and referred to the selecting official for consideration.
Make sure your resume includes detailed information to support your qualifications and answers to the job questionnaire.
Additional information
We may use this vacancy to fill other similar vacant positions.
Position may be subject to a background investigation.
A one-year probationary period may be required.
The person selected for this position may be required to file a financial disclosure statement within 30 days of entry on duty. FAA policy limits certain outside employment and financial investments in aviation-related companies. www.faa.gov/jobs/workinghere/financial-disclosure-requirements
NOTES:
1) Applicants must apply online to receive consideration for this vacancy announcement. Faxed, mailed, or emailed applications cannot be accepted.
2) Please ensure you answer all questions and follow all instructions carefully. Errors or omissions may impact your rating or may result in you not being considered for the job.
3) Some, all or none of the applicants may be interviewed.
4) This position is covered by the FAA Core Compensation plan. Additional information about core compensation is available on the following website: http://jobs.faa.gov/FAACORECompensation.htm
5) Position(s) may be realigned based on approved reorganization.
6) Position(s) will be filled within AMK-222, which will become AMK-254 in the upcoming reorganization.
7) Additional information regarding living in Oklahoma can be found at www.abetterlifeokc.com
8) To confirm receipt of documents, please contact Caleb Weston at Caleb.A.Weston@faa.gov
This is not a bargaining unit position.
Links to Important Information: Locality Pay, COLA
Candidates should be committed to improving the efficiency of the Federal government, passionate about the ideals of our American republic, and committed to upholding the rule of law and the United States Constitution.
A career with the U.S. government provides employees with a comprehensive benefits package. As a federal employee, you and your family will have access to a range of benefits that are designed to make your federal career very rewarding. Opens in a new windowLearn more about federal benefits.
Review our benefits
Eligibility for benefits depends on the type of position you hold and whether your position is full-time, part-time or intermittent. Contact the hiring agency for more information on the specific benefits offered.
Required Documents
A Notification of Personnel Action (SF-50) is required to verify area of consideration. Other supplemental documentation will be accepted in combination with your online application. These documents must be included with your application or emailed to 9-AMC-AHF-S210@faa.gov on or before the closing date of this announcement. All emailed documents should reference the announcement number.
If you are an FAA employee, you MUST provide a copy of your SF-50 (Notification of Personnel Action) containing information in Blocks 15, 17, 18, 19, 22, and 24 so it can be used to verify your position title, series, grade, tenure, and organization of record by the closing date of the announcement. You may fax your SF-50 or upload it into the on-line application. If faxing the SF-50, please ensure you include the vacancy announcement number on the faxed copy.
If you are an FAA employee, you can access and print your SF-50 from the eOPF system https://eopf.opm.gov/dot/.
If you are relying on your education to meet qualification requirements:
Education must be accredited by an accrediting institution recognized by the U.S. Department of Education in order for it to be credited towards qualifications. Therefore, provide only the attendance and/or degrees from
schools accredited by accrediting institutions recognized by the U.S. Department of Education.
Failure to provide all of the required information as stated in this vacancy announcement may result in an ineligible rating or may affect the overall rating.