Cynthia Kelly

Cell:540-***-****

Email: adv8o1@r.postjobfree.com

Status:Green Card

Summary:

I am an experienced Database Administrator with over 5 years of hands-on experience in Database designing, testing, and supporting next-generation database solutions predominantly in Linux Operating systems/390 Operating systems or mainframes. Proficient in an assortment of Information technologies among Oracle, DB2, and Jira ticketing systems, with a record of increased responsibility with 15 minutes Mean Time to Repair (MTTR) Service Level Agreement (SLA) with our clients. Duties include Installation of oracle software and DB2 software, Configuration, Patch Installation, and migrating the database from oracle on-prem to amazon rds. instance, Cloning, database Replication, Database Security, Performance Monitoring and Tuning, Upgrades, Backup and Recovery, RAC setup, and setting up Data Guard for disaster recovery. Proficient in prioritizing and completing projects and assigned tasks in order of priority. An ambitious, out-of-the-box thinker, and a proactive team player, with strong verbal and written communication skills. Willing to learn new processes/technologies, great with time management, paying attention to detail, multi-tasking, and providing optimal customer service.

Skills:

• Patching and Upgrades

• Oracle 11g/12c/19c

• Backup and Recovery using Oracle RMAN and IBM utilities

• Data Guard

• RAC / ASM

• Migration

• Cloning

• Unix Shell Scripting

• Refresh from prod to test.

• Jira

• 24/7 On-call Rotation

• Performance Tuning using buffer manager control (BMC)

• Opatch Utility/ Opatch Auto

• DBCA, DBUA, OUI

• Indexing, views, partitioning

• ASH, AWR.

• SQL Tuning Advisor

• Optimizer Statistics

• Explain plan.

• Database Tools: OEM, SQL Plus, SQL Loader, DBCA, Toad, OEM Grid, RMAN, Exp/Imp/Data Pump, GitHub, GitLab

Experience:

Database Administrator/Consultant

March/2019 – 2023

Genpact Ltd. Cincinnati, Ohio

• Tuning of Oracle Databases for performance improvement using AWR, ADDM, ASH, explain plan, and other OS-related utilities like a top command, vmstat, iostat, and using Oracle Enterprise Manager (OEM 13C) to manage databases.

• Upgraded databases from versions 11g,12c to 19c using DBUA.

• Tune performance of queries with the help of BMC component of db2

• export and import data into db2 databases using IBM utilities

• Convert non-container 12c databases to CDB databases in 19c after upgrading.

• Converting physical Standby database to Snapshot standby database for testing.

• Performed Oracle Software Installations and create databases using DBCA as well as RMAN backups.

• Implemented Oracle TDE to provide transparent encryption to secure data at rest.

• Design and Maintaining Physical standby maintenance (Switch over - using Data Guard Broker) for disaster recovery.

• Migrate oracle databases from on-prem to RDS instance using data pump export utility and amazon s3 integration.

• Designed and implemented different backup strategies like Cold, Hot, RMAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.

• Involved in troubleshooting production issues like deadlock monitoring and automation of daily jobs like deleting old backups.

• Generated AWR reports using OEM and analyzed the reports for Oracle wait events, time-consuming SQL queries, tablespace growth, and database growth.

• Installed and Managed Oracle 13c Grid Control (OEM 13C) for monitoring production, Active data guard (DG Broker), Stage, and Dev systems.

• Responsible for assisting Application Teams in writing and reviewing queries using tools such as GitLab.

• Partitioned large tables to improve database performance.

• Refresh the dev environment with production data for testing

• Scheduled RMAN full backup and incremental level 1 backup using crontab.

• Use Oracle SQL tuning advisor to tune problematic queries.

• Upgrade databases from versions 11g,12c to 19c using oracle data pump utility.

Oracle Database Administrator January /2018 - March/2019

CenturyLink Inc. Monroe, LA

• Install and configure oracle software for versions 11g, 12, and 19C.

• Perform yearly disaster recovery tests to ensure that the standby database can easily assume the role of the primary database in an event where the primary database is unavailable.

• Create user accounts in the database, manage users' accounts, and drop employers' accounts from the database that are no longer with the company.

• Perform Oracle quarterly security patches on our database to prevent our system from vulnerabilities.

• Use tools such as GitLab to review developers' queries before they can be deployed to production.

• Restored client missing data from a backup or used oracle flashback technology if the data was deleted not more than 14 days ago.

• Creating materialized views and views to improve database performance and security.

• Perform logical backup using oracle data pump expdp/impdp utility.

• Monitoring the health of the database using tools such as OEM 13C

• Scheduled RMAN backups, purge jobs, and Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, and Crontab.

• Tuning long-running queries to ensure that CPU/MEMORY are always in stable condition. We usually contact support to kill long-running queries if it’s too problematic.

• Involved in installing and configuring two Node RAC (Real Application Cluster).

Education and Training:

• AS: Information Technology systems

• Bachelor in computer sciences

Location.

Illinois

Contact this candidate