Sql Server Oracle
Resume:
Hernandez Anyiabey
Oracle Database Administrator
*****************@*****.***
OBJECTIVE
Highly Creative, dynamic and detailed oriented Oracle database administrator professional with over 7 years of experience seeking a position in your company so I can be able to bring my expertise so as to help the company reach its goals. Experienced in multitasking, detailed-oriented, good at prioritizing, enjoys working with people and communicates effectively both at the technical and managerial levels.
PROFESSIONAL SUMMARY
Over 7 years of experience as an Oracle Database Administrator with hands-on experience in database installation, administration, configuration, production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
•Installed, Configured and Administered Oracle databases 9i, 10g, 11g and 12c.
•Provided 24X7 production support to high critical databases
•Worked extensively on Oracle Software Installation, Oracle Database Upgrade, Migrations (from 10g to 11g and to 12c) and Patching {Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch}.
•Proficient in all the phases of Software Development Life Cycle (SDLC) as well as Software Implementation Life-Cycle (SILC).
•Configured, Managed and Administered Container (CDB) and Pluggable (PDB) Databases.
•Extensively used Database Administrative tools like Oracle Enterprise Manager (OEM), OEM Grid and Cloud Control, SQL*PLUS, TOAD.
•Handled operational responsibilities like database Refreshes/Copy backs, Security, Documenting Standards and Procedures.
•Performance tuning of the database – SQL Tuning, Used Tuning utilities like DBMS.STATS, TKPROF, EXPLAIN PLAN, AWR, ADDM, Scripts and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes.
•Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing and use of Hints, Stored outlines, Statistics for the same.
•Extensive Experience with RMAN Backups and Logical Backups.
•Logical backups using Data Pump and Import/Export utilities.
•Worked extensively on UNIX Korn Shell and Bash Shell scripting for Database RMAN backups, maintenance, Housekeeping and REFRESHES for databases.
•Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 12c, 11g RAC, 10g RAC servers for the purpose of disaster recovery procedures.
•Installed and configured Golden Gate for replication.
•Involved in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICATE issues.
•Implemented and administered Oracle Golden Gate (v10) for Database Replication between production and reporting node, by using Oracle Streams in parallel to secure data and having the availability of the database during regular the upgrade or maintenance operation.
•Installed, Configured, and Administered Two and Three Nodes Oracle 11g RAC for High Availability Solutions.
•Wrote scripts to inform the DBA’s regarding the status, performance and space management of the database
•Worked with development and operations staff in resolving problems quickly and efficiently
•Wrote several Purging/Administrative shell scripts on Linux which are being used as standard scripts at the workplace.
•Experience in Installing Microsoft SQL Server 2008/2012
•Upgrading Microsoft SQL Server 2008 to 2012 to 2014.
•Administering SQL Server backups FULL, TRANSACTIONAL and DIFFERENTIAL using LightSpeed and TSM
•Restoring SQL Server Databases from FULL and DIFFERENTIAL backups
•Shrink LOGS and DATAFILES using SQL Server Management Studio (SSMS) to create space so as to ensure application operation
•Use Microsoft Business Intelligence Tools to troubleshoot faulty SSIS Packages
•Generate Performance reports using PA Performance Tools
•Creating, Scheduled and Implemented Backup and Maintenance plans for SQL Server 2008/2012 Databases.
•Decommissioning Microsoft SQL Server 2008/2012 Servers as required by the business
•Restoring SQL Server Databases from FULL, DIFFERENTIAL, and Transaction Logs backups.
TECHNICAL EXPERIENCE
OPERATING SYSTEMS:
RHEL, Solaris, UNIX, Windows
RDBMS:
Oracle 12c,11g, 10g, 9i, SQL Server 2008/2012
LANGUAGES:
SQL, PL/SQL, UNIX Shell Scripting.
APPLICATIONS/ TOOLS:
DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, OEM Cloud Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, SQL Navigator, TOAD, Data Pump (expdp, impdp), SRVCTL, SQL*Plus, CRSCTL, SSMS
TUNING TOOLS:
SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ASH, ADDM, DBMS.STATS, PA Performance TOOL
PROFESSIONAL EXPERIENCE:
Blue Cross Blue Shield - Dallas
TX January 2016 - Present
Role: Oracle/SQL Server DBA
Environment: AIX, RHEL, Solaris, Windows, Oracle 11g/12c/10g, Oracle RAC (11g), Data Guard, Oracle Grid/Cloud Control, RMAN, ASM, SQL Developer, TOAD, SQL*Plus.
Responsibilities:
•Supported & maintained over 900 Production/Test/Development databases on various servers.
•Installed, configured, and maintained Oracle 10g, 11gR2 and 12c on Aix, Linux, Windows and also Upgraded and Migrated from Oracle 10g to 11g and to 12c.
•Monitoring Backup and Reporting Batch Jobs for completion.
•Wrote UNIX backup and refresh Korn, Bash Shell scripts that are been used Enterprise wide.
•Designed UNIX Shell Scripts for Monitoring Database activities like Tablespace Usage, Gathering Schema Stats.
•Created UNIX Bash and Korn Shell scripts for Server house cleaning like clearing unwanted trace and logfiles according to accepted SLA.
•Extensively implemented Data Pump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
•Strong skills in applied security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
•Performed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Automatic Session History (ASH), SQL Advisory Framework etc.
•Administering Security User Management, Privileges, Roles, Auditing, Profiling, Authentication
•Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM file systems.
•Installed Microsoft SQL Server 2008/2012
•Upgraded Microsoft SQL Server 2008 to 2012 to 2014.
•Shrink LOGS and DATAFILES using SQL Server Management Studio (SSMS) to create space so as to ensure application operation.
•Used Microsoft Business Intelligence Tools to troubleshoot faulty SSIS Packages.
•Generated Performance reports using PA Performance Tools.
•Deployed dtsx and bat SSIS packages for Application Updates.
•Decommissioned Microsoft SQL Server 2008/2012
•Created, Scheduled and Implemented Backup and Maintenance plans for SQL Server 2008/2012 Databases.
•Restored SQL Server Databases from FULL, DIFFERENTIAL, and Transaction Logs backups.
Lowe’s - Mooresville
NC May 2013 - December 2015
Role: Oracle/SQL Server DBA
Environment: RHEL, AIX, Solaris, Windows, Oracle 12c/11g/10g, Oracle RAC (11g), Data Guard, Oracle Grid/Cloud Control, RMAN, ASM, SQL Developer, TOAD, SQL*Plus.
Responsibilities:
•Managed a Team of 3 DBA’s on a Dataguard and RAC Project.
•Supported & maintained over 1000 Production/Test/Development databases on various servers.
•Installed, configured, and maintained Oracle 10g, 11gR2 and 12c on Linux and also Upgraded and Migrated from Oracle 10g to 11g.
•Implemented Backup Strategies that have become the blueprint for the Organizations Backup Solutions.
•Monitoring Backup and Reporting Batch Jobs for completion.
•Wrote backup and refresh on UNIX Bash and Korn Shell scripts that are been used Enterprise wide.
•Wrote UNIX Shell Scripts for Monitoring Database activities like Tablespace Usage, Gathering Schema Stats.
•Wrote UNIX Bash and Korn Shell scripts for Server house cleaning like clearing unwanted trace and logfiles according to accepted SLA.
•Extensively implemented Data Pump, conventional Export/Import (Oracle 12c, 11g, 10g) for migration and logical backup of database.
•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”.
•Performed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).
•Installed and configured Golden Gate for replication.
•Involved in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICATE issues.
•Implemented and administered Oracle Golden Gate (v10) for Database Replication between production and reporting node, by using Oracle Streams in parallel to secure data and having the availability of the database during regular the upgrade or maintenance operation.
•Troubleshoot and resolved Abended Processes in Oracle Golden Gate 11 and 12
•Upgraded Oracle Golden Gate from 11 to 12.
•Installed, Configured, and Administered Two and Three Nodes Oracle 11g RAC for High Availability Solutions.
•Administering Security User Management, Privileges, Roles, Auditing, Profiling, Authentication
•Used OEM Grid and Cloud Control extensively for administrative tasks.
•Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.
•Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery Solutions.
•Installed Microsoft SQL Server 2008/2012
•Shrink LOGS and DATAFILES using SQL Server Management Studio (SSMS) to create space so as to ensure application operation
•Used Microsoft Business Intelligence Tools to troubleshoot faulty SSIS Packages
•Generated Performance reports using PA Performance Tools
•Deployed dtsx and bat SSIS packages for Application Updates.
•Decommissioned Microsoft SQL Server 2008/2012
•Created, Scheduled and Implemented Backup and Maintenance plans for SQL Server 2008/2012 Databases.
•Restored SQL Server Databases from FULL, DIFFERENTIAL, and Transaction Logs backups.
Globys - Seattle
Washington March 2010 - April 2013
Role: Oracle DBA
Environment: Oracle 10g/11g, HP-UX 11, Sun Solaris 10.0, RAC, Oracle Streams, RMAN, Data Pump, SQL TRACE, TKPROF, EXPLAIN PLAN
Responsibilities:
•Provided 24X7 supports for all the production, Test and development databases.
•Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
•Successfully performed migrations from Oracle 10g/11g to 11gR2 RAC (Real Application) Database.
•Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.
•Scheduling and Monitoring Batch jobs for reporting.
•Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
•Configured, Administered and Troubleshoot Oracle Streams for Data Replication
•Configure block change tracking to work with RMAN Merged incremental backups.
•Implemented UNIX Bash scripts for database backups and refreshes that became the Enterprise standards.
•Created and Scheduled UNIX Shell Scripts for Monitoring Database activities like Tablespace Usage, Gathering Schema Stats
•Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
•Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
•Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
Heritag Home Group, LLC - Highpoint
NC February 2009 - March 2010
Role: Help Desk
Maintained daily performance of computer systems.
Installed, modified, and repaired computer hardware and software.
Installed computer peripherals for users.
Wrote training manuals.
Trained computer users.
Walked customer through problem-solving process.
Followed up with customers to ensure issue has been resolved.
Contact this candidate