SUMMARY:

• Six Years of extensive experience in the IT industry involving Oracle Database Administration, Oracle Applications Administration. Worked extensively on Oracle 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
• Experience in Installation, configuration of Oracle RAC, developed multi nodes RAC environments for a multi TB database with ASM and Data Guard environments.
• Planned and implemented DR & high availability solutions using OEL 11g Standby Database using Oracle Data Guard, 11g RAC.
• Expertise with Oracle Enterprise Manager, RMAN, Schema & User management
• Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.
• Excellent experience in installation, configuration and administration of Oracle 8i, 9i, 10g, 11g in UNIX/LINUX and Windows environment.
• Proficient in Oracle Database Administration activities such as Upgrades, Patches, TAR support, Cloning, Backup and Recovery, Performance Tuning, Capacity Planning, Script Development, and documentation.
• Involved in performance tuning and database reorganizations. Worked on Disaster Recovery and Implementation.
• Utilized Oracle Streams and GoldenGate for data replication and synchronization
• Extract/Replicate with Golden gate for active - passive, live setup
• Proficiency in Disk management and problem resolving techniques with a good understanding of Capacity planning and efficient usage of the disk space. Performed SAN analysis and provided recommendations
• Proficient in all the phases of Software Development Life Cycle (SDLC) as well as Software Implementation Life-Cycle (SILC).
• Knowledgeable in using Grid Control and OEM Features and worked with databases which have critical and BLOB data
• Supported Streams Database where Database, Schema, Table level Replication is done. Worked on Partitioning and Materialized views
• Extensively used Database Administrative tools like Oracle Enterprise Manager, DBA Studio, SQL*PLUS, TOAD
• Monitoring VLDB (Very Large Databases) using Grid Control.
• Wrote several Purging shell scripts on Linux which have been using as standard script at the workplaces
• Designed complex ER diagrams, Data Flow Diagrams/Process Diagrams to detail the specifications
• Handled operational responsibilities like database refreshes/copy backs, security, documenting standards and procedures, data migration, data clean-up, data archiving, etc
• Developed RMAN scripts for database backup and recovery including- hot and cold backup
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes
• Good at Data Dictionary views, User Security and Auditing.
• Team player with excellent interpersonal, analytical and communications skills
• Wrote scripts to inform the DBA’s regarding the status, performance and space management of the database
• Participated in planning and implementation of off-site Disaster-Recovery planning and testing
• Worked with development and operations staff in resolving problems quickly and efficiently
• Proficient in raising TAR with Oracle Support and using Metalink to resolve the bottlenecks in the database environments
• Monitored and managed various database components (logical & physical) like table- spaces, segments
• Worked extensively on Shell scripting for backup, recovery and maintenance for databases.

TECHNICAL SKILLS:

RDBM: Oracle 12c/11g RAC/10g RAC/9i/8i

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

LANGUAGES: SQL, PL/SQL,UNIX Shell Scripting

TOOLS: RMAN, ASM, SQL*Loader, DataPump, TOAD, DBCA, DBUA, OEM/GridControl, Oracle Data Guard, ERWIN, TOAD

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

ETL: Informatica, External Tables

OTHER: EMC, NetApp, Veritas NetBackup, TSM

PROFESSIONAL EXPERIENCE:

Confidential, Roseville, CA

Oracle DBA

Responsibilities:

• Managed & trained a team for 24x7 support for Apple Online Store Production Databases and Applications With High Criticatility
• Performed Daily Heath check and generated reports for all Critial Databases and based on it performed Risk Mitigation Plan
• Installation, configuration and administration of Oracle 12c release 3, 11g databases
• Implemented Oracle 11g RAC, 10g RAC and Standby Databases including Active Data Guard for High Availability and Disaster Recovery
• Database Upgrades and Migration of Databases from 9i to 10g and 10g to 11g, applying patches whenever required
• Designed and Implemented Common Backup Platform on Primary and Disaster recovery Centers
• Debugged the OS watcher files and found out the time where DB load is high and depending on that proposed solution to the team
• Death with Vendors and DBs supporting External End users
• Installed and configured Databases in Disaster Recovery Center and Loaded the ETL data
• Applied CPU patches
• Working knowledge on Hadoop(1.2.X) on ETL
• Handled a Data transfer for ETL data from Hadoop to Oracle
• Backup and Recovery of the databases using RMAN and conventional Hot and Cold backups
• Migrated databases from Linux, Sun Solaris to AIX.
• Extensive knowledge on OEM
• Involved in design and layout for the database structures and implemented them
• Performance monitoring and tuning using Explain Plan, STATSPACK, SQL TRACE, TKPROF, Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM)
• Cold Backup, Hot Backups, Logical Backups and RMAN Backups (Incremental Backups)
• Implemented SOX, auditing, TDE, SSL setup.
• Design and implementation of backup and recovery procedures
• Implemented Oracle Streams for the replication of data
• Capacity planning and benchmarking
• Rebuilding of Indexes, Partitioning of large table for better performance and management
• Installation, configuration and administration of Golden Gate
• Replication using Golden Gate, streams, Dataguard and DG broker
• Managing OLTP/Data Warehousing Databases
• Implemented Databases with FSFO
• Managed and trained the offshore TCS team on day to day basis

Environment: Oracle 12c/11g RAC/10g RAC/9i, Sun Solaris, Red Hat Linux, Confidential -UX, EMC, Windows, OEM(Grid Control), SQL, PL/SQL, RMAN, ASM,TKPROF, STATSPACK AWR, ADDM, SQL* Loader.

Confidential, Tucson, AZ

