SUMMARY

• 7+ years of experience as an Oracle DBA. Expertise in database administration, production support, installation, upgrades, patches, performance tuning, backup and recovery, UNIX shell scripting and advanced features including Oracle ASM 11g/10g and Oracle RAC 11g/10g.
• Experience with working on UNIX, Linux, HP UX, AIX, Sun Solaris and Windows environments.
• Installation and configuration of Oracle 11g/10g/ 9i in UNIX/LINUX and Windows environment.
• Involved in administrating multiple 24/7 Production Oracle 11g/10g/9i databases as well as Development/Test databases.
• Experience in Upgrades from Oracle 10g to Oracle 11g and Migrations of oracle database from Window platform to Linux on development, integration and production environment.
• Designed and implemented backup and recovery strategies. Extensively used conventional and RMAN for backup and recovery. Logical backup using and full/ partial export/import, sqlldr and Data Pump.
• Experience in Patch set Upgrades, one - off patches using OPATCH utility.
• Efficient in SQL query optimization and instance tuning using, TKPROF, SQL Trace, Explain Plan, AWR reports and strong understanding of Oracle optimizer and statistics.
• Experience in maintaining and monitoring databases by Oracle Enterprise Manager (OEM).
• Oracle Database capacity planning, space management and storage allocation.
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• Expertise in loading data from flat files using external tables, SQL*LOADER.
• Experience in tools such as TOAD, SQL*Navigator, SQL Loader etc.
• Designed, Implemented and Administered SQL Server databases, also implemented security, schema management, Back-up, restore, Scheduling and Maintenance task.
• Knowledge of INFORMATICA
• Experience in Writing Perl Scripting, Shell Scripting.
• Strong analytical and problem solving skills with ability to work within team environment and independently when needed.

TECHNICAL SKILLS

Languages: PL/SQL, SQL, SQL*PLUS, C, Java, Shell Scripting

Database: Oracle Exadata, Oracle 12c, 11g RAC/10g RAC/9i/8.x, MS Access

Operating System: UNIX, Solaris, AIX, HP-Unix, Linux, Windows 2005/2003/XP/2000/NT

Tools: GoldenGate, SQL*PLUS, SQL Developer, TOAD, Sql Navigator, PUTTY, OEM, RMAN, SQL* LOADER, Imp/Exp and Data pump, Aqua Data Studio 4.7, Humming Bird Connectivity, Cygwin - XOther Technologies ODBC, Crystal Reports, MS Office, SFDM, Erwin 4.0/4.2/7.6, Relational Database Design.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• Provided 24x7 support for Production, Development, and test databases.
• Production database administration, support
• Worked on Auditing of the databases and be part of developing an application for internal Auditing at Enterprise level. Involved right from designing to production.
• Created different process documents for day to day DBA activities and make sure Databases are Audit compliance.
• Created databases on Oracle Database Appliances.
• Consolidated several databases into ExaData.
• Installation, Configuration and Administration of Oracle 12, 11g RAC
• Implementation of High Availability solutions with Oracle 11g RAC Standby Database, Replication.
• Installation, Configuration and Administration of GoldenGate
• Data replication using GoldenGate.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Migration of 10g databases/clients to 11g.
• Migrated NON ASM databases to ASM databases.
• Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Upgrade and Migration of Database’s from 10.2.0.5 to 11.2.0.4 and applying patches whenever required.
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export)
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Logical, Physical Database Design.
• SQL, PL/SQL Development. Writing PL/SQL functions procedures, packages and triggers.
• Developing scripts for automation using shell scripts.
• Worked on Instance Tuning, Memory Tuning and SQL Tuning.
• Good exposure to oracle technologies like AWR, ASM, Flashback and data pump import/export
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
• Written Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Partitioning of large tables for better performance and manageability..
• Involved in migrating databases from Windows to Linux, HP-UX to IBM AIX.
• Capacity Planning and Benchmarking
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, ADDM.
• Applying Quarterly patches and Version change patch bundles.
• Created users, roles and granted privileges according to the business requirements.
• OEM 12c installation, upgrade, patching.
• Extensive knowledge of Oracle OEM 12c Architecture, Framework, and Infrastructure.
• Works with management, peers and vendors to design and implement hardware/software configurations, logical models, operational management models and business continuity plans for systems under management.
• Provided support for Production, Development, and test database.

