Database Administrator

Stellar Professionals

Richmond, VA, United States

11 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Query Performance ASP.NET JavaScript (Programming Language) .NET Framework Ajax (Programming Language) HTML5 C Sharp (Programming Language) Cascading Style Sheets (CSS) Computer Programming Databases System Configuration Database Applications

+15 more

Software Debugging JSON JQuery Microsoft SQL Server Visual Basic .NET (Programming Language) Server Administration Server Supported Gaming Service Pack Microsoft SharePoint SQL Stored Procedures SQL Server Reporting Services Transact-SQL Performance Monitor SQL Server Management Studio (SSMS) Powerapps

Job description

We are seeking a versatile Database Administrator to join the Department of Rail and Public Transportation (DRPT) in Richmond, VA. Serving as an Assistant Agency DBA, this role is responsible for providing core database administration, managing Microsoft SQL Server environments, maintaining SSRS reports, executing T-SQL programming, and offering full application and server support across agency project teams., * SQL Server Administration & Support: Manage Microsoft SQL Server instances, execute administrative maintenance, optimize query performance, and ensure database availability and security.

T-SQL & Reporting: Program complex T-SQL scripts, stored procedures, and triggers; design, deploy, and support enterprise reports using SQL Server Reporting Services (SSRS).
Application & Code Maintenance: Maintain, debug, and upgrade existing database applications and legacy code written by internal developers.
Server & System Administration: Assist IT project managers with server maintenance, system configuration, performance monitoring, and security patching.
End-User & Project Support: Provide technical troubleshooting, investigate operational issues, translate requirements into database schemas, and interface with external agencies.

Requirements

Database Administration: Progressively responsible experience with Microsoft SQL Server management, configuration, and maintenance.
SSRS & T-SQL: Hands-on expertise in developing SSRS reports and writing/optimizing T-SQL queries and procedures.
Code Maintenance & Troubleshooting: Proven capability to review, update, and maintain source code developed by third parties or legacy teams.
End-User Support: Experience delivering technical support, resolving database/application incidents, and troubleshooting user issues.
Communication & Collaboration: Excellent oral and written communication skills with the ability to work independently or within cross-functional project teams., * Development Stack: Experience building and supporting applications with .NET (4.8+), ASP.NET (C# / VB.NET), HTML5, JavaScript, jQuery, CSS, and AJAX/JSON.
Microsoft Power Platform & SharePoint: Experience creating Power Apps, working with DAX queries, and managing SharePoint integrations.
Public Sector / VITA Experience: Prior experience with Commonwealth of Virginia IT standards, VITA policies, or public sector transport agencies.