SUMMARY

• 7+ years of experience in Oracle database administration in Linux, Unix and Windows platforms. Experience include Installation, Upgradation, Migration, Memory Management, Data Modeling, Performance Monitoring, Tuning, System maintenance, Cloning, patching, user support, TAR management, Database security, Troubleshooting database design, Documentation, Backup and Recovery and supporting Application deployment and interested in RBDMS like TERADATA, NETTEZA.
• Experience in Design, Development, Integration and Testing of Oracle Databases.
• Proficient experience and a track record of delivering quality solutions for enterprise level distributed systems.
• Expertise in leading the teams for maintenance of 24X7 high - availability applications and databases.
• Expertise in Installations/upgrades, Migration and monitoring of Oracle 9i, 10g, 11gR1, 11gR2 on RHEL 5,6 Solaris 5.10, HP UX 11i, IBM AIX and Windows Environments.
• Installation/Upgrades: Oracle 9i, 10g and 11g, 12c Upgrades. HA, MAA architecture involving RAC 10.2/11.1/11.2 with Physical/Logical Standby Setup, Grid Infrastructure 11.2 Installation and Upgrades.
• Handled huge database Migration: cross-Platform Server Migrations from Linux-itanium to x86 64bit, HP-UX-i, IBM AIX, Oracle RAC Migrations from Netapp to HP-EVA, Netapp to XP 12k, and Netapp to EMC VMax, Data-Center Migrations.
• Expertise in Monitoring of Oracle OEM 12c (12.1) Cloud Control Installation, Administration, configuration, OEM 11g/12c Installation, 11g OEM to 12c OEM Upgrades, Management Connectors for OEM Grid - HP Open View, Remedy, SQL Server, EBS plugins, ERP AMP Patching, IBM Tivoli, Quest Foglight, HP Openview, Alarmpoint, Nimsoft.
• Specialties: Oracle RAC Installations and Administration, Migrations from Single Instance to Cluster and ASM, Database Upgrades and Administration, Disaster Recovery solutions with Data Guard. RMAN implementation, clonings, backups and recovery, OEM Grid Control 11g and 12c Cloud Control, Shell Scripting, Oracle Internet Directory, Database Performance Tuning, Real Time SQL Monitoring, Oracle Streams, Golden Gate - Advanced Replication. worked on building and rolling out new 12c databases for test/dev/qa environments.
• Experience in Coordinating DBCR (Database Change Request) and DBUR (Database Update Request) for Non-Prod and Prod Environments.
• Implemented oracle 12c flexi asm for pre-prod environment.
• Managed Microsoft Active\Active and Active\Passive Clustered SQL Server 2000, 2005 and 2008/R2 environments.
• Worked on upgrading of oracle databases from 11g to 12c.
• Expertise in using 12c, 11g features Active data guard/snapshot standby, Grid Infrastructure, and 10g Features DATA Pump, Flash back recovery, AWR, ADDM, Grid Monitoring, Recycle bin, followed OFA standards while building database.
• Installed, Configured Oracle 12c Goldengate on Oracle 12c Database.
• Strong experience in supporting development, unit test, system test, Integration test, certification test, production databases under almost all flavors and different versions of UNIX.
• Experience in implementing DR Solutions: DG Broker, Physical standby, Logical standby configurations, Connect Time Failover, Maximum Availability Architecture (MAA). Experience in High Availability solutions with Oracle 11g RAC, ASM, FLASHBACK and Standby (DATAGUARD).
• Worked with projects/operations/professional services team and co-ordinated multiple tasks Confidential hand with expertise and solid plan
• Experience in Real Application Clusters (RAC) setup with 4 nodes, configuration and cluster interconnection with Automatic Storage Management (ASM).
• Hands on experience with following Replication methods: Materialized Views, Oracle Streams, Logical Standby, Golden Gate, EMC SRDF, Time Finder.
• Experienced in features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
• Implemented data load by replication methods like Materialized Views, Golden gate from OLTP systems into data warehouse databases.
• Converted file system based Database to Oracle ASM along with Oracle RAC.
• Experience with complex database recovery scenarios, Export/Import Datapump.
• Experience with Oracle Golden Gate installation, configuration and troubleshooting across heterogeneous Operating Systems.
• Experience in bi-directional and broadcast replication from source to target Databases using Golden Gate 9.5 and Golden Gate 10.0.
• Have Hands on experience in Oracle 10g, 11g 4Node RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM, Configuration and Patching, RAC Backup and Recovery).
• Upgraded existing, high available production Oracle databases by DBUA and manual upgrade method to PSU patch set updates 11.2.0.3, 11.2.0.4 from 11.2.0.1.
• Worked on Performance optimization of large objects (LOB, BLOB, CLOB) by monitoring redoes generation, increasing log buffer size, block size and changing archiving procedures and Query tuning using Statspack, TKprof and OEM
• Capable of tuning SQL using EXPLAIN PLAN, DB Statspack, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and tracing Confidential user level and TKPROF.
• 24/7 Production Database Support and maintenance, SR Tracking and Remedy and Global service desk Support.
• Can work independently to ensure that the databases are operating efficiently and ensure proper backup and disaster recovery methods are maintained.
• Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )
• Possess good leadership, excellent communication and time management and presentation skills with excellent technical, analytical, interpersonal, problem solving and organizational skills.

