Database Analyst

Commonwealth of PA | Dauphin County, PA

Posted Date 11/26/2019
Description The Information Technology Office is seeking a highly motivated and experienced professional to support the Agency's SQL Server environment. This position will monitor day-to-day operations within the Agency's enterprise-wide Oracle applications.

We offer a competitive salary and great state benefits. Apply today!
 
IMPORTANT:  YOU MUST APPLY TO THIS VACANCY POSTING, MEET ELIGIBILITY REQUIREMENTS, COMPLETE THE SUPPLEMENTAL QUESTIONS AND RECEIVE A SCORE.  YOUR SCORE IS ONLY VALID FOR THIS SPECIFIC VACANCY.  ONCE THIS POSITION IS FILLED, YOUR SCORE IS NO LONGER VALID.
 
  • Full-time employment
  • Work hours: 8:30 am - 5:00 pm; Monday - Friday; 1 hour lunch
The incumbent will be responsible for monitoring and testing database backup and recovery procedures for ORACLE and SQL Server environments (RMAN/VERITAS). Verifying and testing ORACLE database and application integration after ORACLE Database Administrators clone our ERP IBMS systems.

The incumbent will assist higher level Database staff in support of the Agency's ERP responsibilities by processing ORACLE and SQL Server code migration requests as identified by Activity Log database entries. Code is migrated from development environments to integration, user acceptance tests and production environments.

The incumbent will assist ORACLE Database Administrators by using Oracle's Enterprise Manager software to monitor ERP system performance, database and table growth, and overall system health.Qualifications:
  • Must meet PA residency requirement – For more information on ways to meet PA residency requirements, follow the link and click on Residency
  • Minimum Experience and Training Requirements: One year as an Applications
    Developer 1 or Information Technology Generalist 1; or two years of information technology experience that includes one year in the analysis, design, and maintenance of databases in overall support of database administration or in the analysis and design in overall support of data administration, and an associate's degree in any information technology field; or four years of information technology experience that includes one year in the analysis, design, and maintenance of databases in overall support of database administration or in the analysis and design in overall support of data administration; or a bachelor's degree in any information technology field
  • This position requires a minimum of six months full-time PL/SQL experience and a minimum of six months full-time Oracle Administration experience
  • Based on your answers to the supplemental application questions regarding education, you may be instructed to upload a copy of your college transcripts to your application. Unofficial transcripts are acceptable
  • Must be able to perform essential job functions

Veterans: Pennsylvania law (51 Pa. C.S. §7103) provides employment preference for qualified veterans for appointment to many state and local government jobs.  To learn more about employment preferences for veterans, go to www.employment.pa.gov/Additional%20Info/Pages/default.aspx and click the Veterans' Preference tab or contact us at ra-cs-vetpreference@pa.gov.
 
Telecommunications Relay Service (TRS):  711 (hearing and speech disabilities or other individuals)
 
The Commonwealth of Pennsylvania is proud to be an equal opportunity employer supporting workplace diversity.
  • Score valid for this specific posting only
  • Score based on information reported on application and supplemental questions
  • Provide complete and accurate information or:
    • score may be lower than deserved
    • application processing may be delayed
    • disqualification may result
  • May only test once under this announcement
  • Email notice of test results provided

Share this job