SUMMARY

• Over seven years of experience as an Oracle Database Administrator having hands on experience in database administration, installation, configuration, upgrades, performance tuning, backup and recovery, space management, database security.
• Significant experience working with teams responsible for Oracle Database Administration (DBA) in large enterprise environments.
• Consistently performed core day to day Oracle DBA tasks.
• Significant experience design, implementation, maintenance onOracle11g RAC under Linux environment.
• Significant experience leading teams responsible forOracledatabase production support, applications and data modeling.
• Demonstrated strong partnership with other Service Delivery teams in the successful execution of standard processes (incident management, problem management, release management, change management, etc.)
• Experience includes leading globally distributed teams to manage multiple concurrent product releases, while effectively resolving conflicting priorities.
• Significant hands - on experience withoracleinstallations and version upgrades Experienced in using 11g features Data pump; Flash-Back Recovery, AWR, ASM, ADDM, Grid monitoring, and Recycle Bin.
• DeliveringOracleDatabase performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, 11gOEM Grid Monitoring.
• Experience inOracle10g/11g RAC,OracleASM,OracleData Guard, andOracleRMAN.
• Optimal configuration of SGA and PGA.
• Expertise in monitoring, performance tuning and troubleshooting.
• Expertise in Security administration, roles, profiles.
• Gathered database/Objects statistics using DBMS UTILITY, DBMS STATS packages and ANALYZE command.
• Scheduling and Troubleshooting Database performance issues using Statspack, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Checking for Alert log file for errors and monitoring the Hit ratios.
• Management of schemas, objects, tables & indexes partitioning.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Senior Oracle DBA & SQL Server

Responsibilities:

• Performed database and system administration for a corporate network supporting over 250+employees. Managed servers in an active directory environment, ensuring that each server has 100%uptime. Provide troubleshooting assistance with networks and web services.
• Installed, configured Oracle ASM, RAC instances, Data Guard and Stand-alone instance
• Migrating and upgrading the databases to higher versions.
• Enhanced Oracle RMAN scripts for nightly backup.
• Setup the materialize views for replication.
• Provided assistance to Customers In Solving ORA- errors
• Provided assistance to Memory Corruption and Dictionary Corruption Errors.
• Provided consultative services to implement the Memory configuration for Database Instance and ASM instances.
• Automated SQL Jobs for nightly backup and reporting
• Created database procedures, scripted, database alerts and monitored scripts.
• Managed multiples database environments from Oracle 10g - SQL Server 2008R2 -SQL 2012.
• Installed and configured SQL Server cluster within VMware environment
• Involved in all phases of database development, from assessment to QA/QC and support
• Installed, configured Oracle ASM, RAC instances, Data Guard and Stand-alone instance.
• Installed, configured and upgraded Oracle, SQL Server software, etc. and related products
• Developed documentation and maintaining dba procedures
• Supported Land Mark users within Oracle Database environment
• Handled database server tuning, capacity planning, physical database design and implementation of database Security
• Installed and configured ESRI SDE for Petrel, Openwork's and OFM
• Developed automated process of loading Daily Production Report within OFM
• Successfully migrated Landmark databases environment to RAC One Cluster
• Designed, Implemented and document DR Solutions
• Successfully configured, implemented databases within VMware environment.

Environment: s: Sun Solaris 9.0, Linux 5.0, Windows 2003, Dataguard, ASM, Oracle 10g, 11g, SQL*Plus, Grid Control, TOAD, SQL server 2000, 2005, 2008, 2012

Confidential, San Ramon, CA

Oracle DBA

Responsibilities:

• Installed, configured Oracle ASM, RAC instances, Data Guard and Stand-alone instance
• Experience Migrating and upgrading the databases to higher versions.
• Enhanced Oracle RMAN scripts for nightly backup.
• Setup the materialize views for replication.
• Provided assistance to Customers In Solving ORA- errors
• Manage users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
• Tuning the Databases for optimization using STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size.
• Installed Oracle Client s/w on Client machines.
• Experience in providing technical expertise to design efficient and cost effective solutions for Oracle database systems.
• Experience in SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, AWR, Statspack, Explain Plans and monitor the database performance on daily basis.
• Having stored outlines before and after Database tuning to stabilize and optimize the database by changing the parameters
• Expertise in Capacity planning, sizing and designing of databases for both ASM and Non ASM file systems.
• Setup backup and recovery procedures using RMAN.
• Have done database backup and recovery using (Cold backup/ Hot backup/ Logical).
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Providing production support 24/7 for Database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Worked Tuning the Databases for optimization using STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size.

