Oracle Data

****

NorthBrunswick, NJ, USA

****

**/**** ** *******

Hampton, GA

CHRISTIAN CHIEJINA

OBJECTIVE

Highly diligent and dedicated Database Administrator with strong verbal and communication skills seeking a challenging and performance driven position with an innovative, resourceful and fast growing organization. Education

Bachelor of Science: Mathematics

Rutgers State University of NewJersey

Bachelor of Science: Electrical Electronics

University of Lagos

Certification

Oracle Certified Associate

Summary of Skills

Professional experience of Oracle 11g/10g and

12c database server installation and

administration.

In dept knowledge of PL/SQL, Backup/Restore,

Troubleshooting and Performance tuning on 24/ 7

/ 365.

Professional experience of high availability

technology like RAC, Data Guard and Cluster.

Experience working in Windows, HP-UX and AIX.

Experience working on UNIX, LINUX and

windows.

Extensive performance tuning experience,

specializing in instance tuning and SQL

optimization.

Extensive experience with designing and

implementing Oracle databases, including

systems architecture, project management,

implementation and tuning.

Proven capability to approach problems

effectively and creatively in complex environment. Technical Proficiency

Database Utilities SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Table spaces, SQL*Loader, RMAN, Data Pump, Export, Import, 12C Grid control and Golden gate Work Experience

Oracle Database Administrator

Providence Solutions

Supporting multiple databases for production, development, test and staging purposes on Linux environment.

Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases. Refreshing Dev and Test instances with data from Production on a regular basis. C: 732-***-**** *********.********@*****.***

01/2014 to 06/2016

North Brunswick, NJ

Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.

Thorough knowledge in setting up infrastructure for databases in huge data-centers. Installed Oracle 11g on Linux platform using ASM.

RMAN point in time recovery and Instance recovery done on 11g Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.

Upgrade and Migration of Database from 11g to 12c and applying patches whenever required. Monitoring and optimizing the performance of the database/application using OEM along with homespun scripts.Capacity planning: Allocate system storage and plan future storage requirements. Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls. Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.

Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation. 24x7 Production Support. Responsible for Backup and Recovery for Oracle Database. Responsible for designing the Oracle Database and schemas. Creating OEM alerts that provides notifications through emails. Thorough knowledge in setting up infrastructure for databases in huge data centers. Detecting and correcting instance performance problems. Locating and tuning SQL statements. Involved in session management and monitored the critical wait events, blocking sessions in the database

.

Worked on user management mainly on grants, privileges, roles and profiles. Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.

Implemented both unidirectional replication as well as bi-directional replicate using Golden Gate. Migrating data across different platforms.

Creating listeners, services, public and private database links. Managing, training and supervising offshore teams and Junior DBA's. Experienced with running Oracle database on Virtual Machines. Experience in managing large databases involving Partitions. IT Systems Administrator

Walmart

Planned and implemented high availability solution such as Real Application Cluster(RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file system.

Fixed bugs as they were encountered.

Executed functionality and feature development both within current application framework and on next-generation frameworks.

Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls. Worked on both VMS and UNIX environments.

Performing monthly and annual performance reports for trend analysis capacity planning. Performing housekeeping tasks like checking logs and trace files. Monitoring rollback segment and temporary table space use. Strong skills in applying security patches(patch set, Critical patch updates(CPU)/patch set updates(PSU)) using perl based utility "Opatch".

Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints whenever possible, amongst others. Participate in Conference discussions about the different applications and database environments. Performed database tuning and resolved database access issues. Maintain excellent communication with management during various projects. User creation and implemented Security administration by creating roles, views and granting the necessary system privileges for users.

01/2012 to 01/2014

Edison, NJ

Consolidate databases onto less servers to cut software and infrastructure costs. Experience in 24x7 on call production system support as well as development support. Loading data from flat files to database using SQL*Loader, External Tables. Investigating suspicious database activity using Auditing. Design and implement database scripts to incorporate schema changes as needed. Applied quarterly patches in Oracle PSU / CPU.

Upgrading of oracle database in different and multiple platforms. Very familiar with new features of 12c and have good experience with 12c. Experience with Tapes Backups and Storage/Recovery from Tapes. Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.

DBA

The Total Computer & Communication Solution Company Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.

Refreshing Dev and Test instances with data from Production on a regular basis. Installed Oracle 11g on Linux platform using ASM.

RMAN point in time recovery and Instance recovery done on 11g. Monitoring and optimizing the performance of the database/application using OEM along with homespun scripts.

Creating OEM alerts that provides notifications through emails. Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance. Extensively used AWR, ADDM and explain plan for periodic performance tuning. Loading data from flat files to database using SQL*Loader, External Tables. Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

Refreshed/cloned databases using RMAN utility.

Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Made optimal use of Oracle Support in resolving the SRs. Involved in converting a single instance database to Oracle 11g, 10g RAC databases. Designing and developing SQL procedures, query performance tuning. Handled daily production problems/change requests with Oracle. Proactively managed the databases; set up alarms for managing any exceptions in day-to-day management of the databases; pre-empted and prevented issues, disasters from happening. Worked on application and database security (data access, passwords, network, etc). Monitored database and SQL performance using Stats pack, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.

Implemented Data Guard on Oracle 11g with high availability and performance configurations and participated in Data Guard Fail over tests.

Export and Import of database objects to copy from one database to another database. Worked extensively on monitoring grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.

Expertise in maintaining Database Security using auditing. Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Proactively managed the databases; set up alarms for managing any exceptions in day-to-day management of the databases; pre-empted and prevented issues, disasters from happening. Monitoring several databases varying Terra byte sizes using Oracle Enterprise Manager Grid Control.

Contact this candidate