SUMMARY

• Over 12 years of IT Experience including 9 years as an Sr Oracle DBA. Worked extensively on Oracle 12c,11g, 10g, 9i, and 8i versions involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security.
• Expertise in installation, setup and configuration of Oracle 11g, 10g, 9i, & 8i on LINUX, SUN SOLARIS, HP - UX, IBM-AIX, WINDOWS
• Expertise in Oracle Enterprise Manager (OEM) and setup of Oracle Grid Control
• Implemented RMAN backups (Full, Incremental and Cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard
• Implemented and delivered core edge technologies of Oracle 10g (EM Grid Control, and RAC)
• Bi-directional replication and Uni-directional replication in Golden gate
• Installed and Worked on 12C databases
• Maintain Oracle SQL and Unix shell scripts, debugging and tuning. Ability to pro-actively understand and manage end user/customer expectations.
• Great experience applying patches and performing DB Migrations. Plan and Design Backup/Recovery solution using Shell scripting and RMAN.
• Migrated Oracle 11g to 12c and Database Administration on Oracle 9i,10g, 11g and 12c environments,
• Installed Oracle 11g & 10g RAC software with ASM & OCFS2 file systems
• Have implemented two type of standby databases supported by DATA GUARD, logical standby and physical standby databases
• Provide best practice on new technology and implementations. Provides expertise and makes recommendations for physical database design, testing, performance tuning, and implementation of DB. Performance issues (track and trend overall database performance and database area, index, and drive performance)
• Implemented various replication solutions using Oracle Data Guard, Oracle Streams
• Configured and installed Golden Gate in unidirectional and Bi-directional replication for Oracle 11g Databases for High availability and reporting projects
• Worked on large-scale databases with size more than 1 TB in large system environments
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN
• Created development, testing, staging, production, RAC and standby databases for OLTP, and Data Warehousing using customized shell scripts and stepwise
• Good experience in applying security patches and migration of Oracle server from 10g to 11g, 9i to 10g & 8i to 9i
• Performance issues (track and trend overall database performance and database area, index, and drive performance).
• Provide best practice on new technology and implementations. Provides expertise and makes recommendations for physical database design, testing, performance tuning, and implementation of DB.
• Have implemented two type of standby databases supported by DATA GUARD, logical standby and physical standby databases in 11gR2 on two node RAC
• Worked on large-scale databases with size more than 12 TB in large system environments
• Worked as a team member to provide 24x7 on-call production database support
• Logical and physical modeling using Erwin
• Worked on Data Modeling, Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.
• Expertise in loading data from flat files using external tables, SQL* Loader.
• Creating the Private and Public database link.
• Good Programming Skills in SQL, PL/SQL, UNIX Shell Scripting.
• Experience in Load and Performance testing of the database servers and application servers, analysis and documentation of results
• Database replication using snapshots, materialized views and advanced Replication methods
• Excellent communication and interpersonal skills

TECHNICAL SKILLS

OPERATING SYSTEMS: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2,6.1 Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows 98/NT/2000/2003/XP

RDBMS: Oracle 12c/ 11g/10g/9i/8i, Oracle 10g (RAC, Data Guard), SQL Server 2005

LANGUAGES: SQL, PL/SQL, C, UNIX Shell Scripting, Ksh, bash and Perl Scripting

SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN),Oracle STREAMS, Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Performance Tuning, Real Application Clusters (RAC), ASM, Sql Navigator, ERwin, TOAD, Data Pump (expdp, impdp), Shareplex, Autosys, Golden Gate, Query Analyzer, Crystal Report, ETL (Informatica 8.5), VERITAS NetBackup, Developer 2000, SQL*Plus, SQL*Loader

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

Software: Oracle Web, Oracle form Server, Oracle reports, EMC.

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Oracle DBA Lead

Responsibilities:

• Providing services as an Oracle Database Architect/Administrator, short contract project, providing on-site and on-call support to High Availability Databases.
• Architect, Built & maintained Oracle 11gR2 RAC (ASM Real Application Cluster), Non-RAC (ASM) and File System based databases of varying sizes.
• Perform DBA task such as Migrated Oracle 11g to 12c and Database Administration on Oracle 9i,10g, 11g and 12c environments,
• Performance tuning, Schema creation, maintenance, and trouble shooting
• Architect, Built & maintained Oracle 11gR2 RAC Cluster Physical Standby active databases
• Migrated Oracle 11gR2 RAC databases and nonRAC databases to in-house Datacenter.
• Developed Oracle PL/SQL Packages to Scrub Data to refreshes internal lower environment databases.
• Developed RMAN Backups, Data Pump and disaster recovery management policies.
• Implementation ASM Databases on Linux uDEV drives.
• Created & Modified ASM disk groups and allocate space on devices & space management.
• Expertise design of Oracle Schemas, tables, triggers, packages, procedures, db links, views, sequence, Materialized views, constraints, and indexes.
• Extensive performance tuning after migration of web based price quote applications databases and recommendations of code enhancements and implemented best practices.
• Management of web applications safety and sensitive PII information including confidential sensitive information and media Information protection policies.
• Setup and manage RAC environments for our customers, Monitor, recommend and implement changes to database applications ensuring satisfactory end-user response time with reliable database connectivity. Implement physical database changes, and performance reports.
• Worked on Oracle 11gR2 Golden Gate replication to propagate tables & schema based replication.
• Resolves database performance issues, database capacity issues, backup, replication, and other distributed data issues.
• Ensure that the database software infrastructure is in place and up to date to support other infrastructure components (e.g., operating system and hardware) and application development
• Maintain Oracle SQL and Unix shell scripts, debugging and tuning.
• Extensive performance tuning of database, and node management.
• Ability to pro-actively understand and manage end user/customer expectations.
• Provided Support to other Oracle Databases on rotation basis to maintain & configure RAC cluster and non-cluster databases including monitoring, Day to Day (SLAs) activities.
• Excellent communication skills, day to day maintenance activities, automation, SharePoint, kronos, bruha, documentation, positive problem solving skills and team building.
• A Big Team member and work well with all levels of business & Oracle Advance Technology Team

Environment: Windows 2010, Sun Solaris 10, Red Hat Enterprise Linux 5,performance Tuning, ASM, RMAN, FTP, putty, Data Guard, Oracle 10g/11gR2/12c RAC, OEM11 &12C, Golden Gate, TOAD, PL/SQL, SQL*Loader.

Confidential, Chicago, IL

Sr Oracle DBA

Responsibilities:

• Installed and Configured Oracle 11.2.0.3 databases on Linux and also migrated Oracle databases from Solaris to Linux.
• Configured and maintained Oracle Data Guard for Disaster Recovery environment using DG Broker for RAC one Node Databases.
• Maintained Production databases upto 7TB.
• Configured and installed RAC One Node Production Databases with Automatic Storage Management (ASM).
• Provided 24/7 on-call support for Oracle production/development databases to ensure maximum availability.
• Upgraded oracle OEM 12cR1 - OEM 12cR3.
• Installed Automatic Storage Management (ASM) for stand-alone and RAC One Node databases and performed migration of databases from file systems to ASM.
• Configured and installed Golden Gate in unidirectional and Bi-directional replication for Oracle 11g Databases for High availability and reporting projects
• Configured RAC 11gR2 Data Guard Standby Databases using Data Guard Broker.
• Performed RMAN backup and also developed backup strategies using incremental and cumulative backup methods.
• Moving data from development to production through transportable tablespace exports.
• Scheduling the backups for the database using EM 12C cloud control.
• Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database auditing and managing user groups, Database security, OS space monitoring etc.
• Installed and worked on 12C databases.
• Configured and Implemented Oracle 11g Database Two node Real Application Cluster (RAC) using Automatic Storage Management (ASM) and responsible for High Availability.
• Extensively worked on 12C Oracle Enterprise Manager (OEM) grid control for monitoring needs.
• Performed various RMAN strategies like RMAN Backup, RMAN Restore and RMAN Recovery etc.
• Configured and Performed Hot and Cold Backups for Non-prod databases, and Cloning of Databases using RMAN methodologies for setting up UAT and DEV environments.
• Excellent experience of database Backups and Recovery strategies using RMAN, Export Import

Environment: Oracle 10g/11gR2/12c RAC, Windows 2008, Sun Solaris 10, Red Hat Enterprise Linux 5, ASM, RMAN, FTP, putty, Data Guard, OEM11 &12C, Golden Gate, TOAD, PL/SQL, SQL*Loader.

Confidential, Humble, Texas

Sr Oracle DBA

Responsibilities:

• Installation, configuration and maintenance of Oracle 10g/11g databases.
• Installation, configuration and administrating Oracle GoldenGate replication between oracle databases.
• Part of the team for database upgrade from 10.2.0.2 to 10.2.0.4 with logical and physical standby in place.
• Set up, configured and maintained oracle data guard/Veritas Cluster (primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Performed day-to-day DBA jobs for managing Production/Development databases.
• Excellent experience in Opatch and Oracle upgrades.
• Support & Maintenance of Production, Development and Test Databases on various servers Solaris and HP.
• Creating and managing users with appropriate tablespaces and Indexes, public and private database links.
• Rebuilding Indexes and gather statistics on tables on different databases on a regular basis to gain database performance.
• Manage users, privileges, profiles, schemas using Oracle Grid Manager, Oracle Enterprise Manager (OEM) and SQL.
• Worked on original export/import and datapump export/import
• Tuning the Databases for optimization using AWR, ASH, ADDM, STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size.
• Used Quest live, re-org and IONS for database tuning.
• Configured shell scripts for job/process automation.
• On call DBA and provides 24X7 supports for production issues.
• Excellent experience in moving databases to different servers and schemas to different databases.
• Excellent experience in managing space for tablespaces with physical and logical standby databases in place.

Environment: Oracle 11g/10g/9i, data guard with physical and logical standby databases, Sun Solaris 10 on M5000/M3000, HP servers, Oracle Enterprise Manager, RMAN, SQL, TOAD, AWR, ASH, ADDM, TPROF, Explain plan, STATSPACK, and Oracle Golden Gate replication from oracle to oracle databases.

Confidential, Dearborn, MI

Oracle DBA

Responsibilities:

• Installation & Configuration of Oracle 11g, 10g on Linux (RHEL 3, 4). Upgraded databases to 11g (dev).
• Participated in creating RAC (3 Node, Size 17T)
• Implemented various replication solutions using Oracle Data Guard, Oracle Streams.
• Implementation of physical standby database.
• Have Worked with applications that use Hibernate.
• Implementation of RMAN backups.
• Configured ORACLE DATAGUARD.
• Gathered Oracle Database statistics - like Table space sizes, Data files sizes, etc.
• Planning Backup strategy for all instances. And Log Monitoring.
• Recover Database from backup. Used Data Pump for bulk data migration.
• Migrating database schemas.
• Improved Performance of database by tuning parameters like library cache, log buffer, missing & rebuilding indexes, buffer cache hit ratio, sorts, reparsing of SQL, free list contention .
• Performed RAC Installation over local file system. Voting & SRVM disk are located on RAW partitions and database is on ASM file system
• Confident about using Explain plan, Tkprof, Events tracking, Auto trace and identifying the execution plan and tune queries, using indexes, hints etc
• Created symbolic links to access these Raw Partitions from the Oracle Database
• Responsible for database security and patching and Control and monitor user access
• Performed day to day database administration on existing databases and applying patches (OPATCH) and upgrades as needed,
• Installed, Configured and effectively used Oracle ASM, AWR, ASH, ADDM features
• Participated as a member of the engineering teams for database-related tasks like optimizing the sql’s
• Maintained effective database performance monitoring procedures
• Control and monitor user access to databases and maintain database security
• Allocate storage and develop plans for future storage requirements.
• Maintain documentation of systems and standard operating policies and procedures.
• Resolve development and QA database requests

Environment: AIX 4.3.3, HP -UX 11.23, Solaris 9, Windows XP, Oracle 9i, RAC, OEM, RMAN, DBCA, Data Guard, Putty, Java, XML, Load Runner, TOAD, Erwin, UNIX, RHLinux 4.0.

Confidential, New York, NY

Oracle DBA (Oracle Consultant)

Responsibilities:

• Worked extensively on providing support to oracle high availabilityRAC databases.
• Involved in disaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backupsand disaster recovery strategies using RMAN.
• Involved in Oracle 10g RAC installation on new and existing systems.
• Designed database models for enhancements to existing databases.
• Performed SQL and Application tuning using OEM tuning advisor, explain plan and TKprof.
• Responsible for supporting and migrating huge volume (1TB) of data between different servers and versions.
• Supported 7 database out of 35+ databases deployed.
• Responsible for developing design documents for new database designs and enhancements.
• Coordinated DBA team of 3 for new application implementation on database migration from Sybase.
• Installed and configured Data Guard oracle 10g Databases.
• Worked with developer in tuning multiple PL/SQL stored procedures and SQL queries.
• Performed multiple data migrations using oracle Data Pump and regular exp and imp.
• Memory tuning by using ASMM (Automatic shared Memory Management). Sort area size, Buffer cache, Shared pool size, Different pool like Recycle pool, Keep pool.
• Implemented 10g features like Undo retention Guarantee, Flashback table, Flashback version query, Flashback Transaction query, Recycle bin.
• Implemented Oracle Advanced Indexes
• Creating the Private and Public database link.
• Creating Materialized View and Using Query Rewrite for Performance.
• Expertise in configuring Network using Net Manager.
• Configured listener.ora and tnsnames.ora as on when required for clients.
• Creation of database with the complete understanding of hardware configuration to provide maximum performance and high availability.
• Hands on practice on ASM (Automatic Storage Management).

Environment: Oracle 8.1.6 /9i, HP-UX 10.2/11.0, HP 9000, Windows NT 4.0, Erwin, Power Mart, Oracle Replication Manager, RDBMS, Export/Import, Unix Shell Scripts, TOAD, Tkprof and SQL*Net/Net8

Confidential, New Jersey

Technical System Analyst

Responsibilities:

• Responsible for day-to-day business application support including setting up user accounts and access, security, troubleshooting or debugging problems,
• Providing technical supports and installation upgrades.
• Participate in the implementation of new projects such as project schedules, research evaluation, test plans, and system requirements.
• Support and assist Financial System users and security to ensure integrity, accuracy, and protection of systems.
• Update and maintain SQL Database on daily basis and responsible for importing data to Accpac and Excel.
• Develop, maintain, and access reports and ad-hoc reports such as month-end, daily sales, yearly budget, and forecasting using Crystal Reports, Excel and Accpac.
• Responsible for ongoing production support for daily and monthly financial activities by providing analysis, troubleshooting, and technical support for the business.
• Includes managing problems tracking and resolution with the vendors, and successfully supporting upgrades, testing, and system setup and configuration.
• Assist and support Financial and Accounting Dept. to participate in monthly and annual budget and forecasting process to ensure to work properly and correctly system.