Environment: s: Oracle Solaris 11,10, Oracle Linux, Windows 2003, SOA, Oracle 10g and 11g, TOAD 9.5, Oracle Enterprise Manager 11G.

Confidential, Pittsburg, PA

Oracle Database Administrator

Responsibilities:

• Part of the migrating team responsible for up gradation from Oracle 9i to Oracle 10g.
• Performed day-to-day DBA jobs for managing Production/Development databases.
• Installed, configured Oracle ASM, RAC instances, Data Guard and Stand-alone instance
• Migrating and upgrading the databases to higher versions.
• Worked on Opatch and Oracle upgrades.
• Responsible for installing, upgrading and configuring the Oracle server.
• Worked in release management involving database components.
• Oracle security and familiar with database vault.
• Manage users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
• Tuning the Databases for optimization using STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size.
• Automation of job scheduling by crontab.
• Database Tuning - Tuning Applications, Memory Tuning and Tuning Disk Usage.
• Setup backup and recovery procedures using RMAN.
• Have done database backup and recovery using (Cold backup/ Hot backup/ Logical).
• Created and managed database objects such as tables, indexes, partition tables and views.
• Expert in upgrade and configuration of MS SQL Server and databases in clustered and non-clustered environments.
• Installed Service Packs in SQL in standalone and clustered environment.
• Established and maintained disaster recovery, backups, restore, attach, and detach migrations across SQL servers.

Environment: s: Sun Solaris 9.0, Linux 5.0, Windows 2003, Dataguard, ASM, Oracle SQL*Plus, Grid Control, TOAD, SQL server 2000, 2005, 2008

Confidential, New York, NY

Oracle & SQL Server DBA

Responsibilities:

• Installed Oracle 11gR2 RAC with 2 Nodes on (RHEL- 5.0,64-bit Processor) with New SAN Storage
• Performed Migration of the databases from file system to Automatic Storage Management (ASM) for managing huge data in SAN.
• Experience ensuring the high availability, Performance and integrity of databases.
• Configured physical Standby databases with Dataguard and managed Dataguard using data guard broker (DGMGRL).
• Installed Oracle 10G and 11G, Grid control Agents on Linux, Sun Solaris and Windows servers.
• Have worked as Data modular building complex logical data models using sophisticated modeling techniques and tools like TOAD, Erwin, Visio and KeepTool.
• Responsible for Data Modeling and converting Domain model to Data model- logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database implementation, high performance, streams, failover and Disaster Recovery.
• Setup backup and recovery procedures using RMAN.
• Have done database backup and recovery using (Cold backup/ Hot backup/ Logical).
• Created and managed database objects such as tables, indexes, partition tables and views.
• Created and managed users, roles, privileges, profiles, schemas using OEM.
• Manage data architects, data administrators and client enhancement requests.
• Handling large database environments (Data warehouse) using ETL tool and Oracle Enterprise Manager (OEM), Grid Control on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, AWR, Statspack, Explain Plans and monitor the database performance on daily basis. Having stored outlines before and after Database tuning to stabilize and optimize the database by changing the parameters.
• Strong ability with UNIX shell scripting to automate tasks and also in Crontab and dbms scheduler for scheduling jobs.
• Extensively worked on Database administration activities like Installation, Configuration, Backup & Recovery and Database Security.
• Expert in upgrade and configuration of MS SQL Server and databases in clustered and non-clustered environments.
• Installed Service Packs in SQL in standalone and clustered environment.
• Experience working with Windows 2003 Server - Administration and Installation.
• Monitoring alerts through SCOM and MOM.
• Good in Implementing SQL Server change control process.
• Established and maintained disaster recovery, backups, restore, attach, and detach migrations across SQL servers.
• Database and log backups & restoration, backup strategies, scheduling backups.
• Created Database Security by giving proper permissions to users and Admins.

