Job Description
Job Title: Senior SQL Database Administrator Location: Little Rock, AR, USA
Mode: Onsite
Hourly pay: $30/hr
Experience: 5 - 7 years
Overview:
This is a Senior SQL Database Administrator role responsible for end-to-end administration of SQL Server 2016/2022 and later, including installation, upgrades, patching, maintenance, security, auditing, backup/recovery, and disaster recovery to meet RPO/RTO. The role requires strong expertise in T‑SQL, performance tuning, ETL, SQL Server native tools like Profiler, Extended Events, DMVs, Always On, Linked Servers, and managing VLDBs and high‑transactional systems. You will also handle Windows Server Administration, including building/maintaining Windows Servers & EC2 instances, Failover Clustering (WFCS), PowerShell scripting, endpoint protection, and storage management on AWS. Additional responsibilities include capacity planning, encryption, managing .NET components, web/app/file servers, and providing 24‑hour support for critical systems. Preferred skills include GenTax/FAST architecture, cloud, firewall, Active Directory, and security standards like PUB1075/FIPS/PII.
Job Responsibilities:
- Overseesthedesign,development,andmaintenanceofASP.NETWebFormsapplications
- Maintainandenhanceexistingcode
- Performandparticipateindesignandcodereview
- Identifyrisksandmakerecommendationsforbestpractices
- Meetswithandmanagesexpectationsofkeystakeholders
Required Skills:
- SENIORSQLDatabaseAdministratorSkillsandExperience(4Years)
- SQLDatabaseadministration(seesub-bulletsinJD)SQLServer2016orlater(4Years)
- WindowsServerAdministrationexperience(seesub-bulletsinJD)(3Years)
- Certifications
- 24hrSupport
- SQLServer2022(orlaterversions)databaseadministration:
- InstallingandupgradingSQLServers,includingapplyingservicepacks,cumulativeupdates
- Performingroutinedatabasemaintenance
- KnowledgeofSQLServerAgentandjobs
- Monitoringerrorlogsandeventlogsfordatabaseerrorsandwarnings
- SQLServernativetoolsandservices
- SQLServerProfiler
- IndexTuningAdvisor
- SQLServerConfigurationManager
- ExtendedEvents
- PerformanceMonitor
- DynamicManagementView
- SQLServerBrokerService
- LinkedServers
- MSDTC
- SQLServerSystemDatabasesknowledge
- SQLServerHealthChecksandPolicies
- ManagingSQLServersecurityandauditing
- Usersecurity
- Authenticationmethods
- SQLServeranddatabaseauditing
- Encryptionatrest,transit,andbackup
- CapacityPlanningforstorageanddatabaseobjects
- MaintainingandmanagingSQLServerdiskstorageandexperiencewithAWSstoragesystemstoensurestorageisproperlyutilized
- ManagingdiskstorageforWindowsFailoverClusterService(WFCS)
- Databasebackupandrecovery
- Establishingstandardsandschedulesfordatabasebackups
- DevelopingrecoveryprocedurestomeetRPOandRTO
- Restoringdatabaseswithpointintimerecovery
- CreatingandtestingDisasterRecoveryplans
- ProficientinTSQLcoding,tuning,andETLmethodologies
- SQLServerHighAvailabilityMethods
- ExperiencewithVLDB
- Experiencemonitoring,supporting,troubleshootinghighintensesystemswithbothonlinetransactionsandbatchtransactions
- AlwaysOnandAWSHAZones
- WindowsServerAdministrationexperience:
- BuildingandmaintainingWindowsServersandEC2Instances
- Installingandmanagingendpointprotection
- ApplicationServer,WebServer,FileServer,andFTPServerconfigurationandmaintenance
- UtilizingPowerShellforadministrationtasks
- WindowsFailoverClusterconfigurationandmaintenance
- WindowsServerRolesandFeatures
- .NETFrameworkComponents
Preferred Skills:
- GenTaxSoftwareApplicationarchitectureandapplicationmaintenance
- ExperiencewithFASTGenTax/DS-VSarchitectureandapplicationmaintenance
- Familiaritywithindustrysecuritystandards(PUB1075,FIPS,andPII)
- Cloudcomputingknowledge
- Cloudstorage,backup,andrestoremechanisms
- Firewalladministrationandmaintenance
- ActiveDirectoryknowledge(GPO,FQDN,DNSServer,SPN)
- Email,SMTP,andProxyServertroubleshooting
- WebServicesdevelopmentandsupport
- Availabilitytoprovide24hoursupport
- Strongcommunicationskills,bothoralandwritten