SUMMARY

• Around thirteen years of experience in Database Administration operations on Oracle 12c, oracle 11g, 10g, 9i, 8i on various platforms like HP - UX, SUN SOLARIS, AIX, Red Hat Linux, Windows NT and VMware. Knowledge in MongoDB
• Experience Working in ORaas, Maas cloud clusters.
• Expert in Administration of Productivity Tools including OEM, RMAN, Exp/Imp, RAC/OLTP/Partition, Data Guard, Oracle Clusterware, ASM, Data Pump.
• Expert in Installation, Administration, Creation, Backup & Recovery Strategy and Database Security for Databases having more than 500+ users
• Experience working in OLTP, OLAP, Production, Test/UAT and Development environments.
• Proficient on setting up and managing User Managed Physical Standby database and Data Guard databases.
• Extensive experience in Troubleshooting, Developer/Client Support, Migration & Upgradation of Database from 8i to 9i, 9i to 10g,10g to 11g and 11g to 12c.
• Monitored and optimized Database Performances through Database Tuning, System Tuning and Application Tuning using Stats pack, AWR, ADDM, DBMS SYSTEM, SQL ADVISOR, DBMS STATS, Explain Plan, SQL*Trace, TKPROF.
• Expert in installing, upgrading, RDBMS patches and security (CPU/PSU) patches, TAR support. Duties include Database Tuning / Reorganization, RMAN Cloning for Day-1 Reporting, Flash Recovery configuration, User and Security management, Auditing, General Troubleshooting, and Configuring servers.
• Expert in SQL query optimization using Explain Plan, Utlbstat / Utlestat, TKPROF reports, gathering statistics, pinning the objects, and running scripts.
• Expert in Production Database Daily Administration such as data loading, data processing, job scheduling via OEM, UNIX crontab and Data Warehouse maintenance such as partitioning tables, creating materialized views.
• Restoration and recovery of data using VERITAS NetBackup and Sqlbacktrack.
• Experience working in Database capacity planning, space management and allocation.
• Proficient in Designing, coding, testing and debugging of PL/SQL Function, Triggers, Procedures and Packages.
• Expert in replication setup, configuration, maintenance and upgradation of replication process using Oracle Goldengate.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and Experience working in VLDB (very large database) and real-time OLTP Environments.
• Experienced in Full software development life cycle (SDLC) of Database Administration.
• Experienced in writing scripts in UNIX shell scripting and PL/SQL scripting for automating daily activities in CRON.
• Experience in SNOW, INFOMAN and QC
• Actively learning the concepts of AWS - RDS for Oracle.
• Adequate working experience with ITIL process oriented projects, fulfilment of SLA’s (service level agreements). Prepared standard documentation for continuous business, services and process improvement plans for the client and vendor.
• Strong organizational, administrative and problem-solving skills, statistical analysis skills, proficient with analytic and quality assurance, experience leading small teams in developing and documenting business requirements.
• Good team player with excellent communications and interpersonal skills also can work independently to reach the deliverables.

TECHNICAL SKILLS

RDBMS: Oracle 12c, Oracle 11G, Oracle 9i & 10g(RAC), Mongo DB

Operating Platforms: Linux, IBM-AIX, HP-AX, Sun Solaris, Windows 2K/NT & Sun cluster

Database Management: Oracle Enterprise Manager & Grid control

Oracle Utilities/Features: RMAN, Sql* Loader, TkProf, DBVerify, Log Miner, Golden Gate GGSCI, Datapump, Data Guard, CONVPRM

PLSQL Development: Rapid SQL, PLSQL Developer & TOAD.

Programming: SQL, PL/SQL, Shell scripting & C programming

Scripting tools: UNIX Shell Scripting, PL/SQL

Backup Utilities: SQL Backtrack, IBM Tivoli, Veritas Netbackup, CommVault Sisimpana

Tuning Tools: EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH, ASMM, Oracle Tuning Pack

PROFESSIONAL EXPERIENCE

Confidential, Irving, Texas

Responsibilities:

• Upgraded Oracle 11gdatabases from 11.2.0.1 to 11.2.0.4 using patch set.
• Installation of Oracle Restart and ASM diskgroup on AIX 7.1
• Experience on Applying Patch set and OPatch as per oracle recommendation.
• Database configuration and creation. Data refresh across different environments using expdp/impdp and exp/imp.
• Experience on database cloning using Hot, Cold and RMAN backup.
• Perform Continuity of business test using standby setup. Deploy recovery techniques during media failures.
• Extract and report database performance co-ordinates using Statspack /AWR.
• Experience in configuring OEM 12c cloud control load balancing by adding additional OMS using F5 Service Load Balancer (SLB).
• Implementing database audit and working on functional id remediation project.
• Proactive space management. Creating and assigning roles meeting the Risk Assessment standards.
• Periodical review of Technology Review Assessment Matrix concerned with database.
• Writing Basic Shell scripts for load monitoring and Housekeeping of Trace files Raising RFC for New implementation or for any major changes in database.
• AWR and ADDM report Generation and Implementing ADDM suggestion to a particular query which causes performance Issue.
• Monitoring the database and related services using 10g grid control. Crontab job scheduling based on end user request.
• Resolved the issues for Conflicts between Source and Target GoldenGate Databases
• Troubleshoot GoldenGate collision issues and GoldenGate DML Replication
• Database Monitoring using Scripts. Monitoring Space and Index usage.
• Responsible for solving the Workaday issues faced by the development users. Monitor locks and release locks.
• Carried out DB Cloning and provided the cloned database for development side.

Confidential

Responsibilities:

• General technical trouble shooting. Database Monitoring using Scripts. Monitoring the database and related services using 10g grid control.
• Crontab job scheduling based on end user request. Raising RFC for New implementation or for any major changes in database.
• Perform Continuity of business test using standby setup.
• Proactive space management. Deploy recovery techniques during media failures. Troubleshooting database management and connectivity issues.
• Data refresh across different environments using expdp/impdp and exp/imp.
• Carried out DB Cloning and provided the cloned database for development side.
• Monitoring Space and Index usage. Rebuilding Index on the needed objects.
• Enforce adherence to IT Processes including SDLC, Change management, and other fundamental processes.
• Move databases from NONASM to ASM.
• Work with Development team on designing standardized data models, and standard and optimal PL/SQL code.
• Oversee the Development and implementation of Database security policies and procedures, in line with corporate objectives.
• Patched Oracle Database Server 9i and 10g using Opatch, apply security patches (CPU/PSU).
• Utilized recovery methods like Point in Time Recovery (PITR) and Table Space Point in Time Recovery (TSPITR) using RMAN.
• Data Loading using SQL*Loader and DBVERIFY for corruption checking.
• Implemented physical database design after sizing tables and indexes and creating tablespaces taking into account I/O load distribution.
• Conducting Disaster Recovery Drills periodically to ensure Continuity-of-Business.
• Monitor database growth and regularly review them and provide Capacity Planning for databases.
• Publishing Maintenance Calendar for Databases and ensure to review the Activities carried out.

Confidential

Responsibilities:

• General technical trouble shooting. Database Monitoring using Scripts. Monitoring the database and related services using 10g grid control.
• Crontab job scheduling based on end user request. Raising RFC for New implementation or for any major changes in database.
• Perform Continuity of business test using standby setup.
• Proactive space management. Deploy recovery techniques during media failures. Troubleshooting database management and connectivity issues.
• Data refresh across different environments using expdp/impdp and exp/imp.
• Carried out DB Cloning and provided the cloned database for development side.
• Monitoring Space and Index usage. Rebuilding Index on the needed objects.
• Responsible for configuring and managing the standby database in manual recovery mode.
• Fine-tuning of the Database, including Memory (SGA), I/O and Application.
• Identify areas to improve Oracle response time, Monitoring File I/O.
• Creation and Maintenance of Database Links and Snapshots for providing point in time Representation of Data and Maintaining Transactional Consistency.
• To schedule Database Reorganizations (Defragmentation) In order to keep the database running smoothly
• Attending to day-to-day problems in the Oracle database and taking suitable actions for trouble shooting.
• Identifying PL/SQL objects that need to be pinned.