Environment: s: Sun Solaris 9.0, Linux 5.0, Windows 2003, Dataguard, ASM, Oracle SQL*Plus, Grid Control, TOAD, SQL server 2000, 2005, 2008

Confidential, Chicago, IL

Oracle and SQL DBA

Responsibilities:

• Supporting Oracle Customers running various versions of Oracle database (9i, 10g)
• Worked on various performances related issues.
• Worked with Storage team for ASM and other file system needs.
• Set up unidirectional Golden Gate for replication.
• Setup the materialize views for replication.
• Provided assistance to Customers In Solving ORA- errors
• Provided assistance to Memory Corruption and Dictionary Corruption Errors
• Provided consultative services to implement the Memory configuration for Database Instance.
• Provided assistance to Implement Huge pages /Large Pages in Unix platforms
• Assistance to High memory utilization issues in Unix and Windows Platforms
• Worked on many data refreshing tickets using Data Pump and RMAN Duplicated database.
• Worked with Oracle Development and Oracle Bug Diagnostics Escalation Team for solving the bugs hit by the customer
• Provided assistance to numerous customers in production Database Hung and non-responsive issues
• Has good understanding of analyzing the hang analyze and system state dumps
• Supported application and professional services to manage their data ranging from GB to TB in oracle database, solving of space problem, data loading problem.
• Providing all round DBA support to resolve Application and DB outages on production, development, test and staging Customer environments across the Globe.
• Involved in resolving issues after Installations, Upgrades, Cloning, patching (both DB and Applications), CPU patches, and one off patches.
• Setup the RMAN Backups for all the Production databases satisfying RTO and RPO. Leading in performing periodic DR Drill and testing RMAN backups with various scenarios..
• Evaluated Oracle Database Monitoring and PL/SQL tools.
• Helped on Demand engineers in the dry run for disaster recovery test for On Demand Customer instances.
• Investigate, diagnose, and quickly resolve issues in production and testing environments. Work closely with the customers to quickly resolve production problems.
• Monitored data files, logical data storage and data growth activities
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN.
• Perform capacity planning required to create and maintain database environments.

Environment: s: Linux 5.0, Windows 2005, Oracle 9i, 10g, SQL*Plus, Grid Control, TOAD, SQL server 2000, 2005, 2008, TOAD 9.5, Oracle Enterprise Manager, SQL server 2000, 2005, 2008

Confidential

Oracle DBA

Responsibilities:

• Performed database and system administration for a corporate network.
• Provide troubleshooting assistance with networks and web services.
• Migrating and upgrading the databases to higher versions.
• Part of the migrating team responsible for up gradation from Oracle 9i to Oracle 10g.
• Worked on Opatch and Oracle upgrades.
• Responsible for installing, upgrading and configuring the Oracle server.
• Worked in release management involving database components.
• Manage users, privileges, profiles, schemas using Oracle Enterprise Manager.
• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Set up Grid Control to monitor databases.
• Worked on import/export, export datapump/import datapump and SQL- loader.
• Backup/Restoration, scheduling Backups, taking Logical Backups
• Setup backup, recovery and testing backups and procedures using RMAN.
• Have done database backup and recovery using (Cold backup/ Hot backup/ Logical).
• Created and managed database objects such as tables, indexes, partition tables and views.
• Created and managed users, roles, privileges, profiles, schemas using OEM.
• Manage data architects, data administrators and client enhancement requests.
• Handling large database environments (Data warehouse) using ETL tool and Oracle Enterprise Manager (OEM).
• Good in Implementing SQL Server change control process.
• Established and maintained disaster recovery, backups, restore, attach, and detach migrations across SQL servers
• Database and log backups & restoration, backup strategies, scheduling backups.
• Created Database Security by giving proper permissions to users and Admins.

Environment: s: Linux 5.0, Windows 2003Oracle 8i, 9i, SQL*Plus, TOAD, SQL server 2000, 2005.