Oracle DBA

Oracle DBA Position Description Do you want to take your career to the next level as part of a dynamic company that gives you a direct stake in its success? Are you ready for the responsibility of working with high profile clients? We are seeking a motivated Oracle DBA to join our team. Your attention to detail and positive attitude will be highly valued. If you are great with juggling different tasks and like working with smart, talented people, this is the place for you!Your future duties and responsibilities This will be a great opportunity to the right candidate providing member exposure to working of a Global Supply Chain organization in a collaborative environment with team member's spread across the globe. Besides technical skills, the member should be fluent in English. Working knowledge of Agile processes & tools, CICD tools like Gitlab, Jenkins required.• Should be familiar with working in Agile mode• Perform applications database administration (Oracle and SQL server) functions including SQL code review, performance analysis, query tuning, database application design, physical data modeling, and developer support• Work with development teams in database design process and make suggestions/recommendations based on data manipulation needs of the application.• Setup and Manage Oracle streams and Golden gate.• Shell Scripting for standards database activities.• Knowledge on Sql loader.• Actively monitor database servers and respond to any alerts• Works with customers on fixing production issues.• Provide database support in all phases of SDLC.• Work with team members to come up with solutions in line with group's standards• Participate in 24X7 for various production support, database maintenance, housekeeping and installs• Collaborate with Operations Database group, Systems Administrators and Capacity Planning groups as and when situation demands• Ability to quickly diagnose the problem areas and come up with solutions and/or workarounds• Evaluation and recommendation of software products in database management arena.• Should have strong time management skills with willingness and ability to prioritize multiple projects/initiatives at the same time.• Proactive with strong team, interpersonal and communication skills• Setup DR and HA strategy and support routine DR testing.• Establish database standards for operations, upgrades, migrations and onboarding new applications and/or clients.• Write clear, concise, well organized user documentation to maintain standards and procedures.• Balance various database infrastructure projects.• Maintain and manage yearly, monthly and weekly Partitions for Partitioned tables and indexes.Required qualifications to be successful in this role CGI is looking for an experienced Oracle DBA with minimum 10 years experience, with good written & oral communication skills. This right person for this role should possess following skills:• 7+ years of experience in Oracle DBA with performance tuning expertise.• 3+ years of DBA experience in other DBMS systems (SQL Server, Azure and Mongo DB). - optional• 5+ years of shell scripting experience.• Ability to work well in a team environment, as well as maintaining a flexible attitude are a must• Ability to develop and drive database administration strategies and initiatives as per the needs of the team• Ability to quickly synthesize ideas, options, and thoughts into solutions to management to aid in decision-making• Prior hands on working experience in Oracle DBA with performance tuning expertise and exposure to other DBMS systems (SQL Server, Azure and Mongo DB) is key to be successful in this role.• Ability to multitask on several projects is key to be successful in this role.• Good communications skills are a must, as this role involves working with business users; managing expectations.• Oracle 11g, 12c and 19c• Bachelor's Degree#doubledown

• Database Administration
• Oracle
• Shell Script