IT Specialist (Database Administrator)

Employer
USAJobs
Location
Washington, D.C
Posted
Oct 23, 2021
Closes
Nov 01, 2021
Hours
Full Time
Duties

Summary

This position is within the Office of the Treasurer (T), Digital Solutions Operations (TDS-OPS). The primary purpose of this position is to serve as the technical POC between system owners and the solution providers that services to the Gallery ensuring business applications/systems meet the functional, system security and performance requirements, conduct performance tuning, system patching activities in accordance with the Gallery's cyber security mandates and business requirements.

Learn more about this agency

Responsibilities

Incumbent:
  • The Database Management System Administrator will serve as the Database Administrator (DBA) within Digital Solutions; Operations (TDS-OPS). Serve as primary technical focal point for all issues relating to Gallery Enterprise Databases, comprised of Microsoft, Oracle, MySQL and PostgreSQL DBMS platforms. Capture, analyze and report on problem areas and help resolve issues associated with PaaS, SaaS, and COTS applications / systems/services. Provide hands-on technical expertise (architectural, design and operational) in support of business services deployments. Provide administration, upgrades, patching, security hardening, troubleshooting, backups, restoration and monitoring of the Enterprise Databases in 24x7x365 environment. Conduct periodic backups and disaster recovery plans validation. Provide data migration, transformation and multi-system integration. Troubleshoots complex technical issues in multi-tiered applications in heterogenous operating systems and hosting environments. Implements and support performance tuning and monitoring of DBMS and applications.
  • Provide day to day administration, security hardening, patching and upgrades of Active Directory and Operating Systems in Gallery's on-premise and cloud virtual infrastructure. Develop automation scripts and troubleshoot complex technical and/or functional issues in multi-tiered applications environment. Work with other subject matter experts and stakeholders with design, development and troubleshooting of technical issues. Rack and stack physical hardware. Monitor and respond to s generated by monitoring systems. Maintain and periodically validate enterprise backup. Support periodic systems disaster recovery exercises. Maintain accurate inventory of hardware, software in ServiceNow and/or other management tools. Provide on-call after hours support.
  • Works under broad policy guidance; applicable statutes; Gallery regulations and directives; and directives of Congress and the President as well as regulations from OMB, GAO, GSA, NIST and other Federal agencies. Other sources of guidelines include various internal management and/or operational processes, documents, handbooks, instructions, directives and other recognized IT procurement and contracting control practices and standards. Creates, maintains and contributes towards technical and process documentation. Manage projects, performs market research, cost-benefit analyses, develop Statement of Work (SOWs), participate in vendor/product evaluation and selection processes. Serve as Contractor Officer's Representative (COR) for designated contracts. Ensure timely annual maintenance/renewal of assigned products and/or contracts. Support maintaining accurate budget.


Travel Required

Not required

Supervisory status
No

Promotion Potential
14

Requirements

Conditions of Employment

  • You must be a United States Citizen.
  • Subject to a background/suitability investigation.
  • Designated and/or random drug testing may be required.
  • Selective Service Registration is required for males born after 12/31/1959.


Your resume serves as the basis for qualification determinations and must highlight your most relevant and significant work experience and education (if applicable) as it relates to this job opportunity. Experience refers to paid and unpaid experience, including volunteer work done through National Service programs (e.g., Peace Corps, AmeriCorps) and other organizations (e.g., professional; philanthropic; religious; spiritual; community, student, social). Your resume must include the dates of all qualifying experience (from month/year to month/year) and the number of hours worked/volunteered per week.

