SUMMARY

• Over 7+ years of experience in design, administration, development, analysis and implementation stages of various databases like MongoDB, ORACLE, SQL Server and MySQL.
• Over 3+ years of experience in MongoDB large scale database systems.
• Extensive experience in designing MongoDB replica sets and multi - sharded cluster.
• Experience in upgrading and migrating various versions of Mongo database on different platforms.
• Focused on architecting NoSQL databases like Mongo and Cassandra databases.
• Designed and developed load balancing Mongo applications.
• Good experience on advanced queries, query conditionals and aggregation framework.
• Good experience on MongoDB scaling across data centers and/or in-depth understanding of MongoDB HA strategies, including replica sets.
• Used MongoDB third party tools (ROBO MONGO, MongoDB access manager) and mongo-built in binaries to monitor and analysis teh performance of MONGODB.
• Worked on initial sync of replicaset issue across different versions of Mongo.
• Extensive experience in scripting in Linux, UNIX and Windows environments.
• Full life cycle experience in highly secure, extremely large-scale deployments of very high volumes of critical data wif extensive security.
• Participated in DR activity of database for every quarter.
• Well experienced in Planning Application implementation from end to end includes architecting, designing teh metadata, building, loading data. Worked wif Business unit, Process unit, Review process, Rules.
• Responsible for most of teh view/controller changes, model/database integration wif other members of teh team.
• Good noledge on database security and implementation of auditing.
• Supported production database servers and applications dat provided secure mission and critical services.
• Worked on Change management Requests (CMR), Incident Management Requests (IMR) and Line Items. Ability to grasp new technologies quickly and adapt to teh same.
• Experience in preparing teh Technical Documents on relevant topic.
• Performed on-call technical support to minimize teh impact of system disruptions.
• Managing projects ranging from simple implementation to heterogeneous setup for organizations of varying size and complexity in a 24/7 production environment.

TECHNICAL SKILLS:

Programming Languages

: Ruby, Java, C, SQL, PL/SQL

Scripting Languages: Python, Ruby scripting, Shell scripting, JavaScript

Databases: Mongo, Cassandra, Hadoop, Neo4j, SQL Server, MySQL, Oracle, DB2

Application &Web Servers: Apache Tomcat, WebLogic

Development Tools: Eclipse IDE, NetBeans, TextMate, RubyMineProtocols: HTTP/HTTPS, TCP/IP, SOAP, SMTP,REST

Operating Systems: Linux, Unix, Solaris, Windows

Database Tools: Mongo utilities (Mongostat, Mongotop, Mongofile, Mongodump, Mongorestore, Mongoexport, Mongoimport), Oracle RMAN, Export-Import, SQL Loader, TOAD, DBCA, Netca, MS Visio, RAC

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. Mongo Database Administrator (DBA)/Developer

Responsibilities:

• Experience in deploying, managing and developing MongoDB clusters on Linux and Windows environment
• Database management for scheduling, tuning, taking backups using on-premise MMS monitoring and backup solution.
• Point in time Backup and recovery in MongoDB using MMS.
• Data modeling for data from RDBMS to and MongoDB for optimal reads and writes.
• Used Neo4j for graphical based search.
• Responsible for managing MongoDB environment wif high availability, performance and scalability perspectives.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, Stored outlines, Statistics.
• Worked on different storage engines in Mongo. Managing Mongo databases using MMS monitoring tool.
• Worked on balancer issues and chunk migration failures.
• Created users in mongo database and assigned specific roles to maintain security of Database.
• Performance tuning and stress-testing of Mongo database using Mongo utilities.
• Troubleshooting of different versions of Mongo database systems and cluster configurations to ensure high-availability in various crash scenarios and restoring roll backs to avoid loss of Data .
• Upgraded Mongo systems from 2.6 to 3.0.5. Also involved wif creating shards, replica sets, monitoring, and projections for Mongo Systems.
• Explain plan of mongodb java scripts and suggested tuning of queries when and where it is required.
• Developed JavaScript’s to monitor health of Mongo databases and perform ad-hoc backups using Mongodump/mongoexport and Mongorestore/mongoimport.
• Worked wif Gridfs collections to store large size documents and enabled sharding wif range based sharding keys..
• Administered multiple environments, automating backups and checks, restore, validation/integrity checks, growth modeling and predictions, and system expansion; assisted wif upgrade efforts wif MongoDB
• Worked on Mongodb database design and indexing techniques.
• Good noledge on MongoDB write concern majority.
• Implemented read preferences in MongoDB replica set.Configured hidden members in replicaset.

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

