SQL Server DBA-Locals

SQL Server, T-SQL, SSIS, ETL, Azure, Microsoft Entra, backup and restore mechanisms, Windows Failover Cluster Service, Power Shell, Always On Availability Groups, Log Shipping, database replication, Redgate

11/16/2026 - 06/30/2027

Initiallyremotebuteventuallymaybein-officeat
1221

Mc Kinley Avenue ,Columbus Ohio.

Database Maintenance&Configuration:

Install,configure,patch,andupgradeSQLServerinstancesacrossproduction,staging,anddevelopmentenvironments.

Manageserverstorage,systemdatabases,anddatafilestructures.

Performance Monitoring&Tuning:

Proactivelymonitorsystemhealth,resource allocation,andservermetrics.

Optimizedatabaseperformancebywritingorrefiningindexes,tuningcomplexqueries,andresolvingblockingordeadlockissues.

Backup&Disaster Recovery:

Design,test,andexecutereliabledatabasebackupandrecoverypolicies.

Implement High Availability (HA) andDisaster

Recovery(DR) solutions,suchas

Always On Availability Groups ,Log Shipping,Failover Cluster Instances ,ordatabasereplication.

PerformperformancetuningandsystemconfigurationacrossmultipleDBMSplatforms.

Throughouttheapplicationlifecycle,collaboratewithITdevelopmentstafftodesignDBMSarchitectureandestablishstandardsfordataexchange,includingrobustdatasecuritymodels.

Applyanunderstandingofbusinessintelligenceconceptswhendevelopingstandardsandbestpractices.

Createcomprehensivedocumentationcoveringinstallationprocedures,monitoring,security policies,configuration changes,migrationprocesses,andbestpracticesfordevelopmentteams.

Workcloselywiththe State Chief Information Security Officertoimplementandenforcesecuritystandardsestablishedbythe Stateof Ohioandthe Ohio Department of Rehabilitation and Correction .

Developer Support&Code Review:

Assistdevelopmentteamswithschemarefinement,tabledesign,efficientdatatypeselection,andcodereviewsforstoredprocedures,triggers,functions,andcomplexT-SQL queries.

TheSQLServerDBAprovidesserveradministrationfor

MicrosoftSQLServerdatabaseproducts.

TheDBA3willberesponsibleforimplementing,configuring,maintaining,andensuringtheperformanceandavailabilityofSQLServersystemstokeepcorporateapplicationsavailableandrunningsmoothly.

Soft Skills:

Sharpanalyticalandtroubleshootingskills,strongattentiontodetail,andtheabilitytoexplaincomplexdatabaseissuestonon-technical stakeholders.

Regularlymonitorsandfine-tunesDBMSperformancetooptimizeefficiencyandreliability.

CollaboratescloselywithITArchitecturestaff,theChief Information Officer ,andITManagerstodevisesolutionsthatfulfillagencyrequirements.

Contributestotheanalysisanddevelopmentofthesolutiondesign’sbusinesscase,authoringrelevantsectionstosupportdecision-making.

Handlescomplextechnicalchallengesbyproviding

TierIIIresolutionforcriticalissues,reinforcingsystemstabilityandcontinuity.

Developsdatabasestrategiestomeetbusinessneedsandappliesprojectplanningprinciples,theories,practices,and techniques.

Conductsformalmentorshipactivitiesforpeersandlower-level staff,providingguidancethroughverbalinstructionortechnicaldocumentation.

Whenassigned,servesasamemberofa

Disaster

Recovery/Business Resumption Team ,Incident Response Team ,orsimilarpublichealthresponseteam,whichmayrequire
24/7operationsatremotelocations.

Experience:

5+yearsofdedicatedhands-onexperiencemanagingenterprise-level

MicrosoftSQLServerdatabaseenvironments,including on-premise sand

Azure-based platforms.

Advancedcommandof Transact-SQL(T-SQL) languagesyntax.

Hands-onfamiliaritywiththird-partymonitoringandbackuptools,suchas

Redgate.

College degree Required4

Years

Performance Monitoring&Tuning Required5

Years

Required5

Years

Developer Support&Code Review Required5

Years

dedicatedhands-onexperiencemanagingenterprise-level

MicrosoftSQLServerdatabaseenvironments,including on-premise sand

Azure-based platforms.

Required5

Years