TECHNICAL SKILLS

Databases: Oracle 12c/11g/10g/9i/8.x, RAC 10g/11g, MS Access, SQL Server 2005/2008, My SQL.

Oracle Tools: Sqlldr, Enterprise Manager (OEM), TOAD, Third party Code migration tools, DBA Studio, Quest Stat (erp patch code Migration), kintana, quest central, Sql*net, Net8.

Application Servers: Fusion Middleware 10g, Apache Server (1.3.9/1.3.12/1.3.19 ), Apache HTTP 2.0, Tomcat 5.0, 5.5 & 6.0.

Operating Systems: Linux, IBM-AIX (4.3/5.2), HP-UX (10.20), Sun Solaris (2.6, 7, 8), Win NT 4.0.

Languages: SQL, PL/SQL, C, shell scripting, perl, awk, Html, DHtml, Java.

Application Tools: Workflow Builder, VMware, MS Office, MS Visio.

Other Tools: SHERPLEX, DB-SPY, BMC-PATROL, Veritas backups, EMC Networker,AWS.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Oracle DBA

Environment: RHEL 6.x, IBM AIX 6.1 Oracle 11gR1, 11gR2, 12c, RAC, ASM, RMAN, OEM Grid Control 12c, Golden Gate 10.0, Data Guard.

Responsibilities:

• Provided Production & test environment support while coordinating with Unix Team and storage team to configure the OS infrastructure for Oracle Databases.
• Implemented, developed, tested and maintained, PL/SQL stored procedures and functions.
• Monitoring database performance and database operation to prevent downtime and slowness of the services.
• Worked on setting up/installation and configuration of release 11g R2 RAC with ASM and Raw Devices and 11g CRS on IBM AIX 6.1.
• Performed conversion of Single Node Instance to multi node RAC with ASM, and adding instance to existing RAC.
• Documented all Oracle 12c installation/Upgradation work and delived KT to all team peers.
• Worked on Oracle RAC with SRDF Implementations for cross data center replication.
• Responsible for performance Monitoring and analysis of 11g RAC (Real Application Clusters) with AWR (Automatic Workload Repository) reports and ASH (Active Session History).
• Involved in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICAT issues
• Installed, Configured Oracle 12c Goldengate on Oracle 12c Database.
• Implemented Data Pump, Export and Import on day to day basis as per development and test servers.
• Worked closely with the system operations team on database deployment processes and database capacity planning.
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export).
• Written Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Involved in architecting the environment requirements for the project, hardware provisioning, instance strategy, patching strategy and performed three full upgrade iterations on the Test environment including dry run and supported the functional business process teams during the pre-upgrade & post-upgrade tasks and testing and cutover phases.
• Scheduled database maintenance tasks such as tables/indexes analysis, index rebuild, materialized views refresh and db exports.
• Maintained DATA GUARD to provide high availability by implementing physical stand-by database and snapshot-standby and worked with Oracle 11g features 11g Grid Control and Automatic Storage Management (ASM).
• Troubleshooting Space Management & User accounts and privilege issues while coordinating with Unix and application teams.
• Utilized Rman recover table functionality and created proof of concepts for our pre-prod environment.
• Performed proactive database maintenance procedures to ensure optimal performance and uptime and implemented shell scripts for automation of day to day activities
• Coordinating DBCR (Database Change Request) and DBUR (Database Update Request) for Non-Prod and Prod Environments.
• Followed Central Issue and Change Management Process for DEV, QA and STAGE Environment.
• Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine-tuned further.
• Regular Security Patching and Critical patch Updates (CPU) and Patch set updates (PSU) on Oracle databases and interim patches for various bug fixes on database products.
• Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Implemented and configured of Oracle Enterprise manager OEM 12C and Oracle Management Server for maintenance and monitoring of production databases.
• Managing Users, Roles, privileges, profiles, schemas, SQL Monitoring, SQL Advisor, SQL tuning and Metrics, using Grid Control of Oracle Enterprise Manager (OEM) 12C.
• Creating and Managing Primary Objects like Custom tables, Procedures, Packages, Triggers, Alerts & Functions. Views, Indexes, user accounts, roles, grants and performing day-to-day operations
• Expert in monitoring database using Oracle Enterprise Manager (OEM).

Confidential, Dallas, TX

Sr. Oracle DBA

Environment: Sun Solaris 5.9 and 5.10, Linux, Windows, Oracle databases 10.2.0.x, 11.1.0.x, 11.2.0.x Veritas Cluster, Net Backup, VNC server, NETAPP Manager, TOAD, OEM 11g grid control, Datapump, Exp/Imp, Metalink. PL/SQL, SQL*PLUS, VNC, Oracle RAC, Data guard.

