Lead Information Technology Specialist (Data Management)

Summary

Serves as a Lead Information Technology Specialist (Data Management) within the Database & Data Center Support Services Section, AMK-222.

Learn more about this agency

Duties

Help

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

Help

Conditions of employment

• ship 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.

Preview job questionnaire

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. ;br>
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: ;br>
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 ;br>
8) To confirm receipt of documents, please contact Caleb Weston at

This is not a bargaining unit position.

Links to Important Information: Locality Pay, COLA

Expand Hide additional information

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.

Benefits

Help

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.