SUMMARY

• 8 years of working experience in database administration, design, development, performance tuning, and high availability solutions, worked with variety of Red Hat Linux, AIX and Windows platforms with Oracle (12c/11g/10g/9i/8i). Highly competent in Administration, Monitoring and specialized in Advanced DBA skills such as Performance Tuning, Database Backup and Recovery, Data analysis, testing development, installation, and migration.
• Installed, configured Oracle Enterprise Manager 10g, 11g Grid Control and 12c Cloud control to monitor Oracle databases on multiple platforms.
• Experience with Exadata database support, patching, tuning and performance.
• Experience with RMAN, Oracle Enterprise Manager (OEM), OEM Grid control, Data warehousing, Oracle Data guard.
• Planning, designing, and supporting RAC/ASM environment. Experience in working with RAC databases.
• Extensive DBA experience in supporting multiple instances of Oracle database including Development, Reporting, Data Warehousing, User acceptance testing & Production.
• Experience in using data pump import/export utility of Oracle.
• Experience in deploying, managing and developing MongoDB clusters.
• Installing & configuring Oracle cluster ware & Database Software.
• Experienced in working with tools like TOAD.
• Experience in database migration by designing and implementing database logical and physical storage structures.
• Expertise in Database Space Management, Memory Tuning and Application Tuning.
• Configured Data guard to provide high availability by implementing Physical stand by database.
• Experience in analyzing database & rebuilding indexes to improve database performance.
• Applying oracle patches (CPU, PSU and ONE - OFF), upgrade and migration of databases using the OPatch utility and fixing bugs.
• Designed and developed Supplier Site and Supplier Contact Conversions to migrate Supplier data to Oracle R12 EBS system.
• Installed and configured Oracle Grid control and deployed agent on managed targets.
• Designed and implemented centralized backups and recovery strategies using recovery manager RMAN. Involved in hot/Cold Backup and Cloning of databases using RMAN.
• Worked with several Multi node and multi-tier environments.
• Extensively used NZSQL & NZLOAD utilities to load the data into Netezza databases.
• Worked as on-call support team member for administering OLTP 24X7 production databases.
• Worked in various environments like Linux, HP-UX, Sun Solaris, and Windows.
• Worked with Oracle EBS, contributed in design and development of the Implementation of Oracle R12 Procure to Pay, from end to end.
• Proficiency with Installation and maintenance of replication tool GoldenGate by creating extract process, extract pump, and replicate.
• Experience in using GoldenGate in moving large volumes of transactional data, with minimal impact to online systems.
• Worked with Oracle Middleware Products includes WebLogic Server and experienced in the Oracle PL/SQL programming language.
• Experience with Oracle Streams to replicate or migrate data from one system to another and Oracle EBS administration.
• Experience in writing PL/SQL Stored Procedures, Functions Packages and Triggers, UNIX Shell Scripting and Perl scripting.
• Excellent experience in writing SQL queries.
• Worked with Oracle Ebusiness Suite patching and cloning.
• Expertise in working with the tools like SQL Analyzer and managed system events by using OEM.
• Experience in conversion of Single Node Instance to Multi node RAC with ASM, and adding instance to existing RAC.
• Experienced in upgrades, migration, configuring logical/physical architecture, SQL, Tuning, database access, Security and auditing.
• Technical Support for Oracle, including management of databases, concurrent managers, listeners.
• And I had managed skills in all aspects of the physical database including schemas, DDL, users, security in development, UAT and production environments.
• Excellent interpersonal and problem-solving skills together joined with strong customer service attitude.
• Excellent analytical, communication skills, work ethics and ability to work in a team environment with strong determination and commitment to the deliverables.

TECHNICAL SKILLS

Operating Systems: Oracle Linux, Red Hat Linux, Solaris 8/9/10, HP-UX, AIX 5.2/5.3/6.1/7.1 , Windows NT/2000/2003/XP/2008/vista/7

