Talent.com
Cloudious LLC
SQL Database Administrator (SQL DBA) – Database Assessment & ModernizationCloudious LLC • Dallas, TX, United States
SQL Database Administrator (SQL DBA) – Database Assessment & Modernization

SQL Database Administrator (SQL DBA) – Database Assessment & Modernization

Cloudious LLC • Dallas, TX, United States
2 days ago
Job type
  • Full-time
  • Quick Apply
Job description

Position - SQL Database Administrator (SQL DBA) Database Assessment & Modernization

Location Dallas or Austin, TX (4 days office / week)

CTH (3 months max) or FTE

Role Overview

We 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 Responsibilities

Database 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:
    • Query performance
    • Wait statistics
    • Resource utilization
    • Index effectiveness
    • Blocking and deadlocks
    • 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:
    • Database maintenance jobs
    • SQL Agent jobs
    • Database consistency checks
    • Capacity management
    • Patch and upgrade management
  • Ensure adherence to operational best practices.

High Availability & Disaster Recovery

  • Assess current HA/DR architecture.
  • Review:
    • Always On Availability Groups
    • Log Shipping
    • Replication
    • Clustering
    • 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:
    • User access controls
    • Authentication mechanisms
    • Encryption practices
    • Auditing and monitoring
    • 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 Skills

SQL Server Administration

  • Microsoft SQL Server (2012/2014/2016/2019/2022)
  • SQL Server Configuration Manager
  • SQL Server Agent
  • Database Maintenance & Administration
  • Installation, Upgrade & Patch Management

Performance Tuning

  • Query Tuning
  • Index Optimization
  • Execution Plan Analysis
  • Performance Monitoring
  • Wait Statistics Analysis
  • Resource Optimization

High Availability & DR

  • Always On Availability Groups
  • Log Shipping
  • Replication
  • Failover Clustering
  • Backup & Recovery Strategies

Monitoring Tools

  • SQL Profiler
  • Extended Events
  • DMVs
  • Performance Monitor
  • SQL Diagnostic Tools

Migration Tools

  • SQL Server Migration Assistant (SSMA)
  • Data Migration Assistant (DMA)
  • Azure Database Migration Service
  • SQL Assessment Tools

Soft 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.
Create a job alert for this search

SQL Database Administrator (SQL DBA) – Database Assessment & Modernization • Dallas, TX, United States

Similar jobs

Database Administrator

TradeJobsWorkForce75379 Dallas, TX, US
Full-time

Responsibility for the evaluation of database software purchases Supervision of modifications to any existing database software to meet the needs of their employer Responsibility for maintaining th... Show more

 • Promoted

Senior Database Administrator - Remote

Motion RecruitmentDallas, TX, United States
Remote
Full-time +1

Our client is looking for a Senior Database Administrator on a 11-month contract in Irving, TX.Join over 20,000 employees at this global company specializing in technology-enabled claims and risk m... Show more

 • Promoted

DB2 Systems Programmer / DBA - 100% Remote

Conexess Group, LLCAllen, TX, United States
Remote
Full-time

Job Title :DB Systems Programmer / DBALocation :% Remote (Must reside in one of the eligible states listed below)Eligible States :Alabama, Arkansas, Florida, Georgia, Iowa, Illinois, Indiana, Kentu... Show more

 • Promoted

Information Technology Professional

US NavyBardwell, TX, US
Full-time

Information Technology Professional (IT/CTN/IS).Information Systems Technicians, Cryptologic Technician Networks, and Intelligence Specialists keep the Fleet connected, informed, and secure by oper... Show more

 • Promoted

Border Patrol Agent (BPA) Entry Level - New Hire Sign-On and Retention Incentives

U.S. Customs and Border ProtectionIke, TX, US
Full-time

Customs and Border Protection Officer (CBPO).Customs and Border Protection (CBP) offers those interested in a career in law enforcement an exceptional opportunity to work with an elite team of high... Show more

 • Promoted • New!

