Client : Amadeus Inc• MongoDB Ops Manager Administration.• MongoDB as service configuration.• MongoDB Configuration on VMware cloud foundry.• Setting up and administration of multi-node Mongodb sharded cluster.• Manage mongo db upgrades, including hardware migrations.• Administer multi node replica sets and sharded servers.Client : Anthem Location : CTResponsibilities: MongoDB Data model design for migration from DB2 to MongoDB.• MongoDB Schema Design using DB Ref, Manual Ref, Embedded Data Model Design. • Enable DB level authentication and create users as per application requirement.• Performance improvement through right index strategy in MongoDB Prod environment.• Define and implement backup strategies per data retention requirements.• Manage mongodb and setup testing environments using backup and restore.• Designing and maintaining complex solutions in MongoDB consisting of large amount of writes/updates and reads • Prepare scripts to automate day to day activities.

Client Citibank, Irving Texas Mongo DB ArchitectResponsibilities:• MongoDB Ops Manager Administration.• MongoDB as service configuration.• MongoDB Configuration on VMware cloud foundry.• Setting up and administration of multi-node Mongodb sharded cluster.• Manage mongo db upgrades, including hardware migrations.• Administer multi node replica sets and sharded servers.• MongoDB Schema Design using DB Ref, Manual Ref, Embedded Data Model Design. • Enable DB level authentication and create users as per application requirement.• Performance improvement through right index strategy in MongoDB Prod environment.• Define and implement backup strategies per data retention requirements.• Manage mongodb and setup testing environments using backup and restore.• Designing and maintaining complex solutions in MongoDB consisting of large amount of writes/updates and reads • Prepare scripts to automate day to day activities.• Environment: MongoDB , RHEL 6.X, Windows 2k

Client Eog Resources, Houston Texas DBA ArchitectResponsibilities:• Administer multi node replica sets and sharded servers.• Manage and maintain mongo DB servers across multiple environments.• Define and implement backup strategies per data retention requirements.• Manage mongodb and setup testing environments using backup and restore.• Enable db level authentication and create users as per application requirement.• Environment: Mongodb , RHEL 6.X• Performance Analysis and Optimizing database queries with MongoDB

Responsibilities:• Migration of Sybase Database to Oracle 12c Database.• Lead DBA for Datacenter Migration Project involved in project planning, POC for migration strategy.• Collaborate with multiple teams, work with offshore teams, 24*7 on-call production support.• Installed Oracle 12c on RHEL 6.5 for 11g to 12c database upgrade POC.• Installed Golden gate, created Extracts/Replicats for replication of data.• Plan and schedule RMAN backups (hot, cold and incremental backups) • Setup 12c Oracle Enterprise Manager (OEM)• Cloning / Database Refresh of Oracle 10g, 11g using RMAN and user managed • Environment: Oracle 12c, 11g, IBM AIX, RHEL, SQL, PL/SQL, RMAN, Erwin, PHP Scripting.

Client : PIMCO, Network Rail, Morrison, Woolworth, Carsales, Sony Entertainment NetworkResponsibilities:• Managed Oracle 11g databases on Exadata X3-2/X3-3 machines.• Managing 1000 + enterprise level database systems, achieving the goal of 99.99% availability at acceptable level of performance• Performing Root Cause Analysis (RCA) and break fixes and DB releases.• Install/Configure Oracle 11g R2 RAC (Grid Infrastructure) with ASM and ACFS file system.• Setup/maintain Active Data Guard between primary and DR site.• Install/maintain Oracle 11g databases in Amazon EC2 Virtual Private Cloud (VPC).• Configure/maintain OEM 11g and 12c and install agents for database servers.• Managing 50+ Goldengate V11.2 instances and processes used for replication.• Setup/maintain Goldengate EXTRACT and REPLICAT groups through GGSCI.• Incidents and Ticket resolution using HP OpenView and HPSM (Service Manager)• Designed Backup and Restore process for point in time recovery of production database.• Monitoring and Tuning the CPU, memory usage, disk optimization, I/O contention, paging, network statistics on UNIX servers using TOP, IOSTAT, NETSTAT, VMSTAT, TOPAS, NMON.• Space management at Database level (Tablespace) as well as OS level • Creating and review the Change and problem incident.• Supported Application upgrade using Oracle Flashback database for faster rollback.• Worked as a Project Lead for DR exercise including Tier -1 critical database.• Define standard for Database file system layout by placing the database files to appropriate Tier-1/2/3 disks.• Worked in setting up of automatic baseline gathering for 11g databases.• Configured Database resource manager plan directives to improve the backup timing and performance during business hours.• Installed Oracle Data Access Component for creating linked server with MS SQL server for backup reporting..

