PROFESSIONAL SUMMARY:

• Over eight years of professional experience as oracle DBA, providing 24*7 support for multiple OLTP database and data warehousing environments on various platforms Experience on high volume databases with sizes varying from 50 GB to 200+ TBs of data on various version of Oracle from 9i, 10g, 11g to 12c on SUSE, UNIX/LINUX, HP - UX, IBMAIX, SUN Solaris, windows environment.
• Hands-on experience in upgrading the oracle databases (9i to 10gR1, 10gR1 to 10gR2, 10gR2 to 11g, 11g to 12c).
• Experience in applying oracle database patches using OPatch utility.
• Experience in installation and configuration of Oracle 10g with RAC using ASM, configured user log on load balancing and failover on RAC database for high availability.
• Installed and Administered Oracle 12c, 11g ASM & 10g RAC with ASM & Oracle Clustureware File System (OCFS2).
• Hands on Experience in 10g, 11g grid control and 12c cloud control and intensively used for diagnostic & tuning activities.
• Strong expertise in maximum availability architecture setup for Oracle EBS R12.1 environment on Exadata (X3-2 & X5-2) infrastructure using active Dataguard and GG replication setup.
• Migrated multi-terabytes size database migration from Linux to Exadata X3 and X5 database machine using RMAN restore and using oracle Golden Gate replication.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
• Expertise in Backup and recovery issues related (loss of OCR, Voting Disk and Oracle cluster ware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Also used the Merge backup for backing terabyte databases. Issues with block change tracking & also flash recovery area.
• Extensive experience in performing backups and tested crash recoveries using conventional hot, cold backups and RMAN.
• Maintaining and troubleshooting Data Guard replication to ensure timely failover in the event of a disaster.
• Hands on experience of daily monitoring oracle instances and maintenance of databases using Oracle Enterprise Manager(OEM), Oracle GRID, ISQL*Plus, and SQL*Plus command line scripts.
• Experience with Data Guard, creation of physical standby and resolving the physical standby database gap.
• Proficient with RAC, ASM, Standby Database, Data Guard, Replication. Experience in basic and advanced replication using Golden Gate. Experience in configuring oracle data guard and streams.
• Worked on distributed database configuration, creation of database links and snapshots using STREAMS for 2 way replication of data.
• Monitoring database performance and space utilization - investigating and resolving reported issues as well as recommend upgrades/updates.
• Involved in migration of Microsoft SQL server to Solaris Oracle, doing schema re-engineering, and conversion of TSQL stored procedure to oracle PL/SQL, transformation of all MS-SQL data tables to oracle.
• Experience in SQL, PL/SQL, Database procedures, Triggers, Packages.
• Proficient in database administration activities such as upgrades, patches, TAR support, cloning, backups, recovery, performance tuning, capacity planning, script development and documentation.
• Data Modeling activities include designing the database to support various applications of the client by developing logical and physical models using Designer/ERWIN based on the requirements specified by the client.
• Experience in instance cloning and code migration processes.
• Extensive Experience of Distributed transaction processing (DTP) in RAC environments, which includes both XA and distributed SQL transactions.
• UNIX system administration - database and application integration efforts; CVS system installation experience; heavy UNIX shell scripting, CORN jobs.
• SQL - Query optimization expertise, including data integrity analysis for application customization testing and creating analytical metrics.
• Comfortable working alone or driving goals as part of a team.

TECHNICAL SKILLS:

Operating System: HP-UX 10.x/11.x, IBM AIX 4.x/5L, Sun Solaris 2.6/8/9/10, Linux 2.x/3.x/4.x/5.x and Exadata X3-2, X2-2, X3-5

RDBMS: Oracle 9i, 10g, 11g, 12C, oracle 10g/11gR2/12c RAC and MS SQL server

Database Servers: Oracle Application Server 10g, HP 700 Series, HP Superdome, Sun Enterprise 450 &880, Sun 3500, 3800, 6800, Sun fire 4800, V1280, Dell PowerEdge.

Languages: SQL, SQL *Plus, PL/SQL, C, C++, UNIX Shell Scripting

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, Datapump, Goldengate, Erwin, TOAD, Shareplex.

Tuning tools: TK PROF, EXPLAIN PLAIN, STATSPACK, SQL*TRACE, AWR, ADDM

WORK EXPERIENCE:

Confidential, Virginia Beach, VA

Sr. Oracle Database Administrator

Responsibilities:

• Provided 24*7 support for all the production and development databases ranging from 100GB to 4TBs.
• Provide DBA support with a high degree of customer service, technical expertise, and timeliness. Provide adequate and creative solutions to user problems of reasonable nature to ensure user productivity and assuring data is protected and recoverable as required.
• Analyze load and capacity allocation and participate in performance debugging exercises when required. Plan for backup and recovery of the database, and allocate system storage and plan future storage needs.
• Worked on Exadata(X3, X4 and X5) one-eighth, half-rack and quarter rack services.
• Study relevant business processes, understanding application design/behavior and the data flow, criticality and dependencies.
• Responsible for configuring, administering, and maintaining the database environments in a RAC configuration.
• Experience in shell scripting for various CORN jobs to be run.
• Experience with data transfers and sharing using flat files.
• Expert in performance tuning of database, memory & I/O. used tools such as AWR, ADDM, STATSPACKING, HANG ANALIZE, SYSTEM STATE and analyzing queries using EXPLAIN PLAIN, SQL-TRACE, TKPROOF, OEM.
• Excellent experience in OLTP/DSS database system, implementing and managing large oracle databases (VLDB).
• Upgraded database from 11g to 12c.
• Proactive database monitoring using 12c Grid monitoring tool.
• Upgrade of Grid and Oracle Infrastructure on multi node RAC cluster from 11.2.0.3 to 11.2.0.4.
• Performed Migration between different data centers, Non ASM to ASM, Single instance to RAC.
• Extensively worked on identifying bugs and installing necessary/latest CPU/PSU patches in a rolling fashion for both the Cluster ware home and Database home.
• Responsibilities include database upgrades, patching, security, troubleshooting and issue resolution and backup procedures using RMAN and data pump.
• Implemented Dataguard with maximum availability, protection and performance configurations and worked with Dataguard Fail over and Switch over cases by configuring Physical/Active standby databases.
• Create automated scheduled jobs for integrity checks, index defragmentation and update statistics.
• Good in Database and Transaction log Backups and Restoration, backup strategies, scheduling the backups.
• Work closely with system administrators to recommended appropriate hardware changes (server level mostly for disk spaces) while providing support for both NON-PROD and Production environment.
• Implemented Bi-Directional replication in golden gate from target to source and source to target and configuring parameters for DDL support in golden gate replication.
• Participated in off release deployments to PFX and PROD environments to give support as DBA.
• Performing and prepare maintenance for adding new luns, changing IP’s and kernels for Production environment.
• Used TOAD as third party software for analyzing the database issues and generating results sets in xls formats.
• Configure, monitor and trouble shoot Nimbus monitoring tool.

Environment: Oracle 11g, 12c, SQL, PL/SQL, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, Red Hat Enterprise Linux, ASM, HTML, Exadata X3-2, X2-2, X3-5.

Sr. Oracle Database Administrator

Responsibilities:

• 24 hrs. production support.
• Installation, configuration and maintenance of 11g RAC and stand by databases.
• Installed and maintenance of oracle 10g, 11g databases.
• Worked on multiple RAC clustered environments ranging from 2 nodes to 5 nodes per cluster.
• Implemented Goldengate for data recovery and data migration for Oracle 11gR2 RAC 2 nodes on RHEL and debugging Goldengate issues such as extract or replicate rebuild and abend.
• Implemented oracle 11g new features like real application testing (RAT), RMAN new compression algorithm and tested active standby data guard.
• Involved in fresh installation of 11.2.0.1 and 11.2.0.2 and 11.2.0.3 RAC databases on ASM and NFS file systems.
• Evaluate, resolve and escalade database monitoring events as part of a level 1 supporting staff.
• Configured dataguard to provide high availability by implementing physical stand by database and worked with various oracle 10g features: streams, 10g grid control and automatic storage management (ASM).
• Implemented and configured 11g grid control on RHEL 5U7.
• Database patching using OPatch Perl script.
• Developer environment setup, support, cloning and refreshes.
• Worked on data transfers and sharing using flat files.
• Reading alert.log and user trace files and diagnosing the problem.
• Management of schemas, objects and partitioning the tables & indexes.
• Upgrading development and production databases to oracle 10g.
• Developed logical and physical data models and data flows using Erwin.
• Responsible for setting and managing user accounts, granting required privileges to users.
• Responsible in managing and optimizing transactional replication in OLTP environments.
• Optimizing and tuning SQL Queries using TRACE FILE, TKPROF and EXPLAIN PLAIN.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
• Implemented backup and recovery functions using hot, cold and RMAN procedures.
• Used RMAN for backup and recovery and performed backup validations using RMAN, Tivoli storage manager (TSM) and NetBackup.
• Developed scripts to proactively monitor and databases and alter the DBA on events such as running out of extents, disk space and actively involved in shell scripting for various CORN jobs to be run.
• Responsible for optimizing the queries and application tuning.
• Performed SQL tuning and assisted developers with coding PL/SQL.
• Automation of data load using shell scripting and SQL*Loader.
• Performed other regular DBA activities including space management and performance monitoring.
• Involved in process improvement, oracle server installations/upgrades/patches, space monitoring, capacity planning, backup & recovery, disaster recovery, database performance tuning, memory tuning, application tuning, security administration, data warehousing, data guard, oracle advanced replication, real application clusters, oracle standby.
• Code review to ensure that the new customizations were developed with in corporate programming standards.
• Oracle database monitoring, troubleshooting and resolving the issues.

ENVIRONMENT: Oracle10g, 11gR2, RHEL 4U8, 5U8, OEM DataGuard, Netapp NFS, SQL loader, RMAN, Datapump, Netapp, VLDB.

Sr. Oracle Database Administrator

Responsibilities:

• Installed and Configured 2node RAC on Linux.
• Installed and Configured and maintained oracle 11g.
• Oracle Grid Control 11g Installation and Configuration.
• Refreshing the Database from one version to another version.
• Configuration of Physical Standby database for maximum performance mode - Oracle Data Guard
• Installation, Configuration and Maintenance of Oracle RDBMS and Client software in various environments.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities
• Performed rolling patch upgrades on RAC environment for bug fixing
• Setup of Jobs using the Oracle Enterprise Manager (OEM) database control
• Daily incremental backup and weekly full backup of databases using RMAN
• Involved in migration of applications of the clients.
• Loading data into database tables using SQL *Loader
• Implemented Materialized views, database links
• Regular database management on 10g and 11g OEM
• Working Knowledge of installation and configuration of GOLDENGATE in Unix environment
• Done Installation and configuration of golden gate on 11g database for the replication.
• Implemented Bi-Directional replication in golden gate from target to source and source to target.
• Resolving the conflicts between the target and source database.
• Configuring parameters for DDL support in golden gate replication
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Table space monitoring, Performance monitoring and tuning for performance improvement
• Creating batch files and automating the tasks
• Granting roles and privileges to end users
• Managing, troubleshooting and resolving oracle database and application issues.
• Daily health checkup of the database using TKPROF, AWR, ADDM.
• Monitoring alert log/system log and managing Database Locks and blocking sessions
• Defragmentation of tables and indexes for improved performance and efficiency.

Environment: Oracle 10g, 11g, SQL, PL/SQL, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, Red Hat Enterprise Linux, ASM, HTML

Oracle Database Administrator

Responsibilities:

• Installed Oracle DB 10g, 11g RDBMS, RAC on ASM, Applying Oracle Critical patch updates, Implementing and Manage Data Guard, Replication, Backup and Recovery support and performance tuning etc.
• Installed Grid Infrastructure Software on new Linux Servers for 2 node and 3 node RAC and Failover environments and Oracle Grid Control11g Installation.
• Migrated Non-ASM databases to ASM environment for high availability using RCONFIG.
• Configured and maintained Standby Databases in OLTP environment to automatically synchronize with production database.
• Configured the Data guard for switchover and failover and thereby providing high availability.
• Coordinated operating system setup/upgrades and infrastructure troubleshooting in partnership with system administrators.
• Implemented Recovery Manager (RMAN) Recovery Catalog performed Complete and Incomplete recovery.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.
• Having good exposure in user management, Table space Management, Session Management, undo Management issues.
• Experienced in managing space issues in the Database Level for table space and Regular file system cleanup at UNIX level.
• Generated AWR, ADDM and ASH reports for database issues
• Automation of data load and data parsing using Pl/Sql procedures, corn shell scripting and Sql*loader.
• Created bit-map Indexes for data warehouse databases.
• Involved in the error checking and testing of the ETL procedures and programs Informatics session log.
• Performed security management and accessibility control by managing OS and Password file authentication, creating profiles, privileges and roles.

Environment: Oracle 9i/10g, LINUX, Windows 2003 server, OEM, Shell Scripting, PL/SQL.

 Sr. Oracle Database Administrator(contract)

Responsibilities:

• Installed and configured Oracle 9i databases
• Managing users, roles and privileges, space management Creating storage structures, Performance Tuning
• Responsible for maintaining multiple development and test databases.
• Monitoring Applications proactively.
• Actively involved in gathering requirements, system design, development, and application support.
• Written Database stored Procedures, Functions, Packages & Triggers
• Performed Unit, System and User Acceptance tests of different modules.
• Managing, troubleshooting and resolving oracle database and applications issues.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Working alongside programmers and contributing to the development process.
• Performance monitoring and tuning.
• Re-organization of Tablespaces and Application and Database Performance tuning.
• Troubleshooting DB related issues. Providing scripts for taking regular backups.
• Performed day-to-day database administration and ensured integrity, security, and availability of the database.
• Storage management, sizing the database objects, monitoring file systems, and table space growth.
• Performance tuning of the queries using Explain Plan, tkprof, Statspack.
• Alerts setup for Database monitoring.
• Planned and implemented Backup and Recovery strategies.
• Provided Ad-Hoc reports from the Data Warehouse for management.
• Developed user documentation for supporting tools and database and created problem resolution repository.

Environment: Oracle 8i, 9i, Red Hat Linux, Windows, Data Guard, OEM Grid Control, UNIX Shell Script, TOAD, PL/SQL, SQL*Loader, Data Pump, RMAN, ASM