Job description

Title: Database Administrator (Hybrid Schedule) State Role Title:Salary Non-Specified Hiring Range: $114,000 - $120,000 Pay Band: UG Agency: Virginia Retirement System Location:Virginia Retirement System Agency Website:www.varetire.org/careers Recruitment Type: General Public - G Job Duties The Virginia Retirement System (VRS) is seeking a skilled Database Administrator to oversee the daily operations of the SQL Database Servers in VRS, ensuring their installation, maintenance, upgrades, and overall management. This role is crucial for maintaining the security, integrity, performance, and availability of all agency data. Additionally, this role develops and implements database administration procedures, standards, and guidelines and is responsible for updating, modifying, and removing data in accordance with VRS policies, while ensuring adherence to backup protocols. Essential functions include but are not limited to: • Participates in the design, development and implementation of databases, often leveraging new technologies. • Installations and configures of SQL Server 2016, 2019 and SQL 2022 in clustered environments. • Administers databases running on SQL Server clusters, SQL Always On platforms, including the latest versions (SQL 2016, 2019 & 2022). • Ensures compliance with industry regulations and best practices related to data security and privacy. • Monitors and maintains the effective operation of databases and servers. • Provides production support for SQL databases as required. • Performs daily data fixes and refreshes, managing and completing ad-hoc database requests. • Refreshes the Lower Environment, ensuring data cleanliness. • Implements and manages database backup and recovery strategies to maintain data integrity and availability. • Conducts data scrambling in compliance with all relevant policies and procedures. • Collaborates with cross-hierarchal teams to enhance services across agency lines. • Works effectively with all levels of management and staff to improve processes and procedures. • Participates in Disaster Recovery exercises and documents procedures. • Provides other technical support and completes special projects and tasks as required. • Participates in on-call rotations. Minimum Qualifications Bachelor's Degree in Computer Science or a related field. Four (4) years of experience working with MS SQL Server 2016, 2019 and 2022 on Windows Servers or an equivalent combination of education and experience. Excellent database skills and the ability to manage the day-to-day operations of the database. Demonstrated project management, troubleshooting, analytical, problem resolution, and customer service skills. Abilities to effectively communicate; prioritize; deal with multiple priorities and activities simultaneously; work in a team environment. Excellent database administration skills and a good working experience of MS SQL Server including Clustering, Always on Availability Groups, SSIS & SSRS. Working knowledge of Rubrik Backups, PostgreSQL, MySQL, Microsoft Azure SQL Database, AWS Redis, Mongo DB, etc. Demonstrated experience with Data modeling, SQL scripting and Powershell. Experience in DB Provisioning, Migrations, Monitoring and Performance tuning . Experience with SQL Maintenance tools/applications (such as Idera monitoring tools). Additional Considerations MS SQL Server, Azure certification is preferred. Special Instructions VRS is unable to provide sponsorship for this position now or in the future. Applicants must have authorization to work in the United States without the need for sponsorship now or in the future. The current hybrid schedule for technology employees is 3 days onsite (Tuesday, Wednesday and Thursday) and 2 days remote (Monday and Friday). All employees must be able to work the current hybrid schedule and report to the office as needed on designated remote days. You will be provided a confirmation of receipt when your application and/or résumé is submitted successfully. Please refer to "Your Application" in your account to check the status of your application for this position. Contact Information Name: Human Resources Email: careers@varetire.org 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 800-552-5019. 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.

Requirements