Manager Data

SYNOPSIS:

IT professional with total experience of 7+ years of relevant experience in Development of Client/Server applications using NoSQL databases, Oracle databases/Oracle applications tools and RDBMS concepts.

Over 3+ years of experience in installation, configuration and administration for MongoDB versions 2.x, 3.0.0 and 3.2.x.

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

Proficiency in multiple databases like MongoDB, Cassandra, MySQL, ORACLE and MS SQL Server.

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

Focused on architecting NoSQL databases like Mongo, Cassandra and Cache database.

Designed and developed custom Mongo applications specific to clients’ needs.

Thorough experience in designing MongoDB sharded cluster and monitoring with OPS manager and cloud MMS.

Strong experience in SQL, SQL*PLUS, PL/SQL, back end programming using Packages, Functions, Stored Procedures, Exception handlers, Views, Ref Cursors, Record Types, UTL_FILE and other built in packages for Oracle 12c/11g and also SQL queries/reports and scripts.

Worked on various phases of Software Development Life Cycle (SDLC) such as Project Requirement Analysis, System Analysis & Design, Coding, Unit Testing, Quality Assurance, Project Planning and Documentation.

Expertise in developing complex code units, Database triggers and using the latest features to optimize performance (Bulk Binds, Materialized views, Inline views, Global Temporary Tables).

Applied skills in software development, architecture, design, and support for new and existing products.

Excellent analytical, logical and programming skills, Self-Motivated, Self-Starter, and Team Player, can work with minimal supervision. Effective Communication, Organizational and Time management skills.

Experience in implementing new procedures and a fast learner.

Have a good skill in trouble shooting and solve problems effectively.

CERTIFICATIONS

Certified servicenow administrator

PROFESSIONAL EXPERIENCE:

Cable Vision/Altice USA, Long Island, NY May 2015 – Till Date

Sr. MongoDB Administrator

Responsibilities:

Worked on troubleshooting and evaluating different NoSQL database systems and cluster configurations to ensure Redundancy, high-availability in different crash scenarios.

Implemented and managed multiple environments (up to 10TB), automating backups and checks, restore, validation/integrity checks, growth modeling and predictions, and system expansion; assisted with upgrade efforts with MongoDB

Responsible for Design, Architecture, and Capacity planning for MongoDB/Cassandra clusters.

Assisted in managing MongoDB environment from Disaster Recovery, availability, performance and scalability perspectives.

Configuring high availability using geographical MongoDB replica sets across multiple data centers.

Played Key Role in implementing MongoDB write concern to avoid loss of data during node failures.

Played Key Role in Implemented read preferences in MongoDB replica set using tag sets.

Implemented setting Priorities for the nodes, delayed secondary’s as per the Application Requirements.

Good knowledge in configuring Oplog size as per the mongo DB requirement.

Implemented MongoDB on physical machines, Virtual machines as well as AWS.

Implemented Time To Live Index, Capped Collections to wipe out aged data based on requirements

Good knowledge on MongoDB database concepts such as transaction, locking, transactions, indexes, Sharding, replication.

Used MongoDB third party tools (MONGOVUE,ROBO MONGO, MONGOOWL) and mongo-built in binaries to monitor and analyze the performance of MONGODB.

Involved with creating shards, replica sets, monitoring, Backup and Restore .

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

Migrated Mongo database systems from No-SSL authentication to SSL authentication using certificates.

Backup & Recovery, Database optimization and Security maintenance.

Implementing on-premise MMS/OPS manager monitoring and backup solution.

Implemented various Indexes like single, compound and text on various collections to achieve better query performance.

Good experience in writing Ruby/Python scripts to monitor Mongo databases and perform ad-hoc backups using Mongo dump and Mongo restore.

Extensive knowledge in deploying, configuring, managing sharded MongoDB clusters.

Good experience in choosing shard keys based on the application query pattern to the collections.

Good knowledge on working with Range based shard key, Hashed based shard key and Tag aware sharding.

Good knowledge on chunk migrations, splitting and balancing across the cluster.

Implemented pre-splitting mechanism using shard keys to distribute data across shards.

Environment: MongoDB, Cassandra, Mongo Chef, MMS, Cloud Manager, OPS Manager Linux/Unix, Sharding, Replication, Gridfs,TTL,Storage engine, java scripting, Shell scripting, Microsoft Visio.

