Manager Data

K.Parasuram

Email: *************@*****.*** Ph #: 704-***-****

Professional Summary:

Over 5 years of experience in NoSQL Database Administration and Oracle database administration. Involved in migrations, configuration, database security, capacity planning, space management, data modeling, backup and recovery, cloning, auditing, SQL, PL/SQL, NoSQL, Amazon web services, troubleshooting and documentation.

Experience in upgrading and migrating various versions of Mongo database on different platforms.

Focused on architecting Mongo database.

Designed and developed custom Mongo applications specific to client needs.

Proficiency in multiple databases like MongoDB, ORACLE.

Fast learner can quickly incorporate and implement new procedures with efficiency and accuracy.

Skilled in troubleshooting with good organizational and interpersonal skills.

Team player with excellent communication skills and ability to lead. Self-motivated individual with exemplary analytical and problem-solving skills.

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.

Involved in designing various stages of migrating data from RDBMS to Mongo DB.

Expertise in AWS, experience in implementing new AWS EC2 instances and working with EBS and S3 storage.

Experience in Installation, Configuration and Maintenance of Oracle 12c,11g/10gRAC with ASM and single instance database.

Full life cycle experience in highly secure, extremely large-scale deployments of very high volumes of critical data with extensive security.

Experience in various phases of SDLC such as requirements gathering, analysis, design, implementation, maintenance of software applications and testing Client/Server and web applications.

Responsible for most of the view/controller changes, model/database integration with other members of the team.

24x7 Production Database Support to ensure availability, efficiency and recoverability.

Professional Experiences:

Client: John Deere, Milan-IL Sept 18 – Till Date

Role: Mongo DBA

Responsibilities:

Worked on MongoDB database concepts such as building Indexes, Shard clusters, replicasets.

Design architecture of MongoDB multiple versions 3.4.x, 3.6.x, 4.0.x Replica sets, Sharded cluster.

Experience in managing MongoDB environment from availability, performance and scalability perspectives.

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.

Enabled SSL, PEMKeyFile, CAFile and coordinated with Devops team and Linux Admins regards to Root Certificate.

Migrated Mongo database from MMAPV1 storage engine to WiredTiger storage engine.

Managing Mongo databases using MMS monitoring tool.

Worked on multiple BSON type objects and used based on requirement.

Implemented multiple CRUD operations and familiar with new enhancements in each release.

Supported Bulk Write operation jobs and analyzing the queries and performed tuning based on environment.

Supported Mongo queries in improving performance by analyzing performance tests.

Wrote services to store and retrieve user data from the MongoDB for the application on devices.

Performance tuning and stress-testing of NoSQL database environments 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.

Developed Python scripts to monitor health of Mongo databases and perform ad-hoc backups using Mongodump and Mongorestore.

Built Ops manager from scratch.

Monitored Mongo replicasets using Ops manager.

Did Point-in -time restores, backups, profiling on Ops manager.

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 creating distinct types of indexes on different collections to get reliable 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 secondaries to avoid human failures in coding and development.

Created Ad hoc reports by querying multiple collections with $lookup operator

Have written various aggregation pipelines ($group, $project, $sort, $match, $limit and $skip) and created views based on the different business requirements

Strong experience in analyzing chunk migrations, splitting and balancing across the cluster.

Skilled in troubleshooting with good organizational and interpersonal skills.

Environment: MongoDB 3.4, 3.6, 4.0, Ops Manager, mtools, Robo 3T, Studio 3T, Aggregation, Mongo Shell, Sharding, Replication, shell scripting, python.

Client: Lowes, Mooresville-NC May 17 – Sept 18

Role: Mongo DBA

Responsibilities:

Experience in managing, installation, configuration and administration of MongoDB (Versions 3.0x, 3.2x, 3.4X and 3.6X)

Good knowledge on creating collections and performed CRUD operations like Update, Insert & Delete and using aggregation operators.

Good experience with installing, configuring and monitoring with OPS manager.

Experience in adding clusters to the Ops Manager.

Worked on setting up the scheduled backup in Ops Manager. Worked on setting up the alerts from Ops manager.