Databases: RDBMS Oracle 8i/9i/10g/11g/12c, SQL SERVER 2005 and 2008, MySQL, MongoDB.

Languages: SQL and PL/SQL programming for oracle, C, C++, UNIX/NT Shell Scripting, PERL Scripting.

Tools: and Utilities: Recovery Manager RMAN, OEM, EBS, TOAD, SQL*Loader, Export/Import, Data pump, Query builder, Net Backup, SQL Tuning Advisor, SQL Performance Analyzer, Data Guard, Cloning, Migrations, GoldenGate, Database Configuration, Database Upgrade, ASM, AWR, Oracle Enterprise Manager(OEM)

Tuning Tools and Monitoring: TKPROF, EXPLAIN PLAN, SQLTXPLAIN, STATSPACK, ADDM, AWR, and ASH, AUTO Trace. Oracle Cloud Control 12c, Grid Control 11g, BMC Patrol, Diagnostic Tool.

Other Tools: SQL Loader, MS Office, MS Project, XML/BI Publisher, Workflow Builder, Oracle Streams and VM box, Exadata.

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Sr. Oracle DBA

Responsibilities:

• Installed and configured Oracle Database Software 11g, 12c on Red hat Linux operating system and responsible for administering and monitoring Oracle 12c/11g OLTP Production, Development, and other environment databases.
• Installation, Configuration and Maintenance of Oracle 11g RAC with ASM and single instance database. Administrated Real Application Cluster (RAC) databases running on ASM.
• Installed, Configured and managed 11g Oracle Enterprise Manager (OEM) grid control for Performance, Administration and Maintenance of Databases. Successfully maintained multiple databases.
• Installed and configured one to one GoldenGate replication and resolved out of sync issues. Handling GoldenGate replication issues which are responsible for out of sync in Test environment.
• Managing the existing the GoldenGate replication process and setting up new GoldenGate replications for ETL process.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Implemented Data guard (Standby) for high availability/disaster recovery and Upgrade of Databases from 11g to 12c.
• Worked on MongoDB database concepts such as locking, transactions, indexes, replication, and schema design.
• Testing, evaluation and troubleshooting of different NoSQL database systems and cluster configurations to ensure high-availability.
• Successfully Implemented and upgraded R2R and P2P applications in Oracle EBS.
• Assisted in integration of Exadata applications into current IT actionable events and solutions. And expert in Monitor and fine tuning the Exadata Database Machine Hardware.
• Experience in maintaining Active Data guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
• Responsible and accountable for solution delivery, release management process to prioritize, plan, build, test and execute, executive reporting in release management and delivery of business capabilities for Oracle e-Business suite.
• Created automated file feeds for other interacting systems and developed automated report generation scripts using Perl scripting.
• Experience in reading and writing xml reports with Perl XML modules and Cleansing Active Data generated from weblogs with automated scripts in Perl
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Configured RAC on Red Hat Linux Advanced Server with 4 nodes server side load balancing using Automatic Storage Management.
• SQL, PL/SQL Tuning and Monitoring.
• Integrated the backup status, reporting for the entire database in the enterprise to enable the web reporting using oracle, SQL, PL/SQL, UNIX shell scripting.
• Created OEM for automatic monitoring, differential backup and full back up.
• Used TOAD and Netezza for querying and debugging application.
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database. Performed replication using Oracle Streams and GoldenGate Technology.
• Designed and implemented backup and Disaster recovery strategies with RMAN. Performed logical backup using traditional export/ import and Data Pump.
• Modify database structures as required by developers due to business or application requirements, clone development databases for testing and training.
• Provided 24x7on call production support for ORACLE, MySQL and SQL Server Databases.
• Implement Stored Procedures and Triggers based on business plans using PL/SQL.
• Performing conceptual data modeling, data analysis, data profiling, data mapping and implementation for product integration with client's applications.
• Providing database administration support for application development teams for Maintenance, backup and Emergency software releases.

Environment: Oracle 12c, 11g Grid Infrastructure, MongoDB, Perl Scripting, Oracle 11g RAC and Standalone, Exadata, 11g ASM, 11g Grid Control, Red Hat Linux, HP-UNIX Windows, DBCA, OEM Grid Control, SOA Suite 11.1.1.3, Oracle Data Guard, TOAD, Solaris 11, GoldenGate, Oracle Database Backup, Data Pump, Tuning, SQL* Loader.

Confidential, Louisville, KY

Oracle Database Administrator

Responsibilities:

• Installed and maintained Oracle 11g/10g databases for testing, development and production on Linux, HP-UX and Windows.
• Planned for database performance for maintaining huge data volume 60 TB database.
• Support and maintenance of 200+ oracle databases (10g, 11g) and 200+ instances.
• Responsible for upgrading Oracle 10g RAC to 11g RAC.
• Responsible for Implementation of Oracle 11g Grid Control and configured nodes for proactive monitoring.
• Used Oracle Streams for replications of data between remote databases, monitoring and Troubleshooting of Database Replication issues.
• Knowledge on Exadata, Creating a storage index, tuning the parameters, Involved in migrating Databases to Exadata.
• Added new business entities to Oracle EBS, meet their integration and reporting requirements.
• Configured Physical Standby for Production databases and converted Physical standby to Snapshot Standby and Active data-guard.
• Writing Perl scripts to provide an interface between the CGI web pages and database for various modules of the release tool.
• Configuring high availability using geographical MongoDB replica sets across multiple data centers.
• Fixed errors and various bugs with necessary alterations to Perl scripts and managed batch in UNIX for data automated import and export of data using Perl Scripts.
• Involved in the upgrade of Oracle Webtier 11g OHS and configuring SSL for OHS on Red hat Linux servers.
• Performed cold backup, hot backup using conventional backups and RMAN, recovered various development and critical Production databases.
• Installed and configured oracle 10g and 11g Management Agent and cloned it to the multiple nodes.
• Maintained Data guard to provide high availability by implementing physical stand-by database and snapshot-standby databases.
• Configure ASM and handling issues and suggesting feasible workarounds for ASM Metadata corruption. Implemented and monitored 11g RAC Logical Standby database for reporting.
• Setup and monitoredmulti node RAC to RACData guardwith real time applyfor DR and offload backups.
• Implemented and administered Oracle GoldenGate for Database Replication between production and reporting node, by using Oracle Streams.
• Performed conversion of Single Node Instance to multi node RAC with ASM, and adding instance to existing RAC.
• Participated in implementation of High Availability solution based on the failover process supported by Veritas Cluster Server. Supported database activities using Cluster Manager GUI, administered shutdown/startup process for databases, listeners.
• Moved databases from one clustered server to another for maintenance purposes. Mounted/dismounted file systems.
• Reading Alert Logs and User trace Files for diagnosing the Problem.
• Performing object storage management and capacity planning using precise software and Stats pack.
• Performance tuning for Oracle Day-to-day maintenance and management of the several different databases in development. And provided full DBAsupport for OracleApplications in Production, Test and Development environments.

Environment: Oracle 11g and 10g, GoldenGate, MongoDB, Perl Scripting, Exadata, Data Guard, RAC, Recovery manager (RMAN), Harvest, Statspack, Oracle Streams, AWR, ADDM, OEM 10g, 11g, Solaris, Windows, IBM AIX 6.1, PL/SQL, TOAD, shell scripting.

Confidential, Redmond, WA

Oracle DBA

Responsibilities:

