TECHNICAL SKILLS:

Databases: Oracle database versions 11gR2, 12cR1, and 12cR2 HP Vertica Analytic versions 7.1, 7.2 and 8.1

Database experience Hadoop Cluster installation and advanced configuration Oracle RAC and Grid Infrastructure configuration and upgrading Working in both an OLTP and OLAP environments HP Vertica installation, advanced configuration and upgrading

Development tools Oracle Enterprise Manager (OEM) 12c and 13c, SQL Developer, Quest TOAD Suite, Aqua Data Studio, DB Visualizer Engineered Systems Exadata v2 Full Rack Exadata x3 - 2 Full Rack Exadata x5-2 Half Rack

Operating systems experience Unix/VM Ware ( Solaris, HP - UX, DecAlpha, AIX, Linux ), RHEL release 6.9

PROFESSIONAL EXPERIENCE:

Confidential, Birmingham, Alabama

Oracle Exadata Database Administrator

Responsibilities:

• Working in an 8-node RAC cluster environment on Oracle Exadata Engineered Systems
• Assisted with the Data Center Move
• Database partial and full refresh to new servers for testing
• Disaster Recovery Testing using Snapshot Standby
• Applying Oracle Exadata Full Quarterly Stack Patches (patching the storage servers, compute nodes, grid, databases and infiniband switches)
• Active Data Guard configuration and implementation on Exadata servers ( production and standby )
• Installed and configured Oracle databases across all environments
• Database migration from Solaris to Exadata x5-2 and from Exadata x3-2 (8-nodes) to Exadata x5-2 (4-nodes)
• Upgrading Oracle databases from 11.2.0.4 to 12.1.0 in an Exadata Production and Test environment
• Upgrading Oracle databases from 12.1.0 to 12.2.0 in an Exadata Development environment
• Participating in an on call 24x7 support rotation
• Performance Tuning ( Use of SQL hints, SQL Profile, ADDM,AWR )
• Use or Oracle Advanced Security Features ( Database Full and Partial Redaction of sensitive client information, Transparent Data Encryption (TDE) of tablespaces and Network Data Configuration )
• Assisting the ETL team and managing Oracle Data Warehouse environment ( table partitioning, advance compression )
• Database Compression with use of Exadata Hybrid Columnar Compression
• Creation of Views and Materialized Views
• Participate in database deployments in a Production Environment
• Golden Gate installation and configuration for replication
• Oracle Application Express ( APEX ) installation, configuration and upgrading
• Working in a 6-node cluster environment on HP Vertica
• Confidential Vertica security implementation
• Confidential Vertica Upgrade from version 7.1 to 8.1
• Confidential Vertica Performance Tuning of Projections

Confidential, Scottsdale, Arizona

Oracle Database Administrator

Responsibilities:

• Worked as a member of the Pepsi Inc. info structure support team
• Responsible for providing 24x7 on call support rotation for Oracle databases
• Provide database support for production, development and test environments utilizing Oracle 11gR2, Oracle for Linux 6.x, vSphere (ESXi) and Windows 2008. This includes approximately 40 oracle instances running on the various environments.
• Supported Oracle Application (Weblogic) in a production environment
• Install and configuration of Oracle 11gR2 database(s), client(s). Server install and configuration for all related Oracle products - Linux and Windows environments’
• Configured and Implemented both Physical/Logical design of the databases
• Applying OPatch and the latest PSU patches. This would also include using a rolling patch
• Upgrading from Oracle version 11.2.0.3 to 11.2.0.4
• Support for down time production upgrades, fixes, and new releases - DTS (Down Time Sunday).
• Creation of various SQL scripts for data guard, performance checks and cron jobs
• Load Testing for Oracle RAC two-node clusters, including installation and configuration
• Migration of databases from server to server
• Backup and Recovery scenarios using RMAN in a no catalog environment
• Rebuilding of indexes
• Installation, setup, configuration and layout of Oracle databases on servers: Testing and installing on Virtual Servers
• Created roles, privileges and assigned roles to user
• Provided documentation and procedures to client as required
• Restoring databases from Cold-backups (database testing for Oracle Support)
• Creation of Hot Backups and Cold Backups (used for migration and testing in both the Dev and Test environments)
• Data Guard configuration and implementation (physical) using Data Guard Broker
• RMAN Point-In- Time- Recovery
• Performance Tuning (High Disk reads, killing inactive sessions connected to the database, tuning memory usage, bottle-necks, updating statistics, row chaining, SQL tuning using the SQL advisor, RMAN data recovery advisor, AWR reports)
• Database Renaming
• Managing transactions (rollbacks and flashback operations)
• Use of Sharepoint for creation, tracking, status and assignment for CR’s (change requests) from within Confidential and/or generated by the client
• Worked with Oracle Support in resolving database related issues
• Enforcing database security and auditing (statement, privilege and schema)

Confidential, Indianapolis, Indiana

Oracle Database Administrator

Responsibilities:

• Supports databases on 10g & 11g in Linux environments
• Provide senior DBA-level support for applications, including developing data migration scripts, data validation queries, and a maintenance plan for the various development versions of these applications.
• Managing consistent, inconsistent, full and incremental backups using RMAN in a catalog environment
• Provide documentation and support for all aspects of maintenance and development.
• Work with application development team staff to develop & test database architecture and approve all production schema changes.
• Implement all changes to database design.
• Constantly work with the clients on issues regarding data element changes, especially eliminating unwanted data.
• Responsible for the creation of and upkeep of the Database Configuration Management document for application systems.
• Work closely with test and application Development team providing optimal database solutions.
• Maintain backup and recovery procedures.
• Database security enforced creating privileges and roles
• Applying quarterly patches
• Database refresh using datapump
• Migration of data between different applications including Oracle versions.
• Monitoring Space usage
• RMAN Recovery operations
• RMAN Validation and Backup