Jacqueline Cosmas

Oracle Database Administrator

Cell: 214-***-****)

Email: ad3f7p@r.postjobfree.com

I have over 8+ years of hands-on experience as an Oracle Database Administrator. I possess complete life cycle knowledge including Installation. Worked on Oracle 19, 12c, 11g, 10g versions involving database administration, production support, installation, configuration, Data Guard, Upgrades, Patches, Migration, Backup and Recovery, Performance tuning, Cloning, space management, Data Pump and security.

PROFESSIONAL EXPERIENCE

Federal Reserve Bank, Dallas TX Feb ‘21– Present

Oracle DBA

●Applied PSU/CPU Patches, ASM Patches, Grid Infrastructure Patches, Online Patches, one-off Patches and rolling patches on 12c and 19c databases.

●Used Oracle Enterprise 13.5 for monitoring multiple databases and notification of database alerts, and configured EM agents on multiple database servers.

●Implementing Data pump, conventional export/import utility of Oracle 10g to 11,12c, 18c $ 19c for re-organizing Databases/Schemas/Tables to improve the performance.

●Proficient with Database Cloning, Migration, and Patching of Oracle Databases.

●Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 19c Grid and 19c database.

●Used import/export utilities for cloning/migration of small sized databases and Data pump import/export to move data between 10g to 11,12c, 19c environments.

●Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Data pump, conventional Export/Import of Oracle 10g to 11,12c, 19c.

●Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN.

●Manage database Users and Schemas by creating and granting them appropriate profiles and privileges for database security and development.

●Applying upgrade patch, maintenance, and interim patches on all the databases.

●Thorough knowledge of setting up infrastructure for databases in huge datacenters.

●Installed Oracle 12c and 19c on Linux platform.

●Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

●Successful in Upgrading RDBMS Databases from version 12c to 19c.

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

Boeing, Troy, MI Nov’18 - Jan’21

Oracle DBA

●Managed databases sizes ranging from 50G up to 4TB Databases.

●Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.

●Implemented switchovers from primary to physical standby databases and have also converted physical standby to snapshot database as a part of planned maintenance activities.

●Implemented Failover to physical standby database as part of disaster recovery strategy.

●Rebuilding Indexes and gather statistics on tables on different databases on a regular basis to gain database performance using DBMS_STATS package.

●Utilizing Enterprise manager to monitor alerts, schedule jobs, monitor SQL loads, generate AWR reports

●Configured Oracle Data Guard to ensure disaster recovery, high availability, and data protection.

●Database monitoring and performance tuning using OEM GC, AWR and ADDM, ASH, SQLT, TRCA, SQL Access Advisor, SPM,

●Used import/export utilities for cloning/migration of small sized databases and data pump import/export to move data between 9i, 10g, 11g and 12c environments.

●Applying upgrade patch, maintenance, and interim patches on all the databases.

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

●Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers, and UNIX shell scripts.

●Thorough knowledge of setting up infrastructure for databases in huge datacenters.

●Installed Oracle 11g and 12c on Linux platform using ASM.

●Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

●Efficiently performed installation, setup, and creation of three node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.

●Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.

●Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 10g to 11 and 12c RAC databases.

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

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

AT&T, Richardson, Texas Jan ’16 – Nov ‘18

Oracle DBA

●Supporting multiple databases for production, development, test, and staging purposes on Linux, Solaris, and Windows environments.

●Implemented a solid SDLC Methodology

●Implemented switchovers on primary and standby databases as a part of planned maintenance activities.

●Rebuilding Indexes and gather statistics on tables on different databases on a regular basis to gain database performance using DBMS_STATS package.

●Successfully upgraded the databases from 11g to non CDB 12c.

●Successfully migrated 12c Non CDB databases to pluggable databases.

●Created Oracle Wallets and implemented Tablespace level TDE security.

●Successfully setup 4 node Primary RAC with 3 node physical standby for new application in 11GR2. Tuning the Databases for optimization using AWR, ASH, ADDM, STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size.

●Configured Oracle Data Guard to ensure disaster recovery, high availability, and data protection.

●Automated the Data Replication process using Materialized Views for reporting databases.

●Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple databases and notification of database alerts, and configured EM agents on multiple database servers.

●Implementing data pump, 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 data pump import/export to move data between 9i and 10g/11g environments.

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

●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 datacenters.

●Installed Oracle 11g on Linux platform using ASM.

●Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

●Efficiently performed installation, setup, and creation of four node cluster RAC with Oracle 12c database using GRID infrastructure with ASM file systems on RHEL 7.5.

●Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.

●Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 12c databases.

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

Bachelors in Computer Science

St. Mary’s University

Texas

Contact this candidate