Job Title
MS SQL DBA
Company
Sumeru Solutions
Job Description
Below MSSQL JD.
- The candidate should have excellent work experience in MSSQL database Architecture, migration to AWS EC2, and knowledge of CLR and SSIS.
- Install, configure, upgrade, and patch MS SQL Server databases. Well-versed in resolving security violations on MSSQL servers/DB.
- Perform regular database maintenance tasks, including backups, indexing, and integrity checks.
- Design, implement, and regularly test disaster recovery plans to ensure minimal downtime on on-premises installations.
- Manage and automate backup processes, ensuring data availability and integrity, using native and 3rd party backup tools like Rubrik, AWS Backup service, and S3.
- Monitor database performance and proactively tune databases, optimizing SQL queries, indexes, and configurations.
- Identify and resolve performance bottlenecks, ensuring high availability and fast response times.
- Design, implement, and manage high-availability solutions, including SQL Server clustering, Always-On Availability Groups, and database mirroring.
- Configure and monitor replication strategies such as transactional replication, merge replication, and log shipping to ensure data availability across environments.
- Troubleshoot and resolve high availability and replication issues, minimizing downtime and data loss.
- Good understanding of Amazon Web Services (AWS) such as EC2, RDS, VPC, S3, backup services, and other offerings.
- It is good to have experience with other AWS Aurora and RDS (Like Oracle, PostgreSQL, and MySql).
- Candidate should have 12+ years of experience with the MSSQL database, preferably certified in MSSQL and ASW.
Expected Salary
Location
USA
Job Posting Date
Wed, 28 Aug 2024 22:35:50 GMT