Gloria Njoku

434-***-**** adn2sn@r.postjobfree.com (USA GREENCARD)

ACADEMIC QUALIFICATIONS

Qualifications Obtained, Institution, Date of Graduation

MBA (HRM), Multimedia University, Cyberjaya, Malaysia. July

B.Sc. (ED) University of Nigeria Nsukka, Nigeria. December 1997.

SUMMARY

Oracle/PostgreSQL Database Administrator with nearly 7 years of hands-on experience in database installation and configuration, production and development support, upgrades and patches, performance monitoring and tuning, backup and recovery, space management, database security, cloning and migration.

Database Administrator 02/2016 - present.

Logitech, Birmingham, AL

Database Administrator

Managed databases via TOAD, SQL Developer and 13c Cloud control.

Implementation of High Availability solutions with Oracle 12c on RAC and Data Guard

Created restore points and bounced the database.

Start/stop OEM agent

Managing disks and disk groups with ASM.

Applied PSU and one-off patches.

-Generated reports and turned output into csv files.

Documented and assisted in Data MIGRATION from ORACLE Databases to PostgreSQL database on premises and in AWS Cloud.

Installed/configured PostgreSQL (9.5, 9.6. and recently worked with PostgreSQL VERSIONS 10, 11).

Manage and monitor databases using pgAdmin and queried using tools like DBeaver and Sql workbench.

Tuned autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.

Proactively managed standby replication and hot standby for disaster recovery.

Applied DBCR (Database Change Request) and PCR (Product Change Request) and created code drop.

Refreshed databases using RMAN, Export Import and Data Pump utilities.

24*7 Production database administration support.

Performed Explain Plan analysis for Query Optimization and SQL tuning.

Analyze and tuned long running jobs by working closely with the application teams to analyze objects, rebuilt indexes, query tuning using SQL TRACE, AWR, TKPROF and Explain Plan.

Troubleshoot performance related issues.

Used pg_Hero for Performance TUNING mostly, SQL Tuning using EXPLAIN ANAYZE and PG_STAT_ACTIVITY.

Performed maintenance activities like vacuum, vacuum full, analyze; Checking the auto vacuum jobs, customized vacuum on certain tables and columns.

Perform database migration from Oracle to PostgreSQL on premises and on AWS, using Migration Tool Kit, Ora2pg, DMS and SCT.

Configured and monitored streaming replication between master and slave.

Monitored CPU utilization, memory, Database Connections, and storage space daily using pg_stat_activity, PEM, Pg_view and AWS CloudWatch alarms. Also use customs shell scripts deployed on crontab to monitor performance and resources.

Resolved gaps in Oracle Data Guard.

Worked on snapshot standby databases. Converted standby databases to R/W mode for testing purposes and converted back to read only with apply mode after testing.

Worked with storage admins to get disk space for Oracle ASM Disk groups.

Worked with Oracle support in resolving issues.

Written scripts to automate repeating tasks.

Setup threshold in 13c cloud control for alerts.

Performed Cleanup maintenance by allocation space in FRA/mount points.

Generated ASH, AWR, ADDM reports and worked with app teams on performance.

implemented a backup strategy following company SLA; execution of backup schedule for both physical using Pg_base_backup and Pg_backrest and Pg_dumpall and Pg_dump for logical backups.

Used restoration techniques like pg_restore and (PITR) Point in Time Recovery.

Configuring streaming replication (including cascading replication). configured a REPLICATION between MASTER and SLAVE and monitored On-Going REPLICATION.

Used Pg_Bouncer for connection pooling, pg_Badge for generating statistic reports.

Experienced in tuning PostgreSQL database settings & Troubleshooting performance issues, Managing Users and Tablespace on PostgreSQL Servers.

Used Customized scripts, to monitor database growth, TABLE growth, automated backups using cronjobs.

Upgrading database version using pg_dump/pg_restore and pg_upgrade tools and updating the latest security patches to the database, which are provided by PostgreSQL open source community.

Deployed Database security policy and installation, using passwords, privileges and user profiles, Enabled Encryption for databases.

Database Administrator 03/2013-01/2016

Health First- NY.

Database Administrator

Installation and configuration of new servers per customer requests. Cloning the Development, test and UAT environments with production data as per customer's request.

Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 11g production implementation.

Installed Oracle 11g on Linux platform using ASM.

Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.

Created and monitored Physical standby databases on maximum protection, performance mode using Data guard for Disaster Recovery and High Availability using DATA GUARD broker (DGMDRL) to manage and configure both Primary and standby database during DR testing and Failover scenarios for Prod & non-prod databases (Oracle 11.2.0.3 and Oracle 12.1.0.3)

Responsible for implementation and administration of disaster recovery strategies for 24/7 operations and deployment of high availability systems on Oracle 11g.

Upgrading Grid Infrastructure and databases from 11.2.0.3 to 11.2.0.4 and from 11.2.0.4 to 12c.

Have experience upgrading Oracle DB from 12c to 18c.

Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

Upgrade and Migration of Database from 11.2.0.2to 12.2.0.2 and applying patches whenever required.

PostgreSQL Installation, Configuration, Migration, Upgrades and Patches. Server versions ranged from PostgreSQL 8.2 to 9.5.

Migrated database from Oracle to AWS using EC2 and RDS instances

Involved in Installing/configuring PostgreSQL version 9.6 to 11

