Database Administrator 2 in Pennsylvania, USA, Pennsylvania, United States

Job Information

Commonwealth of Pennsylvania Database Administrator 2 in Pennsylvania

Database Administrator 2

Print (https://www.governmentjobs.com/careers/pabureau/jobs/newprint/4650929)

Apply

Database Administrator 2

Salary

$86,299.00 - $131,208.00 Annually

Location

Dauphin County, PA

Job Type

Civil Service Permanent Full-Time

Job Number

CS-2024-87801-01533

Department

Executive Offices

Division

EX OA ETSO Comp Cld Srvs Div

Opening Date

09/12/2024

Closing Date

9/25/2024 11:59 PM Eastern

Job Code

01533

Position Number

00046156

Union

Non-Union

Bargaining Unit

Pay Group

ST10

Bureau / Division Code

00812812

Bureau / Division

ETSO Compute and Cloud Services Division

Worksite Address

651 Boas Street

City

Harrisburg, Pennsylvania

Zip Code

17120

Contact Name

Matthew Zyroll

Contact Phone

717.836.3503

Contact Email

mzyroll@pa.gov

Description
Benefits
Questions

THE POSITION

Are you passionate about database management and looking to make a meaningful impact in your community? Join the Enterprise Technology Services Office, Compute and Cloud Services Division team as a Database Administrator 2. This is a unique opportunity to leverage your technical expertise to support vital public services, ensuring the integrity, security, and efficiency of our data systems. Apply today to become part of a dedicated team committed to innovation and excellence.

We offer a collaborative and engaging work environment where we provide modern infrastructure services such as high availability. Why work with us? We provide a telework schedule, state employment retirement, and exceptional benefits package!

DESCRIPTION OF WORK

As a Database Administrator 2, you will be responsible for the design, development, implementation, and support of efficient and effective databases with varying product version and licensed features. Work includes planning and implementing database reorganization and conversion maintenance, managing system performance through the use of system diagnostic tools and reports, as well as participating in IT planning activities with application development and operations personnel. You will have the opportunity to supervise three staff members for further Oracle Database support and engineering.

You will also be responsible for developing data models for new and existing systems. These duties include understanding of business rules and converting logical designs into physical structures applying data normalization rules. You will also continue work in progress by other department staff such as starting from a conceptual or logical model or begin work by developing initial models starting from function requirements gathered by business analysts.

Make your career aspirations a reality with our office!

Interested in learning more? Additional details regarding this position can be found in the position description. (https://careers.employment.pa.gov/pd/PD_NEOGOV.asp?p=00046156)

Work Schedule and Additional Information:

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

REQUIRED EXPERIENCE, TRAINING & ELIGIBILITY

QUALIFICATIONS

Minimum Experience and Training Requirements:

One year as a Database Administrator 1;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 (https://www.employment.pa.gov/Additional%20Info/Pages/default.aspx) . For more information on ways to meet PA residency requirements, follow the link (https://www.employment.pa.gov/Additional%20Info/Pages/default.aspx) and click on Residency.
You must be able to perform essential job functions.

Legal Requirements:
The selected candidate for this position must undergo a fingerprint-based records check to be in compliance with the Federal Bureau of Investigation (FBI), Criminal Justice Information Services Division (CJIS).
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 willnotbe 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.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).

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/testoncefor this posting.
Your results will be provided via email.

Learn more about our Total Rewards by watching this shortvideo (https://www.youtube.com/embed/HtcSRnndflc?rel=0) !

Health & Wellness

We offer multiple health plans so our employees can choose what works best for themselves and their families. Our comprehensive benefits package includes health coverage, vision, dental, and wellness programs.*

Compensation & Financial Planning

We invest in our employees by providing competitive wages and encouraging financial wellness by offering multiple ways to save money and ensure peace of mind including multiple retirement and investment plan options.

Work/Life Balance

We know there’s more to life than just work! Our generous paid leave benefits include paid vacation, paid sick leave, eight weeks of paid parental leave, military leave, and paid time off for most major U.S. holidays, as well as flexible work schedules and work-from-home opportunities.*

Values and Culture

We believe in the work we do and provide continual opportunities for our employees to grow and contribute to the greater good. As one of the largest employers in the state, we provide opportunities for internal mobility, professional development, and the opportunity to give back by participating in workplace charitable giving.

Employee Perks

Sometimes, it is the little “extras” that make a big difference. Our employees receive special employee-only discounts and rates on a variety of services and memberships.

For more information on all of these Total Rewards benefits, please visitwww.employment.pa.gov and click on the benefits box.

*Eligibility rules apply.

Do you have one or more years of experience as a Database Administrator 1 while employed by the Commonwealth of Pennsylvania?

Yes
No

02

If you are claiming experience in the above question, please list the employer(s) where you gained this experience in the text box below. The employer(s) and a description of the experiencemustalso be included in the appropriate sections of your application if you would like the experience to be considered in the eligibility decision. If you claimed you do not have experience, type N/A in the text box below.

03

How many years of information technology experience do you possess in the analysis, design,andmaintenance of databases?
2 or more years
1 to less than 2 years
No experience

04

If you are claiming experience in the above question, please list the employer(s) where you gained this experience in the text box below. The employer(s) and a description of the experiencemustalso be included in the appropriate sections of your application if you would like the experience to be considered in the eligibility decision. If you claimed you do not have experience, type N/A in the text box below.

05

How many graduate-level college credits in database technology or database concepts do you possess? If you are claiming credits/degree, you must upload a copy of your college transcript(s) for this education to be considered in the eligibility decision. Unofficial transcripts are acceptable. You must attach your transcript(s) prior to the submission of your application by using the "Attachments" tab on the left. You will not be able to add a transcript(s) to the application after it has been submitted.

If your education was acquired outside of the United States, you must also upload a copy of your foreign credential evaluation. For more information on foreign education credentials, please visithttps://www.employment.pa.gov/Additional%20Info/Pages/default.aspx#q3and click on Other Information.

30 credits or more
Less than 30 credits
None

06

You must complete the supplemental questions below. These supplemental questions are the exam and will be scored. They are designed to give you the opportunity to relate your experience and training background to the major activities (Work Behaviors) performed in this position. Failure to provide complete and accurate information may delay the processing of your application or result in a lower-than-deserved score or disqualification. Youmustcomplete the applicationandanswer the supplemental questions. Resumes, cover letters, and similar documents willnotbe reviewed for the purposes of determining your eligibility for the position or to determine your score.

All information you provide on your application and supplemental questions is subject to verification. Any misrepresentation, falsification or omission of material facts is subject to penalty. If requested, you must provide documentation, including names, addresses, and telephone numbers of individuals who can verify the validity of the information you provide in the application and supplemental questions.

Read each question carefully. Determine and select which "Level of Performance" most closely represents your highest level of experience/training. List the employer(s)/training source(s) from your Work or Education sections of the application where you gained this experience/training.The "Level of Performance" you choose must be clearly supported within the description of the experience and training information entered in your application or your score may be lowered.In order to receive credit for experience, you must have worked in a job for at least six months in which the experience claimed was a major function.

If you have read and understand these instructions, please click on the "Yes" button and proceed to the exam questions.

If you have general questions regarding the application and hiring process, please refer to ourFAQ page (https://www.employment.pa.gov/Additional%20Info/Pages/default.aspx) .

Yes

07

WORK BEHAVIOR 1 – DEVELOPING STANDARDS, POLICIES, AND PROCEDURES

Develops database and data administration standards, policies, and procedures. Develops and implements policies, plans, and standards related to database design and use, database structure, database integrity, security, configuration, naming conventions, data elements, data dictionary, data sharing, entity relationship diagrams and methodologies, and quality assurance. Develops and approves standards related to security mechanisms and disaster recovery.

Levels of Performance