SUMMARY

• Having 6 years of experience in Database design, Administration and development in Mongo DB, Oracle and SQL Server
• 3 years of experience in MongoDB Installation, Configuration and Administration. Experienced in NOSQL Database design and principles (MongoDB, Cassandra)
• Proficient in designing MongoDB dynamic schemas and Data modeling concepts.
• Experienced in implementation of backup and recovery process for various databases like MongoDB, Oracle and SQL Server.
• Worked on Ops manager monitoring tool to support multiple versions of MongoDB.
• Good knowledge on Mongo utilities (mongostat, mongotop, mongoperf, mongodump and mongorestore)
• Efficient in handling Index rebuilding, maintenance activities on secondary’s without impacting business in rolling fashion across the replica sets.
• Ability to understand the project requirements and deliver it with proper estimation and quality
• Experience in UNIX skills including writing shell scripts, CRON JOBS and utilities
• Extensive experience in the entire process of the software development life cycle (SDLC) including requirements definition, prototyping, architecture, design, implementation, testing and maintenance.
• Experience in administering Oracle (9i/10g/11g) and SQL Server databases.
• Good experience writing robust, well - tested front end and back end codes
• Strong knowledge on Document store databases like MongoDB and Cache store services.
• Experience with Agile methodologies and involved in all aspects of software development life cycle including requirements definition, prototyping, architecture, design, implementation, testing and maintenance
• Highly dedicated, quick starter, solution driven pattern programmer, Strong in Object Oriented Analysis and Design, Excellent at solving complex problems under strict deadlines
• Self-motivated, goal-oriented, innovative, flexible and resourceful team member
• Excellent Communication, Interpersonal and Leadership skills

TECHNICAL SKILLS

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

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

Databases: Mongo, Cassandra, Microsoft SQL Server, MySQL, Oracle 9i/10g/11g, DB2

Protocols: HTTP/HTTPS, TCP/IP, SOAP, SMTP,REST

Operating Systems: Linux, Unix, Solaris, Mac iOS, Windows

Other Relevant Tools: MS Office(MS-Excel, MS-PowerPoint, MS-Project 2013)

Database Tools: Mongo utilities (Mongostat, Mongotop, Mongofile, Mongodump, Mongorestore, Mongoexport, Mongoimport), Oracle RMAN, Export-Import, SQL Loader, TOAD, DBCA, Netca, MS Visio, ASM, RAC, TOAD, ERWIN, PLSQL Developer, Sql Loader Utility, OEM Grid Control, NETCA

PROFESSIONAL EXPERIENCE

Confidential, Allen Park, MI

MongoDB Database Administrator/Developer

Responsibilities:

• Designed and Developed Mongo instances on containers as part of organizations initiative to build a data center of the future.
• Created multiple pods inside containers and managed them through kubernetes orchestration capabilities on OpenShift by RedHat.
• Worked on replication controllers inside the containers and backed up the entire cluster with persistent volume claims on coreos tectonic.
• Administered and managed Github and Quay repositories to store mongo images and monitor those images everyday for possible vulnerabilities.
• Consulted with the operations team on deploying, migrating data, monitoring, analyzing, and tuning MongoDB applications.
• Created docker images for mongo and configured several instances and replica sets through them.
• Study and analyze the database needs of the application team within the organization and provide them with optimized solutions using MongoDB.
• Maintained database performance, capacity planning, backups and performance tuning.
• Distributing replica set members across geographically distinct data centers for redundancy and provides fault tolerance if one of the data centers is unavailable.
• Administering replica set health using Mongo OPS Manager to maintain data using high availability and automatic failover.
• Provide technical documentation, infrastructure diagrams to train, collaborate team on-site and offshore.
• Maintain Rally backlogs, iteration planning, as a push to Agile project from Waterfall methodology.

Environment: MongoDB, Docker, Kubernetes, CoreOs Tectonic, OpenShift, RedHat, Quay, GitHub, OPS Manager, Powershell, Vagrant.

Confidential, Charlotte, NC

Mongo Database Administrator

Responsibilities:

