Manager Data
Resume:
Email: **********.****@*****.***
Contact: 630-***-****
SIVA PRASAD NANDI
SUMMARY
An excellent IT professional with 11 years of focused experience in various domains including banking, financial, telecom and manufacturing.
Extensive experience in relational database design, analysis, development, administration, implementation, trouble shooting and quality management.
Proficient in Oracle 9i/10g/11g/12c software installations, migrations, database capacity planning, automated backup implementations, Data Guard, disaster recovery management, performance tuning of Oracle 12c/11g/10g/9i databases on unix and windows NT platforms.
Experience in involving with architect group in designing the logical and physical model of the databases.
Thorough understanding of the Oracle data dictionary and internals.
Experience in oracle Golden Gate replication and administration tasks including setup of unidirectional and bidirectional replication across heterogeneous and homogeneous platforms.
Good experience in troubleshooting Golden Gate replication related issues at various process levels like extract, data pump, replicat, initial load, log dump and change synchronization.
Extensive experience in unix administration, shell scripting.
Experience on Oracle public cloud with full rack Exadata machines with RAC and RAC One node databases. Good understanding of Exadata architecture, administration and monitor Exadata machines using dcli and 12c cloud control.
Extensive experience in Data Guard setup, troubleshooting, switchover, failover, active Data Guard, fast start failover and snapshot standby databases.
Exceptional team player with excellent communication and interpersonal skills.
Experience of 24/7 production database support and on call support activities.
Experience in monitoring and optimizing the performance of the databases using OEM,AWR, ADDM,ASH,SQL tuning advisor, sql performance analyzer.
Oracle RAC DBA Experience:
Planning, developing, deploying and supporting of RAC/ASM environment for 10g, 11g and 12c versions.
Installing & configuring Oracle cluster ware & database software (troubleshooting using cluvfy & handling common issues that arise during integration, bugs, network issues, configuration files issues, OCR issue, de installation & clean-up of cluster ware).
Working experience with customers for different RAC related issues:[hang check timer, split brain, RAC recovery, ASM, OCR corruptions, voting disk loss & so on]
Backup and recovery issues related to corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Issues with block change tracking & flash recovery area.
Resolved/diagnosed node eviction issues.
Experience in clusterware, GI and database upgrades from 10g to 11g and 12c.
Experience in add/removal of nodes in cluster environment.
Oracle DBA Experience
Over 11 years of experience in Oracle DBA (12c/11g/10g/9i/) in production, development, and test environments.
Worked in 24x7 production environment and provided on-call and day-to-day support.
Involved in datacenter migration for storage change projects.
Migrated non-ASM single instance to ASM RAC Instance.
Strong troubleshooting, problem solving, analytical and design skills.
Expertise in Oracle enterprise manager (OEM 11g and 12c), TOAD, Sql Developer, Apex.
Experience in logical and physical design of databases for OLTP and data warehouse.
Expertise in handling very large database (VLDB) and OLTP environment.
Experience in database version upgrades from Oracle 9.x to Oracle 11.x and 12.x.
Expertise in performance tuning of production database towards optimal performance based on the changes in the database, storage structures, and application changes.
Experience in Oracle 12c/11g/10g/9i – installation and implementation of new features.
Experience in capacity planning, space management.
Expertise in Oracle backup & recovery using RMAN, user managed backup.
Experience on Oracle Golden Gate replication and Administration tasks.
Experience in EBS (R12.1), installations, custom environment creation, patching, cloning and administrations tasks related to oracle applications.
Experience in Oracle advanced compression, wallet management and transparent data encryption.
Experience in database security, auditing, FGA.
Experience in database cloning, refreshes across different environments.
Experience in database migrations using data pump, Exp/Imp, RMAN, transportable tablespaces, cross platform migrations.
EDUCATION
Bachelor of Engineering (B.E) in Computer Science & Engineering.
CERTIFICATIONS
Oracle Certified Professional (12c, 11g, 10g)
ITIL Foundation Level
TECHNICAL SKILLS
Hardware/OS : Linux, Windows, SUN Solaris, HP UX, IBM AIX,
Tools/ Utilities : Toad, Sql Developer, DBA Spot Light, RMAN, Commvault, OEM 11g,
12c, CHM, Cluvfy HPSM, Remedy, Clarify, Golden Gate
Databases : Oracle 12c/11g/10g/9i/
PROFESSIONAL EXPERIENCE
Client: Caterpillar, Morton, IL Jan-2016 to till date
Role: Sr. Oracle DBA (Global Information Services)
Responsibilities:
Upgrade of Oracle 10g/11g databases to Oracle 12c.
Carried out database backup & recovery using RMAN.
Patch deployment using provisioning and patching tool.
Migration of databases across data centers.
Provided DBA support to review and make database schema changes to Labware, CVTP, EQUIPMENTDATA and other mission critical applications.
Performed data extract, validation, standardization as needed and upload into Oracle database.
Carried out performance tuning and recommended solution to application teams.
Carried out Installation, configuration, upgrade, patching and support of Oracle databases.
Supported Oracle cloud database as service. Application developers can request and maintain their development database.
Configured Golden gate to maintain replication (change data capture) to other Oracle, MySQL and Microsoft SQL Server databases.
Involved in troubleshooting Golden Gate replication related issues related to Extract, Data pump, Replicat and worked on log dump utility.
Logical Data modeling and creating physical database designs using ERWIN.
Application database support by creating schemas, tablespaces, partitions, indexes, etc.
User access management by creating roles, views and object/system privileges.
Performance tuning by using EXPLAIN PLAN, SQL TRACE, AWR/ADDM reports, SQL Profiles and Advisors.
Database cloning using RMAN and schema refresh using data pump utilities.
Writing shell scripts to monitor activities like availability of database & listeners, space utilization, gathering statistics, index rebuilding etc.
Worked with Oracle support for product bug issues.
Supported Data Guard environments with active Data Guard.
Client: British Telecom May-2014 to Dec-2015
Role/Project: Senior IT Consultant (Wholesale)
Responsibilities:
Installation of Oracle 11g, 12c databases in standalone & RAC environments.
Worked on production/test environments supporting 24/7 and on call support for all production related issues.
Performed cluster ware upgrades and database upgrades from 10.x to 11.x and 11.2.x to 11.3.x including clusterware, GI and databases.
Managed Oracle restart environments.
Planning and implementation of security, backup and recovery strategies using RMAN and also commvault third party tool to administer all backup activities.
Managing users and resources, controlling user privileges, roles and auditing.
Working closely with application teams and supporting on various performance and configuration issues on day to day basis.
Worked on Data Guard, switchover and failover activities as part of disaster recovery management.
Monitoring of databases using enterprise manager cloud control 12c to analyze performance and to maintain availability of various targets in database servers.
Worked on Golden Gate replication setup for various wholesale applications, involved in administration and troubleshooting issues.
Applied quarterly GI PSU and Database PSU as per Oracle recommendations.
Client: Oracle, USA Oct-2012 to May-2014
Role: Oracle Cloud (Platform As Service) & Senior IT Consultant
Responsibilities:
Installation of Oracle 11g databases in standalone, RAC & RAC one node on Exadata environments
Database and GI patching on Exadata full rack and half rack environments.
Worked on public cloud Project supporting all databases related to Infrastructure which are hosed on Exadata systems.
Experience on RAC one node relocations, migrations.
Performed clusterware and database upgrades from 10.2 to 11g R2.
Involved in handling on apex and webLogic environments.
Implemented RMAN incrementally updatable backup strategy for cloud databases, TDE for all customer databases.
Performed disaster test cases across datacenters.
Worked on enterprise manager cloud control 12c which was used to manage all targets in Exadata machines.
Monitoring database performance of Infrastructure and customer databases.
Involved in Golden gate replication setup of unidirectional and bidirectional.
Managing users and resources, controlling user privileges, roles and auditing.
Worked on Data Guard builds, active Data Guard, switchover and failover activities.
Client: Dell International Services Apr-2009 to Oct-2012
Role/Project: DBA Advisor (Dell.com Support)
Responsibilities:
Installation of Oracle 9i, 10g, 11g databases.
Planning and implementing of security, backup and recovery strategies
Maintaining regular backup and recovery procedures
Supported data center migrations along with upgrades for huge databases.
Worked on data guard environment and performs quarterly switchover test for High availability testing activities.
Managing database environments like dev,sit,uat,perf,prod;
Monitoring database performance.
Applying patches to database including bug patches, one off patches, CPU Patches
Involved in troubleshooting of SQL query and performance tuning, database instance tuning, tuning memory allocation, tuning I/O, tuning contention, tuning related to sorts and free lists and check points.
Managing users, resources, controlling user privileges, roles and auditing.
Client: Fidelity Investments (USA) Feb-2007 to Apr-2009
Role/Project: Oracle DBA (FIIS-fidelity investments institutional services)
Responsibilities:
Installing of Oracle RDBMS software on various platforms(AIX,WINDOWS)
Worked on 10g Clusterware.
Performed upgrades of databases from 9i to 10G
Performed RMAN backup and recovery procedures with Tivoli storage manager.
Involved in migrating non ASM instance to ASM instance.
Applied one off and quarterly CPU patches.
Involved in database creation and reorganization
Performed database refreshes using export/import and RMAN.
Creating primary database structures, altering according to the user requirements.
Responsible for managing database files, schema objects, table spaces, objects and disk spaces.
Maintenance of development, production, QA test databases.
Automated RMAN backups and logical backups (export/import) Tasks.
Controlling and monitoring user access to database.
Client: Hitachi Global Storage Systems(USA) Dec-2005 to Jan-2007
Role: Oracle DBA
Plan,install, configure and performs patching, upgrades of Oracle RDBMS software on various platforms.(AIX/WINDOWS)
Database Creation and Reorganization
Allocating system storage and planning future storage requirements for the database system.
Modifying the database structures to accumulate application growth and maintain peak performance.
Responsible for managing database Files, schema objects table spaces, objects and disk spaces.
RMAN backup and recovery procedures with Tivoli storage manager.
Data Guard administration with a near site and a remote site standby database.
Automated RMAN and logical backup Tasks.
Involved in point in time recovery to restore database to an earlier point in time to restore customer data.
Controlling and monitoring user access to database.
Familiar with Import And export utilities
Performance tuning tasks including Regular analysis of database.
Experience on regular database tasks like index monitoring, row chaining, database links, tracing, explain plan, tkproof.
Contact this candidate