Database Administrator

Job Description

Position Description:

Job Title: Oracle DBA
Position: Software Engineer
Experience: 3-5 Years
Category: Software Development/ Engineering
Job location: Mumbai or Bangalore
Position ID: TBD
Employment Type: Full Time
Qualification: Bachelor's degree in Computer Science or related field or higher with minimum 3 years of relevant experience.
Understand big picture and client needs by engaging with Product owners and build right database designs.
• Support Production and UAT databases and help them with their Product Upgrade from DB perspective.
• Lead and Own client data base upgrade & migration activities
• Keep / Optimize database for operational and performance efficiency. Identify any existing deficiencies and rectify.
• Database management, Maintenance and Troubleshooting activities.
• Handle deadlock, performance and other complex issues.
• Improve overall team’s knowledge and skills.
Your future duties and responsibilities
Engage in client upgrade projects and drive requirements.
• Plan and drive migration/upgrade projects
• Troubleshoot and perform RCA on incidents
• Optimize database platforms
• Perform health checks and right size environments
• Carry performance tuning activities
• Drive database automation
• Hands-on with writing Queries
• Read execution plans – infer and advise changes based on the plans
• Index monitoring/maintenance
• Query Statistics monitoring/maintenance
• Use Database Engine Tuning Advisor
• Use of Extended Event – logging, understand the reports and work/suggest on next steps
• Be open to research arond new requirements like Oracle to Sqslrv migration, Oracle to Postgress migration. Evaluating a DB Automation tool etc.
Required Qualifications To Be Successful In This Role
Must-to Have Skills: Oracle , Backup Strategy, DB/Query Tuning. Instance Upgrade, Cross-Platform experience

Skills:

• Database Tuning
• English
• GIT
• GIT
• Jenkins
• MS SQL Server
• Oracle

What you can expect from us:

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.