• Created new Mongo multiple versions Instance - based on architectural requirements. Configured and set up the database with multi storage engine, dynamic schemas, users and roles.
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design.
• Set up and administered large clusters consisting of numerous shards/replica sets.
• Delivered full life cycle support of clients. Optimize query performance by building various types of indexes.
• Managing indexes efficiently and measuring Index use of all database operations. Implemented Document validation option in multiple databases.
• Familiar with Embedded and Normalized data models in MongoDB. Backup and restore LVM snapshots on MongoDB Linux environment.
• Calculating database and system I/O statistics for MongoDB performance tuning.
• Created GridFs collection for large documents which are having BSON-document size more than 16 MB.
• Cleaning orphan chunks in GridFs collections. Different levels of access provided by database roles.
• Good knowledge on database Administration and, cluster Administration and superuser roles.
• Handling rollbacks during Replica set failover and restore rollbacks to avoid data loss.
• Monitoring chunk migrations and debug issues when chunk migration failure's occurs in shared cluster.

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

Confidential, Roseland, NJ

Mongo DB Admin

Responsibilities:

• Performed Installation, configuration of multiple versions of MongoDB (2.x, 3.0.x, 3.2.x)
• Determined Use Case would bring various data from different applications and create a single view of the data for quick access.
• Created data model and imported data using mongo import. Granted users authorization and authentication.
• Backed up databases using Mongodb backup facility in OPS manager. Migrated data from MMAPv1 to WiredTiger storage engine.
• Developed, deployed and managed several MongoDB clusters whilst implementing robustness and scalability via Sharding and replication, including automating tasks with own scripts and open-source tools for performance tuning and system monitoring.
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design.
• Developed enhancements to MongoDB architecture to improve performance and scalability.
• Collaborated with development teams to define and apply best practices for using MongoDB.
• Rolled out and administered sharded and non-sharded clusters.
• Used various MongoDB utilities (mongostat, mongotop, mongoperf, etc) to monitor database.
• Designed and implemented GridFS collections.
• Monitored and tuned user-developed JavaScript using explain plan.
• Changed priority of replicaset nodes to keep Primary on specific data nodes. Worked on BulkWrite operations in MongoDB.
• Implemented LDAP authentication mechanism in MongoDB cluster.

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

Confidential, Denver, CO

Sr. Database Administrator

Responsibilities:

• Provide level 3 support to mission critical, Production, Test and development databases in 24*7 environment
• Performance tuning to enhance performance of SQL statements. Improved performance of existing process that reduced runtime from 8 hours to 5 minutes.
• Created script to migrate users from one environment to another.
• Improved existing storage capacity reporting to analyze and provide trend to leadership.
• Automated excel dashboard and reporting with the use ODBC connectors that saved 5 man hours every day.
• Performed POC’s on NoSQL databases. Implemented NoSQL databases like Mongo, Cassandra in Dev/Test environment.
• Perform compression and move activity and data warehouse database
• Database cloning through Data Pump Import and Export
• Develop and maintain monitoring scripts to check the health of the database
• Unix Shell scripting

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

Oracle Database Administrator

Responsibilities:

• Designed, maintained, created and configured databases for DEV, UAT and PROD.
• Provided the support to the application team in benchmarking and also to get the desired data for testing using the flashback feature.
• Created, added redo logs and members. Monitored the log switching in the redo logs.
• Operating System security, Data security policy, User security policy and Password Management policy as per bank’s requirement.
• Database Backup through RMAN to Tapes and restore from Tapes to disk
• Import and Export of Data. Daily backup of archive logs
• Managed disk space and paging space management for the consistent performance of database.
• Analyzed the bank’s requirements and implemented the changes on the database level.
• Created and configured the logical standby database. Monitored performance of the logical standby database. Kept the PROD and Data guard in sync.
• Monitored application servers for the 100% uptime and load balancing. Managing the load balancing of two nodes through the user connections on the application servers.
• Monitored Disaster Recovery server and checking the log transfer. Ensuring the data to be in synch.
• Applied Security Interim Patch and upgraded the database.
• Tuning of databases for consistent performance. Prepared reports for AIX system to monitor the system level performance, resource utilization.

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

Confidential

Jr. Data Analyst/DBA

Responsibilities:

• Provide level 1 and 2 to support mission critical database for 24*7. Installing ASM, Creating Database and providing Database Support & Maintenance.
• Export / Import and Job Scheduling.
• Database Migration from Oracle10g to Oracle11g. Cloning of the database and applying the upgrade patches.
• Developed various database monitoring shell scripts.
• Importing Data according to the users request and maintenance of Oracle Production, Development, and Testing Databases.
• Developer’s requests in terms of assisting them in effectively create tables, views, packages, sequences, schema refreshes.
• Resource Management (Create and manage Indexes, Tables), allocate and manage physical storage structures like Datafiles, Redo logs, Control files. Allocate and Manage logical storage structures like Tablespaces.

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