SUMMARY

• 6 years of IT experience in Database design, administration and all aspects of Systems Development using Client/Server technologies that includes Requirements gathering, Analysis, Design and Development
• Extensive knowledge in MongoDB concepts and good knowledge in Administration.
• Experience in upgrading and migrating various versions of Mongo database on different platforms.
• Focused on architecting NoSQL databases like Mongo, Cassandra and Cache database.
• Developed enhancements to MongoDB architecture to improve performance and scalability.
• Expert in Oracle database design and administration.
• Experienced in Writing UNIX Korn Shell Scripting for job scheduling and sequencing
• Experience in Performance Tuning of SQL and Stored Procedures and Java scripts
• Good expertise in using Database tools like MongoVue, Mongo compass and Toad.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Configured MongoDB as a service in Linux and Windows environments.
• Performed Pre Migration Assessment, Migration & Post Migration
• Identifying Reports Complexity, Implemented Row level/Column Level/Report Level Security
• Experience in data retrieval methods using Universes, Personal Data files, Stored Procedures, and free hand SQL
• Proficient in SQL and PL/SQL coding
• Excellent Communication skills

TECHNICAL SKILLS

Database Tools: MongoVue,Robomongo,MongoCheff,Mongodump,Mongorestore,Mongofiles,MMS

Databases: Mongo 2.x,3.0.x,3.2.x,3.4.x Oracle 11g/10g/9i/8i,MS Access 2000, MS SQL Server

Web/Application Servers: Apache Tomcat, JBoss, Web logic

Testing Tools: QTP 9.2, Win Runner 8x, Test Director

Languages: Java, C, C++, COBOL, VB, SQL, PL/SQL, HTML, XML

Others: MS Office - 2003, MS Project

O/S: Windows NT/XP Prof/2003 Server/2000/98/95, UNIX, Solaris, Linux (RedHat 7.0/6.0/5.0)

PROFESSIONAL EXPERIENCE

Confidential, Franklin Lakes, NJ

Sr. Mongo Database Admin/Engineer

Responsibilities:

• Conducting case / system / process study for project planning, scoping, estimation, tracking for MongoDB clusters.
• Built MongoDB multiple version (2.x, 3.0.x,3.2.x and 3.4.x) of cluster.
• Implemented TTL and indexing based on collection of profiling data and EXPLAIN analysis.
• Performed monitoring and capacity planning.
• Responsible in performing multiple upgrades to maintain the database function without errors.
• Experience in handling the service requests with MongoDB Jira for resolving issues.
• Suggested suitable MongoDB Data Modeling techniques for application team.
• Monitoring of Document growth and estimating storage size for large MongoDB clusters depends on data life cycle management.
• Adding and removing shards from sharded cluster.
• Enable sharding on databases and collections by choosing suitable shard keys.
• Familiar with Range based sharding and Hash based sharding.
• Measuring the Index use and dropping the indexes which are not actively used by queries.
• Good Knowledge on Journaling process and manage journaling to prevent data loss.
• Converted replica set and sharded cluster from MMAPV1 storage engine to WiredTiger storage engine.
• Configured SSL PEM key file and CA file to encrypt communication channel connections.
• Enforced Keyfile Access Control in a Replica Set and sharded cluster.
• Converted secondary node to Arbiter based on requirement to reuse of storage for different application.
• Sizing of Oplog based on Workloads and to maintain replication properly across all the nodes.
• Converted mirrored config servers in 3.0 to replicaset in 3.2 version.
• Maintaining Sharded cluster availability and security across all the nodes.
• Installed and configured OPS manager automation, monitoring and backup agent.
• Implemented better backup solution to backup Mongo Databases.

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

Confidential, Richmond, VA

Sr. Oracle/Mongo DBA

Responsibilities:

• Key person in on-boarding the new applications and re-architecting the application by working closely with the architect team.
• Worked closely with the application team to gather the application requirement with respect to the infrastructure build.
• Provided the application team solutions based on the requirement and issues as per the company policies.
• Prepared the Detail Design Document for the Database migrations and the new application on-boarding.
• Prepared the document supporting the application architecture and resource management. Co-ordinated with the offshore to schedule the application releases.
• Performed various database migrations from 10G to oracle 11.2.0.4 and to 12c. The migration involves change of OS platforms/servers/storage using RMAN, datapump and Golden Gate.
• Performed the database migration using Golden Gate to minimize the downtime of the large database.
• Supported the application performance testing. Analyzed the database and application performance. Worked on the performance tuning.
• Worked on the database, cluster build for Oracle 11g and builds of MongoDB.
• Supported the MongoDB database migrations/upgrade from 2.2.3 to 2.4 and higher versions. Installed and configure the MongoDB replica set.
• Worked on Design Engineering of the Mobile Merge application to introduce the MongoDB.
• Designed the MongoDB application to get the feed from other oracle databases.
• Monitored the MongoDB performance using Ops Manager and ROBO Mongo. Raised tickets through JIRA to resolve any issue.
• Installed and configured the OPS manager and automated MMS agents. Installed backup agents.
• Configured Sharding to support the huge data growth.
• Query the MongoDB database using JSON.
• Configured the database RMAN backup in Data Domain and Netbackup. Restored the database as per the requirement.
• Configured Active Data Guard and performed DR test using snapshot database.
• Monitored the database performance using OEM Grid Control
• Configured the Golden Gate replication for the HA purpose. Resolved Golden Gate issues and performed the POC to set up the replication.
• Participated in the HA testing and storage migrations. Also decommissioning of the databases.
• Debugged and modified the shell script as per the requirement and configured in the crontab.
• Addressed all database related issues.

