Commonwealth of Pennsylvania logo
Commonwealth of Pennsylvania
Posted 129 days agoVerified live 13h ago

Database Administrator 1

Brief overview

Dauphin County, PAHybrid
UndergradOr in progress
1+ yrsMinimum
Database designData modelingPerformance tuningSecurity administrationData integrationETL processesDatabase deployment and upgradesTroubleshooting database environments

About the company

Commonwealth of Pennsylvania logo
Commonwealth of Pennsylvaniaarts.pa.gov

The Commonwealth of Pennsylvania employs thousands of people across the state to deliver programs and services to the people of Pennsylvania.

Job description

Summary

The Commonwealth of Pennsylvania is seeking a Database Administrator 1 to support database design, development, and operations for public safety. This role involves ensuring reliable data systems that support critical functions, monitoring performance, and administering security standards.

Responsibilities

  • Database Design: Support database structure planning and development to meet application needs
  • Data Modeling: Create and maintain data models and dictionaries to ensure consistency and accuracy
  • Performance Support: Monitor and tune database performance to improve reliability and efficiency
  • Security Oversight: Administer access controls and apply security standards to protect sensitive data
  • Data Integration: Develop processes to extract, transform, and load data between systems
  • Operational Support: Assist with deployments, upgrades, and troubleshooting across database environments

Skills

  • One year as a Database Analyst or Information Technology Generalist 2 (Commonwealth job title or equivalent Federal Government job title, as determined by the Office of Administration); or
  • Five years of information technology experience that includes two years in the analysis, design, and maintenance of databases in overall support of database administration; or
  • Three years of information technology experience that includes two years in the analysis, design, and maintenance of databases in overall support of database administration, and an associate's degree in any information technology field; or
  • One year of information technology experience in the analysis, design, and maintenance of databases in overall support of database administration, and a bachelor's degree in any information technology field; or
  • An equivalent combination of experience and training
  • You must meet the PA residency requirement
  • You must be able to perform essential job functions
  • You must pass a background investigation and meet Criminal Justice Information Services (CJIS) compliance requirements

Qualifications

Must Haves

  • One year as a Database Analyst or Information Technology Generalist 2 (Commonwealth job title or equivalent Federal Government job title, as determined by the Office of Administration); or
  • Five years of information technology experience that includes two years in the analysis, design, and maintenance of databases in overall support of database administration; or
  • Three years of information technology experience that includes two years in the analysis, design, and maintenance of databases in overall support of database administration, and an associate's degree in any information technology field; or
  • One year of information technology experience in the analysis, design, and maintenance of databases in overall support of database administration, and a bachelor's degree in any information technology field; or
  • An equivalent combination of experience and training
  • You must meet the PA residency requirement
  • You must be able to perform essential job functions
  • You must pass a background investigation and meet Criminal Justice Information Services (CJIS) compliance requirements

Benefits

  • Full-time employment
  • Work hours are 8:00 AM to 4:00 PM, Monday - Friday, with 30-minute lunch.
  • Telework: You may have the opportunity to work from home (telework)part-time, up to three days per week. In order to telework, you must have a securely configured high-speed internet connection and work from an approved location inside Pennsylvania. If you are unable to telework, you will have the option to report to the headquarters office in Harrisburg. The ability to telework is subject to change at any time.

More jobs like this