SQL Server Admin (Hybrid)

cognizant technologies; Dallas (TX); Hybrid; USD 99,000 - 116,000; Full time

Benefits offered by this job

Medical/Dental/Vision/Life Insurance

401(k) plan and contributions

Employee Stock Purchase Plan

Job summary

A leading technology firm is seeking an experienced SQL Server Admin for a hybrid role based in Dallas, Texas. The ideal candidate will have extensive experience in SQL Server & Cloud administration, strong communication skills, and the ability to lead projects. Responsibilities include integrating SQL and NON-SQL databases, supporting application migrations, and solving production issues. This position offers competitive compensation between $99,000 - $116,000 annually, along with benefits like medical insurance and a 401(k) plan.

Qualifications

• Senior level Microsoft SQL Server DBA with experience in large and critical environments.
• Knowledge of SQL partitioning and compression.
• Must have good knowledge in SQL Server permission/security policies.

Responsibilities

• Integrate data between SQL databases and NON-SQL databases.
• Work with client teams on migrating applications.
• Provide on-call and weekend support for SQL and MYSQL.

Skills

SQL Server & Cloud administration

Performance tuning

Writing T-SQL scripts

Automation experience

Excellent knowledge of SSIS packages

Hands-on experience on SQL Server Clustering

At least 6 months experience with AWS Cloud RDS

Education

MS certifications on MSSQL latest versions

Tools

Power Shell

Python

Job description

This hybrid position is open to any qualified applicant in the United States.

This position is hybrid in Dallas, Texas. A qualified applicant must be local to this area or be open to relocation.

Practice - CIS - Cloud, Infrastructure, and Security Services

About Cloud Infrastructure & Security Services: Cognizant’s Cloud, Infrastructure, and Security Services Practice (CIS), is all about embracing digital transformation by driving core modernization holistically across layers. We help customers transform infrastructure and workplace to meet the rapidly evolving needs of the digital era. Our holistic approach delivers key results for our customers by achieving cloud driven modernization and workplace and operational transformation to run the business in a secure environment.

Job Title: SQL Server Admin

Responsibilities:

• Ability to integrate data between SQL databases and NON-SQL databases to SQL databases
• Ability to think about a problem, identify what we have and implement solutions to solve the problem independently.
• Work with onsite client team / Application owners in US / UK to Migrate Applications, Database building and Decommissioning.
• Ability to take lead on some projects and works as part of a team (follow another leader on others)
• Strong verbal and written communication skills
• Ability to think in and out of the box. Come up with service improvement ideas and innovative solutions.
• Self-motivated, conscientious, dedicated individual who works equally well independently or as a member of a team.
• Must be willing to take responsibility and ownership instead of waiting to be assigned work
• The candidate must be willing to provide On-call and weekend support for SQL and MYSQL, the support is rotated among DBA's in US, UK and India
• Enable and support the team in resolving day-to-day production issues, application upgrades and patches, performance analysis, disaster recovery implementation, capacity planning and other activities as may be necessary.
• Work on Change implementations during UK, US business hours & weekends as per change management process
• Documentation & Operational performance reporting
• Own Service Improvements
• Execute on demand IT projects.
• Drive compliance to client and organization processes and policies
• Ensure Quality of deliverables
• The above is not a comprehensive list and could change based on business requirements

Skills Requirement

• Mandatory skills - SQL Server & Cloud administration required skills.
• Senior level Microsoft SQL Server DBA with experience in large and critical environments.
• Knowledge of performance tuning at both server level and query level. Candidate must have knowledge of perfmon, SQL Server dynamic management views.
• Knowledge of SQL server internals.
• Knowledge of SQL partitioning and compression
• Hands-on experience on mirroring, replication and Always ON
• Must have automation experience. Good knowledge of scripting. Ability to write T-Sql scripts, Power Shell, or Python.
• Excellent knowledge of SSIS packages.
• Hands-on experience on SQL Server Clustering.
• Hands-on experience on Integration Services, Reporting services and Analysis services
• Must have good knowledge in SQL Server permission/security policies.
• At least 6 months experience with AWS Cloud RDS

Good to have skills

• MySQL knowledge / experience.
• Linux Knowledge.
• Experience with Cloud services like Azure
• Experience with Snowflake

Certifications Desired:

MS certifications on MSSQL latest versions.

Salary and Other Compensation:

Applications will be accepted until 15 Sep 2024.

The annual salary for this position is between $99,000 - $116,000 depending on experience and other qualifications of the successful candidate.

This position is also eligible for Cognizant’s discretionary annual incentive program and stock awards, based on performance and is subject to the terms of Cognizant’s applicable plans.

Benefits:

• Medical/Dental/Vision/Life Insurance
• Paid holidays plus Paid Time Off
• 401(k) plan and contributions
• Long-term/Short-term Disability
• Paid Parental Leave
• Employee Stock Purchase Plan

Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.