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 - ...Position: Data Architect SQL Database Assessment & Modernization Location: Dallas, TX / Austin, TX Job Description: SQL & Database Technologies Microsoft SQL Server (2012/2014/2016/2019/2022) T-SQL Stored Procedures Query Optimization...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 - ...Senior SQL Database EngineerNextStep Recruiting has partnered with a financial... ...is ideal for an experienced SQL DBA who combines deep database administration skills with growing cloud... ...performance, availability, and modernization initiatives.Required:7+ years of...SuggestedLocal area
NextStep Recruiting
Dallas, TX19 hours ago - Senior MS SQL Server Administrator General Dallas , Texas 10403 Sep... ..., security-focused DBA role responsible for... ...supporting a major modernization initiative. The successful... ...candidate will lead database vulnerability... ...Server vulnerability assessment, remediation, and...SuggestedContract work
- ...DBA ManagerPOSITION - DBA ManagerLOCATION - Remote then onsite in Dallas, TX post COVIDDURATION - 12+ months, likely to convert/extendPAY... ...TYPE - PS + VideoREQUIRED SKILLS - Qualifications• 8+ years of SQL Server DBA experience• Experience with SQL Server versions 2012...Remote work
My3Tech Inc
Dallas, TX4 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 inception...Work experience placement
Careers Integrated Resources Inc
Irving, TX4 days ago - ...Database AdministratorImplement 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...
United IT
Irving, TX4 days ago - ...Sr DBA Admin - SQL Server DBAAPN Consulting, Inc. is a progressive IT staffing... ...duration: 12 monthsDatabase Administrator with general DBA experience... ...to tuning very complex database problems with very high volumes... ...with stakeholders to assess Oracle databases and host decommission...Contract workRemote work
APN Consulting
Richardson, TX4 days ago - ...Description Job Description SQL DBA / Systems Analyst... ...Assists in administering database organizations, standards, controls... ...achieve Relativity Certified Administrator credential within 6 months of... ...applications, analyzing resumes, or assessing responses and identifying...Full timeFlexible hours
Contact Government Services, LLC
Dallas, TX14 days ago $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...
- ...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-...
$60.24 - $68.24 per hour
...Technology division of our client, driving modernization of technology tools and processes.... ...governance controls, data quality assessments, sampling techniques, and... ...scorecards, and dashboards Hands-on SQL experience with Oracle databases, including joins, window functions...Hourly payContract workGenesis10
Addison, TX19 hours ago$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, TX3 days ago$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- ...SQL Database AdminHybrid Onsite - Minneapolis, MN; Atlanta, GA; Chicago, IL; Dallas, TX; San Francisco, CA (3 days/week onsite)Contract through... ...infrastructureExpertise in SQLNice to Have:Data migration experienceRequired Skills: SQL Server, DBA, database infrastructure...Contract work3 days per week
My3Tech Inc
Dallas, TX4 days ago - ...a Tech Practice Leader - Migration and Modernization to build and lead the practice serving mid... ...strategy, and governance required to assess, migrate, modernize, optimize, and operate... ...migration-factory leadership, application and database modernization expertise, field CTO-style...Full timeWork experience placementLive inWork at officeLocal area
$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- ...secure, scalable cloud foundations while modernizing monolithic legacy systems into cloud-... ...migrations, data center exits, workload assessment, wave planning, and legacy app... ...discovery assessments, Migrate to VMs, legacy database migration (DMS), data center exits, migration...Full timeWork experience placementLive inWork at officeLocal areaImmediate start
$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$76.4k - $141.8k
...Senior Database Administrator In this role, you will play a critical part in... ...Your expertise will help drive modernization efforts, including database... ..., and by automating routine DBA workflows. Administer,... ...or GCP). Proficiency in SQL, performance tuning, backup/...Temporary workFreelanceLocal areaFlexible hoursProdigious Worldwide
Irving, TX1 day ago$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$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...- 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, TX9 hours 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
- ...Oracle Database AdministratorLocation: Must live in Dallas - hybrid 2-3 days per weekJob Description:10+ years of physical DBA experience, including experience across Oracle, SQL Server, Exadata, Postgres, Microsoft Access database servers.Needs to know Oracle inside and...Live in
RIT Solutions
Dallas, TX4 days ago - ...Oracle RAC 19c Database AdministratorKey Responsibilities:• Oracle RAC 19c Configurations: Set up, manage, and troubleshoot Oracle RAC 1... ...availability and performance. Incorporate Oracle RAC best practices.• SQL Tuning: Optimize SQL queries and indexing strategies to enhance...
Yochana
Dallas, TX4 days ago $100k - $110k
...Banking Portal Stabilization & Modernization Roles &... ...analyze customer-reported issues, assess business impact, identify root... ...bottlenecks across application, database, middleware, and infrastructure... ...Spring Boot • REST APIs • SQL and relational databases •...Tata Consultancy Services
Irving, TX3 days ago
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!