Oracle DBA

Responsibilities:

• Implementing and maintaining database security (create and maintain users, roles and assign privileges)
• Installation and configuration of multi node Oracle 11g RAC, 10g RAC, Standby databases (Active DataGuard) for high availability and disaster recovery purpose.
• Upgrading databases from Oracle 10g to Oracle 11g
• Cloned/Refreshed Oracle Databases for development and testing.
• Setup backup and recovery procedures using RMAN incremental backups
• Performed block recovery using RMAN. Performed backup validations using RMAN.
• UtilizedOracle Streams and GoldenGate for data replication and synchronization
• Configuration of GoldenGate
• Extract/Replicate with Golden gate for active-passive, live setup
• Setup, configured and maintained Oracle data guard, Oracle Golden gate ensure disaster recovery, high availability and data protection
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM
• Database monitoring using OEM/Grid Control
• Wrote shell scripts for backup automation, cloning, purging trace and log files
• Supported 6 applications at the same time and coordinated with application team for any changes
• Wrote SQL, PL/SQL programs (Functions, Procedures, Packages and Triggers)
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Defining and Implementation of backup and recovery strategies
• Supported Data Modeling, Database Design using ERWIN
• Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O.

Environment: s: Oracle Server 11g RAC, 10g RAC, 9i, RedHat Linux, IBM AIX, Sun Solaris, Windows, RMAN, ASM, SQL*Loader, DataPump, OEM/GridControl, TOAD, ERWIN, Active DataGuard, GoldenGate, SQL, PL/SQL

Confidential, Peoria, IL

Oracle DBA

Responsibilities:

• Working closely with Database Administrators, Database Team, Applications Team, IT Architect and other DBA’s to monitor and troubleshoot the production issues and facilitate business improvements. Consulted with and advised senior management and multiple clients on high impact data or database management issues, influencing strategic direction.
• Work simultaneously with other departments, BMC team and/or outside contractors to resolve system production problems. Also involved in working with Storage Architects and relevant team.
• Perform other duties as assigned.
• Assisted in Database backups, restores and configurations to support testing exercises.
• Involved in writing many Unix and SQL scripts and processes to quickly resolve issues in any Oracle database instance.
• Assisting development groups with database administration in non-production environments
• Responsible in providing Level 2 and Level 3 support of 300+ Production Oracle databases (most of them are RAC and Data-Guard environments) with on-call production support on rotation basis in 24/7environment.
• User management, Space Management, Undo Management, Database Monitoring, Listener monitoring, Backup (RMAN) Management, Blocking session, database tuning, SQL tuning
• Collection of Statspack (11g) and AWR (11g) report
• Part of the planning, analysis, design, implementation, maintenance, and control of the organization's server-class databases.
• Provide customer production and developer support.
• Support medium scale production database applications on multiple operating systems.
• Writing Shell Scripts on various UNIX, AIX, Confidential -UX and Linux Servers for automation of day to day database jobs like Start up - Shutdown, Export Backups as per necessary.
• Troubleshooting oracle errors and providing support to customers and developers.
• Apply patches for oracle databases; Management of Physical Standby database using oracle Data Guard.
• Recovery of production databases at the crisis situation in time.
• Administration of Backup and Recovery using RMAN.
• Management of backup pieces and backup sets using RMAN.
• Management of User Policies, Roles and Profiles for production Databases.
• Alert log monitoring of Oracle Database.
• Managing Users: creating users, synonyms, privileges, roles, quotas
• Managing table spaces, objects, profiles, storage parameters.
• Work on BMC remedy and incident tickets and update / resolve the tickets within the SLA.

Environment: s: Oracle (11g), Rac,Data Guard, ASM, BMC, SLA, Grid Control, Aix, Confidential -UX, Linux and Window 2008 Servers, Putty, Autosys, Golden Gate, Winscp, Toad, Grid Control, TSM, RMAN, Oracle Support.

Confidential

IT Database Administrator

Responsibilities:

• Served as an offshore DBA in the completion of a large-scale implementation, managing it from business requirements analysis stage to solutions delivery support.
• Involved in complete data center migration of the production database.
• Involved in administration activities migrating the Informatica repository from development to testing and production environment.
• Resolved issues by analyzing alert log, trace files, listener log and other database job logs.
• Modified data objects (like Tablespaces), data files and monitored database usage and growth.
• Performed database cloning, backup(full/incremental) and PITR(point-in-time-recovery) using RMAN.
• Configured flashback recovery area, performed logical backup(using utilities exp/imp, expdp/impdp).
• Applied patches complying to oracle standards, resolved user’s day to day issues.
• Installation, configuration and administration of Oracle 10g/9i databases.
• Installation of Oracle Database and Oracle products.
• Implementing Backup/Recovery Strategies.
• Writing scripts for backup and recovery.
• Upgraded databases from 9i to 10g.
• Performance monitoring and tuning using Explain Plan, SQL TRACE, TKPROF, AWR, ADDM
• Creating users and granting privileges.
• Worked with application developers to debug PL/SQL procedure, tune queries and database sizing.
• Designing and enforcing standards and naming conventions.
• Writing UNIX shell scripts for backup and recovery.
• Writing SQL scripts to monitor database performance.
• Writing SQL Loader control files for data loading
• Problem trouble shooting and resolution.
• Database tuning, backup and recovery and general day to day database administration tasks.

Environment: s: Oracle Server 10g RAC, 9i, 8i, RedHat Linux, Sun Solaris, Windows, RMAN, ASM, SQL*Loader, DataPump, OEM/GridControl, TOAD, SQL, PL/SQL