Oracle Data
Resume:
PARVEEN KADYAN
Coppell TX, *****
**********@*******.***
Visa Status- Citizen
Objective:
Sr Oracle RAC DBA seeking opportunities to apply expertise toward solving large, complex IT challenges. over 8 years of experience in database technologies with expertise in design and administration of high-availability Oracle Databases and Data Warehouses. Expertise in translating business requirements into solid database architecture. Multifaceted IT professional, brings wealth of practical knowledge and understanding of software development best practices with proven experience as a team leader and mentor.
Background includes hands-on Oracle DBA, Exadata and Applications DBA with E-business in UNIX/Linux environment. Duties include Database Projects on multi-tier oracle application and database installation, maintenance, migration, security, physical and DR (Maximum Availability Architecture and Disaster Recovery), Cloning, Backup and Recovery & Performance Tuning. Manage and lead technical staffs, problem resolution to support delivery of services and operations and system architecture initiatives.
SUMMARY:
Over 8 years’ experience as ORACLE RAC DBA administrating Oracle 12c, 11g, 10g, 9i.
Extensive hands-on experience in performance tuning, backup/recovery using RMAN and space management for large databases in Production, Testing and Development environments.
Installed, Configured and implemented Oracle 10g RAC & 11g RAC (Real Application Clusters) on LINUX (RHEL) and AIX.
Experience with Oracle High Availability Technologies like Oracle RAC, GoldenGate and Active Data Guard.
Skilled in high-volume workflow with creative problem resolution skills.
Experience includes design, development, implementation and production support.
Experienced in troubleshooting, inter-departmental coordination and time management.
Consistently promoted to positions of greater responsibility.
Production maintenance and 24x7 support for High availability (RAC) systems.
Worked to secure database for SOX by implementing roles, profiles and Oracle’s best security practices.
Worked in project organizational, architecture design and technical management background from development to production.
Lead and successfully completed critical warehouse project (Hardware migration including solid state disk, upgrade to 11.2.0.2).
Experience includes architecture, design, development, implementation and production support for ERP (Peoplesoft) such as HRMS, ELM CMMS and Financial Databases, Retail RETEK (ORMS 13), ATG.
Proficient in Database Backups and Recovery using Logical Backups (Export/Import), Physical Backups (Cold/Hot) and Recovery Manager (RMAN).
Hosted brown bag and knowledge sharing sessions within team, on Oracle features, Linux hugepages etc
Implemented best practices on RAC application which provided consistent stability.
Good team spirit, strong oral and written communications skills, analytical and interpersonal skills and organized working habits with a willingness to learn new concepts.
EDUCATION:
Master of Business Administration, Concordia University Mequon, USA.
Major: Management Information System (2006) Cumulative GPA: 3.6/4.0.
MATC Mequon, USA.
3 credit VB.net programming course.
SKILLS:
Instructor led 11g ORACLE GIRD/RAC training at IBM Lab (IBM).
11g Performance and Tuning by oracle (Rent-A-Center).
PROFESSIONAL EXPERIENCE:
Rent-A-Center: Oracle DBA – (April 2011 to Present)
Rent-A-Center is one of the biggest retailers for rent to own business, operating around 3000 stores. As DBA we are supporting lot of critical OLAP/OLTP enterprise databases.
Responsibilities included installing, upgrading, patching, tuning, monitoring and troubleshooting with large amounts of data and high transaction rates.
Implemented best practices for security, monitoring, and configuration.
Supported Database in Amazon Cloud (AWS)
Administration/BAU:-
Monitored disk spaces (track and trend space utilization) and Raid level recommendations.
Responsible for administering day to day operations of all Oracle databases including Exadata.
Provide User management, Space monitoring, Gather statistics, Performance monitoring, tuning, Alert Log monitoring and backup monitoring.
Providing on call support for all production environments including Exadata.
Participating in change management meetings to provide DBA input and represent the DBA team on all Operational Excellence / Stability calls,
Collaborate with App and other teams to implement changes and successfully completing Project task.
Setup ORACLE OEM Monitoring and use this as standard monitoring tool to monitor all the Databases.
Migrating/upgrade:-
Did POC (Exadata versus Fusion IO): Collaborated with vendor to perform various proof of concept to evaluate new products and features such as Oracle on Exadata versus Fusion IO.
Migrated Data Warehouse environment from HP UNIX platform to Oracle Linux with Fusion IO (Solid state) card used as storage.
Migrated Data Warehouse again to Nimble Storage from Fusion IO.
Successfully Migrated and upgraded database from 10g to 11gr2 using transportable table space, standby and Export/Import dumps. Minimized lot of downtime time to meet SLA.
Before migration and upgrade verified the impact of a database character set change via Csscan (Database character set scanner) and helped development team to fix the data.
Compliance/Security:-
Implemented Fine Grain (FGA) Auditing based on column and statement.
Setup Data Encryption over BD-link to secure data traveling over network through DB-link.
Applied both CPU patches (GRID and RDBMS) when appropriate.
Security Administration by Creation of Users, Managing their roles and privileges.
Performance/Troubleshooting:-
Doing DB code review and work with developers to provide them code enhancements, indexing the tables properly for better performance.
Lead initiative to implement best practice on AS-IS-database / new databases.
Performing troubleshooting and root cause analysis for critical production issues as well as for Exadata via AWR, ADDM, SQLT/SQLHC and ASH.
Tuned redolog files, Tablespaces, Datafiles, storage structures, rollback segments, Temporary segments, Indexes.
Troubleshot processes from start to finish by setting events 10046 and using TKPROF.
Monitoring CPU usage I/O contention memory paging on UNIX/LINUX server.
Identified locks, waits and maintained statistics of the database and tuned
Implemented procedures to strictly flow SDLC (Test and validate code in lower database, before implemented to PROD this initiative significantly reduced production issues and outages.
Implemented table partition for manageability and performance.
Tuning OS and resolving I/O and contention issues. Collecting System Statistics periodically and implementing tuning recommendations.
Experience in tuning Instance/database based on workload.
Experience in implementing SQL plan stability via SQL Profile.
Experience in tuning Linux OS by getting hugepages and other kernel parameters implemented.
Backups and Recovery:-
Configured and scheduled backups on tapes, disks and Net app (documented backup and recovery steps).
Synced standby environments via RMAN incremental backup roll forward this way no need to recreate standby for missing archivelog.
Perform cloning via RMAN duplicate also, patching, and code migrations as necessary to support business requirements.
Restored Databases via RMAN, impdp and BCV.
Experience with ZDLRA for our backup and recovery purposes
Optimized incremental RMAN backup by enabling block change tracking for large databases it significantly reduced backup time and OS resources such CPU.
Tuned 12 TB RMAN full Backup by setting multichannel (for each RAC node), OPTIMIZATION ON worked with to set jumbo frames for backup network.
High Availability/Disaster Recovery:-
Implemented and tested DR solution (Standby database) to ensure recoverability within SLA.
Implemented and used flashback database, table, quires to ensure fast rollback turnover.
Implemented Data Guard broker across all the standby databases this simplified switchover.
Implemented Fast start failover feature for Standby database to minimize downtime for critical database.
Experience with uni/bi-directional replication via GoldenGate.
Implemented read-only services for the Active Data Guard environments for reporting purposes this offloaded lot of load from critical OLTP database.
IBM: ORACLE Core DBA – (March 2010 to April 2011)
Worked in IBM’s one of the biggest DATA Centers and provided oracle DBA support too many Fortune 500 companies.
Most of the databases/application were mission critical so high availability and consistent
Performance was DBA main goal.
Worked with clients (fortune 500 companies) to resolve their oracle Database issues.
Provided 24X7 DBA support to critical databases for fortune companies around 200 databases.
Ensure all major business impacting incidents have the appropriate levels of post mortem review and remediation to ensure there are no repeat incidents wherever possible. Engage the relevant teams and/or individuals.
Successfully installed and configured grid/rac infrastructure of Oracle 11g RAC.
Upgraded and implemented new features of 11GR2. Provided ASM administration as monitoring, adding, and removing disks.
Supported OLTP and OLAP databases. Responsible for administering day to day operations of all Oracle databases.
Performed database performance tuning using Explain Plan and Stats Pack, AWR, OEM GRID Control and Performance views.
Primarily responsible for creating, maintaining and managing highly visible production databases.
Takes ownership of day to day issues and escalations and brings issues to resolution.
Responsibilities also included installing, upgrading, patching, tuning, monitoring and troubleshooting databases with large amount of data and high transaction rates.
Resolved performance issues via AWR, ADDM, and Ash.
Tuned databases by resizing SGA, PGA, redo logs, temp and undo tablespaces.
Identified blocks, locks, waits and maintained statistics of the database and tuned them.
Applied both patches (CPUs and RDBMS) when appropriate.
Participated for DBA Team in all change management meetings to provide DBA input.
Implemented any Adhoc changes to database data.
Configured DB-link to get data from the remote databases.
Monitored disk space (track and trend space utilization). Made Raid level recommendations.
RAC Database creation, review and research of appropriate database configuration parameters.
Configured RMAN as backup method for oracle.
Refresh dev/test database via RMAN duplicate and EXPDP.
Utilized UNIX shell scripting and corn/scheduler to perform Automation of system related daily tasks.
Configured and managed standby databases.
Handle technical escalations during Critical incidents for Oracle databases.
Mentoring Junior DBA’s on process and giving technical guidance.
ACHIEVEMENTS IN THE PROJECT:
All the activities/processes are well documented and practiced.
Handled multiple successful major releases and got client appreciations for the same.
References: Available upon request
Contact this candidate