Rajeev Rajput

** ****** **, ******** ***, NJ ****2

acg0nb@r.postjobfree.com

732-***-****

SUMMARY

A dynamic and innovative hands-on Senior Principal Database Administrator/Architect and Subject Matter Expert with

more than a decade of experience with focus on database design, advanced performance tuning, high performance data

replication, backup and recovery, and business continuity/disaster recovery using Oracle 11gR2 RAC, ASM, EXADATA,

DataGuard, OEM. Resolved highly technical and complex database and infrastructure related issues before they

impact production and business.

PROFESSIONAL EXPERIENCE

J.P. Morgan Chase & Co 11/13 to Present

Sr. Principal Database & Performance Tuning Consultant in High Availability & Resiliency and SWAT Team

• Developed Database Assessment Standards related to Audit, Resiliency and Availability.

• Pro-active deep-dive in-depth reviews, identify risk items in risk register and schedule remediation

• Architected both Infrastructure and Database Resilient Solutions for Critical Applications running on Oracle,

MSSQL – MSCS for local HA and ASYNC database mirroring for DR and Sybase – ASYNC database replication

using log shipping or replication server, choice driven by RTO/RPO and out-of-region requirements.

• Developed methodology and procedures for assessment & evaluation of database related to

Resiliency/Availability gaps within the production estate crown Jewels Applications – Swiftbus, PRPC, BaNCS,

Access Portal, Cash Reporting, ANG, Fircosoft, GCA, iBus, iDDA, iPay, JPM Network Engine, Liquidity Central,

iBus,Zengin, GSM, DUO and many more.

• Provide Oracle database services to application development on all aspects of database performance issues,

database tuning, database configuration, database migration, database layout, high availability, disaster recovery,

database security – audit vault and vendor interactions in line with corporate objectives.

• Familiarity with GTI Database & Pattern Engineering Solution Documents to ensure standard configuration are

configured through OEM and DB Portal

SIRIUS XM Radio Inc. 10/11 to 10/13

Sr. Principal Database Architect /Performance Tuning Expert

• Developed and implemented a technically challenging solution to migrate & consolidate two 15 TB 10g databases

to Linux using 11gR2 RAC-ASM, DataGuard, Linux with SGA size of 420GB and a very complex custom

innovative procedure utilizing many shell scripts, Datapump jobs, concurrent parallel index rebuilds and gather

stats for over 1000+ objects in under 10 hrs. and saved the company millions of dollars.

• Architected migration of SQL server databases using backup and restore, copy database wizard using SQL server

Management Studio and generate the create script using generate Script Wizard(SSMS).

• Lead, manage and provide Oracle database services to application development on all aspects of database

performance issues, database tuning, database configuration, database migration, database layout, high

availability, disaster recovery, database security – audit vault and vendor interactions in line with corporate

objectives.

• Work with infrastructure providers to ensure installation of Hardware, Network, Storage, Middleware, Application

configuration & Installation, Operating systems infrastructure meet the on-going needs of Business and

Application Development teams in terms of performance and security.

• Lead and coordinate the remediation of database audit points, infrastructure security compliance, SOX and DBMS

exception process and resolutions to ensure continuing compliance against audit points and policies, and to

prevent repeat audit points.

• Review capacity planning and sizing documents and provide recommendations for capacity planning and tending

reviews of all oracle databases. Project Estimation process - including attending project kick-offs and reviews as

necessary to appropriately size new environments, recommend & justify infrastructure solutions and deliver

associated cost and resource effort estimates

CREDIT SUISSE 9/08 to 9/11

Consultant/Sr. Oracle Database Administrator Architect

• Provide leadership in the design, architecture of corporate large scale Oracle database infrastructures with a

focus on innovating ways to reduce overall database footprint through Host consolidation on x86 hardware

architectures - EXADATA, CISCO UCS Blade Server 11gR2 RAC, Instance Caging, IO Resource Manager, LPAR

and isolation through Oracle Instance Caging, Oracle VM, VMWare that increases ROI, reduces TCO and meets

the upcoming demand

• Lead, manage and completed EXADATA Proof Of Concept (POC) evaluation and recommendations. Key tasks

included measuring and validating database performance and code scalability using Benchmark Factory(BMF),

migrating current database to X2 Quarter/Half Rack, two six-core Intel® Xeon® X5670 processors running at 2.93

GHz, 96 GB memory, capacity of 600 GB 10,000 RPM High Performance SAS disks, two 40 Gb/second

InfiniBand ports and Smart Flash Cache.

• Lead, manage and provide Oracle database services to application development on all aspects of database

performance issues including troubleshooting WebLogic, Apache, database tuning, database configuration,

database migration, database layout, high availability, disaster recovery, database security and vendor

interactions in line with corporate objectives.

• Work with infrastructure providers to ensure installation of Hardware, Network, Storage, Permissioning and

Operating systems infrastructure meet the on-going needs of Business and Application Dev. in terms of

performance and security.

• Lead and coordinate the remediation of database audit points, infrastructure security compliance, SOX and DBMS

exception process and resolutions to ensure continuing compliance against audit points and policies, and to

prevent repeat audit points.

Merrill Lynch/Bank of America 4/97 to 9/08

Lead Oracle DBA

