SUMMARY:

• Performed backups, recoveries, installations, database performance tuning, tuning applications, database monitoring and operating system configurations.
• Experience in data (hot and cold) backup and recovery procedures.
• Experience in schema management, tablespace, datafile and extent management, as well as user and privilege management.
• Experience monitoring Oracle RDBMS availability, database exports, tablespace, and extents reports.
• Managing Database Structure, Storage Allocation, Table/Index/BLOB segments, and Rollback segments, Constraints, Database Access, Roles and Privileges.
• Load balancing in RAC nodes using TAF
• Possess excellent written and oral communication skills.
• Excellent Experience in installing and maintaining Oracle Dataguard to implement physical Standby Databases for Disaster Recovery.
• Configured and Implemented Physical Standby on 10g and 11g Databases (Data Guard).
• Experience in migrating Standalone Database to High Availability Oracle RAC Environment in ASM.
• Experience in Oracle 10g/11g/12C RAC databases in installations, configurations and Maintenance.
• Expertise in creating Users, Roles and Profiles and Privilege management with rolebased security.
• Supported database on Exadata X7
• Applied patches on computer nodes, Exadata home and storage cells.
• Migrated standalone databases to Exadata
• Implement disaster recovery with use of Exadata
• Installation, Configuration and Administration of Oracle 11g/12c RAC.
• Implementation of High Availability solutions with Oracle 11g RAC, Standby Database (Active Data Guard).
• Configuration, troubleshooting GoldenGate issues
• Setup Uni - directional GoldenGate setup.
• Worked on Data Migration project.
• Setup cronjob and used 13c OEM.
• Manage Backup and Recovery Program for all Oracle Databases. Install, implement and configure RMAN. Oversee, improve and implement scripts, processes, emergency procedures and testing of all RMAN operations.
• Installation, configuration and maintenance of Exadata and Exalytics machines.
• Experience in installation and configuration of Oracle Golden gate (both unidirectional and bidirectional).
• Regular practice of Disaster Recovery Scenerios.
• Work independently and as well working extremely well with other teams and the customer on a daily basis
• Effective communication skills with Project manager, account team, and customer on technical issues and resolutions
• Implementing ASM file system and its maintenance
• Troubleshoot network issues to connect to database.
• Troubleshoot performance issues by generating statspack report.
• Versatile team player with excellent analytical, communication and inter personal skills.
• Responsible to provide the 24*7 support for Production Databases.

TECHNICAL SKILLS:

Operating Systems: Windows NT/2000/XP, Sun Solaris, HPUX, Redhat Linux, AIX

Languages: SQL, PL SQL

RDBMS: Oracle 12c/11g/10g/9i, MS Access, MS SQL Server 2000, DB2

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ASH, AWR, ADD

Tools: RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, NETCA, DBCA, TOAD, Patch Management, SQLNET, ODBC Export/Import, Data pump, DataGuard, VERITAS Net Backup, VMware

PROFESSIONAL EXPERIENCE:

Confidential, Broomfield, CO

Oracle DBA

Responsibilities:

• 24 X 7 Production database administration support.
• Supported database on Exadata X7
• Applied patches on computer nodes, Exadata home and storage cells.
• Migrated standalone databases to Exadata
• Implement disaster recovery with use of Exadata
• Installation, Configuration and Administration of Oracle 11g/12c RAC.
• Implementation of High Availability solutions with Oracle 11g RAC, Standby Database (Active Data Guard).
• Configuration, troubleshooting GoldenGate issues
• Setup Uni-directional GoldenGate setup.
• Worked on Data Migration project.
• Implemented DataGuard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Upgrade and Migration of Databases from 11.2.0.1 to 11.2.0.3 and applying patches as per requirement.
• Performed an In-place upgrade of a Oracle RAC Database from 11.2.0.2 to 11.2.0.3
• 24/7 on-call production database support.
• Refresh the test and development databases from the source production databases on a regular basis using export/import utility.
• Involved in the migration of huge databases of sizes ranging from 100GB to 4TB.
• Migrating single Instance Databases to 2 Node RAC environments.
• Daily incremental backup and weekly full backup of databases using RMAN.
• Setup of Jobs using the Oracle Enterprise Manager (OEM) database control.
• Installed and configured 12C GRID Control.
• Used SQL *Loader for loading the data into database tables.
• Regular database management on 10g and 11g OEM.
• Involved in installation and configuration of Goldengate extract and replicate issues.
• Implemented Bi-Directional replication in golden gate from target to source and source to target.
• Performed patching on Oracle Database Server 10g and 11g using Opatch utility.
• Applying patch set and interim patches whenever required to make the database software up to date.
• Database Admin Support for 11g / 12c databases running in Non-Prod and Prod/DR environments running on Exadata / Exalytics / AIX / Linux and C3 environments.
• Expertise knowledge on Transportable Tablespaces and also Exadata compression and performance tuning.
• Experience in Online and Offline backups and recovery.
• Monitoring & Scheduling jobs for the daily activities for all the databases using CRONTAB.
• Table space monitoring, Performance monitoring and tuning for performance improvement.
• Managing, troubleshooting and resolving oracle database and application issues.
• Performed Explain Plan analysis for Query Optimization and SQL tuning.
• Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, AWR, TKPROF, Explain Plan, TOAD from Quest software (DB Tuning).

