Overview
Trigyn has a contract opportunity for SQL Server Migration DBA in Trenton, NJ. The particulars of the position are as follows.
Description
The department is looking for a SQL Server Migration 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.
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.
- Ensure high availability, disaster recovery, and security compliance throughout the migration process.
- Maintain documentation and support incident resolution post-migration.
- Hands-on experience in SQL Server administration and support (versions 2012 through latest).
Required / Desired Skills
Familiarity with SQL Server migration processes and tools (e.g., Data Migration Assistant, backup / restore, always on, 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)Troubleshooting and performance tuning skills. (Desired)Desired Skills
Good communication and documentation capabilities.Willingness to learn and work in a team-oriented setting.Ability to follow directions while also taking initiative when needed.For Immediate Response call , or send your resume to
TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 9001 : 2015, ISO 27001 : 2013 (ISMS),ISO 20000 : 2018 and CMMI Level 5 certified company.
J-18808-Ljbffr