SQL Database Administrator (SQL DBA) - Database Assessment & Modernization
Full-time
Cloudious LLC
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.
Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the SQL Database Administrator (SQL DBA) - Database Assessment & Modernization in Dallas, TX vacancy
- ...Hi , Our client is looking for an SQL DBA - Database Assessment & Modernization for a project and below is the detailed requirement. Job... ...years of hands-on experience in SQL Server Database Administration. ~ Strong expertise in Microsoft SQL Server 2012...SuggestedFull time
Lorven technologies
Dallas, TX2 days ago - ...Data Architect SQL Database Assessment & Modernization Location Dallas or Austin, TX (4 days office / week)...SuggestedFull timeWork at office
Arkhya Tech Inc
Dallas, TX2 days ago - ...SQL Database Administrator (DBA) A Few Words About Us Integrated Resources, Inc is a premier staffing firm recognized as one of the tri-states most well-respected professional specialty firms. IRI has built its reputation on excellent service and integrity since its...SuggestedWork experience placement
Integrated Resources
Irving, TX2 days ago - ...Job Title: Sr DBA Admin - SQL Server DBA Work Location... ...duration: 12 months Skill: Database Admin Detailed Job Description: Database Administrator with general DBA experience... ...Communicate with stake holders to assess Oracle databases and host decommission...SuggestedContract workRemote work
APN Healthcare Solutions
Richardson, TX1 day ago - MV Transportation is seeking a Database Administrator to support the corporate database environment within... ...role involves setup and management of SQL Server maintenance plans, monitoring... ...communication skills, with 1 year of DBA-like tasks and 2+ years IT experience....SuggestedWork at office
$99k - $116k
...transformation by driving core modernization holistically across... .... Job Title: SQL Server Admin Responsibilities... ...data between SQL databases and NON-SQL databases... ...support is rotated among DBA's in US, UK and India... ...- SQL Server & Cloud administration required skills. Senior...Temporary workLocal areaRelocationWeekend work$49 - $70 per hour
...enterprise-scale Java microservices and modernization programs. This role combines... ...compute, storage, identity, monitoring, database, messaging, and container services.Containerize... ....Contribute to interviewing, technical assessment, onboarding, capability development, and...Contract work- ...Services.Job DescriptionJob Description:-9+ Yrs experience in SQL Server DBA ActivitiesDatabase software Installation and Configuration in... ...standardsDatabase Migrations and UpdatesApplication of database patchesCapacity managementHands on experience in Server Performance...
- ...Job title: Database Administrator Work Location: Richardson,TX 75080 Database... ...Administrator with general DBA experience and Project Management... ...DBA support to Oracle, SQL Server through onpremises and... ...Communicate with stake holders to assess Oracle databases and host...Remote workRelocation
Diverse Lynx
Richardson, TX5 days ago - ...hardware, software and configurations necessary for running SQL server in an optimal fashionPerforms SQL database installation, configuration, patching and upgrades in... ...applications and will provide support to the on call DBA as neededProvide 24x7 support and participate in on-...
$125.76k - $188.64k
...allocating work as necessaryAppropriately assess risk when business decisions are made,... ...technologies.Advanced knowledge of Oracle Database design, performance tuning, and optimization... ...through AI-assisted engineering and modern coding practices while maintaining quality...Full timeFor contractors$50 per hour
...SQL Server DBA Location: SFO or Dallas, Texas Type: In-person (F2F) Hourly Rate: $50 Role Summary: Responsible for end-to-... ...engineering principles into development processes. Support modernization efforts, collaborate across teams, and proactively identify...Hourly payArgyle Infotech
Dallas, TX5 days ago- ...Implement and manage database replication, CDC, Always On, WFC, and high-availability solutions for continuous operation and disaster recovery. • Design, implement, and maintain SQL and Azure database solutions aligned with organizational requirements and industry best...
United IT Solutions
Irving, TX5 days ago $36k - $194.35k
...architecture - Oracle and MS SQL Server in particular, API/distributed... ...across:o Distributed Oracle databases (CCH & CSH)o Ensure seamless... ...legacy (mainframe) and modern (distributed) platforms.o Collaborate... ....Participates in the assessment of software defects discovered...Full timeTemporary workPart timeWork experience placementWork at office- ...SQL Database Admin Hybrid Onsite - Minneapolis, MN; Atlanta, GA; Chicago, IL; Dallas, TX; San Francisco, CA (3 days/week onsite) Contract... ...another Qualifications: ~7+ years of experience as a DBA ~ Extensive experience with SQL Server ~ Strong...Contract work3 days per week
My3Tech Inc
Dallas, TX5 days ago - ...position. ** Strong expertise in relational databases including IBM Db2 (z/OS), Oracle (RAC, EC... ...and PostgreSQL Hands‑on experience with modern distributed and cloud-native databases... ...work across multiple database technologies (SQL and NoSQL) in complex environments...Local area
- ...SQL Database AdministratorThis role is essential in safeguarding and recovering critical data in the event of system failures. Essential... ...competencies include:Proven experience as a SQL Database Administrator with a focus on backup and restore operations.Strong expertise...
Omni Inclusive
Dallas, TX1 day ago $107.12k - $160.68k
...development lifecycle, from feasibility assessment and technical planning through to construction... ...strong command of Oracle PL/SQL for database development.Demonstrated ability to... ...Exposure to cutting-edge technologies and modern engineering practices, including AI-assisted...Full timeWork at officeRemote workShift work- ...Role: SQL Server DBA Location: Dallas, TX Type: Contract Summary :... ...and needs to address challenges with database performance, data quality, and stability... ...DBA Skills: SQL Server 2016-2022 administration Query tuning, indexing, and performance...Contract workLocal area
VBeyond
Dallas, TX5 days ago $60k - $65k
Tech Mahindra is seeking a Junior L2 Database Administrator (DBA) for MS SQL Server in a 24/7 support role. Location is Dallas, TX and Atlanta, GA with Day 1 onsite requirement. Minimum Bachelor’s degree; 3-5 years of experience in SQL Server environments and related duties...$99k - $116k
...technology firm is seeking an experienced SQL Server Admin for a hybrid role based in... ...experience in SQL Server & Cloud administration, strong communication skills, and the ability... ...Responsibilities include integrating SQL and NON-SQL databases, supporting application migrations, and...$67.5k - $172.5k
...(OpenAPI/Swagger)• Integrate APIs with databases and third-party services• Optimize API performance... ..., and documentation of software.Applies modern principles, methodologies and tools to... ...customer solutions.Managing Risk - Assessing and effectively managing all of the...Full timeTemporary workPart timeWork experience placementWork at office- ...with innovative solutions and technologies. Candidates should have extensive IT experience, particularly with Java, modern web frameworks, and database management. The position plays a vital role in ensuring compliance with strategic programs and regulatory requirements...
- JW Affinity IT in Dallas, TX seeks an experienced SQL Database Administrator to manage SQL Server, MSBI apps, BI reporting, and ETL processes across production, development, UAT, and test environments. The role focuses on implementing ETL design, monitoring jobs, backups...Flexible hours
$110k - $120k
...Data Architect (Oracle DBA + Data Modeling) We... ...develop solutions for modernization, from Artificial Intelligence... ...strong expertise in database architecture,... ...design, and database administration. The ideal candidate will... ...Reporting Layer Design SQL Performance Tuning Query...Temporary workFlexible hours- ...Global Bridge InfoTech Inc) We are looking for an experienced Database Administrator (DBA) with deep expertise in Postgres, MongoDB, and Neo4j. The... ...Bridge InfoTech Inc) by 2x Sign in to set job alerts for “SQL Database Administrator” roles. Frisco, TX $99,000.00-$116,0...Contract work
- ...SQL DBA / Systems Analyst Employment Type: Full Time, Mid-level CGS is seeking... ...concepts. Assists in administering database organizations, standards, controls, and... ...willing to achieve Relativity Certified Administrator credential within 6 months of hire....Full timeFlexible hours
Contact Government Services LLC
Dallas, TX5 days ago - ...integration efforts by configuring interfaces, executing ETL processes, and ensuring consistent data flow between ERP and other applications Assess ERP system performance to identify enhancement opportunities and to ensure that ERP customizations are in compliance with security...Full timeTemporary workWork experience placementRelocation
$110.7k - $218.3k
...challenges. Leveraging Deloitte’s unmatched resources and deep industry insights, you’ll deliver innovative, market-driven solutions that modernize finance functions, elevate performance, and drive meaningful organizational change. Join us to empower clients to become strategic...Local areaVisa sponsorship$143.64k - $273k
...Kyndryl, we design, build, manage and modernize the mission-critical technology systems... ...client discovery sessions and AI readiness assessments to surface high-impact use cases... .../Node.js a plus Experience with vector databases (Pinecone, Weaviate, pgvector, Chroma)...Minimum wageFull timePart timeLocal areaWorldwide
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to SQL Database Administrator (SQL DBA) - Database Assessment & Modernization. Be the first to apply!
