Offer summary

Qualifications:

Bachelor's degree in Computer Science, Information Technology, or related field., Proven experience as a SQL Server DBA with a focus on upgrades and migrations., Strong knowledge of SQL Server versions, editions, and upgrade planning., Excellent problem-solving and communication skills, with relevant certifications like Microsoft Certified: Azure Database Administrator Associate..

Key responsibilities:

Lead and execute SQL Server database upgrade projects, ensuring minimal downtime.

Collaborate with stakeholders to define upgrade goals and develop detailed plans.

Perform pre-upgrade activities such as backups, security reviews, and performance optimization.

Conduct post-upgrade testing, performance tuning, and documentation to ensure database stability and security.

Job description

We are seeking a skilled and experienced SQL Server Database Administrator (DBA) to lead and execute the onpremises upgrade initiatives for our clients SQL Server databases. You will be responsible for planning, implementing, and managing the upgrade process while ensuring the stability, security, and performance of our database environment.

**Responsibilities:**

1. **Upgrade Planning:**
Collaborate with stakeholders to define upgrade goals, scope, and objectives.
Assess the current database environment and applications to determine compatibility and potential issues with the new SQL Server version.
Develop a detailed upgrade plan outlining tasks, timelines, resource requirements, and risk mitigation strategies.

2. **Database PreUpgrade Activities:**
Backup and secure existing databases and related objects to ensure data integrity.
Review and optimize database schema, indexes, and queries to enhance performance.
Identify and address security vulnerabilities and compliance concerns.

3. **Upgrade Execution:**
Lead the execution of the upgrade process, ensuring minimal downtime and impact to business operations.
Monitor the upgrade process and address any issues or errors that arise during the upgrade.
Perform necessary compatibility tests and resolve any applicationrelated issues.

4. **PostUpgrade Validation:**
Conduct thorough testing of upgraded databases to verify functionality, data integrity, and performance.
Collaborate with development teams to validate application compatibility and resolve any postupgrade issues.
Document the upgrade process, changes made, and lessons learned for future reference.

5. **Performance Tuning and Optimization:**
Monitor database performance postupgrade and identify opportunities for optimization.
Finetune query performance, indexes, and configurations to ensure optimal performance.

6. **Security and Compliance:**
Implement security best practices for the upgraded databases, including user access, roles, and permissions.
Ensure compliance with relevant data protection regulations and internal security policies.

7. **Documentation and Reporting:**
Maintain comprehensive documentation related to database upgrades, configurations, and changes.
Provide regular status reports to management, highlighting progress, challenges, and recommended solutions.

**Qualifications:**

Bachelors degree in Computer Science, Information Technology, or a related field.
Proven experience as a SQL Server Database Administrator, with a focus on database upgrades and migrations.
Strong knowledge of SQL Server versions and editions, with expertise in planning and executing upgrades.
Proficiency in database performance tuning, query optimization, and troubleshooting.
Familiarity with security best practices and compliance requirements for database systems.
Excellent problemsolving skills and the ability to work under pressure to resolve critical issues.
Strong communication skills to collaborate with crossfunctional teams and stakeholders.
Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate) are a plus.
Experience with scripting languages (e.g., PowerShell) for automation is desirable.
Prior experience in onpremises to cloud migration is a Must.

Required profile