Over 6 years of strong experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows, supporting a variety of mission critical applications with Oracle 10g and 11g. The different DBA tasks include, production support, patch installation, database migrations, Installation and configuration, upgrades, backup and recovery, performance tuning, cloning, space management and security administration. My objective is to be a dynamic member of a challenging workforce where I can put in meaningfully to the overall goal of that organization, achieving self-fulfillment both as a professional and an individual in my chosen career (Oracle Database Administrator)
Databases Oracle 10g, 11g, 12c
Database Tools Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, DBCA, DBUA, ADDM, Oracle Migration Workbench, ERwin, QDesigner, Remedy
Operating Systems MS Windows, UNIX (Solaris 8/9/10, AIX, HPUX), LINUX
Weis Market Inc - Sunbury, PA
August 2015 to August 2018
Oracle Database Adminstrator
Upgrade DBs from 18.104.22.168 to 12.1.
Troubleshoot and resolve slowness or performance issues with extensive investigation and follow-up with respective application teams with RCA and proposed solutions.
Resolve lock/latch and resource contention issues during production hours
ConfigureDataguard and Broker for administration of seamless switchovers.
Upgrade GI and DBs from 11g to 12c with physical standby DBs in place
Utilize SPM SQL Baselines, SQL Profiles and SQL Tuning Advisor for troubleshooting and providing tuning recommendations to application teams.
Generate and analyze EXPLAIN PLAN, SQL*TRACE, TKPROF trace files to identify root cause of SQL performance issues.
Analyze AWR, ASH and ADDM reports and draw conclusions that aid in troubleshooting performance issues.
Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g and 11g environments. Applying upgrade patch, maintenance and interim (opatch)patches on all the databases.
Monitoring and Troubleshooting GoldenGate Replication issues
Day-to-day usage of Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, DatabaseControl, AWR, ADDM,
Tuning/Access Advisors, SQL Performance
Installed Oracle 11g with ASM and OCFS2 File systems.
Involved with installation and maintenance of ORACLE 10g/11g RAC 2 node and adding a node to this cluster database for high availability.
Experience in OracleRAC implementation(Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation)
Good experience RAC Clusterware administration, Configuration and Patching, RAC Backup and Recovery.
Managed RAC Cluster using SRVCTL and CRSCTL and applied patches in rolling Fashion
Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
Monitoring and Troubleshooting of Database Replication issues
Working with Application Development team to address any issues they encounter and provide support and resolution action plan
Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed application like Portfolio Management Systems and vendor applications like SAP Business solutions
Initial load - direct load, direct bulk load, file to replicat, file to database utility; avoiding and handling Collisions during initial load
Configure and build Golden Gate Extracts/Replicate for multiple databases
Data selection, filtering, transformation and column mapping, and Built-in functions in GoldenGate.
Commit change number (CSN), checkpoint file and checkpoint table.
M&T Bank Buffalo, NY
January 2012– August 2015
Oracle Database Administrator
Running scripts and monitoring the load process to avoid any issues in ETL jobs running for a long duration.
Monitored Database growth and provide Database capacity planning for applications expansion or necessary re-organization of tables and indexes as and when required.
Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases. Installed Oracle 10g and 11g on multiple platforms.
Performed up-gradation of 10g to 11g and to 12c
Performed traditional Cold backup in appropriate environments via OS commands as well as logical exports.
Automated routine DBA tasks like backup's and stats by using Grid control job's Implemented 12c RAC Clusters and created POC for failures and performance in the environment and troubleshooting using cluster ware Alert Log Monitoring every day in the production environment
Perform health checks using crsctl and managing services using srvctl
Provided Assistance to application team at the time of SQL tuning in applications. Administration of DATAGUARD
databases in Oracle 11g.
Oracle DB System Development Life Cycle (SDLC) planning and Oracle DB 3-Tier architecture.
Setup RMAN solutions for all Oracle Databases -- created rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purposes.
closely with diverse application development groups and served as single point of contact for testing, tuning and implementing projects / solutions in production environment
Cloned and maintained multiple Oracle Database environments for Development, Testing & UAT.
Applied various database / applications PSU / CPU patches as required.
Performed activities like monitoring the database and provide maximum uptime.
Created and granted users the privileges and roles and resizing the datafiles to manage database growth.
Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability
Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes
Created primary database objects (tables, views, indexes) once application developers have designed an application
Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.
Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures, Functions, etc.
Oracle Certified Associate
BA in Linguistics & Sociology
Fourah Bay College
University of Sierra Leone