Company:
Founded in 1976, CGI is among the largest independent IT and business consulting services firms in the world. With 94,000 consultants and professionals across the globe, CGI delivers an end-to-end portfolio of capabilities, from strategic IT and business consulting to systems integration, managed IT and business process services and intellectual property solutions. CGI works with clients through a local relationship model complemented by a global delivery network that helps clients digitally transform their organizations and accelerate results. CGI Fiscal 2024 reported revenue is CA$14.68 billion and CGI shares are listed on the TSX (GIB.A) and the NYSE (GIB). Learn more at cgi.com.
Position: Associate Consultant-ERP Application & Database Performance Tuning Engineer
Experience: 10-15 years
Category: Software Development/ Engineering
Shift Timing: General Shift/Second Shift
Location: Mumbai, Hyderabad and Chennai
Position ID: J0526-2120
Employment Type: Full Time
Position Description:
We are looking for an experienced ERP Application & Database Performance Tuning Engineer who can proactively identify, troubleshoot, and resolve performance bottlenecks across ERP applications and databases. The candidate will play a critical role in ensuring system stability, optimizing application and database performance, and improving overall operational efficiency in enterprise ERP environments
Your future duties and responsibilities
- Analyze and resolve ERP application and database performance issues in production and non-production environments.
- Perform performance tuning for ERP applications, database queries, batch jobs, reports, APIs, and integrations.
- Identify bottlenecks related to application processing, SQL execution, indexing, memory utilization, locking, and infrastructure.
- Optimize database performance through query tuning, indexing strategies, execution plan analysis, partitioning, and statistics management.
- Troubleshoot slow-running ERP components such as Process Scheduler jobs, App Engines, reports, workflows, integrations, and interfaces.
- Monitor ERP application servers, databases, middleware, and infrastructure health.
- Analyze logs, thread dumps, heap dumps, AWR/ASH reports, wait events, and system metrics for root cause analysis.
- Tune application server configurations, connection pools, cache settings, and multithreaded jobs.
- Support critical production incidents and ensure timely issue resolution.
- Work closely with ERP technical, functional, infrastructure, middleware, and DBA teams.
- Recommend architecture and configuration improvements for better scalability and performance.
- Prepare technical documentation, tuning guidelines, and operational knowledge articles.
Required qualifications to be successful in this role
Qualification Education Qualification: Bachelor’s degree in computer science or related field or higher with minimum 8 years of relevant experience in ERP application support, database administration, or performance tuning roles.
Must to have :
- Strong experience in ERP application support and database performance tuning.
- Hands-on experience with:
o ERP application troubleshooting
o SQL query optimization
o Database performance analysis
o Production issue resolution
o Oracle / SQL Server / PostgreSQL databases
o ERP application architecture
o Application servers and middleware
o Linux/Unix performance monitoring
o SQL execution plan analysis
o Index tuning
o Locking/blocking analysis
o Memory and CPU utilization analysis
o Batch and report performance optimization
- Ability to analyze AWR reports, thread dumps, GC logs, and database wait events.
- Strong analytical and debugging skills.
Good to have :
- Experience with ERP platforms such as PeopleSoft, SAP, Oracle ERP, or similar enterprise applications.
- Familiarity with:
o Process Scheduler tuning
o Integration Broker/API performance tuning
o BIRT/SQR/App Engine/COBOL/reporting performance optimization
- Experience with cloud and containerized ERP environments.
#LI-SB15
CGI is an equal opportunity employer. In addition, CGI is committed to providing accommodation for people with disabilities in accordance with provincial legislation. Please let us know if you require reasonable accommodation due to a disability during any aspect of the recruitment process and we will work with you to address your needs.
Together, as owners, let’s turn meaningful insights into action.
Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…
You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.
Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.
You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.
Come join our team—one of the largest IT and business consulting services firms in the world.
