CAREER SUMMARY:

• Senior - level Oracle Database Administrator with over 15 years of experience in the administration of relational databases (Oracle, Ingres) which includes analysis, design, development, database administration and tuning.
• DBA skills include the Backup and Recovery management (RMAN), Business Continuity Plan (BCP) using Standby databases (DATAGUARD), POC using Golden Gate.
• Replication tool, monitoring of database instances 24x7 using UNIX shell scripts, data modeling tools like ERWIN, third party tool (TOAD) and GRID CONTROL.
• Performed installations and upgrades of Oracle software, Real Application Clusters (RAC 10g & 11g) implementation in Linux, Sun & AIX environment, database tuning, transaction management and tuning of memory structures. Managed VLDBs in a critical OLTP production systems & replication environments.

TECHNICAL SKILLS:

RDBMS: Oracle (12c,11g,10g,9x, 8x), Ingres 2.5/6.4

Oracle Tools: RAC, Grid Control, RMAN, DATAGUARD, Golden Gate

Languages: PL/SQL (Triggers, Procedures, Functions, Packages), Scripting, Java, .Net

Modeling: ERwin

OS: Linux 6.0, 5.2,5.4,AIX 6L, SUN Solaris 5.10

Packages: Quest Tools - TOAD, Spotlight, Microsoft Project

Hardware: HP Proliant blade, Sun Sparc, Compaq Alpha/GS160Alpha 2100, HP 9000 series

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle DBA, Phoenix, AZ

Responsibilities:

• Production Support for over 10,000 production, QA and Dev database environments
• Troubleshoot performance issues using TFA, trace analysis, AWR, blocking locks, temp space issues, undo space issues, latching, parameters tuning.
• Troubleshoot issues like node eviction, voting disk issues, services, ASM management involving RAC databases.
• Re-instantiate Standby databases for out of sync databases.
• Switchover / failback testing for Dataguard
• Golden Gate support
• Restore production databases on flex-clones to recover tables, schemas.
• Refresh QA and Dev databases/schemas from production.
• Promote database changes in DEV, QA and Prod using the change management and approval process.
• Manage Space, server performance issues like CPU spikes, I/O issues, and Memory and storage issues.
• Support Exadata environments working on ASR, performance issues, cell issues.
• Unix scripts to manage exports/RMAN backups, clean up log/trace directories, monitor alert logs, database startup and shutdown, monitor database lag.

Confidential

Sr. Oracle DBA, Phoenix, AZ

Responsibilities:

• Implementation of 12c OEM for monitoring.
• Capacity Planning & Confidential .
• Database refreshes from Production to lower environments.
• Database maintenance and support
• Exadata support
• Troubleshooting and re-instantiation of Dataguard environments.
• Golden Gate support
• Real Application Cluster databases maintenance and support
• Support of Application team development efforts.
• Work with other teams in IT like Unix, network teams to provide solutions to various Business units.

Confidential

Sr. Oracle DBA, Phoenix, AZ

Responsibilities:

• Provide complete life cycle support for oracle databases
• Confidential and application support.
• Upgrade Oracle Databases to 11g
• Test and Implement new oracle 11g features like duplicate database, row cache, new partitioning methods, sql profiles, baselines, AWR reports.
• Database refreshes using RMAN.
• Unix and SQL scripts for various monitoring and tuning jobs.
• Documentation of upgrade procedures and issues while upgrading to 11g.

Confidential, Phoenix, AZ

System Architect/Oracle DBA

Responsibilities:

• Implementation of Grid Control for monitoring, maintenance and troubleshooting the Oracle databases.
• Work on plan to rollout oracle 11G and RAC on Linux based on architecture.
• Work with Performance engineering group to troubleshoot production issues.
• Worked with different database groups to streamline the implementation of oracle RBAC based on company’s defined roles and responsibilities procedure.
• Work with various database groups on capacity planning, propose and implement new database environments based on the customer requirements providing HA solutions.
• Mentor other DBAs to provide technical knowhow to troubleshoot and maintain oracle database environments.
• Test and Document migration plans for new acquisitions/mergers from the database perspective.
• Create standard process document for the end-to-end delivery of database environments.
• Test & Implement various oracle application tools like SOA, BI publisher, AIA, workbench.

Confidential, Phoenix, AZ

Sr. Oracle DBA

Responsibilities:

• Worked on POC for upgrade from 9i to 10G
• Rolled out 10g upgrade as per the approved plan on different databases
• Support Application development in design, tuning and implementation of new code
• Worked on the POC for various tools for Reporting servers
• Troubleshooting issues with slowness, database access, tuning.
• Worked closely with different groups including application, operations, Sys Adm., network as per the requirements

Confidential, Scottsdale, AZ

Sr. Database Administrator

Responsibilities:

• Managing large databases using New Oracle features like partitioned Tables, spifle, and dynamic memory structures.
• Install and Upgrade Oracle on all the hosts as required and prepare documentation to follow standardized procedures.
• Develop procedures to automate database administration functions like startup and shutdown of Oracle databases, backup procedures, tablespace management.
• Implementation of databases inside and outside the firewall.
• Write shell scripts in Unix and VMS to effectively monitor the critical areas of databases like monitoring tablespaces, archive destination, replication, performance stats, mount points, checking and trimming alert.log.
• Develop and Implement Business Continuity Plan (BCP) using Standby Database (8i) and DataGuard(9i).
• Use OEM and TOAD for various database functions
• Test and Implement Backup and Recovery Plans based on the user requirements using RMAN incremental backups and OEM, Cold & Hot backups, and export backups.
• Write data pipelines for movement of data across the databases and platforms
• Use Oracle utilities like SQL*LDR to load external data
• Establish ODBC connectivity between heterogeneous platforms
• Define and enforce data standards by having standard naming convention
• Use data modeling tools like ERWIN in the physical design of database
• Implement Triggers and PL/SQL Procedures to support the production processes
• Enforce business rules through Integrity constraints
• Implement security procedures.
• Setup of Data Migration Process from Ingres to Oracle Platform
• Use of Basic Oracle Replication
• Test and promote Quest SHAREPLEX replication tool between different instances for High Availability.
• Standardize listeners (Net8) across the different platforms and hosts
• Define standards and procedures for database creation, naming of mount points, object and entity naming, use of datatypes, storage of dba scripts, promotion from development to test to production
• Manage Users, Roles, Resources
• Monitor and recompile invalid objects
• Backup of control file
• Maintain trace file locations, trimming listener. log files
• Test and Implement new Features of 9i
• Disk load balancing
• Monitor CPU utilization
• Monitor and optimize various Oracle memory structures like shared pool, data buffers, redo-buffers, sort areas
• Monitor and manage the rollback/undo segments
• Use of estats/bstats to resolve any SQL Tuning issues
• Maintenance of indexes and tables, load balancing by striping data by using partitioning, analyzing tables
• Troubleshoot the user queries using Explain Plan.
• Manage temporary segments

Confidential

Assistant Manager

Responsibilities:

• Database Design, database Confidential, database maintenance and security procedures.
• Planning, analyzing, designing, testing and implementing new developed applications based on the changing needs of the company and an on-going need to update the software being used in its operations.
• Software developed increased productivity and operational efficiency by 400%, for this company as a result of total integration of all the application software running in different functional areas of the company.
• Recognized with ‘ of Excellence’ by the Management for my contributions in the development and automation of application software.

Environment: UNIX, Windows, Oracle

Confidential

Customer Support Specialist

Responsibilities:

• Involved the study of Business models, Development and design of the relational databases
• Implement and troubleshoot the local area networks

Environment: Unix, Windows, Oracle