OBJECTIVE

• To excel in the field of Information Technology as Database Administrator by contributing continuously towards organizational growth by providing seamless database support and to utilize every opportunity to achieve both personal and professional development. Hands - on Cassandra, MongoDB, Big Data Hadoop and Oracle with 8+ years of Admin experience seeks a great opportunity in same area.

SUMMARY

• Having 8+ years of total IT experience including Cassandra, MongoDB, Oracle and Hadoop Administration.
• Over 4+ years of experience in MongoDB (versions 2.4.x, 2.6.x, 3.0.x and 3.2) and CassandraDB installation, configuration and administration.
• Experienced in Mongo database design and principles.
• Consult, make recommendations, and design and provide solutions related to the migration to MongoDB and Cassandra.
• In depth knowledge of MongoDB and hands on experience with installing, configuring and monitoring with OPS manager.
• Experience in Writing MongoDB Schema using Mongos.
• Good experience on MongoDB scaling across data centers and/or in-depth understanding of MongoDB HA strategies, including replica sets.
• Migrated Database from SQL Databases (Oracle and SQL Server) to NO SQL Databases (Cassandra/MONGODB);
• Experience in encrypting Data at rest.
• Experienced in database management, data modeling.
• Having 4 years of experience in DBA activities like Database Creation, Tablespace management, User management, Table/Index management.
• Extensive hands-on AWS experience.
• Deploying, managing, and operating scalable, highly available, and fault tolerant systems on AWS.
• Migrated existing on-premises Database clusters to AWS.
• Experience in provisioning, operating, and maintaining systems running on AWS.
• Experience in installation, upgrading and migrating various versions of database (9i/10g) on different platforms.
• Experience in installation and configuration of Oracle 9i/10g Data guard, switchover and failover.
• Strong experience in installation and configuration of Oracle 9i/10g/11g.
• Experience in implementation of backup and recovery strategies.
• Experience in monitoring the performance of database using performance tools such as Statspack, AWR, ADDM and advisors.
• Well-versed in managing very large databases and large environments.
• Experienced in database high availability solutions RAC, ASM.
• Experienced in database maximum availability Data Guard, Golden Gate.
• Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.
• Experience in preparing the Technical Documents on relevant topic.
• Managing projects ranging from simple implementation to heterogeneous setup for organizations of varying size and complexity in a 24/7 production environment.
• Experienced in multiple aspects of big data.

TECHNICAL SKILLS

RDBMS: Oracle 9i and 10g, 11g

Big Data: Hadoop, Map Reduce, Pig, Hive, Sqoop, Hbase, Cassandra, MongoDB

Application: Retail Applications (RMS, SIM, ReSA, ReIM, BackofficeCentraloffice, POS)

Tuning Tools: 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: SQL, Perl, PL/SQL, Linux/UNIX Shell Scripting, Java, C & C++

Database Tools: Oracle Enterprise Manager Database Control, Rman, Dbverify, Tkprof, Statspack, AWR, ADDM, SQL Loader, SQL Server 2005/2008/2012 , MySQL, Mongo utilities (Mongostat, Mongotop, Mongofile, Mongodump, Mongorestore, Mongoexport, Mongoimport), Ops Center, Ops Manager, MMS monitoring system, Kibana.

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, Missouri

Sr.NoSQL Database Administrator

Responsibilities:

• Experienced in deploying, managing and developing MongoDB and Cassandra clusters.
• Automated routine tasks via scripts and tools.
• Well-versed with MongoDB cluster job performance, capacity planning, connectivity and security
• Design database topologies to support a high-performance environment running in multiple data centers.
• Worked with Development, Storage and Network teams in installation and administration of MongoDB in the IT Enterprise.
• Monitored transaction activity and utilization, with particular strengths in performance tuning highly transactional databases in both the development and production environments including remotely located servers.
• Deep understanding of Disaster Recovery setup and scenarios in support of an installed and tested Disaster Recovery environment.
• Encrypting data at rest with the database keys on Wired Tiger storage Engine.
• Provided 24x7 on-call support for production and development systems for both SQL and NoSQL databases.
• Managed and maintained layered development process environments.
• Experienced in Set and tune System Parameters.
• Was involved and responsible for managing more than 75 NoSql clusters .
• Configuring high availability using geographical MongoDB replica sets across multiple data centers.
• Participated in the wider infrastructure DBA ecosystem of Microsoft SQL, Cloudera Hadoop, and associated tools.
• Experienced in monitoring, back up and scaling Mongo databases using OPS Manager.
• Worked on maintenance of SHARDS, REPLICA-SETS in rolling fashion as a part of high availability service.
• Deploying, managing, and operating scalable, highly available, and fault tolerant systems on AWS.
• Migrated existing on-premises Database clusters to AWS.
• Selecting the appropriate AWS service based on compute, data, or security requirements.
• Estimating AWS usage costs and identifying operational cost control mechanisms
• Ability in identifying and gathering requirements to define a solution to be built and operated on AWS.
• Secured MongoDB Database using MongoDB-CR and SCRAM-SHA authentications.

