Oracle Professional Experience

MELISSA AFETSE

*** ****** ******** **. ********, NC 27377 • Cell: 336-***-**** • *******.******@*****.***

PROFESSIONAL SUMMARY

An accomplished database administrator (DBA) with 7 years of extensive experience in testing, and supporting next-generation database solutions in Oracle Enterprise environments. Exceptional written, verbal, analytical and organizational abilities; proven leader with 5 years’ practical management experience with a highly motivational style, a solid reputation for building and retaining highly motivated teams and development of innovative solutions; results-oriented self-starter with an excellent track record for identifying opportunities for accelerated growth; dedicated team player who listens, thrives on collaborating with diversely talented team members, and integrates their divergent thoughts, opinions, and perspectives into meaningful action; energetic, competitive achiever who can manage multiple priorities and perform under pressure in a fast-paced, rapidly changing environment, global thinking who is degreed in management and adept at training, developing, human resources, and coaching team members and clientele.

QUALIFICATION HIGHLIGHTS

Oracle SQL Fundamental & OCA Certified

Skilled in designing and implementing complete life cycle client servers and database applications with various development tools and languages.

In-depth understanding of security & backup procedures to ensure integrity.

Experienced in data encryption using Oracle TDE to protect the organization’s critical information and exceeding the industry standard.

Experience with various tools, such as TOAD, Spotlight, Oracle Enterprise Manager (OEM), PuTTY, SQL*Plus, Data Pump, SQL*Loader, SnapManager for Oracle, Recovery Manager, & Oracle Secure Backup.

User management, creation, monitoring and administration of database users; altering passwords and granting/revoking access to system/object privileges, roles and auditing user actions.

Monitoring & Reorganization of Tablespaces/Tables/Indexes.

TECHNICAL EXPERTISE

Operating Systems – Linux, RHEL 5.3/5.4/6, Windows 2003 Server & XP

Database Management – TOAD 9.7/10.1/11.6/12.0, OEM 9.2/10g (10.1/10.2), 11g, 12c, Grid Control (RAC), RAT

Databases – Oracle 11g, 10g, 9i, SQL Server 2005/2008

Tuning/Monitoring – RAC 10gR2,11gR1,/R2, 12c, DataGuard 9i/10g/11g, DB Cloning, Standby Databases, RMAN 9i/10g/11g, Spotlight, AWR, ADDM, EXPLAIN PLAN

Tools/Utilities – RMAN, OEM Oracle Management Server, PuTTY, SQL *Loader, SQL *Plus, SQL Server, Export/Import, Data Pump

PROFESSIONAL EXPERIENCE

Oracle Database Administrator

Genworth Financial – 4 Month Contract

Raleigh, NC

March 2017 to Present

Creation of databases and document procedures to migrate and refresh databases between the development, testing, quality assurance, staging & production environments.

Installed and Configured Oracle 12c software on Linux within Oracle RAC environment, including the upgrading of several databases from Oracle 11.2.0.4.

Designed and implemented specific procedures for the application of recent Oracle Critical Patch Updates (CPU) for Grid, RDBMS and JAVA on databases as required.

Worked with Engineers, Developers, Analytics, Legal, and various departments on developing strategy and implementation for retirement of customer data projects.

Performed various DBA Maintenance tasks such as rebuilding and monitoring indexes, validating invalid objects and constraints, reorganization of tables.

Provided daily oversight for performance, troubleshooting, research and code approval as required utilizing TOAD, Spotlight, OEM, and PuTTY.

Continuous workflow monitoring sustained by enforcing guidelines for ServiceNow to ensure migrations between environments and after hour/weekend requests maintained accountability and completion.

Configured and administered Maximum & High Availability for existing 11g RAC environment.

Oracle Database Administrator

Wells Fargo Advisors, LLC

High Point, NC

Dec 2015 to March 2017

Developed a business continuity plan (COOP) for key data elements.

Participated in the full SDLC for new project development.

Created scripts and scheduled backups in ActiveBatch for RMAN database backups and recoveries.

