Are you Richmond R.E.A.D.Y? Respect. Equity. Accountability. Diversity… You!!! Join the City of Richmond Police Department as a SQL Server Relational Database Administrator (DBA) in the Information Services unit. This "hands-on" position involves implementing, configuring, and maintaining critical RDBMS systems to ensure the Department’s application availability and performance. The DBA will work independently and collaboratively to support various in-house and commercial off-the-shelf (COTS) applications.

Key Responsibilities:

• Installing, configuring, and maintaining database servers and Relational Database (RDBMS) software.
• Conducting database maintenance, monitoring, backup, recovery, and patching.
• Deploying database schema updates and executing data loads.
• Providing backup, recovery services, managing file systems and disk space.
• Recommending and implementing system enhancements to improve performance and reliability.
• Writing and editing queries, as well as automated jobs for data import/export.
• Developing and documenting technical processes and procedures.
• Collaborating with developers on database changes and translating business requirements into system requirements.
• Interacting with users, troubleshooting issues, and reporting project status.

Qualifications:

• Knowledge, Skills & Abilities: Advanced technical skills in SQL code reviews, data security, data modeling, and system design. Proficiency in Microsoft Office Suite, Visual Studio, SQL Server, IIS web server, ERP, etc. Excellent problem-solving, multitasking, communication, organizational, and team player skills.
• Experience Required: Developing back-end code in C#, .NET, HTML, CSS, IIS, Git/DevOps version control, MSSQL relational databases, stored procedures, triggers, functions, database normalization, web services, Visual Studio, SQL Management Studio.
• Minimum Training and Experience: Associate's degree in computer science or related field, with three years of maintenance, troubleshooting, and repair experience. Bachelor's degree in computer science preferred. Equivalent training and experience may be considered.

Licensing, Certifications, and Special Requirements:

• Some positions may require a valid Driver's License and a Commonwealth of Virginia Driver's License within 30 days of hire.
• Incumbents assigned to telecommunications systems may require an FCC General Radiotelephone Operator License (GROL) within one year of hire. Specific agency requirements may apply.

Preferred:

• 5-10 years of experience in SQL Server Relational Databases.
• Advanced knowledge of database structures, data modeling, systems design, big data systems, SQL Server monitoring, backup, disaster recovery, and programming/scripting languages.