MS SQL Database Admin Job at DBA Presents, Minnetonka, MN

bnNMbHI0aklYZUtBU2Nqb2VhOFNhMVBVelE9PQ==
  • DBA Presents
  • Minnetonka, MN

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.



#J-18808-Ljbffr

Job Tags

Similar Jobs

The Loan Store

Entry-Level Underwriter Job at The Loan Store

 ...Job Description Job Description Entry-Level Mortgage Underwriter (No Experience Needed) Location: [Plano, Texas] Job Type: Full-Time About the job Join a Team That Feels Like Family Were not your average mortgage company were a close-knit, growing... 

AMN Healthcare, Inc.

Family Medicine Residency Program Director Job at AMN Healthcare, Inc.

Job Description Job Description & Requirements Family Medicine Residency Program Director StartDate: ASAP Pay Rate: $270000.00 - $367000.00 Launch the region's first FQHC-based Teaching Health Center residency program with unprecedented resources and authority...

Top Level Promotions

Work from Home Office Support Assistant Job at Top Level Promotions

 ...position in data entry, office administration, and online research. This role allows you to work from home while gaining practical experience in digital office tasks, record keeping, and supporting client projects. Full training is provided for qualified candidates.... 

AC1 HOMECARE LLC

Certified Nurses Assistant (CNA)/HHA Job at AC1 HOMECARE LLC

 ...Perks Flexible Scheduling Competitive Compensation Careers Advancement Job Summary We are seeking a Certified Nursing Assistant (CNA) to join our team. In this position, you will assist patients with their daily living needs, provide compassionate care,... 

553 West 144th Street Llc

Assistant Property Manager Job at 553 West 144th Street Llc

 ...Description Boutique real estate firm seeking an Assistant Property Manager. We are looking for an assistant PM to join our team to...  ...maintenance activities. The ideal candidate will have proven experience as an assistant PM or similar role. Working knowledge of...