Domain Consultant L2

Wipro • Phoenix, AZ

4d

About The Position

Wipro is hiring a Domain Consultant L2 to work on database development and support, with mandatory experience in Utilities Transmission and Distribution. The role involves developing and maintaining SQL database objects, optimizing queries and database performance, and supporting database work across the software development lifecycle. The consultant will collaborate with development and QA teams, contribute to Agile or Scrum activities, maintain technical documentation, and investigate production database issues. The expected compensation ranges from $60,000 to $135,000, with final compensation based on factors including location, minimum wage obligations, skills, and relevant experience.

Requirements

• 5–8 years of experience.
• Mandatory skill: Utilities Transmission and Distribution.
• Strong knowledge of stored procedures, functions, views, joins, CTEs, indexing, and query optimization.
• Experience with database performance tuning and troubleshooting.
• Good understanding of relational database design, normalization, and data modeling.
• Strong understanding of SDLC methodologies, including Agile/Scrum or Waterfall.

Responsibilities

• Develop and maintain complex SQL queries, stored procedures, functions, triggers, and other database objects.
• Optimize queries and indexes, troubleshoot database issues, and tune database performance.
• Participate in SDLC activities, including requirements analysis, design, development, testing, deployment, and production support.
• Design and modify database tables and schemas to meet application and business requirements.
• Perform unit testing, troubleshoot defects, and support UAT and release activities.
• Work with development and QA teams on data validation, reconciliation, and defect resolution.
• Maintain technical documentation and required SDLC artifacts.
• Follow version-control and CI/CD practices for database and application changes.
• Participate in Agile/Scrum ceremonies and collaborate with distributed teams.
• Support production issues and perform root-cause analysis for database-related problems.

Benefits

• Medical benefits options
• Dental benefits options
• Disability insurance
• Paid time off, inclusive of sick leave
• Other paid and unpaid leave options

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed