SUMMARY

• Over 12+ Years of extensive experience as an DBA
• 2+ Years of Mongodb DBA experience in unix environments.
• 3+ Years of Oracle Exadata experience in Patching and support.
• 8+ years of experience in implementation and installation RAC Database with 2 and 4 nodes.
• 8+ Years of Data Guard experience in implementation and support.
• 4+ Years of Oracle Gloden Gate experience in configuration and support.
• 3+ Years Oracle DBA Development experience
• Good noledge on Data Modeling, Data mart, Designing data warehousing boundaries and Data Transformation.
• Experience in setting up and administration of multi - node Mongodb sharded cluster
• In-depth understanding of MongoDB HA strategies, including replica sets and sharding
• MongoDB Schema Design using DB Ref, Manual Ref, Embedded Data Model Design
• Shell scripts to implement backup and log rotations with Mongodb DBA activities.
• Suitable Index Key Selection and implementation in Mongodb
• Developed Data Migration strategy and implemented teh same from Oracle to MongoDB and MongoDb to Oracle using Pentaho and Talend Tools
• Define and Implement teh process for performing runtime analysis of performance on MongoDB
• Experience with highly available (n-node replica sets), multi-tenant solutions using MongoDB.
• Experience with high transaction, high volume, large data handling in MongoDB
• Defining and Implementing teh backup and restore process for large database (Mutliple Terabytes on one instance) achieving high performance for backup and restore
• Worked as Production/Operations DBA and On-call support in 24x7 environments.
• Installation and Configuration of Oracle 12c/11g/10g/9i/8i databases on RHEL, Solaris, AIX and Windows platforms.
• Performed Installation and setup of Oracle Real Application Clusters (RAC) in Oracle 10g & 11g with ASM OCFS and ACFS file system.
• Expertise in Installing and managing physical and logical standby database for Disaster Recovery (DR) and setup Oracle 11g Active Data Guard.
• Experience in Oracle Enterprise Manager (OEM) 12c/11g/10g Installation and configuration.
• Oracle Gloden Gate replication experience for Oracle 10g and 11g and SQL Server.
• Oracle Recovery Manager (RMAN) expertise in setting up backup & recovery and cloning.
• Experience in performance tuning using EXPLAIN PLAN, TKPROF, AWR Reports, ADDM, ASH and SGA tuning.
• DB design experience creating logical and physical design using Erwin data modeler.
• Excellent experience in managing large-scale OLTP databases 5+TB size in HA and DR setup.
• Managed 11+ TB Oracle 10g & 11g databases in Data warehousing environment.
• Solid experience in oracle database migration, upgrades, applying patch sets, code reviews, database release and deployments and data center consolidation activities.
• Maintained Oracle 11g databases in cloud environment hosted in Amazon EC2.
• Successfully managed complex projects with global implementation, and rapidly evolving requirements.
• Project delivery under stringent time lines and high pressure.
• Adopt in providing Analytically Support to key business Applications /solutions.
• Excellent verbal and written skills, especially with regards to presenting findings to both technical and non-technical audiences.

TECHNICAL SKILLS

Technologies: Mongodb Shard, Mongodb Replicaset, Mongo Ops Manager Administration, Mongo MMS, Cloude Foundry, Pentaho and Talend Tools, Oracle Real Application Clusters (RAC), Oracle Enterprise Manager (OEM), Oracle Recovery Manager (RMAN), Data Guard, Oracle Gloden Gate, Automatic Storage Management (ASM), Oracle Exadata, PL/SQL, Flash Recovery Area (FRA)

Operating Systems: HP-UX 11.x, Solaris 10/9/8, RHEL 6, AIX 5.x/6.x, MS Windows Server

Languages: SQL, PL/SQL, T-SQL,TOAD, HTML, XML, C, C++, Java Script, UNIX shell scripting

NoSQL/RDBMS: Mongodb 2.6, Mongodb 3.0, Mongodb 3.2, Oracle 12c/11g/10g/9i/8i, SQL Server 2012, 2008/2005/2000 , MySQL 5.2

