Resume of Rajesh Kshatriya

Yüklə 58,54 Kb.

tarix	27.12.2018
ölçüsü	58,54 Kb.
	#87647

EDUCATION

RAJESH KSHATRIYA

Email: r_kshatriya@yahoo.com

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 Passing
P.G.D.C.A	Faculty of Technology & Engineering, M. S. University	1996
B.Sc. ( Physics)	Faculty of Science, M. S. University	1995

CERTIFICATION COMPLETED

Name of Institution

Diploma or Certificate

Year of Completion

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 1^st 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 5^th 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.
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 and system resource availability and responded to system memory and data issues.
Expert with OEM Event and Job Managers, Change Manager, Diagnostics & Tuning Packs.

Company: Gujarat Infotech Ltd. Aug-1997 to May-1999

Client : Indian Petrochemical Corp. Ltd. (Aug-1997 to May-1999)
Role & Responsibility : Database Administrator

Working in 24x7 production environment and provided on-call and day-to-day support.
Installation and implementation of the Oracle7.3 on HP.
Manage the database for over 75G size.
Upgradation from Oracle 7.3 to Oracle8.0
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.
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 and system resource availability and responded to system memory and data issues.
Expert with OEM Event and Job Managers, Change Manager, Diagnostics & uning Packs.

Company: Sacred Step Data Network & Infotech Ltd. Dec-1996 to Jul-1997

Client : (Dec-1996 to Jul-1997)
Role & Responsibility : Jr. Oracle DBA & PL/SQL developer

Installation and implementation of the Oracle7.3 on Windows NT
This project incorporates all the inventory management facilities of a giant organization. All the transaction like GOODS RECEIPTS, GOODS ISSUE, GOODS PURCHASE have been developed. Reports were developed using SQL R/W 2.5. Main features of the system are Generation of up to date information regarding stock status, stock availability, stock consumption, minimum stock & the value of the stock.
System analysis and database design
Create scripts to load the data in to tables using SQL Loader
Population of database using SQL*Loader.
Oracle SQL Query optimization.
Evaluation on packages for higher performance using Explain Plan, sql*plus and tkprof
Performance analysis of different database objects
Development of the front-end functionality
Create various Stored Procedures and Database triggers

Yüklə 58,54 Kb.

Dostları ilə paylaş: