Database Administrator - onsite Columbus, OH

Job Title: Dcr-Database Administrator 4(DBA4)Job Type: FT ContractContract Duration: 6 monthsIndustry: State Gov'tCity: ColumbusState/Province: OhioCountry: United StatesAssigned Recruiter(s): Ananth VegirajuNumber of Positions: 1Job DescriptionDatabase Maintenance & Configuration: Install, configure, patch, and upgrade SQL Server instances across production, staging, and development environments.

Manage server storage, system databases, and data file structures.Performance Monitoring & Tuning: Proactively monitor system health, resource allocation, and server metrics.

Optimize database performance by writing or refining indexes, tuning complex queries, and resolving blocking or deadlock issues.Backup & Disaster Recovery: Design, test, and execute reliable database backup and recovery policies.

Implement High Availability (HA) and Disaster Recovery (DR) solutions, such as Always On Availability Groups, Log Shipping, Failover Cluster Instances, or database replication.Automation & Scripting: Write T-SQL, PowerShell, or command-line scripts to automate routine DBA maintenance tasks, including index maintenance, integrity checks, statistics updates, backups, monitoring, and reporting.Security & Compliance: Implement strict role-based access control (RBAC), manage user logins and database permissions, and configure encryption at rest and in transit to maintain data integrity and regulatory compliance.Developer Support & Code Review: Assist development teams with schema refinement, table design, efficient data type selection, and code reviews for stored procedures, triggers, functions, and complex T-SQL queries.Soft Skills: Sharp analytical and troubleshooting skills, strong attention to detail, and the ability to explain complex database issues to non-technical stakeholders.Education: Bachelor's degree in Computer Science, Information Technology, or an equivalent technical field, or equivalent work experience.Experience: 5+ years of dedicated hands-on experience managing enterprise-level Microsoft SQL Server database environments, including on-premises and Azure-based platforms.Technical Proficiencies: Deep expertise in SQL Server Management Studio (SSMS) and underlying database internals.

Advanced command of Transact-SQL (T-SQL) language syntax.

Experience implementing SQL Server Integration Services (SSIS) packages and Extract, Transform, Load (ETL) workflows.

Experience supporting Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.

Knowledge of Azure Monitor, Log Analytics, Microsoft Entra ID, Azure Key Vault, Azure Backup, and Azure role-based access control.

Experience migrating and integrating databases between on-premises SQL Server and Azure environments.

Understanding of Azure database security, networking, scalability, cost optimization, and HA/DR capabilities.

Hands-on familiarity with third-party monitoring and backup tools, such as Redgate.