SUMMARY

• Over 9+ years of experience in as an Oracle Server Database Administration (12c/11g/10g/9i) in Production and Development environment.
• 5+ years financial services experience
• Involved in creation, installation, maintenance and administration of Databases in UNIX, LINUX, AIX, Sun Solaris and WINDOWS Platforms.
• Over 5+ years of experience in RAC (Real Application Cluster) implementation, monitoring and administration.
• Over7 yearsof professional and progressive experience inIBM DB2 UDBwith emphasis on Database Administration, development, migration, Business Requirement Analysis, Application design, testing, implementation andproduction supportof critical OLTP, OLAP and Data warehouse environments.
• IBM Certified Advanced Database Administrator on DB2 V9.7has undertaken several IBM DB2 training courses and has worked through all phases of system development life cycle.
• Expertise in configuring 2 - node, 3-node HADR setup with TSA using different tie-breakers from scratchto Production implementation.
• Expertise in development support activities including installation, configuration and successful deployment of changes across all environments
• Extensive experience in logical and physical design of databases, performance tuning, database utilities, backup and recovery strategies, capacity planning, high availability, disaster recovery, database monitoring, troubleshooting, change and problem management and production support on 24/7 basis
• Expertise in collecting, analyzing and performing system level tuning of databases.
• Expertise in Deep Compression and Table Partitioning.
• Experience in resolving various database issues and bottlenecks by working directly with DB2 Development team.
• Extensive experience with Incident, Problem and Change managements.
• Used BCV split/Data Guard technology to migrate over 13 TB Database.
• Supporting Data Warehouse Database i.e. over 30 TB in size.
• Expertise in Oracle database replication, Expertise in Oracle 11g/10g Data Guard and standby databases, Snapshot maintenance and creation.
• Expertise in handling Very Large Database (VLDB) and OLTP environment.
• Expert in ORACLE Database Administration including planning/implementing backup/recovery strategies using RMAN and without RMAN.
• Expertise in installation and configuration of Oracle and large databases on Unix Operating System.
• Production maintenance and supporting (7x24).
• Extensive experience implementing Disaster Recovery Plans.
• Excellent knowledge in Different types of partitioning.
• Involved in coordination of distributed teams to increase productivity and reduce turnaround times.
• Seeking a position where my experience and capabilities can be used to contribute to a company's objectives.

TECHNICAL SKILLS

Operating Systems: Red Hat Linux RHEL 3.x, 4.x, 5.x, 6.x, HP-UX 10.x, 11.xSun Solaris 9.0/10.0, AIX 5.1, 5.2

Data Bases: Oracle 12c/11g/10g/9i, Oracle 12c, 11g/10g Real Application Cluster (RAC)ASM, MySQL, SQL SERVER 2008/2012, Mongo DB

Languages: SQL, PL/SQL, UNIX Shell Scripting

Tools: /Utilities: RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/ImportRMAN, NETCA, DBCA, TOAD, Exadata, Patch Management, SQLNETOEMCTL, Dbverify, ODBC, Export/Import, Data pump, Data-Guard, ErwinOEL, Log-miner, MS Visio, VERITAS Net Backup, BMC remedyPac 2000, VMware, Crontab, oradebug

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

Terminal Emulation: Putty, Telnet, FTP, TOAD

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Oracle DBA

Responsibilities:

