SUMMARY

• Over 7 years professional IT experience in Analysis, Modelling, Design, Implementation, Support and Administration of Large to Medium scale databases Systems.
• Over 3+ years of experience in MongoDB (versions 2.4.x, 2.6.x, 3.0.x, 3.2 and 3.4) installation, configuration and administration.
• Extensive experience in designing MongoDB multi - sharded cluster and monitoring with MMS and Mongo utilities.
• Experience in upgrading and migrating various versions of Mongo database on different platforms.
• Focused on architecting NoSQL databases like Mongo, Cassandra and Cache database.Extensively worked on Mmapv1&Wiredtiger storage engines.
• Experience in handling CRUD operations in MONGODB.Good experience with JavaScript, Ruby and Python in Linux, UNIX and Windows environments.
• Extensive experience in developing Map-Reduce programs and aggregation frameworks using JavaScript’s.
• Experience in Installation, Configuration and Troubleshooting of Oracle Database on Solaris OS, IBM-AIX, Red Hat Enterprise Linux (RHEL) and Windows on highly transactive and Very large databases.
• Expert level experience in Oracle RAC implementation & administration using Oracle Cluster-ware, Sun Cluster and VERITAS Cluster Server (Oracle Cluster ware setup and configuration, RAC installation, Configuration and Patching, RAC Backup and Recovery)
• Configured Automatic Storage Management (ASM) to fulfil storage needs.
• Experience in Implementing, configuring, trouble shooting, switchover, failover of Physical Standby Data Guard on 10g and 11g.
• Experience in Backup & Recovery techniques of databases running using RMAN.
• Used ADDM (Automatic Database Diagnostic Monitor), AWR (Automatic Workload Repository), ASH (Active Session History) for analysing the database performance and tuning.
• Experience in up gradation of Data bases in 10g and 11g.Experience in Data Migration using Data pump utility.
• Database Refresh from Production to Development and from Development to Test environments.
• Replication of tables to cross platform and Creating Materialized Views.Planning and scheduling Physical Backups (offline/online) and Logical Backups.
• Experience in implementing Flash Back Pointing Time Recovery.Keeping the database up to date by applying the latest CPU and PSU using the OPATCH utility.
• Hands on experience working on High Availability Environments.24 X 7 Production Database on Call Support.
• Exceptional ability to collaborate with team members for code and design reviews. Self-motivated worker with strong focus on business goals and end-user experience.

PROFESSIONAL EXPERIENCE

Confidential - Walnut Creek, CA

MongoDB Architect/Sr. MongoDB Administrator

Responsibilities:

• Extensive experience in deploying, managing and developing MongoDB clusters.
• Creation, configuration and monitoring Shards sets. Analysis of the data to be shared, choosing a shard Key to distribute data evenly.
• Architecture and Capacity planning for MongoDB/ Cassandra clusters. Implementing Ops Manager monitoring and backup solution.
• Worked on maintenance of SHARDS, REPLICA-SETS in rolling fashion as a part of high availability service.
• Backup & Recovery, Database optimization and Security maintenance by creating customized roles at user level.
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design.
• Configuring high availability using geographical MongoDB replica sets across multiple data centers.
• Migrated Mongo database systems from No-SSL authentication to SSL authentication using certificates.
• Migrated Mongo database from MMAPV1 storage engine to WiredTiger storage engine as part of MongoDB 3.0 upgrade.
• Managing Mongo databases using MMS monitoring tool.
• Performance tuning and stress-testing of NoSQL database environments in order to ensure acceptable database performance in production mode.
• Developed Ruby/Python scripts to monitor health of Mongo databases and perform ad-hoc backups using Mongodump and Mongorestore.
• Implemented write concern majority to avoid data loss during system failures. Worked with capped collections to wipe out aged data based on requirements.
• Administered multiple environments, automating backups and checks, restore, validation/integrity checks, growth modeling and predictions, and system expansion; assisted with upgrade efforts with MongoDB.
• Worked on LVM snapshots to backup Mongo databases.
• Worked on creating various types of indexes on different collections to get good performance in Mongo database.
• Implemented read preferences in MongoDB replica set.
• Configured delayed secondary’s to avoid human failures in coding and development.
• Strong experience in analyzing chunk migrations, splitting and balancing across the cluster.
• Worked on pre-splitting mechanism using Range/Hash based shard keys to distribute data across shards.
• Skilled in troubleshooting with good organizational and interpersonal skills.

Environment: MongoDB, Cassandra, Ruby, MMS, Puppet, Linux/Unix, LVM Snapshots, Backup Scheduler, Data guard, Sharding, Replication, Python, Shell scripting, Perl, PyMongo, JavaScript

Confidential - Eden Prairie, MN

Sr. MongoDBA/Database Administrator

Responsibilities:

• Design architecture of MongoDB multiple versions (2.x, 3.0.x and 3.2.x) of Replicasets, Sharded cluster.
• Load balancing of application request’s by configuring multiple mongos instances in sharded cluster.
• Changing the size of system. Profile collection with required size. Analyzing profiler output and implement workaround to resolve issues.
• Understanding Aggregation pipeline operations, have an optimization phase which attempts to reshape the pipeline for improved performance.
• Familiar with compression techniques in Wiredtiger storage engine. Applied patches and upgraded the replica set in rolling fashion.
• Monitoring Oplog timestamp and make sure all nodes status healthy in replica set.
• Worked with Aggregation Pipeline Limits and memory restrictions. Maintaining Sharded cluster availability and security across all the nodes.
• Worked on multiple BSON type objects and used based on requirement. Analyzing explain plan result stages and descriptive of the operations.
• Considering limits and thresholds for existing and new Mongo database implementations.
• Configured Role-Based Access Control with custom roles and privileges.
• Running MongoDB with secure configuration options.
• Provided backup solution using MMS/OPS manager.
• Having knowledge on Index properties and suggesting development team to build index on required fields.