Consumer Research Panel Member

GL IncEnnis, Texas
$15.00 hourly
Part-time +1

Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet... Show more

 • Promoted

Azure Data Architect (Dalas)

1872 ConsultingDallas, TX, United States
Full-time

Our client is a technology-driven organization focused on digital and data transformation across enterprise systems.They are building scalable, cloud-based data platforms to enable analytics, AI, a... Show more

 • Promoted

Restaurant Delivery - Sign Up in Minutes

DoorDashEnnis, TX, United States

DoorDash is the #1 category leader in food delivery, food pickup, and convenience store delivery in the US, trusted by millions of customers every day.As a Dasher, you’ll stay busy with a var... Show more

 • Promoted

Flexible remote AI work. Your schedule. Paid weekly, straight to your bank account.

Meridian.aiEnnis, TX, US
Remote
Full-time

Review and label digital content including text, images, and documents.Every task you complete helps improve how technology interprets information and performs in practical settings.Detail-oriented... Show more

 • Promoted

Product Tester – Remote

OCPAEnnis, Texas, US
$18.00 hourly
Remote
Part-time +1

Product Testers are wanted to work from home in the UK to fulfill upcoming contracts with local and international companies.We guarantee 15-25 hours per week with an hourly pay of between £18/hr.Th... Show more

 • Promoted

Remote Research Panel Participant

GL IncEnnis, Texas
$15.00 hourly
Remote
Part-time +1

Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet... Show more

 • Promoted

Data Entry Product Support - $45 per hour - No Experience

GL Inc.Ennis, Texas
$45.00 hourly
Part-time +1

Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet... Show more

 • Promoted

Risk Management with Hyperion Essbase)

SonSoft Inc.Plano, TX, United States
Full-time

Risk Management With Hyperion Essbase.USA based corporation duly organized under the laws of the Commonwealth of Georgia.Software Development, Software Consultancy and Information Technology Enable... Show more

 • Promoted

SQL DBA - Remote TX

ConnectionDallas, TX, United States
Remote
Full-time

Connection Services is seeking a Network Engineer to join our Technical Staffing Division for a contract to hire opportunity working remotely from Texas only.This is a contract to hire opportunity ... Show more

 • Promoted

Medical Billing and Coding - Entry Level Training Program

Dreambound Inc.Ennis, Texas, US
Full-time

Note : This is an educational program, not a job.Successful completion of the program does not guarantee employment but will equip you with valuable skills for the healthcare job market.Looking to ... Show more

 • Promoted

Senior Data Platform Architect - Remote

Gandiva InsightsDallas, TX, United States
Remote
Full-time

Role :Senior Data Platform Architect (AWS) Remote Only W2 NO C2C Description and Requirements:The Platform Architect leads and implements best-in-class data management strategies and practices in s... Show more

 • Promoted

Remote Product Tester

OCPAEnnis, Texas, US
$18.00 hourly
Remote
Part-time +1

Product Testers are wanted to work from home in the UK to fulfill upcoming contracts with local and international companies.We guarantee 15-25 hours per week with an hourly pay of between £18/hr.Th... Show more

 • Promoted

Remote Data Scientist

Micro1Ennis, Texas, US
$65.00 hourly
Remote
Full-time

AI data lab for training frontier models and evaluating AI agents.Experts contribute their diverse subject matter knowledge across domains such as finance, healthcare, STEM engineering, and more.AI... Show more

 • Promoted

BA with Data Integration

ApolisDallas, TX, United States
Full-time

Experience Required: 8 years overall.Business Analyst (BA) and 4+ years of experience in Healthcare.Sound knowledge of Healthcare and BA work experience especially with Data Integration is mandator... Show more

 • Promoted

Data Entry Product Support - No Experience

GLOCPAEnnis, Texas
$15.00 hourly
Part-time +1

Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet... Show more