Environment: Oracle 9i,10g,11g RAC, 12c, Exadata, SQL,PL/SQL, SQL*PLUS, EXPDP/IMPDP, OEM, RMAN, HP-UX, IBM-AIX, Sun Solaris, RedHat Linux, Windows, Data guard, Sun clusters, Oracle Database Applliance, Quest Performance Analyzer, Patrol.

Confidential, Houston, TX

Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support for both OLTP and OLAP(EDWD) databases.
• Installation, Configuration and Administration of Oracle 11g RAC and Oracle 10g RAC.
• Implementation of High Availability solutions with Oracle 11g RAC, 10g RAC, Standby Database (Active Data Guard), Replication.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Migration of all Oracle 9i/10g databases/clients to 11g.
• Migrated NON ASM databases to ASM databases.
• Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Upgrade and Migration of Database’s from 10.2.0.5 to 11.2.0.2 and applying patches whenever required.
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export)
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Worked on Instance Tuning, Memory Tuning and SQL Tuning.
• Written Shell scripts to Monitor activities like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding.
• Good exposure to oracle technologies like AWR, ASM, Flashback and data pump import/export
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
• Written Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Partitioning of large tables for better performance and manageability..
• Involved in migrating databases from Windows to Linux, HP-UX to IBM AIX.
• Logical & Physical Database Design
• Capacity Planning and Benchmarking
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, ADDM.
• Applying Quarterly patches and Version change patch bundles.
• Created users, roles and granted privileges according to the business requirements.
• Works with management, peers and vendors to design and implement hardware/software configurations, logical models, operational management models and business continuity plans for systems under management
• Worked with Application Teams to resolve issues in data warehouse databases.

Environment: Oracle 9i/10g RAC/11g RAC, SQL,PL/SQL, SQL*PLUS, EXPDP/IMPDP, OEM, RMAN, HP-UX, IBM-AIX, Sun Solaris, RedHat Linux, Windows, Data guard, ERWIN

Confidential, Moline, IL

Oracle DBA

Responsibilities:

• Provided 24x7 support for Production, Development, and test databases.
• Implemented and configured 10g RAC and 11g RAC.
• Migrated NON ASM databases to ASM databases.
• Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Created Streams environment in unidirectional and table level for replication of data. configured and used Oracle FlashBack for minor recovery of objects in the database.
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
• Implemented Oracle Backup and recovery procedures using RMAN & Import/Export.
• Configured RMAN backups for TSM and Commvault and also resolved backup issues.
• Restoring Database’s from Backups on testing environments.
• Effectively uses database replication, security and availability solutions.
• Upgrade and Migration of Database’s from 10.2.0.5 to 11.2.0.2 and applying patches whenever required.
• Applying Quarterly patches and CPU,PSU,One-Off Patches to upadate Oracle version and to fix the bugs using Opatch utility.
• Effectively uses platform-specific, as well as enterprise, monitoring tools to provide fault and pre-fault performance notifications.
• Provides platform-specific performance tuning, installation and configuration.
• Monitors and manages back-up and recovery as well as capacity planning for all Database platforms
• Works with management, peers and vendors to design and implement hardware/software configurations, logical models, operational management models and business continuity plans for systems under management.
• Works with management, peers and vendors to provide ongoing monitoring, performance tuning, implementation and fault root cause analysis.
• Creates design, troubleshooting and operational documentation for all systems under management.
• Authors and peer-reviews knowledgebase articles documenting fault root causes and their respective resolutions.
• Provides and receives cross-discipline training in order to ensure maximum availability of systems under management.
• Carries and responds to off-hours communications device in order to provide 24x7 support to OLTP and OLAP (data warehouse Databases)
• Actively pursues opportunities, as an individual and as part of a group, to improve knowledge, tools and processes.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE,TKPROF, ASH, AWR, ADDM
• Worked on Instance Tuning, Memory Tuning and SQL Tuning.
• Performed database Point in Time Recovery and Table Space Point in Time Recovery using Transportable TableSpaces.

