SQL DBA at Plano, Texas, USA |
Email: [email protected] |
From: Anwer, Convex [email protected] Reply to: [email protected] Position Title: SQL DBA Location: Plano, TX Onsite Day 1 Duration: 5 Months of Contract Rate:$40 to 45 hr. on C2C OR 1099 NEED ONLY GC OR USC CANDIDATES Title: SQL DBA 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/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. Email ID [email protected] Keywords: green card Idaho Texas SQL DBA [email protected] |
[email protected] View all |
Sat Nov 02 00:43:00 UTC 2024 |