PROFESSIONAL SUMMARY:

• Extensive IT industry experience in Oracle Database Administration, from project initiation to testing to deployment and troubleshooting, performance tuning and support. Worked on all facets including installation, configuration, migration, sizing and space management, backup and recovery, cloning, upgrades, RAC, standby, replication, patching, performance tuning and troubleshooting, strategic planning, database security, TAR support, UNIX shell scripting and documentation, auditing and implementation of technology solutions.
• Experience with migrations and upgrades. Hands on experience in upgrading from Oracle 10g (10.2.0) to 11g R2 using TTS upgrade.
• Experience in creating development, test, stage, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts.
• Experience in registering Databases to Oracle 10g/11g/12c Grid Control and registering Databases to RMAN Catalog.
• Experience in Data Loading using SQL*Loader.
• Experience in refreshing data from Production to Development databases and Reorganization of Databases using Export/Import. Experience in Data Pump.
• Performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Application Tuning and Database/Instance Tuning.
• Experience in performance - tuning services like EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 11g, 10g OEM Grid Monitoring, custom scripts troubleshooting Oracle databases using sqltrace.
• Experience in using oracle features - FLASHBACK RECOVERY, ADDM, ASSM, ASMM and 10g/11g/12c Grid Monitoring, SQL Tuning advisor.
• Experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Hands on Unix Shell Scripting for automating the DBA tasks.
• Effective and efficient team player with excellent interpersonal skills, analytical & problem solving skills.
• Strong experience in configuration of RMAN, Planning and scheduling Backups using CRONTAB and CONTROL+M.
• Expertise in basic and advanced replication using Oracle Streams.
• Sound Knowledge and experience in Oracle Golden gate for implementing streams, data replication process.
• Experience in installing, configuring and managing ORACLE GATEWAY 11G.
• Experience in Installation, Configuration, Migration and upgrading (patches) Oracle databases.
• Experience in Monitoring Oracle Databases using Oracle Enterprise Manager, Grid Control, and TOAD.
• Experience with Dataguard environment, Physical Standby Databases and Logical Standby Databases.
• Created and configured a Physical Standby database to meet Disaster Recovery.
• Experience in Backup & Recovery with RMAN and without RMAN.
• Installation of Oracle 11g Standalone software with conventional File systems has been implemented.

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 2000,2003,2008R2

RDBMS: Oracle 11g R2/10g/9i/8i

Languages: SQL, PL/SQL, C,C++, UNIX Shell Scripting, Bash Scripting

Tools/Utilities: NETCA,DBCA,RMAN, OEM, SQL*Loader, SQL Server, EXP, IMP, expdp, impdp, TOADTuning Tools: ASH,ADDM,AWR,TKPROF, EXPLAIN PLAN, STATSPACK

Database Modeling: Erwin 4.0,Toad Data Modeler,Datanamic and start UML

Other: EMC, NetApp, Veritas, NetBackup, HP Data Protector,tsm

PROFESSIONAL EXPERIENCE:

Confidential, Hopkins, MN

Sr. Oracle DBA

Environment: Oracle Exadata IBM AIX 6.3,7.1, Sun Solaris 2.6/7/8, Red Hat Linux 6.0, Oracle 10g/11g/12c, PL/SQL, SQL*PLUS, VNC, ORACLE ENTERPRISE MANAGER 9.2.0, Oracle 12c GRID, QUEST SOFTWARE (5.0), Oracle RAC, Data guard, Toad 8.6, Oracle Applications 11.5.8, Oracle Application server 10g, AD utilities, APEX 2.0/2.2,Sybase, SQL server

Responsibilities:

• Extensively worked on goldengate implementations in peer to peer topology.
• Worked on upgrading of oracle databases from 11g to 12c.
• Worked on building and rolling out new 12c databases for test/dev/qa environments.
• Migrated Oracle database from Non Exadata machine to Exadata using datapump and goldengate.
• Implemented oracle 12c active standby database for test database environment.
• Implemented oracle 12c flexi asm for pre-prod environment.
• Utilized rman recover table functionality and created proof of concepts for our pre-prod environment.
• Installed, Configured Oracle 12c Goldengate on Oracle 12c Database.
• Implemented OEM 12c Repository database, OEM 12c Agent and golden gate plugin Installations.
• Extensive Experience with Change Board Meetings and Change Control Management for all database changes.
• Documented all Oracle 12c installation/Up gradation work and delivered KT to all team peers.
• Worked with projects/operations/professional services team and co-ordinate multiple tasks at hand with expertise and solid plan.
• Contributed as an efficient/reliable team member for all business critical releases and changes.
• Handled all dba work for Business promotional activities.
• Utilized Accurev tool for code version change control activities.
• Worked under high stress situations many times and handled the situation very effectively.
• Performed the code reviews for all the db code coming into the database and fine tuned it before hand.
• Worked with IBM VERITAS Active - Passive clusters.
• Involved in 24x7 support for 4TB, 4 Node production RAC database with on-call pager
• Installation and creation of 11g and 10g databases for Testing, Development and Production
• Installed Golden Gate 12c on IBM-AIX Platform.
• Implemented 12c/11g Data guard with one physical database
• Installed, upgraded Golden gate for Oracle database and enable real-time data integration and continuous data availability by capturing and delivering updates of critical information as the changes occur and providing continuous data synchronization across heterogeneous environments.
• Assist Programmers and Developers with Oracle problems.
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• PL/SQL, Performance Tuning, Application Tuning and Monitoring.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption
• Extensively worked with ASMCMD for managing ASM environment.
• Disaster recovery of Exadata Data guard Physical Standby. Failover/Switchover/Loss of Service/Rebuild/Corruption/Loss of datafile testing.
• Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
• SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF and Statspack.
• Proactive performance monitoring, and capacity planning for future database and server growth using OEM.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Performed Cross platform migration using transportable table spaces and RMAN.
• Planned and performed the database migration from SQL Server to Oracle using Golden Gate.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
• Transformed logical database designs into physical databases using ERWIN Data Modeling Tool.
• Build and implement test, quality assurance, and production databases and environments.
• Coordinated strategies to move data between databases using expdp/impdp.
• Composed maintained and monitored compliance to standards and practices.
• Assisted IT Analysts on technical database issues and features.
• Resolved data integration issues.
• Performed version upgrades and patch installs.
• Able to work effectively with multiple teams at once. Able to thrive in a fast-paced, time compressed and dynamic environment. Solid skills and discipline for Change Management practices processes.
• Solid discipline in providing end-users timely updates on their problems. Installing server software.
• ASM implementation & maintenance. Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating the changes in the database design.
• Proficient in setting up Standby Database supported by ORACLE DATAGUARD for disaster recovery purpose.