Environment: MongoDB - 2.6,3.0,3.2,3.4, Cassandra-4.8,5.0, Hadoop, CouchDB, SQL-server, MMS, Linux/Unix, Ops Manager, LVM Snapshots, Robomongo, MongoDB Compass, Encryption, Ops Center, AWS, Docker, puppet, Elasticsearch-5.0,logstash,Kibana

Confidential, Warren, New Jersey

MongoDB Administrator

Responsibilities:

• Experience in managing large-scale, geographically-distributed database systems, including relational (Oracle, SQL server) and NoSQL (MongoDB, Cassandra) systems.
• Good experience on MongoDB scaling across data centers and/or in-depth understanding of MongoDB HA strategies, including replica sets.
• Extensive experience in deploying, managing and developing with MongoDB clusters.
• Familiar with MongoDB clusters, performance tuning, backup and recovery.
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication and schema design.
• Point in time Backup and recovery in MongoDB usingonsite MMS.
• Efficient in Scalability: Sharding setup, sharding monitoring, shard key selection, inserting large amounts of Data in MongoDB.
• Data modeling for data from RDBMSto Cassandra and MongoDB for optimal reads and writes
• Familiar with MongoDB clusters, Java scripting to load unstructured data into sharding environment.
• Used MongoDB third party tools (ROBO MONGO, MONGOOWL, MONGOVUE) and mongo-built in binaries to monitor and analysis the performance of MONGODB.
• Worked on pre-splitting mechanism using shard keys to distribute data across shards.
• Creation, configuration and monitoring Shards sets. Analysis of the data to be shared, choosing a shard Key to distribute data evenly.
• Migrated Database from SQL Databases (Oracle and SQL Server) to NO SQL Databases (MONGODB).
• Performed on-call technical support to minimize the impact of system disruptions.
• Management of databases on multiple servers.
• Developed Scripts for transferring data from production server to testing/development servers.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, Stored outlines, Statistics.

Environment: Hadoop, Cassandra, Mongo DB 2.4, 2.6, HBase, Ruby, MMS, Puppet, Linux/Unix, LVM Snapshots, Backup scheduler, Dataguard, Pearl, PyMongo, Java script.

Confidential, Winston Salem, North Carolina

Oracle DBA

Responsibilities:

• Key participant in requirement gathering session with business users to understand and document the business requirements of the client as well as the goals of various projects.
• Installation and configuration of Oracle Database Software, Creation and configuration of database development, testing and production purposes
• Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
• Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the Database.
• Involved in writing PL/SQL to maintain the timely orders of the customers, audit history and reports errors.
• Created Packages, Stored Procedures and Functions to be called by Java modules.
• Actively put standards in place to ensure that all application design and code was produced with proper integrity, security and performance. Also, conducted reviews on the design and code frequently to ensure the site standards were being adhered to.
• Enforced and maintained database constraints to ensure integrity of the database.
• Effectively enforced a strategy for troubleshooting problems regarding the databases, applications and development tools.
• Loading external data into the database using SQL Loader
• Performing hot/cold backups of the database
• Implemented RMAN using recovery catalog
• Re-org of database objects
• Monitoring diskspace and tablespace usage
• Actively tuned the SQL queries by using APEX for reduction in the query time and for better improvement in the performance around 30%.
• Cloned or refreshed the database using the production backups in the development and test environments.
• Effective reduction of glitches in the database by analyzing issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM)
• Performed upgrades in oracle database from Oracle 10g to 11g(10.2.0.3 to 11.1.0.6)
• Extensively involved in Weekly Maintenance, Re-Organization and Health Check of Databases.
• Help desk and Support ticket management using TEAMTRACK.
• Used Export/Import and Data pump utilities for full and partial backup through various environments like dev /test/PS /Prod