Environment: Oracle 10g/11g, SQL,PL/SQL, SQL*PLUS, EXPDP/IMPDP, OEM, RMAN, Cygwin - X, Linux, Windows, Data guard, Toad 10.1, Aqua Data Studio 4.7, SQL Server Management Studio.

Confidential, Dallas TX

Oracle DBA

Responsibilities:

• Provided 24x7 support for Production, Development, and test databases.
• Successfully Maintained RAC environments of 3Nodes with ASM file system using cluster ware.
• Involved in Design and implementation of oracle 10g Data Guard both physical/logical standby databases for high availability and disaster recovery.
• Implemented Oracle streams for replication and configured tablespaces for streams administration at database and table level.
• Configuring and using Oracle Log miner and Oracle Flash Back for recovery of the objects.
• Upgrade and Migration of Database’s from 10.2.0.4 to 11.1.0.6 and applying patches whenever required.
• Installed and controlled Grid Control to monitor RAC and Non RAC instances patched and upgraded the grid control
• Monitored Production Database Using O.E.M and Toad DBA Monitor tools.
• Recovering the database from any kind of crash with the minimum data loss.
• Database Recovery (both complete and incomplete) from different types of failure.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Responsible for maintaining Every Day Backups and also to maintain ASM and Disk Space.
• Performed Database Point in Time Recovery and Table Space Point in Time Recovery with the use of Transportable Table space.
• Applying patches quarterly (PSU,CPU,ONE-OFF) for security and to fix the bugs.
• Responsible for supporting the Oracle databases and ensuring their Performance, Availability and Security.
• Planning the size of the Database, Creation of Database and location of initial data files, redo log files and multiplexing them, editing database initialization parameter file whenever required.
• Implementation and release of Database changes as submitted by the development team.
• Create Production Support databases for testing every Week for developers using Data pump Impdp from Production Backups.
• Maintaining all database objects including Schemas, Tables, Indexes, Triggers, Sequences, Primary and Foreign keys, Views, and all Constraints.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, ADDM, AWR, EXPLAINPLAN, SQLTRACE and TKPROF.
• Maintaining Erwin for all the new database changes Implemented during each release.
• Responsible for the Database Builds on Test, Development databases and Monitor Production database during builds.
• Worked with cross-functional team of marketing team, engineers, and production planners to understand business process and develop functional specifications.
• Written Shell scripts to Monitor activates like availability of Database & Listeners, Space utilization, Gathering statistic for the cost base optimizer, Index rebuilding .
• Good exposure to oracle technologies like AWR, ASM, Flashback and Data Pump Import/Export.
• Worked on External tables for Loading Flat files into Database and also created flat files of existing tables for loading into different environment.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL*PLUS, EXPDP/IMPDP, OEM, Toad 9.0, RMAN, DBCA, ErwinLinux, Windows.

Confidential, Baton Rouge, LA

Oracle DBA

Responsibilities:

• Provided 24x7 support for Production, Development, and test database.
• Migration of all Oracle 9i databases/clients to 10g.
• Applying Quarterly patches and Version change patch bundles.
• Implemented backup and recovery procedures using RMAN & Import/Export.
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE,TKPROF, AWR, ADDM.
• Installation and supporting RAC.
• Worked on Instance Tuning, Memory Tuning and SQL Tuning.
• Written Shell scripts to Monitor activities like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding.
• Good exposure to oracle technologies like AWR, ASM, Flashback and data pump import/export
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
• Written Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Building and Configuring RMAN with Netback up, Legato Backup & HP Data Protector.
• Successfully providing 24x7 support for production, development, and test database.
• As part of a pilot project to transfer the database administrative activity to overseas, I have documented and coordinated with the people overseas
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, ADDM.
• Created users, roles and granted privileges according to the business requirements.

Environment: Oracle 9i/10g, OEM Grid Control, RMAN, RAC, Imp/Exp, Data Guard, SQL, PL/SQL, SQL*PLUS, Perl, Shell Scripting, HP-UX PA RISC.