• Provided on-going Support to Global Wealth Management (GWM) Single Client Profile (SCP) and Hub Online

Projects using Oracle 10gR2 on Sun Solaris 5.10 and Siperian MDM (Master Data Management) Hub with over

3TB of data and 18 Database instances supporting release trains like Dev, SE, IDE, QA, UAT, and Production

database environments. The Client Experience Data Program (CEDP) will re-engineer business processes that

include Profiling, Account Opening & Maintenance, and Wealth Management. These processes will enable FAs

and Client Associates (CA) to efficiently obtain and use relevant client information. This will allow FAs to focus on

providing Wealth Management Advisory Services to High Net Worth clients.

• Architected and implemented the development of distributed, redundant, recoverable database architecture for

Merrill Lynch’s Orchestra Active Policy Management (APM) system using Oracle 10gR2 RAC on LINUX Red Hat

4.0.

• Analyzed and Proposed Database Backup Strategies and Disaster Recovery solutions for existing Projects with

respect to mean time to recover. Specific strategies include implementing flashback database, tablespace point in

time recovery for recovering purged objects, VCS clusters for node failures and EMC SRDF solution for Disaster

Recovery. Provide consultancy in planning & implementation of Database Backup and Disaster Recovery

solutions for new projects. Evaluate the feasibility of making Database Backup Strategy and Disaster Recovery

part of the infrastructure for all new projects.

• Developed and implement best practices and standards for database support activities. Provide technical

consulting services to other departments wishing to exploit RDBMS platforms. Provide DBMS topology, tool

evaluation, and design services to applications requiring DBMS specific knowledge base. This includes (but is not

limited to) software vendor evaluation, tool comparisons, providing technical direction as well as information from

technical journals, IBM and other vendors

• Provided technical consulting services to application development and systems areas on topics relating to

database performance, database enablement technologies, database server environmental configuration, and

data access issues.

• Capacity Planning Lead for Oracle Managed Services - Responsible for the ongoing delivery and execution of

oracle managed service solutions effectively and efficiently within DBMS Application environments as well as the

ongoing maintenance to ensure availability, reliability, supportability and manageability.

• Spearheaded OMS migration project for all current service groups from current tier-1, tier-2 Dev, QA and

Production, CNR environments to PA and Teleport Data Center. Provided timelines for the migration and

prioritized the migration of tier-1 and new clients.

• Provided direction for Monthly Capacity Planning Meetings. For capacity planning analysis worked with Team

Quest and completed the Workload Templates for service groups for detailed analysis to identify opportunities for

load balancing, adding CPU’s and additional nodes or failover a service group to another node. Provided OMS

Best Practices Document which significantly reduced the service group build out ETA and prevented space over-

allocation.

• Architected and provided a solution to manage current large volume of metadata within the RMAN catalog

database with over 300+ database and be able to recover full production database in disaster recovery scenario

within Service Level Agreement.

• Implemented Sarbanes Oxley audit and security procedures

• Setup and implemented XML DB in existing Oracle Database by ensuring Correct CLASSPATH, running

initjvm.sql, loading initial sets of Java classes, load xml components via initxml.sql and loading XMLSQL utility into

the database, converted long data to clob, created xml data types, used xml functions for direct xml access,

created procedures for reporting xml data

ERNST & YOUNG LLP 8/94 - 4/97

Oracle DBA

• Successfully transitioned the IW database into a production database through three different hardware platforms

in one year.

• Monitoring and Optimization the performance of the database

• Installing and Upgrading (from 7.1.6 to 7.2.3) including WINDOWS NT

• Allocating system storage and capacity requirements for the systems- Done extensive space management

• Tuning and troubleshoot database applications and provide support to users and clients

• Enrolling, Controlling and Monitoring user access to database

• Identify opportunities for reorganization of tablespaces, tables and indexes as fragmentation occurs

• Managing schema objects - database links, procedures, packages, triggers, sequences

• Planned and developed applications - Billing Workbench, KL merger financial system.

• Maintaining and Updating Applications, solving application related problems and documenting application.

• Assisted Programmers to improve response time

• System security check by using access control lists - lsacl, chacl

• Installed Oracle Web server and Power Browser on Windows NT platform and using Power Browser tools did

DBA administration tasks

EDUCATION

MCA in Computer Applications

BSc(H) in Mathematics

TECHNICAL SKILLS

HARDWARE: EXADATA, IBM P7 AIX 5.3, CISCO UCS Blade Server, Sun Solaris, RH LINUX 4.0, HP-9000 series T-500

and T-800, WINDOWS NT, SCO UNIX, UNISYS, Novell, AIX (IBM PPS Model 7025)

SOFTWARE: Oracle 12c, 11gR2 & 10gR2, 10gR2 RAC, Grid Control, Database Console, Data Guard, MSSQL, Sybase,

Exadata, PL/SQL, Business Objects, KORN SHELL, awk, sed, PRO*C, C, Designer 2000, DOCUMENTUM, Autosys

MONITORING TOOLS: 11g/12c Oracle Cloud Control, Unicenter, BMC PATROL, PRECISE, TOAD, QUEST, Spotlight

ENTERPRISE BACKUP: RMAN and Legato’s Storage Manager, Tivoli TDP

RECOGNITION: Merrill Lynch Special Achievement Award for sustained value

Contact this candidate