US Tech Solutions
SQL DBA
US Tech Solutions, Plano, Texas, United States, 75023
Duration:
6+ Months Contract with possible extension
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.
Experience:· 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.
Skills:· SQL Server DBA, Database Migration
Education:· High School or Equivalent experience
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, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Recruiter Details:Name: AkibEmail: akib@ustechsolutionsinc.comInternal Id: 24-25300
6+ Months Contract with possible extension
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.
Experience:· 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.
Skills:· SQL Server DBA, Database Migration
Education:· High School or Equivalent experience
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, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Recruiter Details:Name: AkibEmail: akib@ustechsolutionsinc.comInternal Id: 24-25300