Database Administrator and SQL Programmer

Title: Database Administrator and SQL Programmer

State Role Title:Info Technology Specialist I

Hiring Range: Up to $90,000

Pay Band: 4

Agency: Dept of Rail & Public Trans

Location:Dept of Rail & Public Trans

Agency Website:;br>
Recruitment Type: General Public - G

Job Duties

The Department of Rail and Public Transportation (DRPT) is currently seeking a qualified individual to fill the position of Database Administrator and SQL Programmer. This position will be responsible for providing web application and database application support services for the agency. Specifically, the Database Administrator and SQL Programmer will be responsible for, but not limited to, database administration, development and maintenance; data analysis and visualization; website and application maintenance, and end user support. As a small Agency with a big impact, team members often perform a variety of duties in order to successfully accomplish our mission. AT DRPT, you won't get lost in the crowd, if you are open to continual learning and being flexible in bringing solutions to challenges this could be a great opportunity for you!

The Department of Rail and Public Transportation offers a generous total compensation package. Well qualified candidates will be eligible to negotiate Exceptional Recruitment Incentives. New external candidates of the Commonwealth will be eligible to negotiate cash and leave bonuses upon hire. Existing State employees will be eligible to negotiate leave bonuses upon hire.

Minimum Qualifications

Progressively responsible experience with Microsoft SQL Server, including expertise in SQL Server Reporting Services (SSRS)
Development experience in building, deploying, and supporting applications using .NET Standard 4.8+ and Visual Basic
Experience with Microsoft Power Platform, including Power Applications and Data Analysis Expressions (DAX)
Strong ability to translate formal requirements documentation into effective database and application modules
Skilled in maintaining and updating code written by other internal developers
Effective oral and written communication skills
Occasional daytime travel required

Additional Considerations

Proficient in Microsoft Visual Studio
Capable of working independently and collaboratively within a team environment
Demonstrated ability to adapt to new systems and procedures rapidly
Experience with backup and recovery technologies for databases
Experience in server and system administration, ensuring optimal performance, security, and reliability
Experience with grant management, transportation or finance applications
Experience with managing WordPress websites and collaborating with developers, designers, and content creators
Knowledge of website security practices and tools, familiarity with SEO best practices, Siteimprove, and Website analytics

Special Instructions

You will be provided a confirmation of receipt when your application and/or rsum is submitted successfully. Please refer to "Your Application" in your account to check the status of your application for this position.

Contact Information

Name: Debbie Barnett

Phone:

Email:

In support of the Commonwealth's commitment to inclusion, we are encouraging individuals with disabilities to apply through the Commonwealth Alternative Hiring Process. To be considered for this opportunity, applicants will need to provide their AHP Letter (formerly COD) provided by the Department for Aging & Rehabilitative Services (DARS), or the Department for the Blind & Vision Impaired (DBVI). Service-Connected Veterans are encouraged to answer Veteran status questions and submit their disability documentation, if applicable, to DARS/DBVI to get their AHP Letter. Requesting an AHP Letter can be found at AHP Letter or by calling DARS at .

Note: Applicants who received a Certificate of Disability from DARS or DBVI dated between April 1, 2022- February 29, 2024, can still use that COD as applicable documentation for the Alternative Hiring Process.