We are seeking a skilled MS SQL Database Administrator with extensive experience in database management, performance tuning, security, and troubleshooting. The ideal candidate will have expertise in managing SQL Server instances (2014, 2016, 2019), performing installations, upgrades, migrations, and supporting application deployments. Knowledge of Oracle and DB2 is a plus. This role requires collaboration with application developers to ensure optimal database design and functionality.
Key Responsibilities:
- Install, upgrade, and migrate MS SQL Server databases (versions 2014, 2016, 2019). Plan and execute database upgrades, including migrations from end-of-life MS SQL Server instances to supported versions.
- Work closely with application developers to provide database solutions, including SQL writing and optimization for application deployments.
- Monitor and resolve slow SQL queries, locks, and blocks. Provide expert advice on troubleshooting and optimization of stored procedures and overall database performance.
- Perform ongoing maintenance and configuration of SQL Server instances to ensure optimal performance. Manage backup and restore operations and schedule tasks using SQL Server Integration Services (SSIS).
- Ensure the security, integrity, and compliance of all databases. Implement proactive measures for monitoring and maintaining the databases' health and security.
- Resolve incidents and problems related to databases or third-party products, ensuring quick and effective resolution.
- Participate in deploying and configuring solutions in cloud environments. Automate cloud operations and develop infrastructure automation scripts. Engage in continuous improvement of cloud-based solutions.
- Administer and maintain servers across virtual platforms, ensuring availability, performance, and reliability.
Requirements:
- Minimum of 3-5 years of experience as a SQL Database Administrator.
- Proven experience with SQL Server versions 2014, 2016, and 2019, including installation, upgrades, and migrations.
- Strong experience in performance monitoring, tuning, and incident resolution.
- Experience in managing database backups, restores, and ensuring high availability.
- Expertise in scheduling and managing tasks using SSIS.
- Ability to work closely with application teams to optimize database design and performance.
- Strong troubleshooting skills for resolving SQL query issues, locks, and database blocks.
- Familiarity with database security best practices and compliance management.
- Experience in deploying, automating, and maintaining cloud-based database solutions.
Desired Skills:
- Strong skills in SQL scripting and optimization techniques.
- Understanding of advanced database security techniques and best practices.
- Familiarity with cloud technologies and infrastructure automation (e.g., Azure, AWS).
To apply, simply click the "Apply" button or send your updated profile to [email protected]
EA Licence No.:18S9405 / EA Reg. No.:R1330864
Percept Solutions is expanding and actively seeking talented individuals. We encourage applicants to follow Percept Solutions on LinkedIn at https://www.linkedin.com/company/percept-solutions/to stay informed about new opportunities and events.