SUMMARY

• Over 15+ years of experience as an Oracle DBA. Experience in Data Modeling, Design, Development & Production Support. Experience in working with International teams and offshore, onshore model.
• Experience in managing large OLTP/OLAP and Data warehouse databases of size multiple TB (100.) Experience widely in performance tuning, Memory Tuning and Application Tuning.
• 24 X 7 Production database administration, support, monitoring, proactive problem recognition and resolution of database issues.
• Experience in configuration, implementation of oracle 10g/11g RAC with ASM disk on Linux servers
• Implemented Golden Gate.
• Oracle advanced Security to mask and secure sensitive Data - DB Vault.
• Experience in upgrading databases to Oracle 10g/11g
• Providing day to day support in extensive Golden gate enviornment (Target/Source- Both Sides.)
• Experience in Agile methodologies.
• In depth experience in Oracle database architecture, Oracle database development, Oracle database administration, database/SQL performance tuning, Data Warehouse
• Experience in Oracle E-Business Suite 11i & R12
• Experience in process improvement, Database Design, Database creation, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Standby Database (Data Guard), Replication, Real Application Clusters, Automatic Storage Management (ASM)
• Exposure to Exadata and Big data
• Experience in Multi Node RAC cluster design, administration and support.
• Experience in analyzing the Database Migration requirement and providing an efficient and workable solution. Worked with Project Managers to understand different client’s requirement and provide an efficient solution keeping in mind the methodology, duration and resources.
• Experience in analyzing and translating business requirements to technical requirements and architecture.
• Experience in VERITAS I/O on oracle database.
• Good knowledge about the technical aspects of telecom Industry and Insurance sector
• Experience in Oracle 9i, Oracle 10g, 11g software installation and configuration.
• Experience in upgrading databases to Oracle 10g/11g.
• Installation and Maintenance of Standby (Dataguard) database.
• Installation, Configuration and Administration of Oracle 10g RAC.
• Applied patches to Oracle Databases.
• Experience in NETBACKUP on oracle database and NETBACKUP for oracle advanced BLI.
• Cloned Oracle Databases for development and testing.
• Proficient in SQL, PL/SQL programming and performing SQL tuning and assist developers with coding PL/SQL. Expertise in AIX shell scripting.
• Experience in optimization and tuning SQL queries using SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR.
• Experience in design and implementation of Backup & Recovery procedures.
• Experience in using RMAN for backup and recovery. Experience in implementing Hot, Cold and Logical backup plans.
• Customization and development of Korn shell scripts.
• Experience in the management of schemas, de-fragmentation and partitioning the tables & indexes to improve the performance.
• Responsible for setting and managing user accounts, granting required privileges to users.
• A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges. Strong listening, interpersonal and analytical skills.
• Result oriented, self-motivated, Team player, ability to work independently.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x, Linux SuSE, and Windows 95/98/ME/NT/2000/XP.

RDBMS: Oracle 11g RAC/10g/9i MySQL, SQL Server 2000/2005

Languages: SQL, PL/SQL, UNIX, Perl Scripting, Shell Scripting, Delphi, C, C++

Tools: RMAN, OEM, SQL*Loader, SQL NET, EXP, IMP, expdp, impdp, TOAD,VB, ORADEBUG, RACDIAG, DBMS APIS, SRVCTL, CRSCTL, OCRDUMP, CDC, Data Modeling - Power Designer, Erwin, Golden Gate

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, Oracle Tuning Pack

Other: EMC, Confidential, Streams, Veritas NetBackup, TSM, HP Data Protector, Shareplex, Confidential filers, DataStage, Pentaho,Informatica

PROFESSIONAL EXPERIENCE

Confidential, CA

Lead Oracle DBA

Environment: Oracle 10g/11g, ASM, Hyperion, APEX, Toad, PL/SQL, SQL, SQL*Plus, OEM 10g/ 12c, 11g RAC, VPD, Linux, Pentaho, Ignite, Informatica, OBIEE, Cherwell, Dataguard

