Information Technology Specialist ((APPSW/DATAMGT))

Summary The incumbent serves as the Technical Solutions Architect for the National Gallery of Art's Oracle financial management system and integrations. The incumbent is responsible for the management and oversight of technical solutions for Oracle eBusiness Suite (EBS), and Cloud-based Software-as-a-Service (SaaS) and Platform-as-a-Service (PaaS) systems, after the EBS has been decommissioned. Responsibilities As the Information Technology Specialist, you will : Provide technical expertise in database query and application development tools such as TOAD, SQL Plus, PL / SQL, and Oracle Workflow Builder as well as a working knowledge of report design, configuration, and generation using Oracle reporting tools and cloud dashboard capabilities. Provide support in the development of data management, and Oracle financials data warehouse initiatives. Provide technical expertise with the architecture, administration, maintenance, support, and integration of Oracle E-Business Suite and Cloud Financials with technologies, database tier components, application tier components, system interface capabilities, reporting, and operating systems. Manage Enterprise Performance Management (EPM) periodic system maintenance (e.g., system snapshots, backups, and defragmentation). Provides expert troubleshooting capabilities for the optimal and efficient operation of Oracle system integrations (e.g.travel systems, third-party procurement systems, payroll, financial institutions, credit cards, etc.). Provide support to the Gallery’s end-users report requests for developing and maintaining custom reports for financial data using Oracle Fusion Cloud reporting tools such as Oracle Transaction Business Intelligence Components (OTBI), BI Publisher, Smart View, Financial Reporting Studio and Oracle BI Cloud Connector. Requirements Conditions of Employment You must be a United States Citizen. This employer participates in the e-Verify program. Males born after 12-31-59 must be registered for Selective Service See "Other Information" section regarding Selective Service requirements. Suitable for Federal employment, determined by a background investigation May be required to successfully complete a probationary period 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. Qualifications GS-14 Specialized Experience Statement : For this position, specialized experience is at least one year of experience, equivalent in responsibility to the GS-13 level in the Federal service, serving as a technical solutions architect or equivalent technical role for an Oracle Financials system. GS-15 Specialized Experience Statement : For this position, specialized experience is at least one year of experience, equivalent in responsibility to the GS-14 level in the Federal service, serving as a technical solutions architect or equivalent technical role for an Oracle Financials system. OR Basic Requirements This standard allows eligibility through meeting either the requirements specified in the section titled Education or the requirements specified in the section titled Experience. Education : All academic degrees and coursework must be from accredited or pre-accredited institutions Undergraduate or Graduate Education : Degree in computer science, engineering, information science, information systems management, mathematics, operations research, statistics, or technology management or degree that provided a minimum of 24 semester hours in one or more of the fields identified above and required the development or adaptation of applications, systems or networks. Requirements Level Education GS-5 (or equivalent) bachelor's degree GS-7 (or equivalent) 1 full year of graduate level education or superior academic achievement GS-9 (or equivalent) master's degree or equivalent graduate degree or 2 full years of progressively higher level graduate education leading to a master's degree or equivalent graduate degree GS-11 (or equivalent) Ph.D. or equivalent doctoral degree or 3 full years of progressively higher level graduate education leading to a Ph.D. or equivalent doctoral degree or Experience Experience must be IT related; the experience may be demonstrated by paid or unpaid experience and / or completion of specific, intensive training (for example, IT certification), as appropriate 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. and Specialized Experience for GS-7 (or equivalent) and Above : Positions at GS-7 (or equivalent) and above require one year of specialized experience at the next lower GS-grade (or equivalent). Specialized experience is experience that has equipped the applicant with the particular competencies / knowledge, skills, and abilities to successfully perform the duties of the position and is typically in or related to the work of the position to be filled. Such experience is typically gained in the IT field or through the performance of work where the primary concern is IT. The employing agency is responsible for defining the specialized experience based on the requirements of the position being filled. OPM Qualifications Standard : Individual Occupational Requirements : Information Technology (IT) Management Series 2210 (Alternative A) You must meet all qualification and eligibility requirements by the closing date of this announcement. Merit promotion applicants must meet the time-in-grade requirement as defined in 5 CFR 300, Subpart F. One year at the GS-13 level is required to meet the time-in-grade requirements for the GS-14 level. One year at the GS-14 level is required to meet the time-in-grade requirements for the GS-15 level. You must meet all qualification and eligibility requirements by the closing date of this announcement. 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). Volunteer work helps build critical competencies, knowledge, and skills and can provide valuable training and experience that translates directly to paid employment. You will receive credit for all qualifying experience, including volunteer experience. Note : Applicants who are referred to the hiring office for selection consideration may be required to submit writing and / or work samples as part of the interview / selection process. If the hiring office decides to request a writing and / or work sample as part of its selection process, the vacancy contact will reach out to you by email to : (1) inform you of this requirement; and (2) provide further instructions. Education Although this position does not have 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. Relocation expenses will not be paid. 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 : Reasonable Accommodation Policy : Veterans Information : Selective Service Registration : Veterans Employment Opportunity Act (VEOA) : To be eligible for a VEOA appointment under Merit Promotion procedures, the veteran must be a preference eligible or a veteran separated after 3 years or more of continuous active service performed under honorable conditions. Noncompetitive Appointment Authorities : For more information on noncompetitive appointment authority eligibility requirements visit the following websites : Persons with Disabilities-Schedule A Special Hiring Authorities for Veterans Special Hiring Authority for Certain Military Spouses Other Special Appointment Authorities Reasonable Accommodation Requests : To learn more, please consult the following resources : Disability Employment - Reasonable Accommodations (OPM) How to contact an agency