Location
Bangalore | India
Job description
Database Administrator
Position Description
Designation / Job Title : Database Administrator
Years of Experience : 3-5 years
Location : Mumbai
Position / Job Description :
• 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.
Job Role / Your future duties & 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 for this role :
• BS/MS degree in Computer Science, Engineering. Should be Analytically very strong.
• Hands on expertise in Oracle Database. Manage large Databases and solutions around that.
• Should have 3+ Yrs. of experience in Oracle, 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
Technologies required :
Oracle, (Sqlsrv - secondary)
Skills :
Mandatory Skills: DB Design and Modelling, DB Normalization, DB Development, DB Tuning, DB Administration
Your future duties and responsibilities
Required qualifications to be successful in this role
Insights you can act on While technology is at the heart of our clients’ digital transformation, we understand that people are at the heart of business success.
When you join CGI, you become a trusted advisor, collaborating with colleagues and clients to bring forward actionable insights that deliver meaningful and sustainable outcomes. We call our employees “members” because they are CGI shareholders and owners, and, as owners, we enjoy working and growing together to build a company we are proud of. This has been our Dream since 1976, and it has brought us to where we are today—one of the world’s largest independent providers of IT and business consulting services.
At CGI, we recognize the richness that diversity brings. We strive to create a work culture where everyone belongs, and we collaborate with clients in building more inclusive communities. As an equal opportunity employer, we empower all our members to succeed and grow. If you require an accommodation at any point during the recruitment process, please let us know. We will be happy to assist.
Ready to become part of our success story? Join CGI—where your ideas and actions make a difference.
Job tags
Salary