SQL DBA

Pay Rate; $48 - $52/Hour

• Manage and administer SQL Server databases in various versions, including installation, configuration, and maintenance.
• Monitor and optimize database performance through query optimization, indexing, and other techniques.
• Implement and maintain high availability and disaster recovery solutions for SQL Server, Always-On, Replication ensuring minimal downtime.
• Ensure the security and integrity of databases by implementing access controls, encryption, SSL, TDE, and data masking.
• Develop and maintain database backup and recovery strategies to safeguard data.
• Plan and execute database migrations and upgrades while minimizing disruption.
• Develop and maintain automation scripts using PowerShell or similar tools to streamline database operations.
• Work with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) for data integration and reporting needs.
• Implement and maintain database monitoring and alerting solutions to proactively address issues.
• Maintain accurate documentation of database configurations, procedures, and troubleshooting steps.
• Significant experience with SQL Server and its migration to AWS EC2 instances and AWS RDS.
• Experience in evaluation an on-premises Data environment and suggest the best fit target environment on AWS.
• Prior cloud database migration experience with sizing and performance tuning.
• Understanding in creating AWS/Azure Landing Zones and Security policies
• Strong understanding of core AWS/Azure services and AWS/Azure architecture best practices
• Hands-on experience cloud native migrations tools such as AWS/Azure Database Migration
• Service and AWS/Azure Schema Conversion Tool
• Good to have AWS/Azure, MCTS, MCITP, and/or MVP certifications.
• Strong experience in SQL tools such as OmniDB, DBeaver, SQL Developer and PGAdmin.
• Extensive experience in database security, backup and recovery, and performance monitoring standards.
• AWS Certified Solutions Architect - Associate and AWS Certified Database Specialty Certifications is a must.
• Strong written and verbal communication skills with the ability to create and present concepts and recommendations to the management.