Database Administrator 2

Commonwealth of Pennsylvania; Pennsylvania; Hybrid; USD 70,000 - 100,000; Full time

Benefits offered by this job

Telework up to 3 days/week

Job summary

Commonwealth of Pennsylvania seeks a Database Administrator 2 to design, implement, and maintain critical databases for public safety programs across the state. You will work with developers, partners, and vendors to deliver secure, reliable, and high-performance data solutions supporting JNET and PCCD.

The role emphasizes collaboration, continuous improvement, and service delivery within a government environment, with full-time hours and potential telework as described in the posting.

Qualifications

• One year as a Database Administrator 1 or six years IT experience with three years in database analysis, design, and maintenance
• Two years’ IT experience with degree in IT and three years in database work
• Equivalent combination of experience and training

Responsibilities

• Design and maintain databases for stability, reliability, and performance
• Analyze database issues, develop solutions, and assist developers and teams
• Monitor database performance, track space usage, and implement efficiency improvements
• Develop data models, create complex queries, and support data migration and QA
• Coordinate projects, maintain plans, review service requests, and report progress
• Collaborate with vendors/contractors and support database enhancements

Skills

Database Design

Technical Support

Performance Monitoring

Data Modeling

SQL Queries

Vendor Collaboration

Education

Bachelor’s degree in IT or related field

Associate’s degree in IT

MCITP Database Administrator

MCTS SQL Server certification

Tools

SQL Server

Database Administration Tools

Job description

THE POSITION

The Public Safety Information Technology Delivery Center is looking for a Database Administrator 2 who is ready to make a difference behind the scenes in the Solutions Management Division. In this role, you will help build and support critical databases that serve public safety programs across Pennsylvania. Your technical knowledge will help keep important systems running smoothly, securely, and efficiently. Join a team that values innovation, service, and continuous improvement.

DESCRIPTION OF WORK

As a Database Administrator 2, you will support the design, development, administration, and performance of databases used by JNET and PCCD within the Public Safety Information Technology Delivery Center. You will work with technical teams, business partners, and vendors to deliver reliable database solutions, maintain system performance, and support critical business needs. As a Database Administrator 2, you will perform the following duties:

• Database Design: Design and maintain databases while improving stability, reliability, and overall performance
• Technical Support: Analyze database issues, develop solutions, and provide assistance to developers, users, and project teams
• Performance Monitoring: Track database performance, evaluate space usage, and implement improvements that increase efficiency
• Data Solutions: Develop data models, create complex queries, and support data migration, quality assurance, and cleanup activities
• Project Coordination: Manage assigned work efforts, maintain project plans, review service requests, and report progress to stakeholders
• Vendor Collaboration: Evaluate software tools, coordinate with vendors and contractors, and support implementation of database enhancements

Work Schedule and Additional Information:

• Full-time employment
• Work hours are 8:00 AM to 4:30 PM, Monday - Friday, with a 60-minute lunch.
• Telework: You may have the opportunity to work from home (telework) part-time, up to 3 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. Additional details may be provided during the interview.
• Salary:In some cases, the starting salary may be non-negotiable.
• You will receive further communication regarding this position via email. Check your email, including spam/junk folders, for these notices.

QUALIFICATIONS

REQUIRED EXPERIENCE, TRAINING & ELIGIBILITY

Minimum Experience and Training Requirements:

• One year as a Database Administrator 1 (Commonwealth job title or equivalent Federal Government job title, as determined by the Office of Administration); or
• Six years of information technology experience that includes three years in the analysis, design, and maintenance of databases in overall support of database administration; or
• Four years of information technology experience that includes three 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
• Two years 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.

Other Requirements:

• This particular position also requires possession of a Microsoft Certified Technology Specialist (MCTS) SQL Server certification and Microsoft Certified IT Professional (MCITP) Database Administrator certification.
• You must meet the PA residency requirement . For more information on ways to meet PA residency requirements, follow the link and click on Residency Guidelines.
• You must be able to perform essential job functions.

Legal Requirements:

• You must pass a background investigation and meet Criminal Justice Information Services (CJIS) compliance requirements.

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.pa.gov/agencies/employment/how-to-apply.html and click on Veterans.

Telecommunications Relay Service (TRS):

• 711 (hearing and speech disabilities or other individuals).

If you are contacted for an interview and need accommodations due to a disability, please discuss your request for accommodations with the interviewer in advance of your interview date.

The Commonwealth is an equal employment opportunity employer and is committed to a diverse workforce. The Commonwealth values inclusion as we seek to recruit, develop, and retain the most qualified people to serve the citizens of Pennsylvania. The Commonwealth does not discriminate on the basis of race, color, religious creed, ancestry, union membership, age, gender, sexual orientation, gender identity or expression, national origin, AIDS or HIV status, disability, or any other categories protected by applicable federal or state law. All diverse candidates are encouraged to apply.

EXAMINATION INFORMATION

• Completing the application, including all supplemental questions, serves as your exam for this position. No additional exam is required at a test center (also referred to as a written exam).
• Your score is based on the detailed information you provide on your application and in response to the supplemental questions.
• Your score is valid for this specific posting only.
• You must provide complete and accurate information or:
• your score may be lower than deserved.
• you may be disqualified.
• You may only apply/test once for this posting.
• Your results will be provided via email.