PROFESSIONAL SUMMARY:

• Around 6 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 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) 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 dataguard.
• 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)

TECHNICAL SKILLS:

RDBMS: Oracle 9i and 10g, 11g, SQL SERVER 2008

No SQL database: Mongo 2.6/3.0/3.2/3.4

Tuning Tools: Profiler,SQL Auto Tracing, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, Tuning advisors, ADDM, oradebug, OS Watcher and SQL Plan stability management etc.

Operating System: Solaris 8/9/10, HP-UX, SUSE Linux, Red Hat Enterprise Linux Advance/Enterprise Server 4/5, HP-UX, Windows 9X/XP/2000, IBM AIX 5.1/5.2/5.3/5.5/6.1,

Languages: Javascript,SQL, Perl, PL/SQL, Linux/UNIX Shell Scripting,HTML, C & C++

Database Tools: Robomongo,Mongocompass,Mongostat,Mongotop,mongovue,Oracle Enterprise Manager Database Control, Rman,OEM, Dbverify, Tkprof, Statspack, AWR, ADDM, SQL Loader, Data Pump,SQL Server 2005/2008/2012,

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, North Carolina

Mongo Database Administrator

Responsibilities:

• Designed, Installed and configured a multi node MongoDB sharded cluster and replica sets on Linux and Windows platforms.
• Ensure technical documentation is kept up to date (architecture/integration diagrams and documentation).
• Good knowledge on 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.
• 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 replicaset to sharded cluster because of data size growth and better query rate planning.
• 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.
• Good knowledge on 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.
• Migrated instances from MMAPV1 to Wiredtiger storage engine.
• OPS manager installation and configuration for sharded clusters.

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

Confidential, Warren, New Jersey

Mongo Database Administrator

Responsibilities:

• Created environment consists of Red Hat Linux servers with replica sets and shards in Dev, Test/Release, Stage, and Production.
• Worked on multiple BSON type objects and used based on requirement.
• Implemented multiple CRUD operations and familiar with new enhancements in each and every release.
• Performance tuning and monitoring of Mongo databases with OPS manager/MMS.
• Familiar with all Mongo shell commands.
• Implemented point in time restores backups using OPS manager.
• Supported Bulk Write operation jobs and analyzing the queries and performed tuning based on environment.
• Understanding Aggregation pipeline operations have an optimization phase which attempts to reshape the pipeline for improved performance.
• Worked with Aggregation Pipeline Limits and memory restrictions.
• Tracing connections to the Mongo database and monitoring utilization of resources for each process.
• Enabling profiling level to debug issues and tuning long running queries.
• Understanding the differences between each version of MongoDB and enable the new features in each release.
• Built index on secondary’s to minimize the impact of building an index on replica set.
• Potentially long running index building operations performed by creating Index in background.
• Extensive experience on Wired tiger storage engine document level concurrency, snapshots and Checkpoints.
• Configured Role-Based Access Control with custom roles and privileges.
• Running MongoDB with secure configuration options.
• Configured hidden replica member and it is used for reporting and backups.
• Migrated replica set nodes from one server to other server without down time.
• Familiar with Range based sharding and Hash based sharding.
• Deploying config servers as replicaset in version 3.2.

Environment: Mongodb2.6/3.0/3.2,OpsManager2.0,Linux,Sharding, Replication,oplog, Linux, mongocompass, robomongo

Confidential

Data Base Administrator

R esponsibilities:

• Involved with installation and maintenance of Oracle Confidential for high availability.
• Involved in the change control process and Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
• Worked extensively on monitoring 10G/11g Grid Control and Configuration of error notifications, installing listeners, and adding them to the grid control
• Maintained 10g/11g Confidential environment and troubleshooting issues. Having good experience in Migrating single Instance database to Confidential Environment
• Performed Capacity Planning, Undo segments and Health check reviews in Confidential .
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement. Scheduling the databases backup using Cron tab and VERITAS net backup.
• Involvement in space management, rectification of lock problems, managed quotas. Performed Migration of databases 10g on Hp - UNIX to Oracle 11gR2 on Linux.
• Created, monitoring database objects like Indexes, Views, Users, and DB Links. Implemented High availability using Golden Gate Replication.
• Wrote scripts for database maintenance activities such as monitoring the growth rate of table spaces and extents. Also wrote UNIX scripts to process batch jobs.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
• Extensively used features such as Data Pump, Flash Back Recovery, ASM, AWR, ADDM for Generating reports
• Created Partition’s estimated stats on one partition1 and copied the stats to remaining partitions using dbms stats.
• Worked with DW team on problem resolution and implemented change requests. - Performance tuning on DW such as Data extraction from production to Data warehouse.
• Installing web logic server and creating domains. Troubleshooting weblogic server issues.
• Starting up and shutting down the weblogic services and managed servers. Deploying ear/jar/war files from weblogic admin console.
• Installing Retail applications (RMS, ReSA, SIM, RIB and CO). Applying patches to all retail applications.
• Upgradation of retail applications.
• Deploying the custom code into all retail applications. Creation of Point of sale (POS) stores and Backoffice(BO) domains under weblogic server
• Involved in 24x7 production database maintenance and on-call support. Conducted time-to-time analysis and monitoring of the software and hardware requirements and act accordingly

Environment: Oracle 10g/11g, Confidential on Sun Solaris, Linux, RMAN, Data Guard, Toad, Exadata, OEM, ASM, Oracle Enterprise Manager (OEM),weblogic server,oracle retail applications.

Confidential

Oracle DBA

Responsibilities:

• Installation and Configuration of Oracle 11g on HP Unix
• Managing data file objects including tablespace and datafiles, object sizing as well as monitoring database usage and growth.
• Managing tablespaces, user profiles, indexes. Responsible for creating user logons and managing user accounts.
• Monitor the instance and plan for future availability of storage on user’s table spaces
• Suggesting tuning solutions for SQL queries and Database.
• Performance Monitoring the Server for Better performance. Adding space to the data files according to tablespace growth
• Backup and Recovery strategies for Oracle database using exp/imp, cold and hot backups.
• Taking an export backup of tables for future database recovery. Modifying Oracle parameter (init.ora) for Oracle performance and growth

Environment: Oracle 9i/10g/11g Confidential with Solaris/redhat,, Toad, SQL plus, Oracle Enterprise Manager (OEM), RMAN, Solaris 9/10,AIX,Shell Scripting,, Net Backup, Time finder Backups, RMAN, Redhat/Suse Linux, expdp, impdp, AWR, ADDM, Statspack, tkprof