Job Title: SQL DBA
Location: Plano, TX (Onsite)
Experience: 10+ Years
If You are Interested, Drop me your Resume to Thomas@innovitusa.com (or) You can reach me on
+1(267)627-5083.
Job Description:
· 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.
· 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 evaluating an on-premise Data environment and suggesting 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.
Innovit USA Inc. is the fastest growing IT Services, Product & IT Consulting Company Headquartered in Langhorne, PA. Innovit management has been in IT Industry for over 23 years.Innovit main goal is to provide high quality and cost effective IT solutions and services to our clients. Innovit provides innovative web development solutions and mobile app solutions to our several satisfied clients worldwide. We work with several Direct Client requirements.