SQL DBA - US Tech Solutions
Plano, TX
About the Job
Responsibilities:
• 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-premise 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/Clienture Landing Zones and Security policies
• Strong understanding of core AWS/Clienture services and AWS/Clienture architecture best practices
• Hands-on experience cloud native migrations tools such as AWS/Clienture Database Migration
Service and AWS/Clienture Schema Conversion Tool
• Good to have AWS/Clienture, MCTS, MCITP, and/or MVP certifications.
Qualifications:
● 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.
About US Tech Solutions:
US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com.
US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
• 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-premise 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/Clienture Landing Zones and Security policies
• Strong understanding of core AWS/Clienture services and AWS/Clienture architecture best practices
• Hands-on experience cloud native migrations tools such as AWS/Clienture Database Migration
Service and AWS/Clienture Schema Conversion Tool
• Good to have AWS/Clienture, MCTS, MCITP, and/or MVP certifications.
Qualifications:
● 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.
About US Tech Solutions:
US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com.
US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Source : US Tech Solutions
