Senior SQL DBA
Location: Atlantic City, New Jersey (Open to Remote- Hybrid )
*You must be legally authorized to work in United States without the need of employer sponsorship, now or at any time in the future*
Qualification:
- Science / Engineering graduate
- 9+ years of experience as a SQL DBA working in a production environment (application support, development, etc)
- Experience of working within an ITIL framework and/or service-oriented organization
- Good written and verbal communication skills
- Documentation skills for processes and procedures
Responsibility:
- Providing level 2 and 3 support for SQL database environment while supporting migration efforts into the cloud.
- Exposure to AlwaysON and PowerShell scripting experience
- Knowledge on Azure Cloud Environment
- experience in installation and patching of SQL Server (2008R22014,2016)
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
- Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
- Strong Experience in High availability(Replication,Logshipping,alwayson,cluster environment)
- Experience in virtualization environment
- Experience with MS SQL Server 2022, 2019, 2017, 2016, 2014, 2012 Enterprise on Windows/Linux
- Experience with MS SQL Server in a clustered environment is a plus (Always on)
- Knowledge/experience with DR (Disaster Recovery) drill and always on
- Experience on database migrations, up-gradation and patching
- Ability to detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention.
- Strong knowledge of backups, restores, recovery models, database shrink operations
- Experience in implementing operational automation.
- Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
- SQL Development ability to write and troubleshoot SQL Code and design ( stored procedures, functions, tables, views, triggers, indexes, constraints
- Power shell scripting knowledge
- Good Hands-on knowledge on PostgreSQL or Mongo
- PostgreSQL/MONGO experience (including replication, partitioning, high availability)
- Install POSTGRESSQL/MONGO server software.
Must Have Skills
- PostgreSQL
- Mongo DB
- SQL Server DB Administration
Good To Have Skills
- MySQL DB Administration
Salary and Other Compensation:
The annual salary for this position is between $[45,000.00 – 128,000.00] depending on experience and other qualifications of the successful candidate.
This position is also eligible for Cognizant’s discretionary annual incentive program, based on performance and subject to the terms of Cognizant’s applicable plans.
Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:
· 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.
#LI-IR1 #CB #Ind123
Employee Status : Full Time Employee
Shift : Day Job
Travel : No
Job Posting : Mar 14 2024
About Cognizant
Cognizant (Nasdaq-100: CTSH) is one of the world's leading professional services companies, transforming clients' business, operating and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build and run more innovative and efficient businesses. Headquartered in the U.S., Cognizant is ranked 185 on the Fortune 500 and is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital at www.cognizant.com or follow us @USJobsCognizant.Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.
Cognizant is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.
If you have a disability that requires a reasonable accommodation to search for a job opening or submit an application, please email CareersNA2@cognizant.com with your request and contact information.