What are the responsibilities and job description for the Database Administrator 1 position at State of Pennsylvania?
Salary : $75,678.00 - $114,915.00 Annually
Location : Lebanon County, PA
Job Type : Civil Service Permanent Full-Time
Job Number : CS-2025-17486-01532
Department : Department of Military & Veterans Affairs
Division : MV App Dvpt
Opening Date : 02 / 03 / 2025
Closing Date : 2 / 17 / 2025 11 : 59 PM Eastern
Job Code : 01532
Position Number : 50699174
Union : Non Union
Bargaining Unit : A3
Pay Group : ST09
Bureau / Division Code : 00132603
Bureau / Division : Applications Development
Worksite Address : Building 0-47 Edward Martin Hall
Worksite Address : Fisher Avenue
City : Annville, Pennsylvania
Zip Code : 17003
Contact Name : Bhuvaneswari Shanmugam
Contact Email : bshanmugam@pa.gov
THE POSITION
Do you have an Information Technology (IT) degree or experience with databases? Are you looking for a career that offers professional growth? The Department of Military and Veterans Affairs (DMVA), Division of Applications Development is seeking a dedicated Database Administrator 1. If you want to work with an IT team that makes a difference and knows the satisfaction of public service, we want to talk to you!
Watch this video to see how you can make a difference caring for Pennsylvania's veterans working for the Department of Military and Veterans Affairs. Come join the DMVA team, apply today!
DESCRIPTION OF WORK
As a Database Administrator 1, you will perform advanced technical and administrative work in data management by designing, implementing, and operating database systems. You will develop storage structures, establish database access methodologies, and implement database expansions, reorganizations, and conversions. You will also establish and administer database policies, as well as develop data models and logical designs. In this role, you will regularly monitor and review infrastructure health checks to ensure the availability, performance, and integrity of servers, databases, and systems.
Interested in learning more? Additional details regarding this position can be found in the position description.
Work Schedule and Additional Information :
- Full-time employment, 37.5 hours per week
- Work hours are 8 : 00 AM to 4 : 00 PM, Monday - Friday, with a 30-minute lunch.
- Telework : You may have the opportunity to work from home (telework) part-time, five (5) days out of ten (10) days. 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 Annville.
- 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 :
Other Requirements :
Legal Requirements :
How to Apply :
Veterans :
Telecommunications Relay Service (TRS) :
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
your score may be lower than deserved.
Learn more about our Total Rewards by watching this short !
See the total value of your benefits package by exploring our
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 visit and click on the benefits box.
Do you have one or more years of experience as a Database Analyst while employed by the Commonwealth of Pennsylvania?
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 experience must also 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.
Do you have one or more years of experience as an Information Technology Generalist 2 while employed by the Commonwealth of Pennsylvania?
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 experience must also 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.
How many years of information technology experience do you possess in the analysis, design, and maintenance of databases?
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 experience must also 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.
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 upload a copy of your foreign credential evaluation report. We can only accept foreign credential evaluations from organizations that are members of the National Association of Credential Services (NACES). A list of current NACES members can be found by visiting and clicking the Evaluation Services Link.
For additional information on foreign education credentials, please visit and click on Other Information.
You must attach your documentation prior to the submission of your application by using the "Attachments" tab on the left. You will not be able to add a document to the application after it has been submitted.
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. You must complete the application and answer the supplemental questions. Resumes, cover letters, and similar documents will not be 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 our
WORK BEHAVIOR 1 - DATABASE CREATION AND TESTING
Develops and maintains data models. Creates and tests physical databases characterized by complex system architecture including the database storage structures and database objects. Ensures that appropriate relationships exist and that indexes are established to provide processing efficiency.
Levels of Performance
Select the Level of Performance that best describes your claim.
In the text box below, please describe your experience as it relates to the level of performance you claimed in this work behavior. Please be sure your response addresses the items listed below which relate to your claim. If you indicated you have no work experience related to this work behavior, type N / A in the box below.
If you have selected the level of performance pertaining to college coursework, please provide your responses to the three items listed below. If you indicated you have no education / training related to this work behavior, type N / A in the text box below.
WORK BEHAVIOR 2 - DATABASE MONITORING AND OPTIMIZATION
Monitors database performance using a system of diagnostic reports. Evaluates and recommends database management technology such as database management systems, database monitoring and tuning tools, and database gateways. Researches the technological advances pertaining to the database environment and proposes or performs installations and upgrades to new versions and products.
Levels of Performance
Select the Level of Performance that best describes your claim.
In the text box below, please describe your experience as it relates to the level of performance you claimed in this work behavior. Please be sure your response addresses the items listed below which relate to your claim. If you indicated you have no work experience related to this work behavior, type N / A in the box below.
If you have selected the level of performance pertaining to college coursework, please provide your responses to the three items listed below. If you indicated you have no education / training related to this work behavior, type N / A in the text box below.
WORK BEHAVIOR 3 - TECHNICAL ASSISTANCE
Troubleshoots and resolves database issues. Responds to escalated incidents by diagnosing and troubleshooting issues and works with end users and service providers to resolve issues. Provides guidance to users, managers, and other information technology professionals in database planning, design, implementation, operation, security, quality assurance, and data administration.
Levels of Performance
Select the Level of Performance that best describes your claim.
In the text box below, please describe your experience as it relates to the level of performance you claimed in this work behavior. Please be sure your response addresses the items listed below which relate to your claim. If you indicated you have no work experience related to this work behavior, type N / A in the box below.
If you have selected the level of performance pertaining to college coursework, please provide your responses to the three items listed below. If you indicated you have no education / training related to this work behavior, type N / A in the text box below.
WORK BEHAVIOR 4 - SECURITY
Establishes standards to ensure adherence with established security policies and recommends changes as needed. Processes all security requests for access to application systems and any other pertinent database schemas. Researches current security solutions and informs management of emerging technologies.
Levels of Performance
Select the Level of Performance that best describes your claim.
In the text box below, please describe your experience as it relates to the level of performance you claimed in this work behavior. Please be sure your response addresses the items listed below which relate to your claim. If you indicated you have no work experience related to this work behavior, type N / A in the box below.
If you have selected the level of performance pertaining to college coursework, please provide your responses to the three items listed below. If you indicated you have no education / training related to this work behavior, type N / A in the text box below.
WORK BEHAVIOR 5 - WRITTEN COMMUNICATION
Prepares written, technical, or narrative documents such as migration plans, test script materials, data dictionaries and user acceptance documents and plans. Maintains activity logs and installation, implementation, and user documentation and identifies and reports recurring system issue patterns and the corrective action taken.
Levels of Performance
Select the Level of Performance that best describes your claim.
In the text box below, please describe your experience as it relates to the level of performance you claimed in this work behavior. Please be sure your response addresses the items listed below which relate to your claim. If you indicated you have no work experience related to this work behavior, type N / A in the box below.
If you have selected the level of performance pertaining to college coursework, please provide your responses to the three items listed below. If you indicated you have no education / training related to this work behavior, type N / A in the text box below.
Required Question
Salary : $75,678 - $114,915
