RAJESH KSHATRIYA
Email:
908-642-8914 (Cell)
EXPERIENCE SUMMARY:
Have over 15 years of focused experience in IT industry in various fields like banking, insurance, financial, retail and manufacturing. Extensive experience in relational database design, analysis, modeling, development, administration, implementation, trouble shooting and quality management. Comprehensive experience as Oracle DBA; proficient in Oracle 7/8/8i/9i/10g/11g Software Installations, Migrations, Database Capacity Planning, Automated Backup Implementation, Tuning Oracle 11g/10g/9i/8i/8.x/7.x on Unix and Windows NT platform. Involved with architect group in designing the logical and physical model of the databases. Thorough understanding of the Oracle data dictionary. Have good experience in UNIX administration, Shell scripting. Have impeccable communication and interpersonal skills and an exceptional team player. Managing the team of Oracle DBAs and actively coordinated with the end user community.
EDUCATION
Title of the Degree with Branch / College/University / Year of PassingP.G.D.C.A / Faculty of Technology & Engineering, M. S. University / 1996
B.Sc. ( Physics) / Faculty of Science, M. S. University / 1995
CERTIFICATION COMPLETED
No / Name of Institution / Diploma or Certificate / Year of Completion1 / Oracle Corporation / OCP DBA / 2001
SKILLS PROFILE:
Hardware : SUN Sparc Series, HP9000, IBM 7040-681, IBM 9119-595, Pentium Servers
and PC's
Operating System: UNIX (SUN Sparc Solaris 2.6/2.7/2.8,9,10, HP-UX 9.x, AIX 5.3,5.2,5.1,4.3),
Windows XP/2000/NT/98/95
Tools / Utilities: DBArtisan, Erwin 3.5.2 /4.0 TOAD, SQL Station 5.0, Informatica 5.1,
Quest Soft ware Tools (Spot light, SQL Lab Vision, Storage and Performance Management) Recovery Manager, Tivoli ADSM version 4.21 for oracle on AIX, Veritas NetBackup (3.5,4.0,4.5) for oracle on Solaris and NT, DBverify, Exp/Imp, expdp/impdp, Server Manager, SQL * Loader, TKPROF, Log Minor, Statpack and Oracle Enterprise Manager grid control
Languages : UNIX shell programming, PL/SQL
Database : ORACLE 11g/10g/9i/8i/ 8.x/ 7.x on UNIX and NT
Oracle RAC DBA Experience
· Architecting, planning, designing, developing, deploying and supporting RAC/ASM environment
· Installing & configuring Oracle clusterware & 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 clusterware)
· Testing and benchmarked the application prior to going into production to determine its effects on GES and GCS with special focus on load testing for interconnect traffic.
· Worked with customer for different RAC related issue :[hangcheck timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss & so on]
· Troubleshoot performance issues for the RAC instances (GC events)
· Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Also used the Merge backup for backing terabyte databases. Issues with block change tracking & also flash recovery area.
· Resolved/Diagnose Node Eviction.
· Upgrade of 10g R2 RAC to 11g R2 RAC
· Add or Remove Node from RAC.
Oracle DBA Experience
· Over 15 years of experience in as an Oracle DBA (11g/10g/9i/8i/8.0.x/7.x) in Production and Development environment.
· Worked in 24x7 production environment and provided on-call and day-to-day support.
· Datacenter Migration between NewYork to Manroe for All oracle databases for Barnes & Noble.
· Datacenter Migration between Denver to boulder for all oracle databases for ABG (Avis Budget Group).
· Migrated Non-ASM Single Instance to ASM RAC Instance.
· Used BCV split/Data Guard technology to migrate over 13 TB Database.
· Supporting Data Warehouse Database i.e. over 30 TB in size.
· Manage RAC environment for Day to Day Database administrator, Performance Tuning.
· Migrate over 3 TB data from Across the Platform ( From Solaris to AIX)
· Strong trouble shooting, problem solving, analytical and design skills.
· Expertise in Oracle 8i database replication, Expertise in Oracle 11g/10g/9i/8i Data Guard and standby databases, Snapshot maintenance and creation
· Expertise in Oracle Enterprise Manager (OEM), TOAD, ERwin
· 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 Migration of Oracle 7.x to Oracle 8.x to Oracle 8i to Oracle 9i
· Expertise in Performance tuning the production database towards optimal performance based on the changes in the database storage structures due to application change requirements. Monitoring and optimizing the performance of the Database through Database Tuning – Tuning Applications, Tuning Memory, Tuning Disk Usage, Tuning OS
· Experience in Oracle 9i/8i/8.x/7x – Installation, Migration and implemented new features.
· Experience in capacity planning, space management, database upgrades/migration
· Experience in working with RAID environment.
· Experience in clustered databases using AIX HACMP technology and Veritas Cluster on Solaris 8.
· 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.
· Oracle Certified Professional (OCP) for DBA
· Good knowledge of UNIX Administrator for the Linux, Sun Solaris 2.7/2.8 & AIX 4.3/5.1
· Database population using SQL*Loader
· Creating and maintaining logins, synonyms and access privileges using roles, controlling access to the database using operating system and Oracle security features.
UNIX Admin Experience
Installation, Disk partition, Unix File Systems, Auto mounting, Patch/ package installations, file system backups and administration.
PROFESSIONAL EXPERIENCE
· Company : Barnes & Noble Apr-2010 – Till Date
Þ Role & Responsibility : Sr. Database Administrator
Ø As a Sr. Database Administrator, I am Responsible for administration of all Oracle Databases at B&N.
Ø Design and implemented Data Center migration for over 18 TB EDW databases.
Ø Upgraded 10.2.0.4 Two Node RAC ASM Database to 11g R2 Two Node RAC ASM
Ø Advanced Backup and Recovery using Oracle’s RMAN software; used offline/online for recovery in a production environment via Korn shell scripting.
Ø 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.
Ø Data center Migration using Data Guard.
Ø Implemented TimesTen (In memory Database) for Personalization and Recommendation project.
Ø Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
Ø Supporting Nook Devices from 1st generation to Nook Tablet.
Ø Implemented BNCLOUD Database to support devices.
Ø Strategic involvement with team for Server virtualization and manageability of infrastructure.
Ø Implemented Stream, Golden Gates for Active-Active Replication between the Datacenter for High Availability.
Ø Currently helping team to use existing infrastructure to achieve Maximum benefit to reduce cost and maximum performance.
Ø Actively working with other teams for Server Consolidation & Database Consolidation.
Ø Changes were made dynamically whenever possible to fulfill high-availability requirements.
Ø Enforced need of regular data purging processes from production, design and development, to deployment.
Ø Implemented and maintained Oracle 10g/11g Data Guard/standby databases for fail-over purposes.
Ø Propagation from primary to standby via automated scripts, and sometimes uses standby databases to immediately restore primary database.
Ø Experience with ‘graceful’ switchover and switchback between primary and standby databases.
Ø Replicated to a disaster recovery site for increased server manageability and availability.
Ø Participated in development of enterprise-wide security standard methodology, and ongoing deployment.
Ø Installation of RAC and Managing RAC Environment efficiently
Ø Proficient in RAC Performance Tuning.
Ø Create and maintain materialized views.
Ø 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 freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
Ø Monitored the production Oracle alert logs for database errors.
Ø Monitored system resource availability and responded to system memory and data issues.
Ø Expert with OEM Grid Control.
· Company : Cognizant Technology Solution May-2000 to Apr-2010
Þ Client : MetLife (June-2002 to Apr-2010)
Þ Role & Responsibility : Lead Oracle DBA
Ø As a Lead Database Administrator, I am Responsible for administration of over 300 Oracle databases.
Ø Leading the Team of 15 DBAs.
Ø Design and implemented Data Center migration for over 13 TB EDW databases.
Ø We have converted Single Node Non-ASM Database to 2 Node RAC ASM Database. We achieved this using Data Guard.
Ø Upgraded 10.2.0.4 Two Node RAC ASM Database to 11g R2 Two Node RAC ASM
Ø Advanced Backup and Recovery using Oracle’s RMAN software; used offline/online for recovery in a production environment via Korn shell scripting.
Ø 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.
Ø Migrate over 13 TB data using Data Guard Technology.
Ø Supporting Data Warehouse Database i.e. over 13 TB in size.
Ø Installation of Oracle & create clustered databases using AIX HACMP technology and Veritas Cluster on Solaris 9.
Ø Strategic involvement with client for Server virtualization and manageability of infrastructure.
Ø We are implementing Solaris Containers to achieve Server Virtualization.
Ø Currently helping client to use existing infrastructure to achieve Maximum benefit to reduce cost and maximum performance.
Ø Actively working with client for Server Consolidation & Database Consolidation.
Ø Changes were made dynamically whenever possible to fulfill high-availability requirements.
Ø Enforced need of regular data purging processes from production, design and development, to deployment.
Ø Implemented and maintained Oracle 10g Data Guard/standby databases for fail-over purposes.
Ø Propagation from primary to standby via automated scripts, and sometimes uses standby databases to immediately restore primary database.
Ø Experience with ‘graceful’ switchover and switchback between primary and standby databases.
Ø Replicated to a disaster recovery site for increased server manageability and availability.
Ø Participated in development of enterprise-wide security standard methodology, and ongoing deployment.
Ø Installation of RAC and Managing RAC Environment efficiently
Ø Proficient in RAC Performance Tuning.
Ø Create and maintain materialized views.
Ø 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 freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
Ø Monitored the production Oracle alert logs for database errors.
Ø Monitored system resource availability and responded to system memory and data issues.
Ø Expert with OEM Grid Control.
Þ Client : Providian (Aug-2001 to June-2002)
Þ Role & Responsibility : Sr. Database Administrator
Ø As a Sr. Database Administrator, I am Responsible for administration of 10 Oracle databases.
Ø Working in 24x7 production environment and provided on-call and day-to-day support.
Ø Providian is the 5th largest Financial Credit card firm in USA.
Ø Sales Performance Analysis and Bench marking. Identify the bottleneck of Performance of the existing sales System; build using Oracle 8.1.6 as a database. The back office system for processing of credit cards.
Ø Installation and implementation of the Oracle8.1.6 on Sun Solaris.
Ø Advanced Backup and Recovery using Oracle’s RMAN software; used offline/online for recovery in a production environment via Korn shell scripting.
Ø Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
Ø Changes were made dynamically whenever possible to fulfill high-availability requirements.
Ø Maintained standby databases, in both local and remote locations, for fail-over purposes.
Ø Replicated to a disaster recovery site for increased server manageability and availability.
Ø 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 freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
Ø Monitored the production Oracle alert logs for database errors.
Ø Monitored system resource availability and responded to system memory and data issues.
Ø Expert with OEM Diagnostics & Tuning Packs.
Þ Client : Robert Half International (RHI) (May-2000 to Aug-2001)
Þ Role & Responsibility : Sr. Database Administrator
Ø Installation and implementation of the Oracle8.1.5 on Sun Solaris.
Ø Manage the database for over 100G size.
Ø Implement the automated Hot Backup scripts for the Daily full backup created in Korn Shell.
Ø Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
Ø Upgradation from Oracle 8.1.5 to Oracle8.1.6
Ø Changes were made dynamically whenever possible to fulfill high-availability requirements.
Ø Maintained standby databases, in both local and remote locations, for fail-over purposes.
Ø Replicated to a disaster recovery site for increased server manageability and availability.
Ø 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 freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
Ø Expert with OEM Event and Job Managers, Change Manager, Diagnostics & Tuning Packs.
· Company: KPIT systems Ltd. June-1999 to May-2000
Þ Client : Forbes Marshal (June-1999 to May-2000)
Þ Role & Responsibility : Database Administrator
Ø Installation and implementation of the Oracle8.1.5 on Sun Solaris & Windows NT 4.0
Ø Manage the database for over 40G size.
Ø Implement the automated Hot Backup scripts for the Daily full backup created in Korn Shell.