Database Administrator 2

Are you interested in the development, design, analysis and implementation of relational databases? If so, consider your next career move with the Office of Information Technology as a Database Administrator 2. In this role, you will have the opportunity to utilize your extensive information technology background to act as a subject matter expert on data visualization, participating in discussions related to special projects and modernization efforts. Take your career up a notch with the Cross Application Integration Division!

As a Database Administrator 2, responsibilities include the oversight and preparation of visualization of data using tools such as Microsoft PowerBI, SQL Server Integration Services, and SQL Analysis Services. This position works with Employment, Banking, and Revenue (EBR) users to advance the usage of data visualization tools, establish and administer standards and serve as EBR liaison with Microsoft regarding data visualization topics. The role involves creating and maintaining appropriate reports and dashboards, establishing recovery procedures as needed on 24 x 7 basis and monitoring performance, space usage and growth. You will have the opportunity to lead planning activities related to the overall usage and design of data products and provide professional advice and opinions to senior management regarding improvements in the technology, the delivery of solutions and the management of tools to provide insights into data.

Additional responsibilities:

• Train and mentor developers and users on data visualization techniques
• Ensure security, integrity and availability of all data
• Available 24/7 for support
• Comply with all bureau and departmental security policies and guidelines

Interested in learning more? Additional details regarding this position can be found in the position description.

Work Schedule and Additional Information:

• Full-time employment
• Work hours are 8:00 AM to 4:30 PM, Monday - Friday, with 60-minute lunch.
• Telework: You may have the opportunity to work from home (telework) part-time. 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

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:

• You must meet the PA residency requirement. For more information on ways to meet PA residency requirements, follow the link and click on Residency.
• You must be able to perform essential job functions.

Legal Requirements:

• This position will have access to Federal Tax Information (FTI) and is subject to the provisions of IRS Publication 1075 (Pub 1075) which requires you to pass an enhanced background check prior to beginning employment. Under Pub 1075, acceptance of a conditional offer of employment will require submission to and approval of satisfactory criminal history reports, including but not limited to: a fingerprint-based federal records check; a PA State Police clearance; a check of local law enforcement agencies where you have lived, worked, and/or attended school within the last five (5) years; and a citizenship/residency verification.

How to Apply:

• Resumes, cover letters, and similar documents will not be reviewed, and the information contained therein will not be considered for the purposes of determining your eligibility for the position. Information to support your eligibility for the position must be provided on the application (i.e., relevant, detailed experience/education).
• If you are claiming education in your answers to the supplemental application questions, you must attach a copy of your college transcripts for your claim to be accepted toward meeting the minimum requirements. Unofficial transcripts are acceptable.
• Your application must be submitted by the posting closing date. Late applications and other required materials will not be accepted.
• Failure to comply with the above application requirements may eliminate you from consideration for this position.

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.

• 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.