This job has closed.

Cloudious LLC · 1 day ago

MS SQL Database Engineer with AWS-RDS

United States

Contract

Remote

Senior Level, Lead/Staff

12+ years exp

Cloudious LLC is one of the fastest emerging IT Solutions and Services company headquartered in San Jose, CA. They are currently hiring a MS SQL Database Engineer with AWS-RDS who will be responsible for managing and migrating MSSQL databases to AWS, ensuring high availability and performance.

Business IntelligenceConsultingHuman ResourcesInformation Technology

H1B Sponsor Likely

Hiring Manager

Laxmi Bhandari

Responsibilities

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)

Qualification

MS SQL ServerAWS RDSDatabase migrationAWS DMSDatabase architectureHigh availability solutionsDisaster recovery planningPerformance tuningBackup automationSoft skills

Required

12+ years of experience with the MSSQL database

Preferably certified in MSSQL and AWS

Strong experience with Microsoft SQL Server RDS on AWS and migrations to cloud

Strong expertise in MSSQL database architecture and large-scale migrations from on-premises data centers to AWS

Experience with end-to-end database migration lifecycle, covering assessment, migration strategy, schema conversion, data transfer, validation, and post-migration optimization