Confidential, Detroit

Database Administrator (DBA)

Responsibilities:

• Responsible for administration and supporting Oracle 11g, 10g and 9i databases on different linux OS such as RHEL,AIX, HP-UX, Solaris and Windows in DEV, QA, UAT and Prod environments.
• Installation and Setting up of Standalone databases,2 node 11g RAC in Linux environment and 11g ASM on RAC databases.
• Clone production databases to lower environment.
• Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.
• Downsizing and defragmenting teh Large Databases by export/import, cloning those using RMAN duplicate features and tan upgrading them to Oracle 11g.
• Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Capacity planning of teh databases.
• Replicate schemas using Golden Gate schema replication which includes online change synchronization and ddl synchronization.
• Export and Import of database objects to copy from one database to another database between different environments.
• Troubleshooting errors and using teh expdp/impdputiliy on a very regular basis for copying data across schemas.
• Created UNIX shell scripts to automate batch jobs through Cron.
• Developed and modified scripts to work efficiently for alerts for ORA error backup and recovery, automatic startup and shutdown databases.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Assisting teh ETL team to improve performance by analyzing SQL statements, reorganizing database objects and design indexes to improve response of queries.
• Setting up and monitoring Cron jobs to schedule database backups wif teh halp of RMAN scripts and daily night exports.
• Monitoring Growth of tables and undertaking necessary re-organization of tables and indexes as and when required.
• Used Explain Plan to monitor teh query execution and views to make sure teh operations run wifout issues.
• Performed CRUD operations like Update, Insert and Delete data in MongoDB.
• Worked on creation of MongoDB databases, collections and deploying JavaScript’s using mongo shell.
• Worked on creating various types of indexes on different collections to get good performance in Mongo database.
• Created documents in Mongo database.

Environment: Oracle 11g, MongoDB, SQL * Plus, SQL*Loader, SQL Developer, Oracle RAC, Shell ScriptsUNIX, Windows XP.

Confidential

Oracle SQL Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions accordance wif Business Requirements for loading data into database tables.
• Involved in Unit Testing Stored Procedures and Functions. Created Materialized Views and partitioning tables for performance reasons.
• Worked on various backend Procedures and Functions using PL/SQL.
• Resolved performance issues and bugs wifin packages, forms, and reports using dbms output, Forms debugger, explain plan.
• Developed UNIX shell scripts to perform a nightly refresh of teh test system from Production databases.
• Coordinate wif teh front end design team to provide them wif teh necessary stored package and procedures and necessary insight into teh data.
• Involved in all phases of teh SDLC for Designing & giving recommended approach to satisfy teh requirements.
• Development of C modules for activation, deactivation and modification of these plans in Clarify Front End
• Created SQL*Loader scripts to load data into teh temporary staging tables.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination wif teh application development team
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Developed procedures using Dynamic SQL.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to teh requirements
• Created Materialized Views and partitioning tables for performance reasons.
• Resolving teh issues on priority basis.
• Responsible for Analyzing and Implementing teh Change Requests.
• Involved in handling teh changes in compiling scripts according to teh database changes.

Environment: C, C++, UNIX shell scripting, Oracle 10g, PL/SQL, Toad, SQL *Plus.