Experience in monitoring, performance tuning and managing MongoDB Cluster.

Experience in deploying, managing and developing MongoDB Clusters.

Worked on maintenance of SHARDS, REPLICA-SETS in rolling fashion as a part of high availability.

Experienced in monitoring, back up and scaling Mongo databases using OPS Manager.

Good knowledge in establishing the Point in time Backup in MongoDB using OPS Manager.

Efficient in Sharding setup, sharding monitoring, shard key selection, inserting large amounts of data in MongoDB.

Experience in installing MongoDB from Scratch.

Experience in identifying the slow queries and analyzing the explain plan. Implemented read preferences in replicaset.

Good Knowledge on Backup/Restoration of Database through Mongo dump/Mongo restore utility.

Hands on experience in building the indexes for the faster querying and good performance.

Experience in resize the Oplog size in MongoDB Versions 3.4 and 3.6.

Experience in migrating the storage engines MMAPv1 to Wire Tiger

Enabled and setup the MongoDB Auditing.

Enabled SSL, PEMKeyFile, CAFile and coordinated with Devops team and Linux Admins regards to Root Certificate.

Experience in creating the PEMKey Files.

Created users in MongoDB at database levels, admin level with assigned privileges. In depth knowledge about the chunk migration in sharded clusters.

Experience in enabling security at data base level by creating users at database level with limited privileges and roles.

Good experience and knowledge on using GridFs in storing large documents exceeding the size limit of 16MB.

Hands on experience in setting up the priority of the nodes in a replicaset. Experience in adding shards in existing sharded cluster.

Environment: MongoDB, MMS/OPS, mongostat, mongotop, mongofiles,, Linux/Unix, primary, secondary, priority, query optimizer, read concern, read preference, write preference,write concern

Client: Tigeen Solutions,India Sep 14 – Nov15

Role: Oracle DBA

Responsibilities:

Provided System support for both development and 24/7 production environments.

Experienced in ORACLE Software Installation, DBCA to create database and DBUA to upgrade Oracle database on the Red Hat LINUX and Windows environment.

Experience in implementing and maintaining Virtual machine (VM).

Tuning for performance at Operating system level and Database Level. Performance tuning with ASH, AWR, ADDM Reports.

Monitors database activity and file usage, and ensures necessary resources are present.

Perform daily incremental backup and full weekly backup using Oracle recommended backup utility, RMAN.

Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.

Developed RMAN scripts for database backup and recovery including hot and cold backup.

Database migration using Data Pump as well as RMAN.

Operating system CPU average, Load average, IDLE time average monitoring by TOP, IOSTAT, NETSTAT, and VMSTAT.

Creating and dropping of users, granting and revoking permissions to users/roles.

Using Oracle Enterprise Manager (OEM) for routine administration, database monitoring, replication process and performance tuning.

Monitoring Oracle RDBMS availability, database exports, tablespace, and extents reports.

Develop and enforce database related policies, standards, naming conventions, operating procedures and best practices.

Create and maintain multiple databases, users, roles and privileges.

Administer database user accounts. Create, modify, reset username/password, lock and unlock user accounts.

Familiar with Fine Grain Access (FGA) and Fine Grain Access Control (FGAC).

Experience in schema management, Tablespace, datafile and extent management, as well as user and privilege management.

Tablespace management including, adding/resizing data files, allocated quotas to user and managed disk space.

Extensively used data moving utilities like export/import, Data Pump.

Familiarity of Oracle High Availability Architecture (HA) involving Oracle RAC, ASM, Golden Gate, Data Guard and EXADATA.

Optimized database performance by analyzing tables and indexes.

Environment: Oracle 10g,RMAN,Virtual machine (VM), Agile/Scrum Windows, MS-Project, MS-Office Suite, MS Visio, MS PowerPoint, Quality Center 10, UNIX, SQL, Data Analysis.

Educational Qualifications:

MS in Computer Science -2018.

University: Texas A and M University Kingsville.

BTech in Electrical Engineering- 2014.

JNTU-Ananthapur.

Contact this candidate