Client : Telstra AustraliaResponsibilities:• Involved in database capacity planning and devising Disaster Recovery (DR) plan • Providing L2/L3 support for 250+ oracle database instances, 20+ Oracle 11i Apps. and 50+ sql server databases• Install/maintain 2 and 4 node 10g RAC databases with ASM• Install/maintain Oracle Enterprise Manager (OEM) Grid Control and create/maintain repository database• Duties include, managing data guard standby databases, monitor/validate RMAN backups, apply db patches, data refresh using exp/imp• Upgraded databases from SQL Server 2000 to SQL Server 2005 using backup/restore.• Created SQL Server Database Maintenance Plans for Backup, Index rebuilding, Database consistency checks and statistics updates.• Monitoring and troubleshooting SQL Server Jobs and alerts.• Performed troubleshooting SQL Server DTS and SSIS.• Oracle 8i, 9i, 10g, OEM grid control, RMAN, RAC, SAN – EMC Clarion, Solaris 8, HP UNIX 11, Windows 2003, SQL Server 2000, 2005, Shell Scripting.Environment: HPUX, Linux, HP Service Guard, Business Copy BC, Sun Solaris, Remedy 7.1, Oracle 11G, 10G, 9i, 8i. Oracle RAC, ASM, GRID, DATA GUARD, Disaster Recovery. SOX, FDA, ITIL.

Responsibilities: Managed Oracle/Teradata database and client software on Unix/Linux and Windows servers to provide for the accessibility, security and integrity of data in accordance with security requirements. Performed upgrades, patch maintenance and integration with vendor software on MP-RAS UNIX, AIX, HP-UNIX, SUSE Linux, and NT platforms. Setup RMAN backup using Tivoli Storage Manager (TSM) and Veritas Net backup. Responsible for Design, setup of Disaster Recovery Systems for Oracle and Teradata. Implemented partitioning adjustments, materialized views, summary tables, Oracle parallelism, indexing improvements, as well as SQL performance techniques. Design and Implement and maintain database security by reviewing audit requirements and exception process. Configured intelligent agents for alerting, security health check and monitoring of oracle database. Tuned SQL queries and PL/SQL code for many applications using OEM, V$SQL, SQL developer, AWR, and explain plans. Worked as a RAC SME for other DBA members. Designed database architecture for Implementing Sun Role Manager database used for Profile/Role management. Designed the operational process for NPI/API data cleansing. Involved in migration of databases from individual UNIX servers to HP superdome. Performed numerous data loads to support provisioning/de-provisioning of native systems. Performed data archiving on Identity Management databases. Performance tuned SQL queries, PL/SQL procedures, triggers, functions using AWR report and awrrpt tool. Setup new database environments for Data warehouse and assisted the ETL team to configure ETL tools. Query tuning by utilizing different join techniques and choosing the correct join based on the SQL query. Optimized the performance of the Teradata platform by configuring Teradata Manager, PMON and Scheduler Manager Components and setting up the alerts.

Client : BP Petroleum industry company, UKResponsibilities: Upgraded oracle databases to 10g, 11g and performed query tuning after optimizer changes. Designed architecture for new database environments and gather software/hardware requirements. Performed Installation of Oracle 11g Grid Infrastructure to support High Availability. Setup new database environments for Data warehouse and assisted the ETL team to configure ETL tools. Tuned SQL queries and PL/SQL code for many applications using OEM, V$SQL, SQL developer, AWR, and explain plans. Setup and configure Multi master Streams replication environments to support different branches. Performance tuned RAC databases to minimize wait events related to GCS and GES. Designed data model for Reconciliation of user accounts provisioned from various native systems. Tuning the SQL queries using sqltrpt script, SQL Profiles and implement the tuning recommendations. Performance tuned SQL queries, PL/SQL procedures, triggers, functions using AWR report and awrrpt tool. Query tuning by utilizing different join techniques and choosing the correct join based on the SQL query. Performance tuned Data warehouse applications by tuning queries using star join and star transformation. Monitored wait events like db file scattered read/db file sequential read to identify missing indexes, index with wrong columns. Worked with IT Risk Office to configure the CTSA user (Account provisioning tool) to create accounts in 10g databases. Worked as Database Architect to convert Oracle RAC to stand alone database. Used optimizer hints extensively for query tuning and optimize joining of remote tables. Query tuning using V$SQL to identify bad SQL that performs excessive Disk reads/Logical reads/executions. Tuned SQL queries scanning skewed data but no histograms built/stagnant indexes on the

Client : BSNL IndiaResponsibilities:• Installed and configured Oracle 9i, 10g on RHEL and AIX environments.• Security via Roles with select privilege (Sox Environment)• Maintaining Oracle names and LDAP.• Data Modeling for use cases, creating logical and physical design, schema mapping between existing legacy system and new application schema.• Activities include Capacity planning, DB Build/Release, space management, tablespace/data file addition, database objects creation (tables, indexes, user and profile management), setup backup and recovery policy, sql tuning.• Experience in Oracle Names and LDAP, Identity management.• Designing the security and database access strategies and Scheduling jobs using crontab.• Tuning SQLs using Explain Plan, SQL Trace, TKPROF reports and SQL Tuning Advisor.• Diagnose and troubleshoot database problems and failures.Environment: Oracle 9i, 10g, IBM AIX, RHEL, SQL, PL/SQL, RMAN, Erwin, PHP Scripting.