SQL Database Administrator
Position - SQL Database Administrator (SQL DBA) – Database Assessment & ModernizationLocation – Dallas or Austin, TX (4 days office / week) Role OverviewWe are looking for an experienced SQL DBA to support SQL Database Assessment and Modernization initiatives. The candidate will be responsible for assessing existing SQL Server environments, analyzing database performance, availability, security, backup and recovery mechanisms, and identifying modernization opportunities.The role requires strong expertise in SQL Server administration, database performance tuning, troubleshooting, migration planning, and operational health assessment. Key ResponsibilitiesDatabase Assessment· Conduct comprehensive assessment of SQL Server environments.· Review database inventory, versions, configurations, and infrastructure dependencies.· Analyze database usage patterns, workloads, and growth trends.· Assess database operational maturity and support processes.· Evaluate database architecture for scalability, reliability, and maintainability.· Prepare database assessment findings and recommendations. Performance Analysis & Optimization· Perform database performance assessment.· Analyze:o Query performanceo Wait statisticso Resource utilizationo Index effectivenesso Blocking and deadlockso Execution plans· Identify performance bottlenecks and optimization opportunities.· Recommend tuning strategies for improved response time and throughput. Database Administration· Review SQL Server administration practices and standards.· Assess:o Database maintenance jobso SQL Agent jobso Database consistency checkso Capacity managemento Patch and upgrade management· Ensure adherence to operational best practices. High Availability & Disaster Recovery· Assess current HA/DR architecture.· Review:o Always On Availability Groupso Log Shippingo Replicationo Clusteringo Failover strategies· Validate Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO).· Recommend resiliency improvements. Backup & Recovery Assessment· Review backup strategies and retention policies.· Validate recovery testing procedures.· Assess disaster recovery readiness.· Identify gaps and risks in backup and recovery frameworks. Security & Compliance· Audit database security configurations.· Review:o User access controlso Authentication mechanismso Encryption practiceso Auditing and monitoringo Compliance requirements· Recommend security improvements and governance controls. Monitoring & Automation· Review database monitoring tools and alert mechanisms.· Assess automation opportunities for administrative tasks.· Recommend operational efficiency improvements.Key Deliverables· SQL Server Assessment Report· Database Inventory Report· Performance Assessment Report· Security Assessment Report· HA/DR Assessment Report· Backup & Recovery Assessment Report· Migration Readiness Assessment· Risk & Dependency Matrix· Database Modernization Recommendations· Effort Estimation & Roadmap Required Technical SkillsSQL Server Administration· Microsoft SQL Server (2012/2014/2016/2019/2022)· SQL Server Configuration Manager· SQL Server Agent· Database Maintenance & Administration· Installation, Upgrade & Patch ManagementPerformance Tuning· Query Tuning· Index Optimization· Execution Plan Analysis· Performance Monitoring· Wait Statistics Analysis· Resource OptimizationHigh Availability & DR· Always On Availability Groups· Log Shipping· Replication· Failover Clustering· Backup & Recovery StrategiesMonitoring Tools· SQL Profiler· Extended Events· DMVs· Performance Monitor· SQL Diagnostic ToolsMigration Tools· SQL Server Migration Assistant (SSMA)· Data Migration Assistant (DMA)· Azure Database Migration Service· SQL Assessment ToolsSoft Skills· Strong analytical and troubleshooting abilities.· Excellent stakeholder communication skills.· Ability to conduct assessment workshops with customers.· Strong documentation and reporting skills.Ability to work independently in customer-facing engagements.