Vacancy expired!
Job Title: MS SQL DBA (Onsite - Locals required) Location: Atlanta, GA Duration: 6 Months Job Type: Corp Corp / 1099 /W-2 Rate: $70/hr on C2C Job Description: Note : Interview Type: Web cam or In-Person Interview Provide operational support of databases from development to mission-critical production implementations in On-Prem and AWS Cloud environments. Coordinate, design, and configure database structures and communication links across multiple database platforms to ensure high availability and minimal downtime. Independently analyze, solve, and correct issues in real time, providing problem resolution database-related incidents and requests. Implement database performance metrics measurements to track and analyze database growth. Monitor the database (performance, memory, CPU) and assist developers with complex query tuning and schema refinement to increase efficiency in all systems. Analyze existing systems and make recommendations on which technology best suits the business requirement for high availability, disaster recovery and/or high performance. Perform switchover and failover activities. Plan and implement homogeneoheterogeneous migrations of databases from On-prem to AWS EC2. Create and manage policies for S3 buckets. Analyze archive requirements and implement data archival processes. Define backup and recovery strategies using Idera SQLSafe or Native SQL Server Backup/recovery. Perform Full database/PTR recoveries per application requirements. Work with respective Application owners/developers to ensure proper database security standards are being followed. Apply patches and upgrades on the databases in regular intervals as per the security compliance. Develop and maintain documentation on Database inventory and Capacity Utilization of the resources. Participate in on-call rotations. (After-hours work includes scheduled maintenance, supporting application deployment, and hardware/software upgrades). MINIMUM ENTRY QUALIFICATIONS: Bachelor's degree in computer science or related field from an accredited college or university. A minimum of 10 years of experience in support of a MS SQL Server database management system. Expertise in/hands-on experience working with Microsoft SQL Server 2019 (with working knowledge or previous administration of SQL 2012-SQL 2016 and Windows Server 2012+). 2+ years hands-on AWS experience, including knowledge of Amazon RDS, Amazon Migration Services, and database replication across multiple AWS regions. Hands-on experience designing and implementing highly available production systems using the following technologies: Database Mirroring, Log Shipping, Windows/SQL clustering, and Availability Groups. Hands-on experience with SQL Server patching and upgrades. Experience with developing scripts for SQL Server Backup, Integrity Check, and Index and Statistics Maintenance. PREFERRED QUALIFICATIONS: MCTS, MCITP, and/or MCDBA certifications are a plus. AWS Certification and/or AWS Certified Database Specialty is an advantage Experience with Oracle 19c Experience in database technologies like Oracle, MS SQL, and AWS DB services like RDS, Amazon Aurora, MySQL, and PostgreSQL. Skill Matrix Skill Required /Desired Amount of Experience Bachelor's degree in computer science or related field Required 0 A minimum of 10 years of experience in support of a MS SQL Server database Required 0 Hands-on experience with SQL Server patching and upgrades Required 0 Recruiter Details: Recruiter Name: Srinivas Contact Number: +1 About GSK Solutions Inc: GSK Solutions Inc is a leading information technology (IT) Services Company that specializes in providing complete consulting solutions and staff augmentation to its clients. We provide on-time, on-budget, and quality service to our clients and consistently meet their expectations. We are known for our superior execution on a sustained basis. GSK has been in the business of providing both commercial and custom product development services, including, Information Security, Software Development, Consulting and IT Audit. GSK implements highly critical and time-sensitive projects for their Fortune 500 clients located across the country.