• Worked as Operational Database Admin in 24x7 production environment and provided on-call and day-to-day support.
• Architecting, planning, designing, developing, deploying and supporting RAC/ASM environment. - Used ocrconfig, srvctl and crsctl utilities in RAC / cluster environment.
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle cluster-ware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files.
• Used ASMCA to create disk groups in RAC environment.
• Configured dataguard for Two Node RAC.
• Migrated ASM Database to 11g R2 Two Node RAC ASM.
• Installed 12C RAC CLUSTER and created 12.1.0.2 in memory databases on TEST and DEV servers.
• Installed Data Guard and standby databases. Snapshot maintenance and creation.
• Mentor other DBAs in effective use of RMAN software and my scripts.
• Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
• Advanced Backup and Recovery using Oracle’s RMAN software; used offline/online. or recovery in a production environment via Korn shell scripting.
• Credential Store is implemented in Oracle GOLDENGATE as an autologin wallet within the Oracle Credential Store Framework (CSF).
• Installed and configured Oracle GOLDENGATE on AIX 6.1 and RHEL 6.3.
• Enabled ENABLE GOLDENGATE REPLICATION, STREAMS POOL SIZE parameters for 11.2.0.4+ databases to support integrated capture in goldengate environment.
• Performed migration using GoldenGate from sunsolaris9 to O.E.Linux 6.1 platforms
• Used report files, trail files, ggserror log to troubleshoot oracle goldengate issues in environment.
• Used different tools in Goldengate environment like defgen, logdump and convchk to manage Oracle Goldengate environment.
• Tested Oracle Goldengate REPLICAT apply run rate with different parameters for large volume tables.
• Used VERIDATA to compare data between instances replicated by goldengate.
• Upgraded databases in RAC and NON-RAC databases.
• Migrated databases to EXADATA x3-4 machine, worked with oracle in configuring environment.
• Upgraded OPATCH UTILITY version to 11.2.0.6 and applied patches to Oracle homes- Refreshing databases using RMAN and Data-pump. Used 11g new feature recovery advisor in RMAN.
• Migrated databases from 11.2.0.4 to 12c.
• Hands on experience with OEM 12c, installing agent, creating templates, daily health check-up of the database using OEM
• Worked on Issues with block change tracking in RMAN& also flash recovery area.
• Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
• Replicated to a disaster recovery site for increased server manageability and availability.
• Implemented Active-dataguard with real-time apply and monitored.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges).
• Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
• Managed appropriate use of free-space within table-spaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
• Used DBMS SCHEDULER for scheduling jobs on databases.
• Verify all scheduled jobs, RMAN jobs have run successfully without any issues.
• Generated AWR, ASH, ADDM reports using OEM 11G/12C and manually to analyze the database performance.
• Worked on Refreshing materialized views, creating views, triggers and new tables according to requirement.
• Created SQL profiles to improve performance of SQL’s in environment, Used SQL TUNING ADVISOR from OEM, EXPLAIN PLAN to tune long running queries on database.
• Worked on rebuilding indexes and partitioning tables, Used ADRCI to check health and errors on databases.
• Clear documentation was prepared on all the tasks performed.

Environment: Oracle 11g/12c, RAC, ASM and Dataguard. Oracle Goldengate, RMAN, Performance Tuning, TOAD 11.x, OEM 11g/12c, Solaris/Linux, EXADATA SQL, PUTTY, EXPLAIN PLAN, AWR, ADDM, ASH, TTS FLASHBACK, DATAPUMPS.

Confidential, Detroit, MI

Sr. Oracle DBA

Responsibilities:

• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation DuplicateDatabases using RMAN Backups.
• Involved in Design and implementation of oracle 11g Data Guard both physical/logical Standbydatabases for high availability and disaster recovery.
• Implementation of High Availability solutions with Oracle 12c,11g RAC,10g RAC, StandbyDatabase(Active Data Guard), Replication.
• Responsible for Installation of RAC and Managing RAC Environment efficiently
• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c
• WebLogic performance tuning and upgrade to 12c and 11g
• Implemented Monitoring Templates and Incident Rule notifications using OEM 12C fordatabasealerting.
• Worked extensively on 12C OEM and configured DB alerts for DBA
• Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views & Query Re-Write.
• Supported functional data warehouse projects.
• Worked with database export & import scripts to backupdatabasestructures and automation procedures
• Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications Work on different versions of Databases with OEM Grid control to maintain thedatabaseeffectively.
• Configured different levels of replication such as DDL replication, DML replication for table level, schema level,databaselevel using Golden Gate.
• Implemented classic Golden gate replication as well as integrated replication. Implementing and maintainingdatabasesecurity (create and maintain users, roles and assign privileges)
• Query optimization, PL/SQL Performance Tuning using Oracle Cost based Optimization techniques, Explain Plan, Trace, Hints and Tkprof. SQL, PL/SQL and UNIX shell scripting.
• Monitored the Applications anddatabaseusing OEM and OAM.
• Document and communicate changes to the OLTP, OLAP systems and data warehouse teams, including Data Modeling, ETL andDatabaseteams.
• Used Automatic Workload Repository (AWR) & AutomaticDatabaseDiagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Built 4 node RAC 10gr2 Standbydatabaseand set up DG Broker
• Setup of High Availability of thedatabaseusing RAC, Standby, Data guard.
• DBA activities such as configuring Grid events, Regular Backup's, Replication, Tuning, and troubleshooting performance issues.
• Maintain, upgrade, troubleshoot all enterprise oracle and SQL serverdatabases
• Install and Configure OracleFusion Applications 11.1.5 on Exalogic/Exadata -- setup and Maintain system and configurations.
• Advanced Backup and Recovery using Oracle RMAN software; used offline/online for recovery in a production environment via Kornshell scripting.
• Provide development and production support related todatabase
• Perform other regular DBA activities including space management and performance monitoring.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Design, development, testing, performance tuning, deployment, and support in Data warehouse system
• Performance Tuning ofDatabases, Oracle instances, and Applications. Finding Performance Bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM
• Upgrade and Migration ofDatabases from 10.2.0.5 to 11.2.0.2 and applying patches whenever required.

Environment: ORACLE, SQL*Plus,OEM/12c,Exadata V1/V2/X2-2/X2-8, PL/SQL, Oracle 11g/10g,RAC, Microsoft SQL Server 2005 & 2008,DB2, Golden gate, Shell scripting, Red Hat Linux 5,Solaris 10,Unix, VCS, Oracle Enterprise Manager, Data guard, ASM, PL/SQL, RMAN, Toad.

Confidential, Kansas City, MO

Sr. Oracle DBA

Responsibilities:

• Worked in data center migration project and Worked in 24x7 production environment and provided on-call and day-to-day support.
• Installing & configuring Oracle cluster-ware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of cluster-ware)
• Performed various activities in Real Application Cluster, created databases using DBCA, used SRVCTL and CRSCTL to manage services and resources on cluster.
• Used cluster-ware logs to troubleshoot Real Application Cluster environment.
• Worked on ASM in cluster environment, Used SYSASM to create disk groups with different redundancy levels.
• Worked on creating ASM dynamic volume.
• Changes were made dynamically whenever possible to fulfil high-availability requirements.
• Maintained standby databases, in both local and remote locations, for fail-over purposes.
• Strategic involvement with client for Server virtualization and manageability of infrastructure.
• Involved in implementing Solaris Containers to achieve Server Virtualization.
• Data center Migration using Data Guard.
• Used Dataguard broker to perform operations in dataguard environment.
• Monitored system resource availability and responded to system memory and data issues.
• Installed and configured Oracle GOLDENGATE on light-ray application and replicated base tables to reporting instance.
• Configured uni-directional replication using goldengate replicated data across instances for load balancing.
• Implemented Goldengate lag monitoring scripts, discard reports and process monitoring scripts in Goldengate environment.
• Cloning databases using RMAN in test & dev environment.
• Refreshing and migrating data across prod, Test & dev environments using DATAPUMP
• Implementing and maintaining database security (create and maintain users, roles and assign privileges)
• Engaged in monitoring free-space within table-spaces and reclaimed space whenever needed.
• Monitored the production Oracle database alert logs for database errors.
• Worked in build stage and performed various operations creating databases, updating, altering tablespaces, indexes, tables, views, synonyms, profile, role and privileges, testing databases parameters in test, dev and production environment
• Upgraded databases from 10g to 11g, upgraded patches using opatch utility.
• Applied patches to database home to 11.2.0.1 and 11.2.0.2 and upgraded databases.
• Estimated growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.
• Clear documentation was prepared on all the tasks performed.