Monitored DR (Data Guard) implementations regarding connectivity issues.

Implemented and oversaw enterprise database security standards and ensuring compliancy with the IT change management process and ISO 27001 compliance.

Implemented database security using Oracle’s Transparent Data Encryption based on Database Security Technical Implementation Guide (STIG) developed by Defense Information Systems Agency (DISA).

Executed and provided ADDM, AWR and database health check reports to information owners and recommended solutions for improved performance.

Performed database tuning by reviewing ADDM & AWR reports, implementing SQL profiles and baselines.

Oracle Database Administrator

Bank of America

Greensboro, NC

Sept 2014 to Nov 2015

Used Oracle Transparent Data Encryption to encrypt tables and Tablespaces.

Wrote several ad hoc scripts for daily DBA activities such as backup and recovery, user creations, granting roles ad privileges, archiving of alert logs, verifying error entries and checking space management.

Created and configured databases by making changes to the Initialization Parameters within the parameter file and dynamically within sessions.

Performed backup and recovery using Oracle’s 11g user managed backup such as automated or manual cold backup and hot backup procedures.

Executed daily health checkup of production which included testing databases and performances of the Oracle Infrastructure.

Processed Daily Administrative Tasks; included by not limited to setting up schedule jobs utilizing Oracle Scheduler, OS Contrab and Oracle OEM Grid Control (11g); Alteration, Modification and Creation of tables, views and sequences, Managed archive and redo logs, create users, assign privileges and roles, modification of tables and object storage.

Knowledge and skilled in backup and recovery utilizing RMAN while setting up backup scripts with cron jobs.

Executed Oracle 10g/11g installation & upgrading software and database projects.

Documented migration process and database creation.

Senior Oracle Database Administrator

Northwestern Mutual

Greensboro, NC

May 2009 to July 2014

Performed database design tasks; enforcing referential integrity standards, creation of databases, tables, table dependencies such as indexes, stored procedures, functions, packages, triggers, views, etc.

Creation of databases and document procedures to migrate and refresh databases between the development & production environments.

Use RMAN to perform database recoveries and migration when necessary.

Installed and Configured Oracle 11g instances software on Linux, upgraded several databases from Oracle 10.2.0.1 to 10.2.0.1 to 11.2.0.4 and applied Oracle Critical Patch Updates (CPU) on databases as required.

Use Oracle flashback technology to restore databases and tables.

Resized database to decrease cloning, backup, and restoring time.

Maintained various SLA’s including ticket response and resolution time.

Work with IT support to ensure secure access to database and applications by configuring and limiting access to servers and folders; managing users, groups, and memberships.

Performed various DBA Maintenance tasks such as rebuilding indexes, validating constraints, reorganization of tables.

Established technical procedures and administrative policies for production, test and development databases physical design, administration, maintenance, tuning, backup and recovery. Allocated system storage and plan future storage requirements for the database systems.

Configured and administered multiple Maximum & High Availability 11g RAC.

Junior Oracle Database Administrator

Jelani Consulting (Contractual)

Greenbelt, MD

February 2009 to October 2012

Database upgrades, resource capacity planning, platform migrations, application consolidations and data center rationalization.

Collaborated with managed service providers, internal development team, consultants, and Oracle Support.

Deployed and implemented Oracle Grid Control (10g, 11g) to monitor all databases.

Created triggers, stored procedures, materialized views for enhanced remote data replication and synchronization.

Maintained database security via unique database roles and object permissions.

Worked with clients and development teams to design, develop, and document database architectures including logical and physical data models, transaction and sizing estimates, capacity planning, fault tolerance and recovery specs, archiving strategies, replication mechanisms, and external systems interfaces.

Migrated data from Oracle 10g R2 database to Oracle 11g on a Linux platform.

EDUCATION

Mohawk Valley Community College

Associate of Science: Business Management

Utica, NY

1999

Prior Professional Experience Available Upon Request

References Available Upon Request

Contact this candidate