Oracle DBA-3-5 Years

Job description

Position Description:

Position: Oracle DBA
Experience: 3-5 Years
Category: Software Development/ Engineering
Location: Bangalore
Position ID: J0924-1980
Employment Type: Permanent

• Steer and own overall product database. Ensure the adherence to database engineering best practices across entire database environment; develop and implement needed checks and processes.

• Understand big picture and client needs by engaging with Product owners and build right database designs.

• Support development organization from all aspects associated with database.

• Build designs that satisfy both functional and non-functional needs of the product and client needs.

• Lead 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

• Read through the Query Store reports, advise/suggest based on the observations

• Use of Extended Event – logging, understand the reports and work/suggest on next steps

Required qualifications to be successful in this role:

Must to have Skills- Mandatory Skills: Microsoft SQL Server, DB Design and Modelling, DB Normalization, DB Development, DB Tuning.

BS/MS degree in Computer Science, Engineering. Should be Analytically very strong.

• Hands on expertise in MS SQL Server & Oracle Database. Manage large Databases and solutions around that.

• Should have 2+ Yrs. of experience in Microsoft SQL Server, DB Design and Modelling, DB Normalization, DB Development, DB Tuning, SQL Reports.

• Successful track record in designing and implementing Microsoft SQL databases.

• Good command on Microsoft SQL Server, DB Design and Modelling, DB Normalization, DB Development, DB Tuning, SQL Reports.

• Knowledge about the Agile, Microservices Based development process and needs.

• Self-driven with great technical interests, should be quick learner, should have attention to Details.

• Possess good communication skills and Client Interaction experience.

• Earlier experience of working in products is preferable.

• Proficient in setting up Microsoft SQL Server and Oracle 19x(New database server setup )

• Troubleshooting & RCA

• Processing Data Base Change Request

• Database/PLSQL Packaging

• Scrub script preparation

• Data masking

• Schema Upgrade/Refresh (Upgrade to specific Build#)

• Performance Tuning activities

• Schema Creation

• DBCM Code changes/design discussions

• Environment Refresh (Client data dump import/export)

• SSAS Deployment/Insights activity

Skills:

·  English
·  Oracle
·  Cloud Computing
·  GIT
·  GIT
·  Jenkins
·  SQL Server

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.