Responsibilities:

• As Production DBA, managed all database issues including database capacity, re-orgs, backup & recovery, scripting and Performance tuning.
• Worked as team member to provide 24/7 on call production database support.
• Supported and maintained multi-terabyte high transactional OLTP RAC-enabled database.
• Implemented Upgradation and Migration of Database’s from 10.2.0.5 to 11.2.0.1 and applying patches whenever required.
• Installed Oracle Clusterware to provide infrastructure for RAC and configured 2 node Oracle 10g RAC with ASM.
• Installed and configured Oracle 11g RAC, developed 2 node RAC environments for a 25TB database by implementing WAN technology to reduce the network traffic.
• Responsible for Installing, configuring and maintaining Oracle Grid Control (10g grid).
• Responsible for regular Security Patching on Oracle Products and interim patches for various bug fixes on database products.
• Migration of Oracle Databases from non-RAC to RAC and non-ASM to ASM Instances.
• Recovering Golden Gate corruptions and managing host/cluster maintenance mode blackouts
• Installed, configured and supported uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing Golden Gate.
• Monitoring of database using Oracle’s Enterprise Manager (OEM), Statspack Reports, Explain Plans, SQL Trace and TKPROF.
• Regularly monitoring the Production databases using OEM 11g Grid control.
• Creating, maintaining, Tuning Standby databases, Disaster recovery using dataguard Broker.
• Applied Consolidated Update, Critical Patch Update (CPU’s), Security alert patches using Opatch.
• Participating in project cutover plans. Validate and refine DBA tasks in the cutover plan.
• Monitor and tune database performance including SQL tuning.
• Implement complex enterprise changes as they pertain to the database environment.
• Strong skill in PL/SQL procedures, packages, triggers and replication.
• Work with development and operations staff in resolving problems quickly and efficiently.
• Clear communication and documentation of technical specifications.

Confidential, Franklin Lakes,NJ

Oracle DBA

Environment: Sun Solaris 9. Oracle 9i/10g, TOAD, Oracle Standby databases, RMAN, Hot backups, Real Application Clusters (RAC) or High Available Databases, Export/Import, Datapump, Oracle Streams.

Responsibilities:

• Installation and creation of 9i, 10g Databases for Development, Quality and Production environments
• Created 9.2.0.4 and 10.2.0.1 databases for Testing, Development and Production on Solaris 9.
• Used Data pump for faster export/import of data in various DEV/TEST environments.
• Performing all daily Maintenance tasks including scheduling backup jobs, monitoring job failures and troubleshooting RMAN backup job failures and interacting with Oracle Customer service when required.
• Upgraded and applied CPU patches and bug fixes as and when required and performed database refresh from Prod to Dev. Troubleshooting Day-to-Day Users Issues in various modules.
• Worked on configuration of Oracle 10g RAC environment and troubleshoot performance problems.
• Responsible for Collecting and analyzing performance statistics for resource consumption and performance anomalies. Managing Tablespaces, Datafiles, Rollback segments, Temporary TBS.
• Used EXPORT/IMPORT to do table level and full database imports as per application team requirements.
• Implemented Streams replication between multiple Production databases (10.2.0.1)
• Developed materialized views for reporting purpose in Oracle 9i, 10g.
• Installed, configured and maintained Oracle 10g Real Application Cluster (RAC).Production support for Oracle database 9i/10g RAC. ASM and CRS installation and new database creation for 10g RAC.
• Developed scripts to proactively monitor the databases and alert the DBA on events such as running out of extents, disk space and actively involved in Shell Scripting for various CRON jobs to be run
• Used RMAN for incremental and cumulative backup/restore.
• Responsible for user and session management.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• As the availability of reporting instance is critical to business Implemented Pro-active scripts across the reporting servers to reduce the failure of replication.

Confidential

Jr. Oracle DBA

Environment: Oracle 9i, 10g IBM-AIX, HP-UX, Windows 2000, RMAN, PL/SQL, Shell Scripting, exp/imp, SQL, SQL/PLUS.

Responsibilities:

• Responsible for, both manage and support 6 production databases and 15 development/test databases with sizes of databases varying from 50 GB to 550 GB.
• Installed and Upgraded Shareplex (3.2 to 4.1) a replication tool for reporting environment.
• Perform daily administration support for database backups, performance tuning and monitoring
• Monitored and diagnosed database performance through monitoring of alert files, trace files.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Worked with Data pump to take the logical backups of databases.
• Worked in performing Point in time recovery using RMAN.
• Used oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases and NETCA (Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.
• Standby database setup via 10g data guard for database Disaster Recovery.
• Implemented shell scripts to reduce the time for large code movements during cut over tasks.
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary. Online/Offline Database Backups and managing database recovery with RMAN.
• Performance tuning via OEM, STATSPACK/AWR for 9i/10g/11g.
• Maintenance tasks like bouncing the production database, services through veritas.
• Effective in gathering the statistics for pinning the objects. Resolving listener and tnsnames.ora issues.