Environment: Oracle 9i/10g/11g RAC 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, EM Cloud Control 12c,expdp,impdp,AWR,ADDM,Statspack,Tkprof

Confidential, Irving, TX

Oracle Admin

Responsibilities:

• 24/7 Production Database support of multi-terabyte Oracle 11g database.
• Performed all aspects of database administration including Installation, Configuration, Patches, Monitoring, Import/Export, Cloning, etc.
• Upgrade/Migrated the production and development databases from RAC /10g to RAC /11g.
• Installation, configuration and administration of Oracle Real Application Clusters (Oracle 11g RAC/Oracle 10g RAC) and Standby Databases for High Availability and Disaster Recovery purpose.
• Plan, implement, and troubleshooting Oracle RMAN backup, restore, and recovery.
• Provide performance tuning, problem diagnosis, data reorganization and database upgrade support.
• Monitor and tune Oracle database for optimum performance. Assist in capacity planning of Oracle database servers.
• Responsible for Creating, Constructing, Operating and maintaining Interfaces using ODI.
• Generated and analyzed STATSPACK, AWR, ADDM, Explain Plan reports, error checking and monitored statistics for performance tuning of the database.
• Performed Data replication and Data transformation.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Performed data loads using SQL*LOADER.
• Developed PL/SQL Packages, functions and triggers to implement various functionalities.
• Experience in Managing work repositories and creating reports.
• Installation and administration of GoldenGate.
• Wrote UNIX Shell Scripts for Backup and cloning.
• Tune SQL, PL/SQL statements found in the reporting utilities and queries.
• Involved in the maintenance and trouble shooting of RAC Databases.
• Monitored and managed the space usage and table partitioning.
• Implemented and Configured Standby database (Data guard) for disaster Recovery.
• Primary point of contact between customer and core development team.

Environment: Oracle 11g RAC/10g RAC, RedHat Linux, Sun Solaris, HP-UX, AIX, Windows, OracleData Integrator, GoldenGate, SQL, PL/SQL, RMAN, SQL*Loader, Import/Export, Data Pump, Data guard, AWR, ADDM.

Confidential

Oracle DBA (Oracle Database Administrator)

Responsibilities:

• Involved in 24x7 support for production RAC and Non RAC database with on-call pager.
• Worked with Application Development team on Test and Production tickets.
• Setting up 9i Oracle Parallel server and 10g RAC for Development and Production Environment.
• Installation and creation of 9i and 10g databases on Testing Environment.
• Installed, Setup, Configured Oracle 10.2.0.4 64 Bit on RHEL 4.8.
• Upgrading of Database from 9i to10g.
• Installed, Configured, Setup, Maintenance and Supported Oracle 10g RAC, Physical Standby database.
• Installed, Configured and setup Oracle Streams between Oracle Servers.
• Used Oracle Streams for Basic and Advanced Data Replication between Oracle Database Servers and Legacy Databases.
• Used Oracle 10gR2 features viz Oracle 10g Real Application Clusters (RAC), Data Guard, Oracle Streams / Replication, automatic SGA tuning, enhanced RMAN with flash recovery area, Oracle data pump, big file table spaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/ Access Advisors, Flash Back Database and several others.
• Monitoring and Troubleshooting of Database Replication issues.
• Performance Tuning of Oracle Database Objects.
• Implemented DATA GUARD (Standby) for high availability/disaster recovery purpose.
• Performed database cloning to setup test and development database.
• Rebuilding of Indexes for better performance, administer database objects.
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining.
• Write SQL scripts to monitor table space and extent growth.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK.
• Applying patches whenever required.
• Data refresh from production to test and development.
• Was involved in developing a Disaster Recovery (DR) plan & implemented a DR exercise.
• Installing and configuring Recovery Manager (RMAN).
• Setting and Installing Oracle Enterprise Manager (OEM) and Enterprise Backup Utility.
• Setting up new Development & Production environments.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Automation of Startup Shutdown on all Production and Development Database.
• SQL Tuning for Performance of Objects.
• Providing Solutions to the Problem Faced by end Users Or Programmers.

Environment: Oracle 9i/10g /11g, RedHat Linux, Sun Solaris, HP-UX, AIX, Windows, OracleData Integrator, GoldenGate, SQL, PL/SQL, RMAN, SQL*Loader, Import/Export, Data Pump, Data guard, AWR, ADDM.