Environment: Oracle RAC, ASM, Data guard and GOLDENGATE. SHAREPLEX, Oracle 10g/11g, SQL server, OEM, GRID control 10g/11g, AWR, EXPLAIN PLAN, TOAD, RMAN, RHEL 5.x, AIX 5.x, HP UNIX.

Confidential

ORACLE DBA

Responsibilities:

• Provided DBA Services to improve their performance of databases i.e. supported company that works with Oracle on a highly OLTP and DW environment.
• Setup Disaster Recovery solutions (Dataguard), Tuning Code, Resolved bottleneck problems.
• Applied Patches, Backup and recovery (with RMAN and Shell Scripts) over high volume Terabyte Databases.
• Installed and configured Oracle RAC.
• Helped other team to migrate from Oracle 10g to Oracle 11gr2
• Installed standalone servers on ASM 11g, worked on creating disk groups, partitioning raw-devices .
• Used ASMCA extensively to create disk groups in ASM environment
• Installed and configured Oracle databases on severs RHEL.5.5 and RHEL 5.8
• Modified SQL*Loader control scripts to eliminate while spaces generally used for data loading.
• Installed & managed 10g OEM grid monitoring solution and deployed agents.
• Performed Logical backup using and full/partial export/import and Data Pump.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Created bit-map Indexes for data warehouse databases.
• Worked with ETL team for understating mappings for dimensions and facts.
• Configured Physical and Logical Standby database for reporting environment.
• Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Clear documentation was prepared on all the processes like program specification, bugs fixing log & change requests for future reference.
• Proactively managed the databases; set up notifications, alarms using shell scripts for managing any exceptions in day to day management of the database
• Efficient in using the Oracle Tools like SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Managing table spaces, user profiles, indexes, storage parameter’s -- Develop table structures, PL*SQL stored procedures and database triggers to implement.
• Responsible to provide 24x7 database administrative activities over different database servers

Environment: Oracle RAC 10g/11g, RMAN, OEM and ASM. RHEL 4.x,5.5,RHEL 5.8, Sun Solaris, TOAD, IMPORT/EXPORT, Windows NT/2000, ETL.

Confidential

ORACLE DBA

Responsibilities:

• Monitored performance of database using AWR report, ASH.
• Participated in group meetings and shared my ideas on different issues.
• Created and Monitored table-space sizes. Worked on undo table-space size and changed undo retention time as per the requirements.
• Created Indexes on tables and performed rebuilding of Indexes.
• Used Explain plan, SQL trace and TKPROF to analyze the database and different SQL queries.
• Had good experience in working with TOAD.
• Worked with other team to convert data dictionary tablespaces to locally managed tablespaces
• Performed cold and hot backups.
• Took the privilege to install database using DBCA and manually.
• Added new datafiles to the existing tablespaces.
• Multiplexed controlfiles and altered different parameters depending on the requirement.
• Created listeners and tnsnames to the new databases using NETCA and manually.
• Good experience on creating views and materialized views on the tables.
• Gathered statistics using packages at different levels (statistics on table, schema) etc.
• Created snap shots manually to compare and take the AWR report.
• Placed small tables in the memory to decrease the response time and made the tables default after the requirement.
• Worked on the Change Requests taking minimum downtime.
• Performed exports and imports and refreshed data across instances.
• Developed, executed and managed Oracle PL/SQL such as procedures, functions, packages and database triggers
• Used RMAN to take backups

Environment: Oracle 9i/10g, RHEL 4.x, 5.x, TOAD, Oracle Windows, OEM 9.2.0/10g, RMAN, Performance Tuning.