What are the responsibilities and job description for the Lead SQL developer position at Cognizant?
Cognizant (NASDAQ: CTSH) is a leading provider of information technology, consulting, and business process outsourcing services, dedicated to helping the world's leading companies build stronger businesses. Headquartered in Teaneck, New Jersey (U.S.). Cognizant is a member of the NASDAQ-100, the S&P 500, the Forbes Global 1000, and the Fortune 500 and we are among the top performing and fastest growing companies in the world.
Practice - AIA - Artificial Intelligence and Analytics
About AI & Analytics: Artificial intelligence (AI) and the data it collects and analyzes will soon sit at the core of all intelligent, human-centric businesses. By decoding customer needs, preferences, and behaviors, our clients can understand exactly what services, products, and experiences their consumers need. Within AI & Analytics, we work to design the future—a future in which trial-and-error business decisions have been replaced by informed choices and data-supported strategies.
By applying AI and data science, we help leading companies to prototype, refine, validate, and scale their AI and analytics products and delivery models. Cognizant’s AIA practice takes insights that are buried in data, and provides businesses a clear way to transform how they source, interpret and consume their information. Our clients need flexible data structures and a streamlined data architecture that quickly turns data resources into informative, meaningful intelligence.
Roles & Responsibilities
A Senior Database Engineer to collaborate with our engineering team to ensure aligned execution of database related activities. SQL Developer with hands-on experience, experience in query optimization and SQL performance tuning, and trouble shooting. Good experience working with planning, creating, scheduling, and monitoring batch jobs using any scheduling/ monitoring tools like CA Autosys or IBM Tivoli. Have a flair for investigating database problems, performance issues, and evaluating best practices to ensure optimal performance on the platform.
Job duties:
- SQL coding, analysis, support, proactive monitoring, troubleshooting, and design
- Designing and developing database code per business needs
- Troubleshooting challenging performance issues and developing proactive measures and trend analysis
- Monitoring database events and continuously optimizing system performance through troubleshooting and tuning
- Provide day-to-day support and maintenance for Microsoft SQL Server 2016/2019 databases for our platform.
- Investigating potential problems and issues raised by users
- Work with engineering team to automate reactive procedures and promote rapid response to database issues
- Maintaining database configurations in compliance with established best practices
Desired Candidate:
- 10 years of Database Development experience supporting mission critical relational databases
- Considerable experience and knowledge of MS SQL 2016 or above and best practices
- Proficiency with OLTP Database Environments
- Programming experience with .NET is a big plus, but not required
- Full systems lifecycle experience (from requirements to delivery) of database projects
- Experience designing, building, installing, configuring, supporting, and maintaining high-volume, large database systems
- Experience managing SQL Server table partitioning
- Good troubleshooting and analytical problem-solving skills
- Experience with database design and management aspects for various compliance programs
- Ability to work effectively in a team environment, as well as independently with limited supervision
Education: Bachelor’s in science engineering or equivalent.
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.
Cognizant is an Equal Opportunity Employer M/F/D/V. Cognizant is committed to ensuring that all current and prospective associates are afforded equal opportunities and treatment and a work environment free of harassment.
Cognizant is recognized as a Military Friendly Employer and is a coalition member of the Veteran Jobs Mission. Our Cognizant Veterans Network assists Veterans in building and growing a career at Cognizant that allows them to leverage the leadership, loyalty, integrity, and commitment to excellence instilled in them through participation in military service.
# L1-AV1# CB#Ind123
Employee Status : Full Time Employee
Shift : Day Job
Travel : No
Job Posting : Oct 05 2022
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.