Application Support & SQL
Department:
Job Summary
Application Support Engineer - .NET & SQL
Lets be unstoppable together!
Circana is a leading provider of technology AI and data solutions for consumer-packaged goods companies manufacturers and retailers. Our predictive analytics and Liquid Data platform help clients measure market share uncover consumer behavior and drive growthpowered by six decades of expertise and an expansive high-quality data set.
At Circana we are fueled by our passion for continuous learning and growth we seek and share feedback freely and we celebrate victories both big and small in an environment that is flexible and accommodating to our work and personal lives.â Were a global company dedicated to fostering inclusivity and belonging. We value and celebrate the unique experiences cultures and viewpoints that each individual brings. By embracing a wide range of backgrounds skills expertise and beyond we create a stronger more innovative environment for our employees clients and communities. With us you can always bring your full self to work.â Join our inclusive committed team to be a challenger own outcomes and stay curious together. Circana is proud to be Certified by Great Place To Work. This prestigious award is based entirely on what current employees say about their experience working at Circana. Learn more at .
Role Overview
The purpose of this role is to provide technical support maintenance and continuous improvement for enterprise data loading and data processing applications built primarily on and legacy technologies. The role focuses on ensuring production stability resolving incidents supporting SQL Server-based data operations and delivering application enhancements to meet business and operational requirements. A key aspect of the position is supporting Microsoft SQL Server stored procedures SQL Agent jobs and batch data processing workflows while driving operational excellence and system reliability.
Job Responsibilities
- Provide L2/L3 production support for data loading data processing and reporting applications.
- Monitor troubleshoot and resolve incidents impacting application availability data integrity and business operations.
- Support maintain and enhance applications developed technologies and legacy platforms.
- Develop modify debug and optimize Microsoft SQL Server stored procedures functions views and T-SQL scripts.
- Monitor and support SQL Server Agent Jobs batch processing schedules and automated data loading processes.
- Investigate failed SQL jobs data load exceptions and application errors ensuring timely resolution within SLA commitments.
- Perform root cause analysis for recurring incidents and implement permanent corrective actions to improve system stability.
- Review execution plans and optimize SQL queries and stored procedures to improve performance and processing efficiency.
- Support application releases deployments and post-implementation validation activities.
- Work closely with business users support teams and developers to resolve production issues and implement enhancements.
- Validate data loads and troubleshoot data discrepancies across multiple systems and databases.
- Prepare and maintain support documentation operational procedures and knowledge base articles.
- Identify opportunities for automation and process improvements to reduce manual effort and recurring incidents.
Requirements Must have:
- 3-7 years of experience supporting enterprise applications in production environments.
- Strong experience with Microsoft SQL Server including:
- Stored Procedures
- T-SQL Development
- Functions and Views
- Query Optimization
- Performance Tuning
- SQL Agent Jobs
- Database Troubleshooting
- Hands-on experience supporting data loading ETL data integration or batch processing applications.
- Experience providing L2/L3 production support and incident management.
- Strong debugging and troubleshooting skills across application and database layers.
- Experience supporting applications developed (C#) and legacy environments.
- Proven ability to perform root cause analysis and problem management activities.
- Experience investigating job failures data processing issues and application performance bottlenecks.
- Strong understanding of application maintenance defect resolution and enhancement delivery.
- Excellent communication skills.
Nice to have:
- Knowledge of the FMCG business domain
- Knowledge of data warehousing and data pipeline concepts.
- Experience in Python
Circana Behaviors
Beyond technical skills experience and role-specific attributes these shared behaviors are fundamental to our culture and success. We seek individuals who consistently demonstrate and champion these behaviors in their daily work:
- Stay Curious: Being hungry to learn and grow always asking the big questions.
- Seek Clarity: Embracing complexity to create clarity and inspire action.
- Own the Outcome: Being accountable for decisions and taking ownership of our choices.
- Center on the Client: Relentlessly adding value for our customers.
- Be a Challenger: Never complacent always striving for continuous improvement.
- Champion Inclusivity: Fostering trust in relationships engaging with empathy respect and integrity.
- Commit to each other: Contributing to making Circana a great place to work for everyone.
Location: This position can be located in the following area(s): Bangalore
An offer of employment may be conditional upon successful completion of a background check in accordance with local legislation and ourcandidate privacy notice. Your current employer will not be contacted without your permission.
Required Experience:
IC
About Company
Circana offers clarity from complexity. Dive deep into consumer behaviors & trends across industries. Optimize decisions & inspire action.