Database Administrator
NJOIT is 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
- 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 | 3-5 years |
| Familiarity with SQL Server migration processes and tools (e.g., Data Migration Assistant, backup/restore, always on, or log shipping). | Required | 3-5 years |
| Proficiency in T-SQL and scripting for automation | Required | 3-5 years |
| Working knowledge of SQL Server features like jobs, indexes, users/roles, and performance plans. | Required | 3-5 years |
| Experience supporting on-premises and/or hybrid environments | Required | 3+ years |
| Strong understanding of SQL Server tools: SSMS, SSIS, SSRS, and SQL Profiler. | Required | 3+ years |
| Hands-on experience with database migration tools and techniques (e.g., Data Migration Assistant, Backup/Restore, Log Shipping, Always On, etc.) | Required | 3+ 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. | Desired | 3+years |
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.
| Skill Required /Desired Amount of required experience in yrs Candidate 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. | Desired | 3 | Years |
| No. Question Candidate Answer | |
| Question1 | Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you agree to this requirement? |
| Question2 | What is your candidate's email address? |
| Question3 | Where does your candidate currently reside (City & State)? |
| Question4 | If your candidate resides more than 1 hour from the Client site, will your candidate relocate for the position? |
| Question5 | Is your candidate available for a Round 1, in-person interview? |
Recommended Jobs
Family Support Staff
Job Description Job Description Salary: The Mental Health Association of Monmouth County seeks a passionate and qualified Family Support Staff for its Intensive Family Support Services (IFSS) …
Material Handler III - Day Shift
Logistics at full potential. At GXO, we’re constantly looking for talented individuals at all levels who can deliver the caliber of service our company requires. You know that a positive work …
Veterinarian Surgeon
Job Description Job Description World Class Medicine. Purpose-Driven Partnership. Veritas Veterinary Partners offer exciting career opportunities in state-of-the-art facilities across the U…
Super Soccer Stars - General Manager (Part-Time) - Bergen County
Job Description Job Description Super Soccer Stars - General Manager (Part-Time) - Bergen County THE COMPANY: Youth Athletes United was created to provide the best programming and service i…
Civil Engineer 3409857349
Civil Engineer Qualifications Bachelor's degree is required in Civil Engineering ~ Experience: ~0-5 years of experience in Civil Design. Responsibilities: As a Civil Engineer, the w…
Medical Assistant
Job Description Job Description We are seeking a qualified Medical Assistant to join our Medical Assistant team. The Medical Assistant will support our healthcare providers by performing various …
Creative Arts Therapist (PT)
Job Description Job Description Title: Creative Arts Therapist Department: PALS Supervisor: Program Director of PALS Effective Date: ASAP Status: Part Time Rate: $35 / hour J…
PD Food Service Worker
Job Title: PD Food Service Worker Location: Jersey City Medical Center Department Name: Dietary Management Req #: 0000210740 Status: Hourly Shift: Evening Pay Range: $18.57 - $18.57 …
Job title: Integration Analyst
Job title: Integration Analyst Hermes Networks Inc. Job code: VC2018 Duties and Responsibilities Integration Analyst, Plainsboro, NJ and other client locations: Develop data extractions,…
Course Navigator (PT)
Job Description Job Description We are seeking student course navigators that support both students and professors with fundamental course technology management, facilitating communication betwee…