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 1 day 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, TX1 day 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, TX1 day ago - ...Data Architect SQL Database Assessment & Modernization Location Dallas or Austin, TX (4 days office / week)...SuggestedFull timeWork at office
Arkhya Tech Inc
Dallas, TX1 day ago - ...specialty areas: Information Technology (IT), Clinical Research, Rehabilitation Therapy and Nursing. Job Description Position: SQL Database Administrator (DBA) Location: Irving - TX Duration: 4 months Job Description: • 6+ years of work experience in Microsoft SQL server...SuggestedWork experience placement
Integrated Resources
Irving, TX2 days 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 workcognizant technologies
Dallas, TX4 hours ago$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-...
$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- ...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
- ...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
GBIT (Global Bridge InfoTech Inc)
Richardson, TX3 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- ...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
- ...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$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...
- ...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
$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- ...Oracle Database Administrator 6 years of experience on Oracle 11.x/Above versions in database administration... ...with scripting. Experience in SQL, PL/SQL. Experience on Exadata, OEM etc. Experience supporting Logical DBA activities. Experience complex query...
United IT
Irving, TX3 hours ago - ...PL/SQL Database Support Engineer Cephas Consultancy Services Private Limited Dallas, Texas, United States About this position Job Id :CLI... ...Oracle-based applications. The ideal candidate will have strong SQL and PL/SQL expertise, experience troubleshooting production issues...
Cephas Consultancy Services Private Limited
Dallas, TX1 day ago - ...shareholders.• To promote employee development. Job DescriptionMust be familiar with multiple DBMS platforms including Oracle, DB2, MYSQL, SQL Server, and/or Sybase.Additional InformationAll your information will be kept confidential according to EEO guidelines....
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!