• Worked as production support, maintaining Production and Development Oracle databases.
• Supported databases including RAC Production database, Data warehouse database and lot of Development and Test databases.
• Installed and configured Oracle 10g, 11g databases on HP-Unix and AIX.
• Installed and configured Oracle RDBMS on UNIX and Windows environments. Created primary database storage structures.
• Build Active Data guard for RAC Cluster and setup Disaster Recovery site.
• Recommended best solutions and methods per requirements and functionalities of Oracle EBS
• Create and maintain DB templates, RAC environments.
• Migrated databases from oracle 10g on Solaris 10 to oracle 11g on Red hat Linux on development, integration and production environment
• Work with Data Migration team and move all the existing data from 11i to R12 and make sure all the transactional data & historical data is going to move successfully into R12.
• Implemented Active Data guard for maximum availability.
• Involved in database administration including 11g RAC Database cloning, tuning, patching and monitoring concurrent manager processing.
• Successfully installed and configured Oracle GoldenGate for Replication in Development and Test environment.
• Perform daily incremental backup and full weekly backup using Oracle backup utility RMAN.
• Migrated standalone databases on AIX/Solaris/Windows and file system to Linux RAC on ASM.
• Setup and configure Standby database (Physical & Logical) for high availability.
• Initiated 10g new feature implementations such as Automatic Storage Management, Flashback features, DBMS Scheduler, ASMM to improve performance and manageability.
• Created, Configured and Set up RMAN Catalog databases and registered target databases with the Catalog.
• Review alert logs and dump files to check for any problems related to the database/users.
• Involved in data modeling techniques using Star Schema, Snowflake Schema, and Entity-Relationship Diagrams. Maintained documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Reorganized databases and Sizing of database objects for effective space management and optimal performance. Oracle Database and Oracle Applications cloning/refresh.
• Create and troubleshoot DB Link’s issues in Oracle for communicating with external databases.
• Done performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Resolving database storage management issues.
• Managed undo segments, processes, memory, online redo log files, data files.
• Integrated the backup status, reporting for the entire database in the enterprise to enable the web reporting using oracle, SQL, PL/SQL, UNIX shell scripting.
• Performing all daily maintenance tasks. Interacting with Oracle Customer service as and when required.
• Maintained documents of Oracle database operations. Prepared documentation of database backup and recovery standards.

Environment: Oracle 11g, 10.2.0.x, 11g RAC, 11g Grid Control, Oracle 10g, HP-UNIX, AIX, Windows, RAC, Data Guard, TOAD, ASM, VERITAS Net Backup, RMAN, Solaris 10, GoldenGate, STATSPACK, SQL* Loader, SQL/PLSQL.

Confidential, Oaks, PA

Oracle Database Administrator

Responsibilities:

• Implementation and Configuration of OEM & Oracle Management Server for maintenance and monitoring.
• Installed and configured oracle10g database and created databases manually.
• RAC installation and configuration for 4 node cluster.
• Upgrade/Migrated the production and development databases from 9i to 10g.
• Performed database cloning/export/import to setup identical databases in the production and development environments.
• Installed, Configured and Managed Oracle 10g on HP-UX and IBM-AIX environments for production, test and development.
• Performance monitoring and tuning RAC databases using RAC check and other utilities.
• Implementing the TAF and RMAN backup in RAC, Load balancing.
• Expertise in ETL tools and created reports in Oracle Discoverer by importing PL/SQL functions on the Admin Layer to meet the client requirements.
• Setting up Physical Standby Database environment using Active Data guard in Oracle 9i, 10g.
• Analysis and application of oracle quarterly patches in dev/ production.
• Experience with Oracle RMAN and Veritas Net Backup.
• Setup of Disaster Recovery databases like Data Guard.
• Performed Logical backups at schema level using Export/Import.
• Extensive experience in developing Data Extraction, Data Transformations, Data Loading (ETL) projects.
• Configured and installed one to one replication using GoldenGate between heterogeneous environments.
• Database instance tuning such as tuning memory allocation, tuning I/O, tuning contention, tuning related to sorts and free lists and check points
• Handled Database recovery (disaster recovery), diagnosed, repaired and was involved to transfer the OLTP data to Data Warehouse.
• Installation of Oracle 10g/9i software on various platforms like Red Hat Linux Adv.
• Created users and set permissions, and managing database security using groups and roles.
• Monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottleneck. Provide technical direction to system administrators.
• Supported different databases like Production, Development, Testing, and Training.
• Co-ordination has been extended to Application developers for coding to improve the performance of the database.
• Database refreshes, environment configurations, and troubleshooting.
• Performing the logical and physical structures for tables, indexes, modeling, normalization and foreign key constraints.
• Provided all kinds of DBA support to development teams as well as production support to various applications.

