Oracle Database Administrator

Job description

Job Description

Oracle Database Administrator

Position Description
Database Administration for supporting Payment group products. DBA will be responsible for install and maintain development databases. He will also be the SPOC for attending and resolving client production issues, DB queries and analysis. DBA will be working closely with various project groups (Development/Maintenance/Support) to ensure a smooth functioning of product environments

Participates in client/project meeting(s) for highly complex project definition, needs assessment on production issues. Evaluates the needs and requirements of the users and provides technical expertise in the development of technical, structural and organizational specifications. Determine appropriateness of data for storage and optimum storage organization.

Support clients at multi geographies. Attend the escalated DB issues and bring the same to closure by working along with Geo BU counterparts

Creates, documents and implements standards and/or complex modeling to monitor and enhance the capacity and performance of the database. Codes complex programs and derives logical processes on technical platforms.

Implement, support and manage the BFSI database.

Design and configure relational database objects.

May design, deploy and monitor database servers.

Design data distribution and data archiving solutions.

Ensure database security, including backups & disaster recovery.

Plan and implement application and data provisioning.

Produce entity relationship & data flow diagrams, database normalization schemata,

logical to physical database maps, and data table parameters.

Proficient in one or more of the leading database management systems, such as, Oracle(Primary), Microsoft SQL Server and IBM DB2

Write Stored procedures, packages, triggers & functions to perform complex functions.

Performance Tuning - able to analyze AWR, ASH, ADDM and STATSPACK reports

Support multiple databases, areas like RAC, Data guard, ASM, RMAN, TKPROF

Perform shell Scripting, Unix Administration when needed

Install and configure Oracle Database

Upgrade database to current version of Oracle

- Backup and restore

- Export / Import

- Troubleshooting complex problems

Your future duties and responsibilities
Your future duties and responsibilities
• Participates in client/project meeting(s) for highly complex project definition, needs assessment on production issues. Evaluates the needs and requirements of the users and provides technical expertise in the development of technical, structural and organizational specifications. Determine appropriateness of data for storage and optimum storage organization.
• Support clients at multi geographies. Attend the escalated database issues and bring the same to closure by working along with onsite counterparts
• Creates, documents and implements standards and/or complex modeling to monitor and enhance the capacity and performance of the database.
• Implement, support and manage multiple databases.
• Design and configure relational database objects.
• Design, deploy and monitor database servers.
• Design data distribution and data archiving solutions.
• Ensure database security, including backups & disaster recovery.
• Plan and implement application and data provisioning.
• Produce entity relationship & data flow diagrams, database normalization schemata,
• logical to physical database maps, and data table parameters.
• Proficient in one or more of the leading database management systems, such as, Oracle(Primary), Microsoft SQL Server and IBM DB2
• Write Stored procedures, packages, triggers & functions to perform complex functions.
• Performance Tuning - able to analyze AWR, ASH, ADDM and STATSPACK reports
• Support multiple databases, areas like RAC, Data guard, ASM, RMAN, TKPROF
• Perform shell Scripting, Unix Administration when needed
• Install and configure Oracle Database
o Upgrade database to current version of Oracle
o Backup and restore
o Export / Import
o Troubleshooting complex problems

Required qualifications to be successful in this role
equired qualifications to be successful in this role
Years of experience: 8 to 10 Years
Primary Skill: Oracle DBA, Performance Tuning
Secondary Skill: PL/SQL Programming, Shell Scripting and Unix Administration
Mandatory: Oracle DBA, Performance Tuning, PL/SQL Programming, Shell Scripting
Optional: Unix Administration
Certifications; OCP in Oracle DBA

Build your career with us.

It is an extraordinary time to be in business. As digital transformation continues to accelerate, CGI is at the center of this change—supporting our clients’ digital journeys and offering our professionals exciting career opportunities.

At CGI, our success comes from the talent and commitment of our professionals. As one team, we share the challenges and rewards that come from growing our company, which reinforces our culture of ownership. All of our professionals benefit from the value we collectively create.

Be part of building one of the largest independent technology and business services firms in the world.

Learn more about CGI at www.cgi.com.

No unsolicited agency referrals please.

CGI is an equal opportunity employer.

Skills

·  Database Mgmt Systems DBMS
·  Database Mgmt Systems DBMS
·  Oracle
·  Shell Script

Reference

718477