Responsibilities:

• Co-ordinator role - Ensuring Incident Management- tickets are below threshold and responding within the SLA.
• Responsible for stabilizing the enviornment and keep it healthy and up and running.
• Responsible for meeting the SLA’s, meeting with delivery team and understanding the project requirement and involved in OLA and documentation.
• Responsible for CR process within the team - ensuring every change is getting captured and been tracked via CR process.
• Responsible for handling escalation from cross functional team/project Managers, providing them required info when/if needed.
• Escalation point of contact for several source systems and articulating issues and triaging.
• Responsible for creating/publishing guidelines.
• Responsible for standard documentation.
• Responsible for support, monitoring, proactive problem recognition and resolution of database issues.
• POC exposure for BigData and Exadata.
• Undergone DB Maestro training
• Undergone EMC snap sync training
• Conducting sizing & capacity planning for Oracle databases.
• Implementation plan review and suggesting changes per standard/process
• Implement Database Partitioning strategies.
• Applied PSU patches, upgraded OPatch.
• Converted single database instances into oracle RAC for high availability.
• Converted 2 nodes RAC enviornment into 5 node RAC.
• Group Admin of OEM ( Oracle Enterprise Manager) for whole group.
• Performance diagnosis, CPU usage, Top,NMON, NETSAT, iostat, SAR
• Using ignite other than OEM for extensive performance diagonis and metrics
• Applied security patches, proactive monitoring of databases and applications.
• Discovering Databases in OEM and configuring them and listeners.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Monitor and tune Oracle database for optimum performance.
• Oracle Realms - Federal, HR - to secure sensitive data.
• Standardized gather stats process.
• Involved in informatica upgrade project and completed successfully.
• Worked as a fire fighter and resolved long time pending performance issues.
• Rebuilding the Materialized views and make sure that none of the materliazed view is in the stale mode.
• Monitoring database through OEM/Ignite.
• Database Vault - securtiy realms to protect and mask sensitive data.
• Customization and development of Unix shell scripts.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using Korn shell scripting.
• Responsible for setting and managing user accounts, granting required privileges to users.
• Perform other regular DBA activities including space management and performance monitoring.
• Responsible for deploying the code in the production and have been taking care of most of the releases.
• Limiting the user management and sensitive data access via - Oracle Advanced security tools - Oracle Database Vault - Data Masking.
• VPD configuration is in progress for row level encryption
• Effective troubleshooting of Performance tuning problems in Oracle database.
• Continuous monitoring of database performance during peak and non-peak loads using AWR.

Confidential, Sunnyvale, CA

Support Manager/ BA Lead Oracle DBA

Environment: Oracle 10g/11g, APEX, EBS 11i and R12,AIX 5.3, AIX 6.1, SQL Server 2012 Toad, PL/SQL, SQL, SQL*Plus, OEM 10g/ 12c, 11g RAC, Golden Gate, Linux, Pentaho, Datastage, OBIEE

Responsibilities:

