Sharan Kumar

MongoDB DBA

313-***-****

adla95@r.postjobfree.com

Professional Summary:

7+ years of experience in installation, migration, designing, backup, recovery, scripting and performance tuning in development, test and production database.

Proficiency in multiple databases like MongoDB and Oracle.

Experience working with storage domains like NFS, NAS and SAN

Experience in working in a cloud environment.

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

Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases. ETL and data warehouse design experience, especially with Greenplum.

Proficient with all major PostgreSQL procedural languages (PL/PgSQL, PL/Perl, PL/PgPython, PL/Tcl) as well as some Oracle PL/SQL and SQL - Server T-SQL.

Excellent SQL skills including query optimization, complex nested and co-related queries, common table expressions, window functions, and business analytical reporting.

Extensive experience in developing Map-Reduce programs and aggregation frameworks using JavaScript's.

Experience in upgrading and migrating various versions of Mongo database on different platforms and provide solutions related to the migration to MongoDB.

Experience in query optimization and performance tuning.

Extensive experience in designing MongoDB replica sets and multi - sharded cluster.

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

Designed and developed load balancing Mongo applications.

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 compass, Mongo Chef) and mongo-built in binaries to monitor and analysis the performance of MONGODB.

Extensive experience in scripting in Linux, UNIX and Windows environments.

Proficient in setting up the standby database using RMAN utility tool, activating and re-building standby databases both physical and logical supported by data guard.

Loading data from flat files, external tables to oracle database tables using SQL*Loader.

Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.

Tuning of the database for increasing performance using the tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, SQLT, AWR, ADDM.

Partioning large tables depending on the data for performance of the database.

Maintaining database security using security compliance auditing and profile management, password complexity in order to control access to the database.

Database management for scheduling, tuning, taking backups using Oracle Enterprise Manager (OEM).

Expertise in using Oracle Grid Control.

Developed database monitoring/health checkup alerts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance and maintenance.

Experience in web logic server and creating domains. Experience in troubleshooting web logic server issues

Experience in installing and upgrading Retail applications (RMS, ReSA, SIM, RIB and CO)

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.

TECHNICAL SKILLS:

Modeling Tools

Microsoft Visio, Jira, GitHub

Programming Languages:

JAVA, SQL, HTML, CSS, Java Script and JSON, Node JS(WT)

Development Tools:

Net Beans, Eclipse IDE, MS Office, MySQL Workbench

Operating Systems:

MS Windows, Vista, Linux, Unix, MVS.

Data Bases:

MongoDBv2.2-3.4, MySQL (5.5-5.6), PostgreSQL 8/9

MS SQL Server v.10-v.12, Amazon DynamoDB, MS Access, Oracle 11g /12c.

Virtual Machine

VM Ware Server

Development Tools

Mongo Vue, RoboMongo, Mongo chef, MongoDB Compass, NoSQL Manager and Mongo Booster, SQL loader

Web Servers

WampServer and AWS

PROFESSIONAL EXPERIENCE:

PG&E, San Roman, CA Sep 2019 to till date

Role: Mongo DB DBA

Responsibilities:

Worked on MongoDB database concepts such as building Indexes, locking, transactions, Shading, replication, schema design

Design architecture of MongoDB multiple versions 4.0.x, 4.2.x Replica sets.

Designed, Installed and configured a multi node MongoDB sharded cluster and replica sets on Linux and Windows platforms.

Designed MongoDB replica sets and multi-sharded cluster

Ensure technical documentation is kept up to date (architecture/integration diagrams and documentation).

Configuring Read Preferences on a per-connection or per-operation basis.

Performed query optimization, understanding query plans and plan cache filters for better performance.

Evaluate performance of Current Operations in database and deliver proper solution based on read,write operations.

Generating Mongo DB and API prototypes for the proof of concepts

Monitoring document growth and storage performance by considering multiple factors like write performance, including random access patterns, disk caches, disk readahead and RAID configurations.

Created Text Index for querying specific documents with string content.

Supported choosing a shard key and make sure even distribution of data across multiple shards.

Converted replica set to sharded cluster because of data size growth and better query rate planning.

Usage of tools like Robo Mongo, MongoChef, and NoSQL Manager for migration of data between databases without any kind of data loss.

Monitoring and fixing chunk migration issues in large sharded cluster environment.

Creation of users and assigning custom roles to provide access.

Configuring SSL keyfiles to implement security across all mongod instances.

Modyfying Priority of nodes to keep specific node Primary all the time.

replicaset election process and voting members to elect new Primary.

Adding and removing shards from sharded cluster.

Analyzing profiler output and take actions to resolve issues.

Creating documentation during project planning, project execution and project maintenance phases.

Resolution of day-to-day related issues, documentation of Mongo DBA routine tasks.

Detecting performance issues in the system by deploying MMS and Mongo DB profiler

Migrated instances from MMAPV1 to Wiredtiger storage engine.

OPS manager installation and configuration for sharded clusters.

Expertise in Analyzing data Quality checks using shell scripts. Upgrading, installing, and configuring PostgreSQL servers.

PostgreSQL Installation, Configuration, Migration, Upgrades and Patches. Server versions ranged from PostgreSQL 8.2 to 9.5.

Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Databases.

Optimize postgresql.conf for performance improvement. Review all PostgreSQL logs for problems.

Environment: Mongodb 3.2/3.4, Ops Manager2.0, MMS, Linux, Sharding, Replication, mongostat, mongotop, gridfs, profiling

Walmart, Bentonville, AR Sep 2016 to Aug 2019

Role: MongoDB

Responsibilities:

Recommending and implementing best services for REST API integration frame work

Formulating a reusable REST API framework to consume Data from and push Data into Mongo DB

Performed migration from MySQL to MongoDB V 3.0.11.

Performed migration without any kind of impact on students, faculty and university administration.

Installed MongoDB, configured, setup backup, recovery, upgrade and tuning and data integrity.

Worked on creation of databases, collections and deployed JavaScript’s using mongo shell.

Performed query construction for further business requirements.

Performed CRUD operations on the data imported.

Overcame challenges like data migration from MySQL to MongoDB.

Usage of tools like RoboMongo, Mongo Vue and NoSQL Manager for migration of data between databases without any kind of data loss.

Responsible for managing MongoDB environment with high availability, performance and scalability perspectives.

Performed operations related to sizing, query optimization, backup and recovery, security and upgrades including administration functions as part as profiling under assistance.

Performed tuning on a daily basis for preventing issues and providing capacity planning using MySQL enterprise monitor.

Developed stored procedures, triggers in MySQL for reducing traffic between client-servers.

Performed MySQL replication setup and administration on Master-Slave and Master-Master.

Environment: MongoDB, MMS/OP’S manager, mongo stat, mongo top, mongo files, Ruby, Puppet, Linux/Unix, LVM Snapshots, Backup scheduler, Pearl, PyMongo, Java script.

Info Base System- Hyderabad, India Aug 2012 to Jun 2015

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 details –

Bachelor of Computer Science from JNTU University – Apr 2012

Master of Computer Science from Silicon Valley University – Aug 2016

Contact this candidate