GS-5 through GS-15 (or equivalent): For all positions individuals must have IT-related experience demonstrating each of the four competencies listed below. The employing agency is responsible for identifying the specific level of proficiency required for each competency at each grade level based on the requirements of the position being filled.
  • Attention to Detail - Is thorough when performing work and conscientious about attending to detail.
  • 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.
  • 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.
  • Problem Solving - Identifies problems; determines accuracy and relevance of information; uses sound judgment to generate and evaluate alternatives, and to make recommendations.

  • There are no special physical demands.

    The National Gallery of Art provides reasonable accommodation to applicants with disabilities. If you need reasonable accommodation for any part of the application and hiring process, please notify us. The decision on granting reasonable accommodation will be made on a case-by-case basis.

    Qualifications

    Applicants must have a minimum of one year of specialized experience at a level of difficulty and responsibility comparable to the next lower grade or comparable pay band in the Federal service or equivalent experience in the private sector.

    Specialized Experience Statement :

    GS-14: Candidates must possess at least one year of specialized experience, equivalent in responsibility to the GS-13 level in the Federal service, designing, deploying and managing databases on Microsoft SQL Server, Oracle, MySQL platforms, in respective Microsoft Windows and Linux Operating Systems, hosted in VMWare-based on-premise and AWS and Microsoft Azure cloud environments. Shall have hands-on expertise with Microsoft Always On and Microsoft High Availability solutions. Hands-on experience with backup and recovery of databases in Microsoft SQL Server, Oracle, MySQL DBMS platforms. Strong knowledge of Structured Query Language (SQL) in Microsoft SQL Server and Oracle DBMS environments. Requires one or more database administrator certifications. Certified Windows 2016 Administrator (MCSA), VMWare v6.5 (or above) Administrator (VCP), and Microsoft DBA (MCDBA) for MS SQL 2012 and later versions.

    Other Relevant Eligibility Criteria : Must have hands-on administration and technical knowledge of the latest Microsoft Server Operating Systems, Linux, Microsoft Azure and Amazon AWS (IaaS) environments, Microsoft Active Directory, Microsoft Active Directory Federation Services (ADFS), Multi-factor authentication, DNS, VMware ESXi, Enter-prise backups, Monitoring, office automation, network and data center IT environments. Hands-on experience with provisioning and managing servers in Amazon Web Services (AWS) environment. Experience with Microsoft Azure hosting environment will be plus. Requires carrying and monitoring of a Gallery-issued mobile device during non-work hours in a 24x7x365 environment. This position has positive education requirement and experience cannot be substituted with experience.

    Candidates must reflect in their submitted USAJOBS resume the possession of this specialized experience. If their resume does not include such specialized experience, they will be ineligible for this position. Those applicants who meet the minimum qualification requirements will be evaluated against these factors to determine the best-qualified candidates.

    Candidates should ensure their resume and submitted materials clearly demonstrate possession of these factors to receive maximum employment consideration.
    • Ability to design, develop, deploy and manage a variety of databases, under Microsoft SQL Server, Oracle and Open Source Platforms to include but not limited to MySQL and PostgreSQL, in heterogenous Operating Systems (Microsoft Windows and Linux) environments, in on-premises, AWS and Microsoft Azure cloud platforms. Hands-on expert-level knowledge of enterprise-scale backup/recovery tools and techniques to perform object-level restores. Hand-on knowledge of database modeling tools, Microsoft Visio and Office productivity solutions. Strong written and verbal communication skills.
    • Hands-on experience with Active Directory, Windows and Linux operating systems, AWS and Microsoft Azure hosted services. Hand-on scripting experience. Strong written and verbal communication skills. Ability to work independently and in a collaborative environment
    • Knowledge of change IT management processes, incident management, security hardening and compliance of database management systems and multi-tier applications, and/or other compliance requirements. Hands-on experience with creation of process documentation and products. Strong written and verbal communication skills. Hands-on experience with project management tools. Experience as a COR on mid to large scale contracts. Strong writing skills and hands-on experience with Microsoft Excel.

    CTAP/ICTAP candidates: To be considered "well qualified" you must meet all of the requirements as described in this section.

    You must meet all qualifications and eligibility requirements by the closing date of this announcement.

    Education

    EDUCATION: Are you using education to qualify?

    This position has a positive education requirement, you may submit copies of your transcripts or a course listing. You must provide documentation supporting your education claims.

    Education must be obtained from an accredited institution recognized by the U.S. Department of Education.

    Foreign education must be reviewed by an organization recognized by the U.S. Department of Education. For special instructions pertaining to foreign education and a list of organizations that can evaluate foreign education, see the Department of Education website .

    Additional information

    • The National Gallery of Art fosters a diverse and inclusive workplace and is an Equal Opportunity Employer.

      • More than one selection may be made from this vacancy announcement.

      • Some positions may require completion of a probationary period of up to 1 (one) year.

      AN EXTERNAL SELECTED CANDIDATE MUST BE FINGERPRINTED AND RECEIVE A BACKGROUND INVESTIGATION, RESULTING IN A SATISFACTORY SUITABILITY DETERMINATION BEFORE BEING HIRED FOR THIS POSITION.

      • All males born after December 31st 1959 must abide by laws regarding Selective Service registration. To learn more about this law, visit the Selective Service web page, Who Must Register . If you are not registered and don't have an approved exemption, you will not be eligible for employment with the Federal government.

      EEO Policy: https://help.usajobs.gov/index.php/EEO_Policy_Statement

      Reasonable Accommodation Policy: https://help.usajobs.gov/index.php/Reasonable_Accommodation_Policy_Statement

      Veterans Information: https://help.usajobs.gov/index.php/Veterans_Information

      Selective Service Registration: http://www.sss.gov/


    How You Will Be Evaluated

    You will be evaluated for this job based on how well you meet the qualifications above.

    Your application will be evaluated and rated under the Category Rating and Selection procedures. The quality categories are defined as "Best Qualified", "Well Qualified", and "Qualified".

    Based on your responses to the job-specific self-assessment questions, eligible candidates are placed for selection consideration into one of three pre-defined quality categories as described below:

    Best Qualified Category - In addition to meeting minimum qualifications for the position, candidates must fully demonstrate proficiency in all major aspects of the position.

    Well Qualified Category - In addition to meeting minimum qualifications, candidates must demonstrate proficiency in some, but not all of the major aspects of the position.

    Qualified Category - In addition to meeting minimum qualifications, applicants must demonstrate a basic level of knowledge, skill and ability of the position.

    If you are eligible for career transition assistance plans such as ICTAP or CTAP, you must meet the definition of "well qualified" which is defined as having a score of 85 or better.

    Application of Veterans Preference: The Category Rating Method does not add veterans' preference points or apply the "rule of three," but protects the rights of veterans by placing them ahead of non-preference eligibles within each pre-defined quality category. Preference eligibles who meet minimum qualification requirements and who have a compensable service-connected disability of at least 10 percent (i.e., CPS and CP) must be listed in the highest quality category, except when the position being filled is scientific or professional at the GS-09 grade level or higher.

    If your resume is incomplete or does not support the responses you provided in your online questionnaire, or if you fail to submit all required documentation before the vacancy closes, you may be rated 'ineligible', 'not qualified', or your score may be adjusted accordingly.

    To preview questions please click here .

    Background checks and security clearance

    Security clearance
    Other

    Drug test required
    No

    Position sensitivity and risk
    Non-sensitive (NS)/Low Risk

    Trust determination process
    Suitability/Fitness

    Required Documents

    Please carefully review the following list to determine what documentation you need to submit.

    Some documents may not apply to all applicants. If you are unsure, click the link for each document type to read more.

    ALL APPLICANTS: You must submit a resume supporting your specialized experience and responses to the online questionnaire.
    • Your resume should list all work experience (paid and unpaid); you should list the full name and address of the each employer.
    • Your experience listing should show the start and end dates (include month, day, and year); you must also list the average number of hours per week that you worked.
    • Your resume should also include any education and training you have completed (list the program title, subject area, number of hours completed, and completion date).
    • For more information about what to include in your resume, please view this USAJOBS Resume Tutorial video on YouTube.
    • It is important that your resume is complete and thorough. If any of the above information is not included in your resume, we may not be able to fully credit you for your experience.

    If specific educational requirements are indicated for this vacancy: Documentation verifying your educational claims which can include unofficial transcripts or any report listing institution, course title, credits earned and final grade. Please see the Education section for more information.

    Current and former Federal employees: Most recent SF-50 (Standard Form 50 - Notice of Personnel Action).

    To properly verify status eligibility, your SF-50 must show the following. If you do not submit an appropriate SF-50, we cannot verify your status eligibility!
  • Full position title;
  • appointment type;
  • occupational series;
  • pay plan, grade, and step;
  • tenure code; and
  • service computation date (SCD).

  • Displaced Federal employees: To be considered CTAP/ICTAP eligible, you must submit documentation verifying your involuntary separation and CTAP/ICTAP status. Please see the OPM Guide to Career Transition for more information.

    Veterans: Veteran eligibility documentation (DD-214, VA Letter, Standard Form (SF) 15 as applicable). Please note: If you are a veteran who has not yet been discharged, you may provide a statement of intent to discharge from your agency which will allow you to apply under the (Veterans Opportunity to Work) VOW to Hire Heroes Act of 2011 .

    Persons with Disabilities: Individuals with intellectual disabilities, severe physical disabilities, or psychiatric disabilities may apply for appointment through the Schedule A hiring authority. Certified verification of a disability from a licensed medical professional; a licensed vocational rehabilitation specialist; or any Federal, state, or District of Columbia agency or U.S. territory that issues or provides disability benefits is required.

    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.