Environment: Oracle 10g/9i, Solaris, RHEL, Windows, Data guard, RMAN, SQL Navigator, OEM Grid Control, RAC, STATSPACK, oracle partitioning, SQL*LOADER, PL/SQL, Scripting.

Confidential

Jr. Oracle DBA

Responsibilities:

• Installed, Configured and Managed Oracle9i on HP-UX and IBM-AIX environments for production, test and development.
• Upgraded databases from Oracle 8i to 9i. Other activities like applying RDBMS patches, security patches, proactive monitoring of databases and applications.
• Monitoring of hot backups, exports on Linux and Windows.
• Performed Refresh of databases on Linux servers
• Write various SQL and PL/SQL scripts and procedures to support applications.
• Set up and administered tablespaces, data files, tables, indexes, views and sequences Configured and managed users, security and Redo logs.
• Performed database cloning to create Test and Development environments from Production.
• Created and maintained materialized views.
• Modified and debugged stored procedures and triggers.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database. And writing scripts for the system and database for the effective functionality and report generation.
• Identifying Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and to see if these queries can be fine-tuned for better performance.
• Created Materialized views, groups for performing SQL*Loader jobs for data loading and used data pump jobs for loading the subscriber and history related data at replicated site.
• Interacted with the users and troubleshoot the problems related to the privileges & resources.
• Monitor database activity and file usage, and ensure necessary resources are present, so that databases function properly by removing or deleting old or obsolete files.
• Performing all the Database Administration activities like space management in database, user and roles administration, schema management, checking alert log of all the databases.
• Monitoring the test database as well as the production database
• Created and managed tablespaces monitored the data files space, resizing and adding new data file.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Involved in gathering requirements from end users.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Estimated growth of database size by detail analysis of the company’s future policies.

Environment: Oracle 9i, RHEL, Window 2003, Oracle Enterprise Manager, HP-UX, IBM-AIX, STATSPACK, TOAD, RDBMS, RAC, RMAN, PL/SQL.

Confidential

Pl/SQL Developer

Responsibilities:

• Installation, Configuration and Administration of SQL Server 2005/2008 on Windows Servers.
• Design and developing database code using PL/SQL programs, Java Programming
• Experience in Design and Implementation of PL/SQL Stored Procedures, Functions, Packages, Ref Cursors, Constraints, Database Links, UTL file and Triggers for Oracle Relational Databases.
• Extensively worked with third party database tools like SQL Developer, Toad and Pl/SQL Developer
• Performed Database backups (operating system, flat file backups & export/import).
• Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler.
• Implemented bulk programming and for all technics to improve the performance of the procedure executions.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys and foreign keys.
• Worked on Active/Active and Active/Passive Clustering.
• Worked on series of PL/SQL validations which checks the Employee Type, Payroll Type and Assignment is present for the employee for that Reporting year.
• Performed query tuning & optimization using Query Plans & SQL Profiler.
• Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, Materialized Views, PL/SQL tables, Cursors, Nested tables, Records, Types and Dynamic SQL for DML operations for better performance
• Developed standards and guidelines to maintain and develop and administer the SQL Server database.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.

Environment: SQL Server 2005/2008, Pl/SQL, T-SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Windows 2003 Server.