Confidential, PA

Environment: RHEL-5/6 64bit, Oracle10g, 11gR2 RAC, OEM, RMAN, Data Pump, ASM,Diagnostic and Tuning Advisors, OLTP, Data

Warehouse

Responsibilities:

• Responsible for providing 24*7 production support
• Performed DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequences etc.), space management (tablespace, rollback segment), and monitoring (alert log, memory, disk I/O, CPU, database network connectivity).
• Hands-on experience with SQL tuning advisor, SQL profile, stored outlines, generating AWR/ADDM and ASH reports to trouble shoot Database contention issues.
• Resolved Shared Memory Allocations, long Transactions, Locking Issues and Deadlocks.
• Delivering Oracle Database performance-tuning services for customers with EXPLAINPLAN, TKPROF, SQL TRACE, 10046 TRACE, 10053 TRACE and OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Responsible for database refreshes from production to non-production environment using RMAN and datapump.
• Scheduled blackouts on the databases using Grid Control for different application requirements.
• Worked on BAU activities-solving tickets, implementing changes through SDLC.

Confidential, Overland Park, Kansas

Oracle DBA

Environment: Oracle 10g/9i, Solaris, VERITAS, OEM, EXPLAINPLAN, TKPROF, AIX, Oracle 10g, RAC,TOAD

Responsibilities:

• 24/7 Production Database Administration Support
• Installed and Configured Oracle 9i/10g RAC.
• Worked on Multiple RAC clustered environments ranging from 2 nodes to 4 nodes per cluster.
• Experienced with SRVCTL, OCR and Voting Disk of 10g RAC.
• Managing two node RAC databases on Red hat Linux advanced server 2.1.
• Performed Database migration from Oracle 9.2.0. To 10.1.0.3
• Implemented Golden Gate for Standby Configuration and developed procedures for Replication.
• Creation of Test and production databases of Oracle Enterprise Edition 8.1.7
• Monitored the growth of the database objects for capacity planning.
• Has primary responsibility for Oracle Data Base and Application performance tuning, physical/logical design and optimization and availability.
• Used Flashback Technology-Query, Table, Drop and Database to undo specific transactions, provided point-in-time recovery of database objects, recovered database objects and rewind entire database to a particular time respectively.
• Perform requirements gathering, data mapping, metadata management and databasemodelling.
• Designed and implemented OLS oracle 9i label cache to enable use of Hibernate with OLS and to improve performance by eliminating repeated use of Oracle conversion functions.
• Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server.
• Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.
• Cleaning the ORACLE HOME file system by cleaning the log files, alert log file and listener.log files
• Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc.
• Backup and recovery utilizing RMAN.
• Working with the application support people to resolve database related issues and running the scripts for the application support people.
• Creating users and database links, snap shots on production and development servers.
• Maintaining system security, defining of roles, profiles etc.
• Checking CRON jobs. Monitoring Application specific background processes.
• Creating materialized views and materialized view logs to implement the table level replication for the MIS databases.
• Use Oracle Metalink Support to resolve different issues related to database servers, security patches.
• Installed and Upgraded Shareplex (3.2 to 4.1) a replication tool for reporting environment.
• Performing Online and Offline database backups on schedule.
• Scripting of Automated backup for Cold / Hot backups.
• Implementation and Configuration of OEM & Oracle Management Server for maintenance and monitoring.
• Installation and Maintenance of Shareplex Replication, Quest-Spotlight.
• Perform database cloning/exp/imp to setup identical databases in the production and development environments.
• Upgrade/Migrated the production and development databases from 9i to 10g.
• Involved in Database sizing, Capacity Planning.
• Identify 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.

Confidential

Jr.OracleDBA/Developer

Environments: Oracle 9i/8i, Windows XP/NT/2000, Standby Databases, Export/Import, RMAN, SQL*Loader,TOAD.

Responsibilities:

• Development and administration of Oracle databases.
• Developed automated scripts to monitor the size of tablespace extents and space utilization.
• Defining storage parameters for tables, indexes, clusters, table spaces, rollback segments, redo logs and data files
• User administration, define roles & profiles and partitioning tables.
• Involved in the installation of Oracle 9i on Solaris and UNIX platform.
• Tracking database security and auditing
• Managing System Global Area
• Monitoring and troubleshooting auto extension of table spaces
• Using TKPROF, EXPLAIN PLAN for the Better performance
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Design and implementation of backup and recovery strategy using user managed backup and recovery
• Hot and cold backups, Restore and recovery
• Exporting & importing of database data and table structure as needed
• Creation of stored procedures, packages and triggers
• Loading of Data from flat files into the Database using SQL*Loader
• Monitor database and system performance
• Tuning SQL Statements, memory (SGA), I/O operations and contention