Oracle Management
Resume:
[pic]
Krishna K. Pingeli
H: 905-***-****
C: 416-***-****
Summary
. 12 years database administration experience in Oracle, MySQL, SqlServer,
Sybase, DB2, Teradata, Cassandra and PostgreSQL.
. Self-starter with strong leadership skills mentoring, guiding DBA teams
for 7 years.
. Strong Understanding with Linux, AIX, Solaris, HP-UX and Windows
platforms.
. Strong expertise in SDLC, developing logical and physical data models
using ERwin, reverse engineer databases into physical data models and
redesign application schemas, forward engineer data models to develop
application schemas.
. Self-starter with strong expertise in performance tuning including huge
pages configuration, backups and recovery.
. top notch exadata specialist with deep knowledge of exadata architecture
and internals having strong expertise in complete management of oracle
exadata racks: 8 node RAC's, ASM, Dataguard, GoldenGate, database nodes,
storage servers, Infiniband switches, exadata health check reports.
. Strong expertise in efficient redesign of grid disks relocating space
from one grid disk to another within same physical disk, redesign of ASM
diskgroups with no impact to any oracle application.
. strong expertise doing rolling upgrades of database nodes and cell nodes
to latest OS image, strong expertise upgrading and applying bundle
patches for grid infrastructure and database ORACLE_HOME's.
. strong expertise in consolidating, migrating standalone databases onto
exadata on dedicated diskgroups(each diskgroup scaled horizontally with
only one hard disk slot from each storage server for best protection and
best I/O performance) for each consolidated database using active
database duplication/rman tape backups, dataguard broker,srvctl
configuration with failover option on all other database nodes.
. strong expertise in setting up,rebuilding 100TB standby databases using
active database duplication and RMAN tape full/incremental backups.
. Strong expertise resolving all exadata incidents: ILOM faults, poor
performing flash disks, hard disks, storage cell issues, grid
infrastructure issues, database nodes issues.
. strong expertise scheduling, working with oracle field engineers in
preventive maintenances(batterty,flashcard), reactive failure incidents
for hard disks, flashcards, RAID adapter, battery etc.
Certifications
. Oracle Database 10g Administrator Certified Professional(2/16/2005)
. Oracle9i Database Administrator Certified Professional(3/19/2003)
. Oracle8i Certified Professional Database Administrator(1/10/2003)
PROFESSIONAL EXPERIENCE
Jan '14 - Present
Lead Database Administrator - Oracle/Exadata, Infrastructure platforms,
Blackberry, Mississauga, ON
. Leading team of 5 DBA's including 3 offshore DBA's in Asia mentoring,
training, guiding corporate DBA team in day-day corporate production
issues.
. Performed many migrations from one server to another with just 30 mins
downtime building dataguard standby using RMAN tape backups and active
database duplication and doing dataguard switchover.
. Completed oracle 11.2.0.4 upgrades for all corporate complex tier 1
applications.
. Managing very high performance demanding tier 1 corporate exadata
production environments: edw, customer analytics with 100TB database
size on each rack having oracle dataguard environments for both.
. Supporting oracle goldengate, MySQL, more than 150 standalone oracle
databases in addition to leading all 11 blackberry exadata machines.
. Performed many production point-in-time restore of application objects
from rman tape backups onto NFS and then extracting and reimporting
using DATAPUMP.
. Written Master RMAN backup scripts and pushed to database servers.
. Very efficient and aggressive in leading day-day issues and helping
other team members
. Managing oncall rotation and particated in oncall rotation for
production incidents.
. Managing grid infrastructure including ASM, OCR, voting disks, CRS
resources.
. Relocating OCR & Voting disks, SPFILE, Control files, redo members
reorg from one diskgroup to another as part of storage reorg and
diskgroups redesign.
. Troubleshooting and fixing all goldengate replication issues including
resync of goldengate tables.
. Managing databases in OEM Grid Control, resolving all application
issues, working with application and development teams.
. Exadata: reconfigured grid disks to make efficient use of storage,
upgraded grid infrastructure from 11.2.0.3 to 11.2.0.4, upgraded image
from 11.2.3.2.1 to 11.2.3.3.1 on all database and cell nodes for all
corporate exadata racks.
. Proposed oracle licensing costs reduction solution to senior
management by consolidating standlone databases onto exadata rack on
dedicated diskgroups with dedicated storage for best high availability
and best protection compared to VCS.
. Reclaimed all free exadata storage in all production exadata racks and
designed 12 ASM diskgroups per rack for exadata
migrations/consolidation with each diskgroup scaled horizontally with
only one hard disk slot from each storage server for best protection
and best I/O performance.
. Reduced oracle standalone servers footprint by 50% by
consolidating/Migrating small/medium standalone databases on newly
designed dedicated diskgroups using active database duplication/RMAN
tape backups, dataguard broker, srvctl configuration, dataguard
switchover with failover option on all 8 database nodes.
. Documented DBA standards and procedures in wiki including migrating
standalone databases onto exadata and Assisted DBA team in exadata
migrations.
Environment: Oracle, MySQL, Oracle GoldenGate, Oracle Exadata
11.2.3.2.1/11.2.3.3.1, Linux, OEM 12C
Jul '12 - Dec '13
Senior DBA, IT Database Operations, Blackberry, Mississauga, ON
. Supported corporate production applications: single handedly managed 7
Exadata racks without any training from day one which includes exadata
storage servers, database servers, grid infrastructure for all
corporate exadata racks.
. Technical expert in the team mentoring and guiding DBA team on day-day
production issues, RMAN restores, physical/logical standby builds.
. Exadata database nodes: upgraded and patched 8-Node RAC grid
infrastructure environments from 11.2.0.2 to 11.2.0.3 without any
database downtime, upgraded and patched 8-Node RAC databases from
11.2.0.2 to 11.2.0.3 with 40 mins database downtime, Applied rolling
YUM patches and upgraded image to 11.2.3.2.1 on all compute nodes for
7 exadata rack environments, troubleshooted and fixed all exadata grid
infrastructure issues, worked with oracle field engineers and replaced
batteries on all exadata compute nodes, setup and configured DBFS
databases on all exadata environments.
. Exadata cell nodes: upgraded all cell nodes to 11.2.3.2.1 for 7
exadata rack environments, worked with oracle field engineers and
replaced batteries, flash cards, hard disks, RAID adapters,
troubleshooted and fixed all cell nodes issues on all 7 exadata
machines. Resized griddisks and reorged space from one diskgroup to
another without any downtime, rebuilt entire cell node from scratch
and reclaimed lost redundancy after super block corruption in system
drive(slot 0,1) caused cell bootup failures for tier 1
application(pcinf).
. Setup and configured MYSQL environments and supported MYSQL
applications.
. Supported many other oracle NON-RAC environments including goldengate,
logical/physical dataguard environments, migrated oracle applications
to Exadata.
. Rebuilt many VLDB standby databases using active database duplication,
traditional methods. Troubleshooted and fixed dataguard issues.
Environment: Oracle 11.2.0.3, MySQL 5.5, Oracle GoldenGate 11.1.1.1.2,
Oracle Exadata 11.2.2.4.2/11.2.3.2.1, Linux, OEM 12c, RAC,
Logical/Physical standby
May '10 - May '12
Senior DBA Consultant, Rogers, Brampton, ON
. Supported over 500 database servers in Oracle, Sybase, SQL Server on
AIX, HP-UX, Solaris, Linux, windows platforms.
. Installed Oracle, created, upgraded, migrated, cloned databases (9i to
10g, 10g to 11g) including RAC/DataGuard/ASM and migrations from one
OS platform to another including non-ASM to ASM for several
applications and for very large databases, Applied Quarterly PSU
Patches for oracle 10g/11g databases.
. Played a lead role in resolving performance issues and assisted DBA
team in troubleshooting database issues for several applications.
. Performed heavy SQL tuning, Instance tuning for several applications,
supported Very large databases starting from SDLC including terabyte
size tables having billions rows tables, implemented Oracle
compression feature for very large tables and saved lot of storage,
performed major data purges and conversions from non-partitioned to
partitioned tables.
. Configured and implemented RMAN tape & disk backups, performed several
point in time Database restores from RMAN tape backups.
. Schema reorganization, Schema management, Space Management, refreshed
schemas, managed oracle wallets & Certificates, ran RCU utility to
create SOA schemas, applied SQL patches.
. Setup GoldenGate tables replication between Oracle and Teradata for
EDW and troubleshooted replication issues.
. Installed Oracle grid control agent on database servers to monitor
databases.
. Installed, configured, patched, cloned, monitored oracle applications.
. Supported Sybase & SQL Server instances including installation,
upgrades, migrations, backups, loads, SQL patches, performance tuning
of instances and sql tuning.
. Supported Sybase & SQL Server instances in clustered and replicated
environments.
. Provided 24x7 oncall support on a rotation basis with DBA team.
ENVIRONMENT:Oracle11.2.0.3/11.1.0.7/10.2.0.5/9.2.0.8,RAC,DataGuard, ASM,
Oracle Golden Gate, SQLServer 2000/2005/2008 R2, Sybase ASE
12.5/15/15.5/15.7, AIX5.3/6.1,Solaris10,HP-UX,Linux,windows,Power Shell
Jun '09 - Jan '10
Senior DBA Consultant, Wellsfargo, San Francisco, CA
. Installed oracle, created, configured, upgraded, migrated, cloned
databases including RAC/DATAGUARD/ASM, applied PSU patches.
. Performed Data Guard switchover, failover exercises in standby
environment.
. Configured and implemented RMAN tape & disk backups, performed several
point in time Database restores from RMAN tape backups.
. Performed heavy Instance tuning, SQL tuning for several applications.
. Schema reorganization, Schema management, Space Management, cloned
schemas, applied SQL patches.
. Supported Sybase & SQL Server instances including installation,
upgrades, migrations, backups, loads, performance tuning of instances
and sql tuning.
. Managed database security and moved data using export/import/load
utilities.
. Provided 24x7 oncall support on a rotation basis with DBA team.
ENVIRONMENT: ORACLE 11.1.0.7/10.2.0.4/9.2.0.8, Data Guard, RAC, ASM, OEM
Grid Control, Autosys, SQL Server 2000/2005/2008, Sybase ASE 12.5/15,
Solaris, AIX,Linux, Windows,DB2 9.5
Jan '09 - May '09
Senior DBA Consultant, KLA Tencor, Milpitas, CA
. Installed oracle, created, configured, upgraded, migrated, cloned
databases, applied PSU patches.
. Migrated DATAGUARD environment for 8 SAP Application databases over
WAN from Sacramento to Singapore which include couple of 1 TB
databases, performed load tests, configured socket buffer size
settings, Monitored and optimized network performance, log shipping
performance between primary and standby databases over WAN.
. Written shell scripts for automating DBA tasks, event notifications.
ENVIRONMENT: ORACLE 11.1.0.7/10.2.0.4/9.2.0.8, Data Guard, Solaris 8/10,
AppWorx, SAP Basis
Jul '07 - Dec '08
Senior DBA Consultant, Wellsfargo, San Francisco, CA
. Installed oracle, created, configured, upgraded, migrated, cloned
databases including RAC/DATAGUARD/ASM, applied PSU patches.
. Performed Data Guard switchover, failover exercises on a periodic
basis in standby environment as per application requirements.
. Configured and implemented RMAN tape & disk backups, performed
several point in time Database restores from RMAN tape backups.
. Performed heavy Instance tuning, SQL tuning for several applications.
. Schema reorganization, Schema management, Space Management, cloned
schemas, applied SQL patches.
. Supported Sybase & SQL Server instances including installation,
upgrades, migrations, backups, loads, performance tuning of instances
and sql tuning.
. Provided 24x7 oncall support on a rotation basis with DBA team.
. Configured huge memory for 32-bit Linux servers for larger SGA to
resolve performance issues.
. Installed OEM agents on the oracle servers for Grid control
monitoring.
. Installed, Configured, patched, cloned, monitored oracle applications.
. Migrated Oracle applications database from single node to 6-node RAC
cluster in production environment and from single node to 4-node RAC
in non-production environment for HR application.
ENVIRONMENT: ORACLE 11.1.0.6/10.2.0.4/9.2.0.8 OEM Grid Control 10.2.0.4,
RAC, Data Guard, ASM, Linux x86/x86-64, Solaris, HP-UX, Windows
2000/2003/NT, TOAD, Autosys, Sybase ASE 12.5/15, DB2 9.1/9.5, SQL Server
2000/2005
Feb '07 - Jul '07
Senior DBA Consultant, Broadridge, San Francisco, CA
. Installed oracle, created, configured, upgraded, migrated, cloned
databases including RAC/DATAGUARD/ASM, applied PSU patches.
. Installed and setup Grid control server at the enterprise level and
monitored all database servers.
. Configured huge memory for 32-bit Linux servers for larger SGA to
resolve performance issues.
. Performed Data Guard switchover, failover exercises on a periodic
basis in standby environment as per application requirements.
. Configured and implemented RMAN tape & disk backups, performed
several point in time Database restores from RMAN tape backups.
. Performed heavy Instance tuning, SQL tuning for several applications.
. Schema reorganization, Schema management, Space Management, cloned
schemas, applied SQL patches.
. Provided 24x7 oncall support on a rotation basis with DBA team.
ENVIRONMENT: ORACLE 10.2.0.3/9.2.0.8, OEM Grid Control, Linux x86/x86-
64(RH4, Fedora Core6), Solaris 5.9, AIX 5.2, SQL Server 2000/2005, Sybase
ASE 12.5/15
Aug '06 - Feb '07
Senior DBA Consultant, Patni Computers, San Francisco, CA
. Installed oracle, created, configured, upgraded, migrated, cloned
databases including RAC/DATAGUARD/ASM, applied PSU patches.
. Installed and setup Grid control server at the enterprise level and
monitored all database servers.
. Configured huge memory for 32-bit Linux servers for larger SGA to
resolve performance issues.
. Configured and implemented RMAN tape & disk backups, performed several
point in time Database restores from RMAN tape backups.
. Performed heavy Instance tuning, SQL tuning for several applications.
. Implemented CDC in ODS environment to capture DML changes from OLTP
databases.
. Performed index monitoring and helped improve performance of queries
using proper indexing strategy by interpreting explain plan and
evaluating indexing reports.
. Generated & interpreted explain plan and tuned SQL queries.
. Written shell scripts for monitoring and to generate business reports.
. Provided 24x7 support on a rotation basis with another DBA.
ENVIRONMENT: ORACLE 10.2.0.2/9.2.0.8, RAC, Data Guard, OWB, HP-UX, TOAD,
Linux, Windows 2000.
Dec '05 - Jul '06
Oracle DBA Consultant, T-Mobile, Bothell, WA
. Installed oracle, created, configured, upgraded, migrated, cloned
databases including RAC/DATAGUARD/ASM, applied CPU patches.
. Installed and setup Grid control server at the enterprise level and
monitored all database servers.
. Configured and implemented RMAN tape & disk backups, performed several
point in time Database restores from RMAN tape backups.
. Performed heavy Instance tuning, SQL tuning for several applications.
. Handled about 100-150 VLDB which varies from 1TB to 2TB in size in
various environments (Production, various Test environments (PET,
QPET, ZPET, NPET, SPET) and development servers.
. Supported and maintained Oracle TIMESTEN databases.
. Monitored Tablespace growth using shell scripts, requested LV's,
created soft links, added datafiles.
. Implemented database auditing & security in all production databases.
. Monitored Oracle databases using OEM 10g Grid Control.
ENVIRONMENT: HP-UX, ORACLE 10.2.0.1/9.2.0.7/8.1.7.4, Timesten, Data Guard,
DataMirror, TOAD, OEM 10g Grid Control.
Jan '05 - Nov '05
DBA/Data Modeler/Data Architect Consultant, Citi Holdings, Orange County,
CA
. Involved in SDLC, Gathered business and system requirements, designed
logical model and converted into physical database design.
. Worked on Database change requests and updated Erwin models.
. Reviewed logical and physical models and created DBCR's for the
changes required.
. Enforced Physical Modeling standards in naming Objects, Constraints,
Sequences, Tablespaces, schemas etc.
. Generated DDL scripts from Erwin Physical Models by forward
engineering and deployed full and Incremental scripts into all
environments.
. Installed oracle, created, configured, upgraded, migrated, cloned
databases.
. Configured and implemented RMAN tape & disk backups, performed several
point in time Database restores from RMAN tape backups.
. Performed heavy Instance tuning, SQL tuning for several applications.
. Schema reorganization, Schema management, Space Management, cloned
schemas, applied SQL patches.
. Supported SQL Server instances including installation, upgrades,
migrations, backups, loads, performance tuning of instances and sql
tuning.
. Provided 24x7 oncall support on a rotation basis with DBA team.
ENVIRONMENT: SQL Server 2000/2005, ORACLE 9.2.0.6/10.1.0.4, RAC, HP-UX, Linux, Windows2000/2003/NT, Erwin, Rational ClearCase,
Rational ClearQuest.
Apr '04 - Dec '04
DBA Consultant, Speedway Corporation, Enon, OH
. Installed oracle, created, configured, upgraded, migrated, cloned
databases including RAC and migrations from single node to 2-node RAC.
. Performed heavy Instance tuning, SQL tuning for several applications.
. Schema reorganization, Schema management, Space Management, cloned
schemas, applied SQL patches.
. Mentored DBA's and developers did knowledge transfer about RAC and
documented all the implementation procedures.
. Configured RMAN with OEM for backup, tested and implemented recovery
procedures.
. Supported SQL Server instances including installation, upgrades,
migrations, backups, loads, SQL patches, performance tuning of
instances and sql tuning.
ENVIRONMENT: ORACLE 9.2.0.5, RAC, AIX 5.2, Windows 2000/2003/NT, Hitachi
SAN, SQL Server 2000
Mar '03 - Mar '04
DBA/Data Architect Consultant, Avery Dennison, Framingham, MA
. Migrated different legacy systems (Sybase, FoxPro, SqlServer, Ms-
Access, Oracle Apps) to Oracle Server by Reverse Engineering into
ERwin Model, source to target mapping of columns, and documented the
model like table and column definitions, enforcing constraints,
validating primary keys with the application group.
. Loaded flat files data from these legacy systems into oracle database
using SQL*Loader.
. Managed all the data models from the legacy systems using Model Mart
repository.
. Installed oracle, created, configured, upgraded, migrated, cloned
databases.
. Configured and implemented RMAN tape & disk backups, performed several
point in time Database restores from RMAN tape backups.
. Performed heavy Instance tuning, SQL tuning for several applications.
. Schema reorganization, Schema management, Space Management, cloned
schemas, applied SQL patches.
. Written backup, database monitoring, event notification shell scripts
in various environments.
. Supported SQL Server instances including installation, upgrades,
migrations, backups, loads, performance tuning of instances and sql
tuning.
. Provided 24x7 oncall support on a rotation basis with DBA team.
ENVIRONMENT: ORACLE 9.2.0.3, Windows 2000, HP-UX, TOAD, ERwin 4.1.4.3,
SQL*Loader, RMAN, OEM, OMS, SQL Server 2000, Sybase ASE 11.9.2/12/12.5.
Jan '02 - Feb '03
Oracle DBA Consultant, Bellsouth, Birmingham, AL
. Installed oracle, created, configured, upgraded, migrated, cloned
databases.
. Configured and implemented RMAN tape & disk backups, performed several
point in time Database restores from RMAN tape backups.
. Performed heavy Instance tuning, SQL tuning for several applications.
. Schema reorganization, Schema management, Space Management, cloned
schemas, applied SQL patches.
. Written backup, database monitoring, event notification shell scripts
in various environments.
. Designed logical & physical data models using ERWIN tool.
ENVIRONMENT: ORACLE 8.1.4.7, 9.2.0.3, RAC, Data Guard, Solaris, ERWIN
3.1.5.2, TOAD, Sql-backtrack, Sun cluster, CCC Harvest Workbench.
Jan '01 - Dec '01
GPSI, Illinois department of Transportation, Springfield, IL
. Reverse Engineered old legacy systems into Erwin model and documented
the model with the help of Legacy application team.
. Redesigned all the objects in the model, refined all the undefined
Referential Integrity constraints.
. Enforced Physical Modeling standards for all Owners, Tablespaces,
Objects and Sequences etc.
. Created Oracle standard scripts for tablespaces, schemas and user
grants and deployed objects into various database environments.
. Generated Forward Engineering script from Erwin Model and deployed
into various environments.
. Loaded data from flat files into oracle databases using SQL *Loader.
. Designed database objects using various Normalization techniques.
. Involved in the system Integration of various legacy systems to create
a master database.
. Migrated data from one environment to another using exp/imp
techniques.
. Generated reports using Erwin Report Template Builder for all objects
and validated with the application team.
ENVIRONMENT: ORACLE 8.1.4.7, Erwin 3.1.5.2, TOAD, Windows 2000.
Education:
Masters degree in Computer Science, University of Illinois at Springfield,
Springfield, Illinois (Aug '00 - Dec '01)
Bachelor's degree in Mechanical Engineering, Osmania University, Hyderabad,
India (Sep '96 - May '00)
Diploma in software applications, VJ Infosystems Limited, Hyderabad, India
(Sep '97 - Dec '98)
Certifications:
Oracle8i Certified Professional Database Administrator (01/19/2003)
. Introduction to Oracle: SQL and PL/SQL Score: 50/57
REGISTRATION NUMBER: I6CDTT00F8
. Oracle 8i: Architecture and Administration Score: 53/64
REGISTRATION NUMBER: IB6DTT5335
. Oracle 8i: Backup and Recovery Score: 54/60
REGISTRATION NUMBER: IC8DTT5124
. Oracle 8i: Performance Tuning Score: 53/57
REGISTRATION NUMBER: ID6DTT5000
. Oracle 8i: Network Administration Score: 49/59
REGISTRATION NUMBER: ID6DTT5002
Oracle 9i database administrator certified Professional (03/19/2003)
. Oracle 9i: New Features for Administrators Score: 47/53
REGISTRATION NUMBER: ID6DTT5003
Oracle Database 10g Administrator Certified Professional (02/16/2005)
. Oracle Database 10g: New Features for Administrators Score: 55/61
REGISTRATION NUMBER: L8CDTT5449
IBM Certified Database Associate - DB2 10.1 Fundamentals
IBM, License Candidate ID : SR3962287 Registration Number: W76DTT507C
Personal Milestones:
Finished the 2002 Chicago Marathon in 3:59:59
Finished the 2002, 2003 Lincoln Memorial Half-Marathons in 1:47
Contact this candidate