Using pgHero for Performance tuning as well as SQL Tuning using explain Analyze and pg_stat_activity.

Performing basic tasks such as objects such as, creating roles, granting privileges, creating tables.

Implementing the use of indexes, and primary & foreign key constraints as required

Providing PRODUCTION SUPPORT based on a ticketing system.

Assisted in defining and implementing MAINTAINANCE PLAN for the database systems.

Performing maintenance activities like vacuum, vacuum full, analyze etc.

Configured PgBouncer for connection pooling and pgBadger for generating statistic reports.

Experienced of tuning PostgreSQL server settings & Troubleshooting performance issues.

Managing Users and Tablespaces on PostgreSQL Servers.

Using Customized scripts, to monitor database growth, TABLE growth, automated backups using Cronjobs.

Checking the AUTO VACUUM jobs, Customized VACUUM on certain tables and columns

Experienced in handling logical and physical database BACKUPS. Assisted in developing and implementing best practices for Disaster Recovery and Backups.

Used restoration techniques like pg_restore and (PITR) Point in Time Recovery.

Performing BACKUPS, and RESTORE, Compressed (gzip) BACKUPS, Database or Schema REFRESHES

Configuring streaming replication (including cascading replication). configured a replication between MASTER and SLAVE, and monitored On-Going REPLICATION

Design and implement high availability solutions for business-critical database applications.

Implement Oracle standby database server deployments, architecture, configuration, implementation, operations, and management.

Creation of technical documents, transportable tablespace, and user managed backup and concept of database system and security.

Database backup using crontab and shell scripting, restore and recovery using RMAN, RTO/RPO and optimization.

Create and configure Oracle advance security and policies using Oracle Cloud Control Enterprise Managerr.

Experience in creating users, tables, views, stored procedures functions in SQL database.

Active participant in discussions related to Backup Strategy, DR architecture. Maintained, patched, and upgraded servers as required.

Monitoring Golden Gate processes various states (like STOPPED/ABENDED/LAG/HUNG) to reduce number of alerts by grouping them together by environment

Support multiple databases for production, development, test and UAT environments.

Installed and configured 3 nodes server-side load balancing Oracle RAC 11g, 12c databases on Linux with ASM and Data Guard.

Involve in 24x7 on-call support of databases of 2.0 TB 3 Node production 11g and 12c RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification

Developed compliance reports and performed auditing at higher levels.

Monitoring and optimizing the performance of the database/application using OEM 12c/13c along with homespun scripts.

Capacity planning: Allocate system storage and plan future storage requirements

Experience in writing UNIX/SHELL scripts for providing the reports.

Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK, SQL*Trace, AWR, ADDM, TKPROF, ASH, SQL tuning advisor etc. Done resetting of storage parameters by series of exports and imports of tables, used conventional as well as direct path loads to upload the data into the server using SQL loader.

Refreshing Dev and Test instances with data from Production on a regular basis.

Developed DML, DDL, Oracle tables, cursors, triggers and UNIX shell scripts.

Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.

RMAN point in time recovery and Instance recovery done on 11g.

Creation of new database on SQL SERVER (2008-2012) using both SQL SERVER MANAGEMENT STUDIO & Manually using transact-SQL

Performed different backup strategies using T-SQL and SSMS

Performed database monitoring and tuning using SSMS & Transact-SQL

Made use of tools such as Dynamic management view (DMV) and application performance management (APM) to resolve performance issues within the database.

Oracle Database Administrator:

Performed monthly and annual performance reports for trend analysis and capacity planning.

Provided Development DBA support for developer queries and requests, which includes query tuning, server tuning, identifying problematic code, etc

Suggested and improved system design and architecture, this includes built New Oracle 10g/11g RAC Databases, ASM Physical and standby systems, enabling LDAP authentication and configuring RMAN backups.

Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on Sun Solaris platform.

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Trouble shooting and performance tuning golden gate replications, monitoring scripts for Golden gate in Unix scripting

Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g and 10g/11g environments.

Monitored the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like SAR, VMSTAT, IOSTAT and TOP.

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN, AWR, ADDM

Responded to all database alerts, warnings, errors in a timely, consistent manner.

Extensively used and explain plan for periodic performance tuning.

Install and configure Cloud Control 12c/13c, deploy 12c/13c agents, plug-in installations on the target servers and monitor databases.

Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.

Implemented and configured 12c grid control on Production server

Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.

Refreshed/cloned databases using RMAN utility.

Performed Database upgrade from Oracle 10g (10.2.0.2) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.

Involved in converting a single instance database to Oracle 11g, 12c RAC databases.

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

Utilized TOAD for database management.

CERTIFICATION:

Oracle Certified Associates (OCA)

SQL Fundamentals 12c

Oracle Cloud Infrastructure Associate

Oracle Autonomous Database Certified

CompTIA Security Plus + certified

TECHNICAL SKILLS:

OPERATING SYSTEMS:

Red Hat Linux RHEL 5.x and Windows XP

RDBMS:

Oracle 11g/10g/12c, PostgreSQL 9.x – 11.x

LANGUAGES:

SQL, PL/SQL, UNIX Shell Scripting, Ksh, bash and Perl Scripting

SOFTWARE/ APPLICATIONS/ TOOLS:

DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, TOAD, Data Pump (expdp,impdp), SRVCTL, SQL*Plus

TUNING TOOLS:

SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

Contact this candidate