Overview
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - Contract
Skills
postgresql
AUTOMATION
DATABASES
MAINTENANCE
MICROSOFT SQL SERVER
ARCHITECTURE
MYSQL
Communication Skills
Problem solving
AMAZON WEB SERVICES
SQL DATABASES
Disaster Recovery
AWS Aurora
System Availability
Self Motivation
Safety Principles
Assembly and Installation
Cloud Engineering
Amazon Elastic Compute Cloud
Amazon Relational Database Service
Amazon S3
Amazon Virtual Private Cloud (VPC)
Data Centers
Database Performance
Installation Technology
Log Shipping
Oracle Applications
Indexer
Database Migration
Alwayson
Backup Devices
Data Loss
Data Transmissions
Database Mirroring
Migration Manager
Job Details
Job Title: MS SQL Database / Cloud Engineer with AWS-RDS
Job Location: Remote
Job Type: Contract
Job Description:
- 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.