CSC, Albany, NY Jan 2014 – April 2015

NoSQL Administrator

Responsibilities:

Designing and architecting mongo Replica set and Shard cluster based on client Requirement.

Worked with development team for schema designing and index suggestion in mongo db.

Extensive knowledge in setting up Ops Manager for the mongo Deployment.

Performed installing and configuring the block store and OPS store for the deployment using OPS Manager and Cloud manager.

Maintaining mongo deployment Replica set and shard cluster in AWS systems.

Deploying automation agent, monitoring agent and back agent settings for the mongo deployment from OPS Manager.

Experience in spinning up mongo Instance from OPS manager using automation agent from OPS manager GUI.

Working with development team in choosing shard key for sharding the collections based on the requirement.

Good experience in migrating mongo deployments from lower version 2.6.x to 3.0.x.

Troubleshooting, analyzing the mongo performance related issues and capacity planning.

Used mongo DB third party tool like mongo chef for mongo security management.

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

Good knowledge on database and collection data migration from one environment to another.

Good experience in cluster configuration and Datacenter awareness for the mongo deployment based on the requirement.

Good experience in writing scripts for creating customized roles for mongo security admins.

Worked on setting mongo Write concerns and read preferences based on the requirement.

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

T- Mobile, Atlanta, GA April 11 – Dec 13

Database Administrator

Responsibilities:

Involved in 24x7 Oracle Production Database Administration.

Performing all the Database Administration activities like installation, configuration, cloning, patching, upgrade, performance tuning, backup & recovery, space management in database, user and roles administration, schema management.

Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications.

Monitored Production Databases, Performed performance tuning, added data files, resized segments, and tablespaces.

Installed and configured Oracle 10g.

Migrated Oracle 9i database to Oracle 10g/11g.

Storage and space management including table spaces and data files.

Monitoring Database for fragmentation and correcting them.

Database performance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan.

Monitoring and Management of table space growth, extent growth.

Planning and implementation of Backup and recovery procedures and Maintenance of Database.

Performed Backup/Recovery using RMAN.

Wrote scripts for Startup, Shutdown and automation of backups.

Monitoring Scheduled jobs of the daily activities for the performance of all the databases.

Prepare the documents of the process and knowledge transferring about the project to the new team members.

Involved in the process of tuning and refining queries of various applications.

Written scripts for Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.

Environment: Oracle 9i,10g,11g, Windows 2000/2003, Linux 4/5/6, RAC, RMAN, Grid, Dataguard.

All State Insurance, FL April 09 – Feb 11

Oracle PL/SQL Developer

Responsibilities:

Created PL/SQL Stored Procedures, Functions, Triggers and Packages to transfer the data from the intermediary database to the main database using DB Links.

Designed and developed Risk engine rules to accept inputs and validate the input through defined set of rules and generate the output using PL/SQL procedures.

Created automated jobs using UNIX Shell scripts to run all the Sql files in a directory by invoking SQL *Plus.

Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming for generating worksheets.

Created Views, Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.

Created PLSQL infrastructure for Debugging and Error Handling using stored procedures and Functions in packages.

Created UNIX shell scripts for Encrypting and Decrypting data files.

Worked with DBA to implement compression on Database tables.

Worked with DBA to set up Oracle Streams that streams data from OLTP to DWH database.

Monitoring Autosys jobs in QA, DEV and production.

Implemented Interval range and Hash partitions to help improve the performance of SQL queries.

Maintaining different versions for DDL extract of schemas and applications files (version control) using Tortoise SVN.

Used Exception Handling extensively to debug and display the error messages in the application.

Involved extensively in Tuning SQL queries and PLSQL scripts by using SQL rewrite, partitions and Indexes.

Perform data modeling and create/maintain and modify complex database triggers and data migration scripts.

Used SQL*LOADER and External tables to upload data into the tables.

Worked on Power Exchange to create Mappings, workflows that loads the data from Flat files coming from source system to Oracle database.

Monitored Informatica workflows using Informatica workflow monitor.

Involved in Implementation and end user training.

Worked on production support, and receive production calls, and working on trouble reports which are received from clients

Environment: Oracle 11g, SQL Developer, SQL Navigator, Tortoise SVN, HP Project and Portfolio Management, Windows XP, UNIX, Secure Shell Client.

Contact this candidate