• Support Manager role - Managing Datawarehouse Operations team of à 7 DBA’s, 8 ETL /Pentaho team members and 8 MDM team members.
• Responsible for meeting the SLA’s, meeting with delivery team and understanding the project requirement and involved in OLA and documentation.
• Responsible for incident management and routing problem tickets to the right group and providing directions.
• Responsible for handling escalation from product vendor (Oracle) and contacting them, providing them required info when/if needed.
• Escalation point of contact for several source systems and articulating issues and triaging.
• 24 X 7 on call support, production database administration, support, monitoring, proactive problem recognition and resolution of database issues.
• Applied Agile method to better adapt to the business requirements changes; quickly designed and coded/implemented the following applications with scrum teams
• Conducting sizing & capacity planning for Oracle databases.
• Installed GoldenGate ( Both Target and Source side) and providing support.
• Installed OEM 12c and configured targets in OEM.
• Implement Database Partitioning strategies.
• Applied PSU patches, upgraded OPatch.
• Maintain and supported MySQL5.5 databases.
• Group Admin of OEM ( Oracle Enterprise Manager) for whole group.
• Performance diagnosis, CPU usage, NMON, NETSAT, ISOSAT, SAR
• Using Axibase other than OEM for extensive performance diagonis and metrics
• Applied security patches, proactive monitoring of databases and applications.
• Discovering Databases in OEM and configuring them and listeners.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Monitor and tune Oracle database for optimum performance.
• Oracle Realms - Federal, HR - to secure sensitive data.
• Performance tuning in MySQL application instances.
• Responsible for optimizing the queries and application tuning.
• Made scripts to compare the init files and other health check reports.
• Rebuilding the Materialized views and make sure that none of the materliazed view is in the stale mode.
• Installed 4 node RAC on Linux. Configured cluster database in OEM.
• Implemented Oracle Golden Gate between SAP and eBI.
• Provide day to day support for GoldenGate (Target/Source - both ways)
• Monitoring database through OEM.
• Database Vault - securtiy realms to protect and mask sensitive data.
• Customization and development of Unix shell scripts.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using Korn shell scripting.
• Responsible for setting and managing user accounts, granting required privileges to users.
• Checking the snap mirror status at regular intervals.
• Managing SOX controls for the process.
• Perform other regular DBA activities including space management and performance monitoring.
• Responsible for deploying the code in the production and have been taking care of most of the releases.
• Limiting the user management and sensitive data access via - Oracle Advanced security tools - Oracle Database Vault - Data Masking.
• Effective troubleshooting of Performance tuning problems in Oracle database.
• Continuous monitoring of database performance during peak and non-peak loads using AWR. Infrastructure Strategies:
• Database upgrade from oracle 10g R2 to Oracle 11g R2 also from Oracle 11.2.0.2 to Oracle 11.2.0.3.
• Designed and Developed Flexplore database environment to off load PROD database for ADHOC reporting.
• Involved in implementing Database vault to secure sensitive data.
• Involved in implementing4 node RAC (11gR2) with Oracle Golden Gate for Real time Reporting data from SAP, ERP and EBI systems.
• Installed Oracle Golden Gate in 4 node RAC environment.
• Upgraded GoldenGate to 11.2.1.0.1.
• Implemented Confidential Snap Mirror strategies for various activities like DB backup, Cloning & Standby Database.
• Completed POC of implementing Oracle Timesten caching on Data warehouse reporting database.
• Implemented Oracle Result cache. Design Database storage Layout for all new implementations.
• Evaluating Oracle Patches, testing patches.
• Provide L3 support for Operational DBA Team.
• Develop POC on new technologies & work with other architect teams to implement solutions.
• Develop Documentation, best practices for Database technologies and providing necessary trainings to operational DBA’s on new technologies like RAC, Golden Gate, performance tuning & best practices.

Confidential, New Jersey

SR Oracle DBA

Environment: Oracle 9i, 10g/11g RAC, Sun Solaris 10, MySQL4.1, RHEL 4.x, Toad, PL/SQL, SQL, SQL*Plus, AIX, Streams, Linux, Windows XP

Responsibilities:

• 24 X 7 Production database administration, support, monitoring, proactive problem recognition and resolution of database issues.
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, 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.
• Utilized oracle streams to capture, propagate and apply the transfer of data, transactions and events within managed databases.
• Performed database cloning to setup test and development database.
• Installation and Maintenance of Stand by database.
• Experience in Disaster Recovery Drills, documented database and application validation steps
• Conducting sizing & capacity planning for Oracle databases.
• Upgrading production and development databases to Oracle 10g/11g.
• Maintain and supported databases MySQL 4.1.
• Experience in implementing Asynchronous oracle streams Change data capture
• Installation, Configuration and Administration of Oracle 10g RAC.
• Applied RDBMS patches, security patches, proactive monitoring of databases and applications.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Responsible for optimizing the queries and application tuning.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implemented Hot, Cold and Logical backup plans.
• Customization and development of Unix shell scripts.
• 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
• Perform other regular DBA activities including space management and performance monitoring.
• Effective troubleshooting of Performance tuning problems in Oracle database.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.