Environment: MongoDB, MMS, OPS manager, mongostat, mongotop, mongofiles, Ruby, Puppet, Linux/Unix, LVM Snapshots, Backup scheduler, Pearl, PyMongo, Java script.

Confidential -Columbus, OH

Database Administrator

Responsibilities:

• Installation and creation of 10g RAC and 9i databases for Testing, Development and Production.
• Experience in managing MongoDB environment from availability, performance and scalability perspectives.
• Major activities include logical and physical database design, capacity planning, performance tuning, database security, disaster recovery, installation and ongoing maintenance.
• Administered multiple environments automating backups and checks, restore, validation/integrity checks, growth modeling and predictions, and system expansion; assisted with upgrade efforts with MongoDB
• Configured Disaster Recover and Logical standby for Production database in 10G. Tune databases performance, Schedule backup, jobs using OEM Grid Control.
• Involved optimizing database schemas, SQL queries, database procedures, and installation.
• Cloned/Refreshed Oracle Databases using RMAN for development and testing.
• Worked with Erwin, ER/Studio, Data Warehousing, Extract Transform and Load (ETL), Oracle Warehouse Builder, SQL, PL/SQL.
• Responsible for setting and managing user accounts, Granting required privileges, profiles to users, Auditing Users.
• Written shell scripts for digitization the process and for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Tuning SQL queries using AWR, ADDM, TKPROF, EXPLAIN PLAN, and SQL TRACE.
• Developed startup/shutdown guides, troubleshooting documents, root cause analysis documents.
• Worked on Data pump (Expdp / Impdp), Import / Export for logical database maintenance.
• Performing Backup/Recovery of all the Oracle databases using RMAN and also setup RMAN catalog for the same.
• Creating tablespaces sizing the system table space, allocating default tablespaces for users.
• Creating tables and indexes, sizing their extent, partitioning and so on.
• Creating users with restricted access, with default and temporary tablespaces.
• Developed database system build sheets, code review check lists, code promotion process documents, outage reporting documents.
• Resolving SQL tuning issues and Tuning Considerations for Different Applications.
• Monitoring the table growth, database growth, current users, and system resource usage and so on.
• Experience in SQL*Loader, loading data from text files.
• Performed scheduling of Change Control-activities and scheduling jobs.
• Performed Database Reorganization regularly to remove row migrations and fragmentation using export and import utilities. Write UNIX Shell Scripts to schedule these activities.
• Contact oracle Metalink to resolve database issues and to raise SR's.

Environment: MongoDB, Oracle 10g /9i, ASM, Sun Solaris 9, Red Hat Enterprise Linux 4.x, OEM, Explain Plan, Tkprof, SQL*LOADER

Confidential

Oracle DBA/Oracle Admin

Responsibilities:

• Involved with installation and maintenance of Oracle RAC for high availability.
• Involved in the change control process and Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
• Worked extensively on monitoring 10G Grid Control and Configuration of error notifications, installing listeners, and adding them to the grid control
• Maintained 10g RAC environment and troubleshooting issues. Having good experience in Migrating single Instance database to RAC Environment
• Performed Capacity Planning, Undo segments and Health check reviews in RAC.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement. Scheduling the databases backup using Cron tab and VERITAS net backup.
• Involvement in space management, rectification of lock problems, managed quotas. Performed Migration of databases 10g on Hp - UNIX to Oracle 11gR2 on Linux.
• Created, monitoring database objects like Indexes, Views, Users, and DB Links. Implemented High availability using Golden Gate Replication.
• Wrote scripts for database maintenance activities such as monitoring the growth rate of table spaces and extents. Also wrote UNIX scripts to process batch jobs.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
• Extensively used features such as Data Pump, Flash Back Recovery, ASM, AWR, ADDM for Generating reports
• Created Partition’s estimated stats on one partition1 and copied the stats to remaining partitions using dbms stats.
• Worked with DW team on problem resolution and implemented change requests. - Performance tuning on DW such as Data extraction from production to Data warehouse.
• Installing Retail applications (RMS, ReSA, SIM, RIB and CO). Applying patches to all retail applications.
• Upgradation of retail applications.
• Deploying the custom code into all retail applications. Creation of Point of sale (POS) stores and Backoffice (BO) domains under web logic server
• Involved in 24x7 production database maintenance and on-call support. Conducted time-to-time analysis and monitoring of the software and hardware requirements and act accordingly

Environment: Oracle 10g, RAC on Sun Solaris, Linux, RMAN, Data Guard, Toad, Exadata, OEM, ASM, Oracle Enterprise Manager (OEM), WebLogic server, oracle retail applications.

Confidential

SAP HANA ADMIN

Responsibilities:

• Installation and Configuration of Oracle on HP UNIX. Managing data file objects including tablespace and datafiles, object sizing as well as monitoring database usage and growth.
• Managing tablespaces, user profiles, indexes. Responsible for creating user logons and managing user accounts.
• Monitor the instance and plan for future availability of storage on user’s table spaces
• Suggesting tuning solutions for SQL queries and Database.
• Performance Monitoring the Server for Better performance. Adding space to the data files according to tablespace growth
• Backup and Recovery strategies for Oracle database using exp/imp, cold and hot backups.
• Taking an export backup of tables for future database recovery. Modifying Oracle parameter (init.ora) for Oracle performance and growth

Environment: Oracle 9i, Toad, SQL plus, Oracle Enterprise Manager (OEM), RMAN, Solaris 9/10,AIX,Shell Scripting,, Net Backup, Time finder Backups, ADDM, Tkprof, Statspack.