Overview
On Site
Depends on Experience
Contract - Independent
Contract - W2
Contract - 6 Month(s)
Skills
T-SQL
database migration
Job Details
SQL Server DBA
Trenton, NJ
6 Months
6 Months
looking for a Mid-Level SQL Server Migration DBA to support planning, execution, and validation of database migrations with practical experience in SQL Server administration/migration tools across multiple versions and hybrid platforms.
NJOIT is looking for a mid-level SQL Server DBA consultant with experience in SQL Server database administration, clustering, always on availability groups, server management, backup & restore of SQL Server databases with focus on database migration spanning multiple SQL Server versions, multiple state agencies.
Key responsibilities
- Assist with the assessment and documentation of existing SQL Server environments.
- Support database migration efforts including backup/restore, scripting, data transfers, and validation.
- Perform routine health checks and troubleshooting during and after migrations.
- Collaborate with senior DBAs, infrastructure, and application teams.
- Execute test migrations and contribute to performance tuning and optimization.
- Ensure data integrity, security, and minimal application impact throughout the process
- Support database migration efforts including backup/restore, scripting, data transfers, and validation.
- Perform routine health checks and troubleshooting during and after migrations.
- Collaborate with senior DBAs, infrastructure, and application teams.
- Execute test migrations and contribute to performance tuning and optimization.
- Ensure data integrity, security, and minimal application impact throughout the process
- Ensure high availability, disaster recovery, and security compliance throughout the migration process.
- Maintain documentation and support incident resolution post-migration.
Skill | Required / Desired | Amount | of Experience |
| Hands-on experience in SQL Server administration and support (versions 2012 through latest) | Required | 5 | Years |
| Familiarity with SQL Server migration processes and tools (e.g., Data Migration Assistant, backup/restore, alwayson, or log shipping). | Required | 5 | Years |
| Proficiency in T-SQL and scripting for automation | Required | 5 | Years |
| Working knowledge of SQL Server features like jobs, indexes, users/roles, and performance plans. | Required | 5 | Years |
| Experience supporting on-premises and/or hybrid environments | Required | 5 | Years |
| Strong understanding of SQL Server tools: SSMS, SSIS, SSRS, and SQL Profiler. | Required | 5 | Years |
| Hands-on experience with database migration tools and techniques (e.g., Data Migration Assistant, Backup/Restore, Log Shipping, Always On, etc.) | Required | 5 | Years |
| Experience with cloud-based migration (e.g., Azure SQL, AWS RDS for SQL Server) | Nice to have | 3 | Years |
| Troubleshooting and performance tuning skills. |
Siva Prasad
Sr.Technical Recruiter
Solomons International
Ph: ;|Fax :( |
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.