2018
NorthBrunswick, NJ, USA
2008
09/2016 to Current
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-485-6758 | christian.chiejina@gmail.com
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.