Environment: MongoDB 2.x,MMS,replicaset,Oracle 10g/Oracle 11g/RAC, Linux, Oracle Enterprise Manager Grid Control, Unix, TOAD and SQL Developer, RDBMS, SQLDBA, PL/SQL, Shell Scripting, stored procedures, ASM, Data guard, Oracle Cloud Services

Confidential, CA

Oracle DBA/Mongo DBA

Responsibilities:

• Managed the Logical standby database and resolved ongoing issues. Maintained the standby database in synch with PROD server. Worked on troubleshooting of the slowness in shipping of archive logs.
• Worked and scheduled on RMAN backup and recovery strategy for new servers and database. Supported the recovery of databases in natural calamities.
• Monitored database performance. Worked on AWR, ADDM, ASH reports for performance tuning.
• Enabled the flashback and even successfully recovered lost data from flashback logs in case of data lost.
• Proposed the architectural implementation plan of migration and installation.
• Managed the user profile and role for secure data access.
• Migrated 10.2.0.4 databases to 11.2.0.3 on ASM and configured new applications. Installed and configured GRID Control and configured the targets to add in the Grid Control.
• Resolved the Grid Control OMS and OMA issues
• Worked on the pre-upgrade and post-upgrade tasks to check the database performance. Used Real Application Testing from Grid Control for the performance and validating the databases. Worked with developers on data validations.
• Applied critical patch and security patches (PSU) on RAC ASM, single node and standby database.
• Implemented data migrations and code migrations as per schedule.
• Installed Golden Gate Director to monitor the GG process and the parameter files. Also installed WEBLOGIC server and client to fulfill the requirement of GG director installation.
• Developed the UNIX shell script to monitor database and to schedule jobs. Monitored server level performance by checking CPU, I/O, and paging. Worked on the system level reports.
• Developed shell script to check listener, database up time, get the automated tablespace and health reports, automated the AWR reports for database monitoring.
• Rebuilding of Indexes to avoid defragmentation and modifying indexes.
• SSL encryption, Mtools, Analysis of data usage for proper index creation and data modeling.
• Distributing replica set members across geographically distinct data centers for redundancy and provides fault tolerance if one of the data centers is unavailable.
• Converted secondary node to Arbiter based on requirement to reuse of storage for different application.
• Sizing of Oplog based on Workloads and to maintain replication properly across all the nodes.
• Maintaining Sharded cluster availability and security across all the nodes.
• Enabled Tag Aware Sharding by tag specific ranges of the shard key and associate those tags with a shard.
• Configured hidden replica member and it is used for reporting and backups.
• Configured delayed member to recover from unsuccessful application upgrades and operator errors including dropped databases and collections.
• Supported choosing a shard key and make sure even distribution of data across multiple shards.
• Converted replicaset to sharded cluster because of data size growth and better query rate planning.

Environment: Oracle 11g/10g /9i, ASM, Sun Solaris 9, Red Hat Enterprise Linux 4.x, OEM, Explain Plan, Tkprof, SQL*LOADER, MongoDB, MMS,OPS, mtools, Robomongo, BSON, JSON, Aggregation, Arbiter

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Installed and configuredoracle9i / 10g databases.
• Created database and location of initial data files, redo log files, control files and multiplexing them editing database initialization parameter files.
• Designed and implemented backup and recovery strategies.
• Tuned application SQL using STATSPACK, SQL Trace and TKPROF.
• Optimized and fine-tuned the database by planning storage requirements, building indexes and altering storage clauses for tables and indexes.
• Created users and assigned roles and profiles to users.
• Maintained data integrity, profiles, resources and password security.
• Used direct path loading vi SQL Loader/ SQL INSERT statement, CREATE TABLE AS SELECT statements, specifying NOLOGGING on staging table, table spaces, parallelized SQL statement execution where appropriate tables.
• Developed PL\SQL code such as procedure, function, package or triggers as well as working with pre-definedoraclepackage to administrate database.
• Coordinated with developers and users connecting to different databases, setting policy and procedures as they relate to database maintenance, security, backup & recovery, SQL coding guide lines.
• Designing and creating schema objects like Database tables, Indexes, Views, Synonyms and all schema objects inOracle.
• Implemented the specific functionality by developing complex PL/SQL code like functions, procedures and packages.
• Performing Daily, Weekly and MonthlyOraclemonitoring and maintenance tasks.
• Coordinating Backup and Recovery operations over all databases, ensuring 100% recoverability.
• Creation of users and Granting them privileges and roles.
• Troubleshooting of various database performances by proper diagnosis Confidential all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory and operating system.
• Writing Shell scripts to automate the data loading processes using Cron jobs and PL/SQL procedures are scheduled usingoraclejob scheduler.

Environment: Oracle 9i,10g SQL Server 7.0, PL/SQL, SQL Loader, RMAN,OracleParallel Server, Import, Export,OracleEnterprise Manager (OEM), TOAD,Oraclewarehouse Builder, SQL Navigator, HTML, JDBC, RedHat Linux

Confidential

PL/SQL Developer

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting data from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

Environment: SQL, PL/SQL, Stored Procedures, XML, XSD, UNIX Shell Scripting,SQL Assistant 6.0, QTP9.2, SQL*Loader, SQL Developer, UNIX, Windows XP