PROFESSIONAL SUMMARY:

• Over 6 years professional IT experience in Analysis, Modelling, Design, Implementation, Support and Administration of Large to Medium scale databases Systems.
• Experience building structured MVC web applications using JavaScript, AngularJS, Node.js, jQuery, Express, MongoDB.
• Proficiency in multiple databases like MongoDB, Cassandra, MySQL, ORACLE and MS SQL Server.
• Extensive experience in designing MongoDB multi - shared 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.
• Extensively used various design patterns such as MVC (Model-View-Controller), Singleton, MVVM.
• 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 fulfill storage needs.
• Experience in Implementing, configuring, trouble shooting, switchover, failover of Physical Standby Data Guard on 10g and 11g.
• 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.
• Application development experience using NetBeans IDE, Brackets, Atom and Eclipse IDE and rich client application development using NetBeans platform.
• 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.

TECHNICAL SKILLS:

RDBMS: Oracle 9i and 10g, 11g

Big Data: Hadoop, Map Reduce, Pig, Hive, Sqoop, Hbase, Cassandra, Mongo DB

Application: Retail Applications (RMS, SIM, ReSA, ReIM, Backoffice, Centraloffice, POS)

Tuning Tools: SQL Auto Tracing, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, Tuning advisors, ADDM, oradebug, OS Watcher and SQL Plan stability management etc.

Operating System: Solaris 8/9/10, HP-UX, SUSE Linux, Red Hat Enterprise Linux Advance/Enterprise Server 4/5, HP-UX, Windows 9X/XP/2000, IBM AIX 5.1/5.2/5.3/5.5/6.1 ,

Languages: SQL, Perl, PL/SQL, Linux/UNIX Shell Scripting, Java, C & C++

Database Tools: Oracle Enterprise Manager Database Control, Rman, Dbverify, Tkprof, Statspack, AWR, ADDM, SQL Loader, SQL Server 2005/2008/2012 , MySQL, Cassandra, MongoDB

WORK EXPERIENCE:

Confidential, Edenton, NC

MongoDB Developer/ Administrator

Responsibilities:

• Worked on the enhancement of the business logic with J2EE with struts framework.
• Involved in analyzing the mongo data and document structures.
• Developed Ruby/Python scripts to monitor health of Mongo databases and perform ad-hoc backups using Mongo dump and Mongo restore.
• 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. Implemented scripts for mongo DB import, export, dump and restore.
• Implementing on premise MMS monitoring and backup solution.
• Involved in the Application deployment with WebLogic server in production and with JBoss in the dev environment.
• Involved working with teams to find performance related activity with the Application as well as with the database side.
• Used MongoDB third party tools (ROBO MONGO, MONGOOWL, MONGOVUE) and mongo-built in binaries to monitor and analyze the performance of MONGODB.
• Installation of MongoDB on physical machines, Virtual machines as well as AWS.
• Backup & Recovery, Database optimization and Security maintenance.
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design.
• Created multiple databases with sharded collections and choosing shard key based on the requirements.
• 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.
• 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.
• Testing, evaluation and troubleshooting of different NoSQL database systems and cluster configurations to ensure high-availability in various crash scenarios.
• Upgraded Mongo systems and involved with creating shards, replica sets, monitoring, and projections for Mongo Systems.
• Worked with capped collections to wipe out aged data based on requirements.
• Administered multiple environments (up to 25TB), automating backups and checks, restore, validation/integrity checks, growth modeling and predictions, and system expansion; assisted with upgrade efforts with MongoDB
• Worked on creating various types of indexes on different collections to get good performance in Mongo database.
• Familiar with MongoDB write concern to avoid loss of data during system failures.
• 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 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, Py Mongo, JavaScript, web logic server, eclipse, struts, Soap and Eclipse.

Confidential, Eden Prairie, MN

Sr. MongoDBA/ Database Administrator

Responsibilities:

• Load balancing of application request’s by configuring multiple mongos instances in sharded cluster.
• Migrated Mongo database from MMAPV1 storage engine to WiredTiger storage engine.
• Changing the size of system. Profile collection with required size. Analyzing profiler output and implements 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, Atlanta, GA

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.
• 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.
• 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, Data Guard, Toad, Exadata, OEM, ASM, Oracle Enterprise Manager (OEM), WebLogic server, oracle retail applications.