Confidential, Washington DC

Oracle DBA

Environment: Oracle 9i, 10g/11g RAC, Solaris 10, SQL Server 2008, RHEL 4.x, Toad, PL/SQL, SQL, SQL*Plus, AIX, Windows XP, HP-UX 10.0

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installation, Configuration and Administration of Oracle 10g RAC.
• Migration of oracle databases from windows to Linux and applying patches for Database using opatch.pl Perl script.
• Used Quest Shareplex for replicating databases.
• Involved in developer Environment Setup, Support, Cloning and Refreshes. Performed database cloning to setup test and development database
• Performed and implemented Hot, Cold and Logical backup plans.
• Involved in Installation, Configuration and Maintenance of 9i to10g as and when needed.
• Proactive database monitoring using Stats pack, Explain plan and AWR report.
• Upgrading development and production databases to Oracle 10g.
• Involved in applying patches to Oracle Databases and Oracle Applications.
• Cloned/Refreshed Oracle Databases for development and testing.
• Experience in implementing Asynchronous oracle streams Change data capture
• Responsible for optimizing the queries and application tuning.
• Conducting sizing & capacity planning for Oracle databases and management of schemas, objects partitioning the tables & indexes
• Perform SQL tuning and assist developers with coding.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Applied High priority, security patches downloaded from Metalink
• Conducted multiple “dry runs” (test runs) to gather timings for production upgrades.
• Monitored regularly whether primary and standby databases are in sync and clearing the backed up archive log files after confirming that they are applied on the standby database.
• Monitored the database objects growth, managing the extents growth and de-fragmenting the objects, which are running out of maximum extents. Monitoring the excessive fragmentation of table spaces and taking remedial steps.

Confidential

Oracle DBA

Environment: Oracle 9i, 10g RAC, Solaris 2.8,10, RHEL 4.x Toad, PL/SQL, SQL, SQL*Plus

Responsibilities:

• 24 X 7 on call - support for both production and development databases with on-call pager.
• Refresh/Cloning of Database and applications for development, testing.
• Installation, Configuration and Administration of Oracle 10g RAC.
• Performance Tuning for optimized results using tools like Explain Plan, SQL*Trace,
• TKPROF and STATSPACK
• Involved in taking periodic Backup of the Database and the software using RMAN and VERITAS Net backup
• Set up of Standby database for faster disaster recovery and Data guard setup for high availability.
• Implemented Oracle Data ware house tool CDC (Change Data Capture).
• Involved in implementing oracle retail management.
• Logical, physical data modeling, implementation and database administration.
• Worked with team in successful installation of 10g RAC on 2 nodes.
• Performed SQL tuning and assist developers with coding PL/SQL.
• Creating and Managing Table spaces with different block-sizes to prevent row chaining.
• Migration of Database and applying patches whenever required
• Installed, Configured, Upgraded & Applied patches for Prod & Dev Servers.
• Installed and Implemented Backup & Recovery procedures.
• Designing appropriate Backup / Recovery Policies for databases.
• Creating table spaces, tables, and users for custom applications.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required
• Capacity Planning & Benchmarking using analysis from STATSPACK reports
• Developed shell scripts to automate the processes and to proactively monitor the database.
• Resolve various application failures due to data entry errors or system errors.
• Involved in identifying problems and implementing corrective actions.

Confidential

Oracle DBA

Environment: PL/SQL, SQL, SQL*Plus, SQL Server 2005, Oracle 9i, Oracle 10g, HP UNIX, AIX, Linux (RHEL), Windows XP