Tools: /Utilities: RMAN,OEM, SQL*Loader, ASM, Export/Import, SQL Developer, SQL Navigator, Data pump, Data guard, TKPROF, EXPLAIN PLAN, AWR, ADDM, Idera SQL Server Diagnostic Manager, Idera SQLSafe, Crontab, HP OpenView, HP Service Manager, putty, WinSCP, Gloden gate, Patch Management, Amazon EC2, Erwin, VERITAS Net backup, CommVault.

PROFESSIONAL EXPERIENCE

Confidential, Connecticut

Mongo DB Solution Architect

Responsibilities:

• Install, Administer, and Optimize MongoDB instances.
• Set and tune System Parameters for MongoDB.
• Automate routine tasks via scripts and tools.
• Install and run Mongodb with multiple instances on servers.
• Secure MongoDB using authentication.
• Configuring, implementing and supporting high availability (Replication) MongoDB cluster.
• Configuring, implementing and supporting High Availability (Replication) with Load balancing (sharding) cluster of Mongodb having TB’s of data.
• Backup and restore mongo databases.
• Optimizing MongoDB CRUD Operations.
• Disaster Recovery setup and best practices, including planning, testing, failover testing.
• Add / remove replica and shard nodes in Mongodb Cluster as needed.
• Design & implement sharding and indexing strategies for huge data sets.
• Migrate mongodbsharded/replica cluster form one datacenter to another without downtime.
• Manage and Monitor large production Mongodbsharded cluster environments having terabytes of teh data.
• Setting up MongoDB Profiling to get slow queries.
• Ensure data replication with no lag.
• Pro-actively identify, troubleshoot and resolve live MongoDB issues.
• Work with Development, Storage and Network teams in installation and

Confidential, Irving Texas

Mongo DB Architect

Responsibilities:

• Setting up and administration of multi-node MongoDB shard cluster.
• Manage mongo DB upgrades from 2.6 to 3.2, including hardware migrations.
• MongoDB Administration on multi node replica sets and shard 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 through Python Script.
• Environment: MongoDB, RHEL 6.X, Windows 2k

Confidential, Irving Texas

Mongo DB Architect

Responsibilities:

• 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

Confidential, Houston Texas

DBA Architect

Responsibilities:

• 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

Confidential, Phoenix Az

Technical Architect

Responsibilities:

• Migration of Oracle Database to Mongodb Database.
• Lead DBA for Migration Project involved in project planning, POC for Migration strategy.
• Collaborate with multiple Application teams,to collect teh requirements for build multi-node mongodb sharded cluster Environment.
• Manage mongodb and setup testing environments using backup and restore.
• Manage Mongo db upgrades, including hardware migrations.
• Installed Oracle 12c on RHEL 6.5 for 11g to 12c database upgrade POC.
• Installed Gloden gate, created Extracts/Replicats for replication of data.
• Knowledge sharing, training. Train junior DBAs and build their expertise to make them independent
• 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: Mongodb, Oracle 12c, 11g, IBM AIX, RHEL, SQL, PL/SQL, RMAN .

Confidential

Principal Database Administrator

Responsibilities:

• Expert in EXADATA server administration
• Solid Exposure to Exadata Configurations including X2-2, X2-8, full rack and teh latest X3-8
• Exadata features including Hybrid Columnar Compression, Exadata Smart Flash Cache, Exadata Storage Index and Exadata Storage Management & Administration
• Good understanding of Disk Storage Entities, Relationships and Key Capabilities of Exadata Database Machine
• Configuring teh Exadata Cell Server Software
• Expert in Assisted Patching Using Oplan
• Managed Oracle 11g databases on Exadata X3-2/X3-3 machines.
• Managing 1000 + enterprise level database systems, achieving teh 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+ Glodengate V11.2 instances and processes used for replication.
• Setup/maintain Glodengate EXTRACT and REPLICAT groups through GGSCI.
• Creating and review teh 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 teh database files to appropriate Tier-1/2/3 disks.
• Conduct Real Application Testing for Major database upgrades or regular performance fixes.
• Built shell script for Database build pre-checks and analyze various enterprise requirements.
• Wrote Perl script for Database server requirements check and firewall port scan, automated DB build using Perl module.
• Worked in setting up of automatic baseline gathering for 11g databases.
• Configured Database resource manager plan directives to improve teh backup timing and performance during business hours.
• Installed Oracle Data Access Component for creating linked server with MS SQL server for backup reporting.
• Configured connect time failover for JDBC thin drivers to facilitate automatic failover of weblogic connections.
• Performed teh space management of database containers as per business user requirements.
• Monitored capacity utilization and performed capacity analysis and reviews to ensure sufficient capacity is provided to meet teh forecasted requirements.
• TEMPEffectively supported teh client’s user security model by creating profiles, roles and assign appropriate access rights to them.

Environment: Oracle 10g & 11g, 11g & 12c OEM, 10g & 11g RAC, RMAN, ASM, Active Data Guard, Oracle Exadata X3-2, Gloden Gate 11.2, Amazon VPC, SQL Server 2000,2005 and 2008.

Confidential

DBA Team Lead

Responsibilities:

• Managed Oracle 11g databases on Exadata X3-2/X3-3 machines.
• Managing 1000 + enterprise level database systems, achieving teh 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+ Glodengate V11.2 instances and processes used for replication.
• Setup/maintain Glodengate 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 teh CPU, memory usage, disk optimization, me/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 teh 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 teh database files to appropriate Tier-1/2/3 disks.
• Conduct Real Application Testing for Major database upgrades or regular performance fixes.
• Built shell script for Database build pre-checks and analyze various enterprise requirements.
• Wrote Perl script for Database server requirements check and firewall port scan, automated DB build using Perl module.
• Worked in setting up of automatic baseline gathering for 11g databases.
• Configured Database resource manager plan directives to improve teh backup timing and performance during business hours.
• Installed Oracle Data Access Component for creating linked server with MS SQL server for backup reporting.
• Configured connect time failover for JDBC thin drivers to facilitate automatic failover of weblogic connections.
• Performed teh space management of database containers as per business user requirements.
• Monitored capacity utilization and performed capacity analysis and reviews to ensure sufficient capacity is provided to meet teh forecasted requirements.
• TEMPEffectively supported teh client’s user security model by creating profiles, roles and assign appropriate access rights to them.

Environment: Oracle 10g & 11g, 11g & 12c OEM, 10g & 11g RAC, RMAN, ASM, Active Data Guard, Oracle Exadata X3-2, Gloden Gate 11.2, Amazon VPC, SQL Server 2000,2005 and 2008.

Confidential

Sr. Oracle DBA

Responsibilities:

• Involved in database capacity planning and devising Disaster Recovery (DR) plan
• Involved in VCS replicated data cluster server administration
• Manage and monitor teh VCS Cluster and replication jobs through VCS agents
• 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.

Confidential

Oracle DBA

Responsibilities:

• Managed Oracle/Teradata database and client software on Unix/Linux and Windows servers to provide for teh 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 teh 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 teh ETL team to configure ETL tools.
• Query tuning by utilizing different join techniques and choosing teh correct join based on teh SQL query.
• Optimized teh performance of teh Teradata platform by configuring Teradata Manager, PMON and Scheduler Manager Components and setting up teh alerts.
• Designed and implemented teh Backup, Archive and Recovery (BAR) solution for teh Oracle/Teradata database systems.
• Served as a technical lead for teh configuration of Viewpoint application for teh monitoring of Teradata systems. Configured for SSL and LDAP user authentication mechanisms, system registration, data collectors, backups, roles manager, port lets, and metrics.

Environment: Oracle 11g/10g, OEM grid control, RMAN, RAC, SAN - EMC Clarion, Solaris 8, HP UNIX 11, Windows 2003, SQL Server 2000, 2005, Shell Scripting.