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. Responsibilities Direct Responsibilities The mission of this position is to maintain our MS Sql Server (2012/19 or later versions), Oracle environment (about 130 Oracle instances for the entire APS), and PostgreSQL databases, ensure data integrity, availability of environment and provide support to developers.
• Execute requested actions based on defined procedures and processes: Ensure data integrity and maintain a high level of databases availability. Manage database backups, restores, and recovery strategies. Migrate databases from legacy to cloud. Perform performance tuning of databases. Maintain multiple databases in accordance with the cloud architecture and standards. Develop scripts to automate manual tasks while providing documentation and procedures. Use Oracle Enterprise Manager Cloud Control to monitor and administer Oracle databases. Ensure compliance with security policies, patching, and updates. Collaborate and work with developers. Manage internal security within the databases (user roles, privileges, auditing). Industrialize manual tasks using Ansible while providing documentation and procedures. Resolve N2/N3 incidents and plan changes. Monitor database performance metrics and suggest improvements. Implement proactive alerts and performance tuning recommendations. Install, configure, migrate, and upgrade databases. Manage database maintenance tasks and capacity planning.
• Coordinate above actions with other teams, especially Paris APS & worldwide application development teams. Contributing Responsibilities
• Contribute to the knowledge transfer with Paris APS teams.
• Contribute to the definition of procedures and processes necessary for the team.
• Help build team spirit and integrate into BNP Paribas culture.
• Contribute to the regular activity reporting and KPI calculation.
• Contribute to continuous improvement actions.
• Contribute to the acquisition by ISPL team of new skills & knowledge to expand its scope. Technical Competencies
• Knowledge on Cloud (Iaas, Paas).
• In depth knowledge of Microsoft SQL Server (2012, 2019, or later versions).
• Knowledge in performance tuning and optimization (e.g., Execution Plans, Indexing strategies, DMV/DMF).
• In depth knowledge of SQL Server Management Studio (SSMS) and Azure Data Studio.
• Knowledge of third party SQL tools (e.g., Redgate SQL Toolbelt, SolarWinds Database Performance Analyzer, or TOAD for SQL Server).
• Knowledge with T SQL.
• Knowledge of scripting with Shell Bash and /or Python.
• AIX/Linux/Windows server administration knowledge.
• Be able to work in Agile Way Of Working.
• Knowledge of Oracle 19c and/or PostgreSQL and/or MongoDB is good to have.
• Knowledge of Always On Availability Groups (AG) and Database Mirroring.
• Knowledge of SQL Server on Azure VM or Managed Instance (or high end SAN/HCI infrastructure).
• Knowledge of SQL Server Integration Services (SSIS) or Bulk Insert/BCP tools.
• Problem determination, workaround resolution, root cause analysis, major incident management
• Knowledge on ITIL: IT Service Management
• Azure Data Studio / SSMS Behavioral competencies
• Agile environment.
• Follows the Customer processes for projects, incident and change management.
• Being standalone and team worker, analytical minded, meet commitment, ability to work in a dynamic and multi cultural environment, flexible, customer oriented, understand risk awareness.
• Motivated self starter, process oriented with high attention to detail
• Quick self starter, pro active attitude.
• Good communication skills, Good analytical and synthesis skills.
• Autonomy, commitment and perseverance.
• Ability to work in a dynamic and multicultural environment.
• Flexibility (in peak periods extra efforts may be required).
• Open minded and show flexibility in self learning new technologies/tools.
• You are customer minded and can translate technical issues into non technical explanations.
• You are always conscious about continuity of services.
• You have a very valuable team spirit and share your knowledge and experience with other members of the team. Working in collaboration with team.
• Client oriented, analytical, initiative oriented and able to work independently.
• Be flexible and ready to provide support outside of Business hours (on call).
• Able to take additional responsibility.
• Able to work from base location Chennai/Mumbai (Whichever is your base location) during hybrid model. Specific
Qualifications:
• Minimum 5 years of experience along with Bachelor's Degree in IT or engineering or equivalent experience.
• Prior experience in similar domain. Skills Referential (Required Knowledge, Skills And Abilities) Behavioral
Skills:
• Ability to collaborate / Teamwork
• Ability to deliver / Results driven
• Communication skills oral & written
• Creativity & Innovation / Problem solving Education Level: Bachelor's degree or equivalent
Location:
Bangalore/Chennai Life at CGI: It 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. LI-SA2 Your future duties and responsibilities Required Qualifications To Be Successful In This Role 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. That same commitment to fairness extends to how we use technology. To support our recruitment team, AI tools may be used to help assess applications though they never replace human judgement. All hiring decisions remain entirely in the hands of our recruitment professionals. Come join our team—one of the largest IT and business consulting services firms in the world.
📌 30520-SQL (Bengaluru)
🏢 CGI
📍 Bengaluru