Environment: Oracle 10g, 11g, 12c, Linux 5/6, OEM, RMAN, Golden gate, Grid, RAC, ASM, Data guard, TOAD, SQL*LOADER, AWR, ADDM, ASH, Data pumps, Exports/Imports.

Confidential, Colarado Springs

Oracle DBA

Responsibilities:

• 24x7 product database support
• Installed and maintained 10g/11g databases for testing, development and production
• Database Monitoring and administration of database using Enterprise Manager Grid control OEM
• Upgraded Oracle Database from 9i to 10g, 10g to 11g.
• Migration of the database from HP-UX to Linux.
• Planned and implemented Oracle 10g RAC, 11g RAC, Standby databases for High Availability and DR solutions
• Cloning of the database from Production to the Test and Development environments using RMAN and conventional methods.
• Applied security related CPU and One-off patches using Opatch utility, Applied RDBMS Patch set Utility PSU
• Installed and configured oracle grid control.
• Used Oracle Streams for replications of data between remote databases
• Performed Cold backup, hot backup using conventional backups and RMAN, recovered various and critical Production databases.
• Prepared backup schedule which include offline, online and logical backups.
• Used Export/Import, Data Pump Utilities to move the data between different databases and for backups.
• Worked on transportation of Table spaces, Data Archival, Re-organization of tables and restoration.
• Tuning of Shared Pool, Library Cache, and Data Dictionary Cache.
• Monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottleneck. Provide technical direction to system administrators
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Generated performance reports and Daily health check up of the database using utilities like AWR, Stats pack and ADDM to gather performance statistics.
• Identified and tuned poor SQL statements using EXPLAIN PLAN, SQL TRACE and TKPROF, Analyzed tables, indexes for improving the performance of the Query.
• Analyzed SQL statements, re-organized database objects and created indexes to improve the performance of the queries.
• Partition of tables to improve performance.
• Created users and allocated appropriate table space quotas with necessary privileges and roles for all databases.
• Worked with Oracle Support for resolving the database related unresolved issues.
• Worked on SQL Loader to load data from flat files, Checking for Row Migration and Chaining on Highly used transaction tables.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL NET connectivity.
• Created DB links across databases and Solved Database connectivity issues by continuously monitoring the status of the listeners and instances.
• Monitored overall system performance and Database growth.
• Served as a member of 24-hour on call support staff.
• Checked alert logs and background trace files on daily basis and resolved problems.
• Scheduled jobs in the database using CRON Jobs and DBMS JOBS.
• Implemented backup for production database. Simulated few possible crucial recovery scenarios using the current available backups to check the effectiveness of the backup plans and also to get a rough estimate of the recovery time involved.
• Automated shell scripts and scheduled batch jobs.

Environment: Oracle 9i/10g RAC/11g RAC, Red Hat Linux, Windows, HP-UX, Sun Solaris, AIX, SQL Server, PL/SQL, Shell Scripting, RMAN, Grid control, Data Guard, SQL Loader, EXP, IMP, Data Pump, TOAD, TKPROF, EXPLAIN PLAN, AWR, STATSPACK, ADDM, ASH.

Confidential, Chicago, IL

ORACLE DBA

Responsibilities:

• Oracle DBA duties involving development and production support such as installations, configurations, backup/restore & recovery, database monitoring & operating system configurations, database performance tuning, assisting in the logical/physical database design, applications profiling, tuning queries and providing support to developers.
• Performing Hot/Cold backups of the database through RMAN or User Managed
• Setup and configured Oracle Physical Standby database (Data Guard), where the standby database was used for disaster recovery.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Review alert logs and dump files to check for any problems related to the database.
• Perform database cloning/exp/imp to setup identical databases in the production and development environments.
• Create and maintain users, roles and privileges.
• Upgrade/Migrated the production and development databases from 11.2.0.3 to 11.2.0.4
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Setup and configured 2 node Oracle 10g RAC with ASM.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Involved in Database sizing, Capacity Planning.
• Installation and configuration of OEM Grid Control 12c.
• Perform Space Management & Troubleshooting the database issues.
• Upgrading OEM Repository and Installing OEM 10Grid Control to monitor all the databases.
• Configured and managed agents to work efficiently with Grid Control.
• Lead coordinator between technical operations team (DBA) and applications users/information systems/processing specialists
• Setting up privileges to create local and remote objects
• Create materialized views to refresh data at regular intervals.
• Using materialized view logs to reduce the replication time costs for fast refreshes.
• Configuring Oracle databases to effectively use the DISM (Dynamic Intimate Shared Memory) to dynamically shrink / grow the SGA.
• Upgrading/Migration from Oracle 8i databases to 9i and to 10g.
• Installing of quarterly security patches on all non-production and production servers.
• Cloning/replicating/refreshing production databases to test/ development environments using RMAN scripts.

Environment: Oracle 9i, 10g /11g with RAC, Oracle Golden Gate, Oracle Data Guard, HP-UX 11i v3,, Sun Solaris 10, RHEL 6.x, TOAD, SUSE 10,11, Control-M, Autosys, PCS, SRDF Replication