Responsibilities:

• 24 X 7 Production Oracle database support and administration
• Involved in Database migration from Oracle9i to Oracle 10g.
• Backup and Recovery using RMAN with external tape backup system.
• Created Recovery Catalog to store multiple database backups.
• Detect corrupted blocks by using DBVERIFY utility.
• Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF etc…
• Partitioning tables by determining the suitable methodology to improve performance and manageability
• Installation of Oracle RDBMS on HP and Solaris boxes
• Day to day operations of various databases at the client sites
• Oracle SGA tuning, change initialization parameters for Function based indexes
• SQL Tuning using Explain Plan
• Work with Unix Administrator to allocate disk space, create volume groups and mount points for database
• Creating users, manage security roles and privileges
• Hot backups, Export/Import, RMAN
• Use glance on HP to check system performance
• Metalink support research
• Use of Logminer utility.
• Daily refresh of Finacle Database & Management.
• Involved in RAC administration including 10g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Cloned/Refreshed Database environments to create patch, test, development and QA environments.
• Other activities like applying RDBMS patches, security patches, proactive monitoring of databases and applications.
• Cloned environments to create patch test, development and QA environments.
• Created scripts to monitor and manage the databases.
• Recreated backup plans and scripts.
• Performed hot, cold, tablespace level backups.
• Applied High priority, security patches downloaded from Metalink
• Conducted multiple test runs to gather timings for production upgrades
• Implemented database Auditing, data security and Remediate high-risk violation in production environment.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Other activities like applying RDBMS patches, security patches, proactive monitoring of databases.

Confidential

Oracle DBA

Environment: PL/SQL, SQL, SQL*Plus, Oracle 9i, Oracle 10g, HP UNIX, AIX, Linux (RHEL), Windows XP

Responsibilities:

• Oracle Patch management on production servers.
• Installation, configuration and maintenance of 10g,9i, 8i production databases on HP-UX
• Designing, Planning and configuring production databases for High Availability (24*7)
• Designing Backup and Recovery strategy for production databases.
• Performance and Tuning of production databases
• Performance and Tuning of applications.
• Installation of Oracle 10g/9i/8i
• Creating of database according to specification required by the application
• Administration and Monitoring of all databases.
• Preparing the database for billing on specific dates.
• Creating Tablespaces, tables, mapping views etc during bill cycles and end of month.
• Space management.
• Analyzing tables and indexes.
• Rebuilding indexes.
• Backup of databases.
• Tuning of database using STATSPACK, SQL TRACE files, TKPROF utilities.
• Troubleshoot the problems related to databases.
• Maintenance of standby database.

Confidential

Jr Oracle DBA

Environment: PL/SQL, SQL, SQL*Plus, Oracle 8.0, 9i, HP UNIX, Linux (RHEL)

Responsibilities:

• 24 X 7 Oracle database support and administration
• Involved in Database migration
• Backup and Recovery.
• Created Recovery Catalog to store multiple database backups.
• Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF etc…
• Partitioning tables by determining the suitable methodology to improve performance and manageability
• Day to day operations of various databases at the client sites
• Oracle SGA tuning, change initialization parameters for Function based indexes
• SQL Tuning using Explain Plan
• Work with Unix Administrator to allocate disk space, create volume groups and mount points for database
• Creating users, manage security roles and privileges
• Hot backups, Export/Import
• Metalink support research
• Cloned/Refreshed Database environments to create patch, test, development and QA environments.
• Other activities like applying RDBMS patches, security patches, proactive monitoring of databases and applications.
• Created scripts to monitor and manage the databases.
• Recreated backup plans and scripts.
• Performed hot, cold, tablespace level backups.
• Applied High priority, security patches downloaded from Metalink
• Conducted multiple test runs to gather timings for production upgrades
• Implemented database Auditing.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Other activities like applying RDBMS patches, security patches, proactive monitoring of databases.