**About the role**
As a Database Engineer Manager at Cognizant TriZetto, you will design and implement product database schemas. You will assist development teams with database design, installation, monitoring, maintenance, and performance-tuning. You will use your technical abilities and knowledge to help support solutions that meet business outcomes and operational requirements.
As a member of an internal database team, you will support multiple database server installations.
This is a development database engineering position, not a production database engineering position. Normal office hours will be observed with rare weekend or after-hours work required. There is no on-call rotation. Duties are shared among the team members including offshore members.
The successful candidate will have a desire to improve their database skills and enjoys working in a collaborative environment. You must be able to demonstrate the ability to adapt and learn new skills as required to help the business reach its goals.
**In this role, you will:**
Essential Functions
- Provide support for database platforms (MS SQL Server, MongoDB)
- Become knowledgeable in existing processes and procedures.
- Design and implement Schema changes to support delivery of Product features.
- Contribute to database and query performance improvements.
- Contribute to documentation as needed.
- Remain knowledgeable on current technical trends and practices.
- Work within the organization to establish and grow best database practices and procedures.
**Work model**
We believe hybrid work is the way forward as we strive to provide flexibility wherever possible. Based on this role's business requirements, this is a hybrid position requiring 3 days a week in a client or Cognizant office in Mesa, AZ. Regardless of your working arrangement, we are here to support a healthy work-life balance though our various wellbeing programs.
The working arrangements for this role are accurate as of the date of posting. This may change based on the project you're engaged in, as well as business and client requirements. Rest assured; we will always be clear about role expectations.
**What you must have to be considered**
Required Experience:
- Experience with Microsoft SQL Server in any edition from SQL Server 2005 and above
- Experience with or interest in NoSQL databases such as MongoDB
- Experience writing code such as Transact SQL
- Understands the concept of relational databases versus NoSQL databases
Behavioral Competencies:
- Team player and works well in large group environments
- Possess strong ability to tackle complex problems creatively, manage risk and influence rapid decision-making
- Highly driven and self-motivated, takes initiative
- Goal oriented
- Accountable to self and team
- Passion for learning new business, software and process concepts
- Desire to learn performance tuning and troubleshooting
- Ability to tackle problems to seek solutions
- Good written and verbal communication skills
Technical Competencies:
Demonstrated enterprise-level knowledge of systems design.
Advanced knowledge of SQL design, implementation, and performance tuning.
Advanced knowledge of relational databases, such as SQL Server.
Competency in technologies such as: -
- Microsoft SQL Server 2005 and above i.e:
o Ability to install or learn to install and configure SQL Server in VM environments
o Ability to perform or learn to perform backups and restores
o Ability to create SQL Server Agent jobs as needed
o Ability to use or learn to use Profiler traces and other tools.
o Ability to write or learn to write Transact SQL code
o Familiarity with Query Store
o Familiarity with database concepts such as indexes, foreign keys, stored procedures.
o Ability to manage database server security
- Familiarity with NoSQL databases such as MongoDB a plus
- Familiarity with SQL Server Integration Services a plus
- Microsoft Office Components
- Familiar with E/R Studio (any version) is a plus.
- Ability to create documentation to share knowledge gained with others
**These will help you stand out**
Desired Experience:
- Prior experience in healthcare industry a plus.
- Experience with "free" tools such as sp_whoisactive, FirstResponder Kit, and DMV queries
- Experience with Alpha Anywhere server and development tools.
Education: Bachelor's degree in computer science or a related discipline. An equivalent combination of education and work experience may be taken into consideration in lieu of a degree.
We're excited to meet people who share our mission and can make an impact in a variety of ways. Don't hesitate to apply, even if you only meet the minimum requirements listed. Think about your transferable experiences and unique skills that make you stand out as someone who can bring new and exciting things to this role.
_*Please note, this role is not able to offer visa transfer or sponsorship now or in the future*_
\#LI-NC1
**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.
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.