Job Description

Job description

Please find below the MSSQL JD.

The candidate should have strong expertise in MSSQL database architecture and large-scale migrations from on-premises data centers to AWS, including EC2- and RDS-based deployments.
Experience should include end-to-end database migration lifecycle, covering assessment, migration strategy, schema conversion, data transfer, validation, and post-migration optimization.
Hands-on experience with cross-account and cross-region database migrations leveraging AWS DMS, native backup/restore, and replication mechanisms.
Install, configure, upgrade, and patch MS SQL Server databases and RDS. Well-versed in resolving security violations on MSSQL servers/DB/RDS.
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 Experience with 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.

Job Tags

Similar Jobs

Gpac

Trust Officer Job at Gpac

Trust Officer A Trust Officer is a banking professional who services trusts and investments. This is a relationship-based role, where customers can span generations. This role can service private and corporate trust accounts. Trust Officer Qualifications:* Bachelor...

Sands Chevrolet Glendale

Body Shop Finish Buffer Job at Sands Chevrolet Glendale

Our current paint team is producing 2,000 hours per month and are in need of an additional finish buffer to complete the 2,200 hours scheduled. Become a key member of the Sands Collision paint team.This is the perfect position to master your skills and move up in the...

Tek Ninjas

Food Server II Job at Tek Ninjas

...Job Title: Food Server II Location: Irvine, CA 92618 Duration: 3 Months (with possible extension) Position Summary: The Food Server II displays and practices a work-style that reflects the mission, vision and values of the department and hospital...

TNStumpff Enterprises

Mail Carrier Job at TNStumpff Enterprises

...leader in Contract Delivery Service for the United States Postal Service, with offices in20 states, is currently seeking applicants to deliver mail PART TIME on a CDS mail route solicited and posted by the USPS in the Watford City, ND area. Applicants must be at least 1...

KeyMik

Campus Recruiter Job at KeyMik

...experiences. As we grow, so does our need to attract the next generation of creative thinkers and problem solvers. Were hiring a Campus Recruiter to own and grow our early-career and internship hiring programs from campus partnerships to intern onboarding. If you...

MS SQL Database Admin Job at Cloudious LLC, Remote

YnNDWEVuVUpRT21VbUhUUENWUE83SUR5WVE9PQ==