Database Administrator
Position Description Company Profile: Founded in 1976, CGI is among the largest independent IT and business consulting services firms in the world.
Position Description Company Profile: 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 Job Title: Teradata Senior Database Administrator Position: Senior Systems Engineer Experience: 5 to 7 Yrs Category: IT Infrastructure Main location: Hyderabad / Bangalore Position ID: J0826-1921 Employment Type: Full Time Qualification: Bachelor’s degree in computer science or related field or higher with minimum 3 years of relevant experience. Job Description: Teradata Query Performance DBA Key Responsibilities . Monitor Teradata database performance, system health, and workload utilization. . Analyze and troubleshoot slow running, resource intensive, and failed queries. . Perform detailed SQL/query performance tuning using Teradata Explain plans and performance tools. . Analyze query execution plans and identify issues and collect, validate, and maintain optimizer statistics to improve query plans. . Recommend appropriate Primary Indexes, Secondary Indexes, Partitioned Primary Indexes (PPI), Join Indexes, and other physical design improvements. . Monitor and tune Teradata Workload Management (TASM) policies and workload classifications. . Investigate workload bottlenecks and recommend changes to workload priorities and resource allocations. . Work with application and development teams to optimize SQL and ETL workloads. . Review new SQL/code changes for potential performance impacts. . Participate in incident management and root cause analysis for database performance issues. . Develop scripts and automation for performance monitoring and recurring DBA activities. . Prepare performance reports and recommendations for technical and business stakeholders. . Required to work in US Eastern shifts #LI-SY4
Your future duties and responsibilities
Required qualifications to be successful in this role
Posted September 1, 2026