SUMMARY:

• Ten plus years of total IT experience with six years as Oracle Database Administrator, two plus years of experience as MongoDB (No - sql) admin along with Ops-Manager & BRS and one year of mysql experience. Working with prestigious organization having hands on experience in production database administration, support, installation, configuration, upgrades, patching, performance tuning, backup and recovery, cloning, space management, database security & auditing.
• 24/7-production database support and maintenance, participated in a on-call rotation. TAR/SR Tracking, Jira (mongodb support), Central station Support and Remedy support.
• Extensively worked on setups, DB upgrades, complex migrations, cloning, security and administration under stringent deadlines
• Open to take up, self-train and learn any new technologies.
• Experience in patching and upgrading of Oracle and Mysql databases.
• Proficient with Physical & Logical Standby Database creation and maintenance, Data Guard setup.
• Experienced in Disaster Recovery setup, Switchover, Failover and FSFO operations, snapshot standby mode for Oracle Databases.
• Experience in setup and maintaining Database Security - SOX, auditing, TDE, compression and SSL.
• Installation, configuration and troubleshooting of Oracle Streams on Active-Active and Active passive.
• Extensive Experience with DD-BOOST, Cold Backup, Hot Backups, Logical Backups, Flashback and RMAN Backups (Incremental Backups) techniques to ensure business continuity.
• Proficient in performance tuning, database optimization using Explain Plan, STATSPACK, SQL TRACE, TKPROF, Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM).
• Performance Management, Partitioning of large table for better performance.
• Expertise on Installation & Configuring EM Grid Control & Em Agents 12c.
• Experience in OLTP database systems, managing Critical Oracle Databases.
• Mysql Master-Slave setup and user management.
• Experience in Installation, Configuration, Administration, Monitoring and upgrading mongo databases
• Installed mongoDB (2.*/3.2 versions), created and upgraded replica sets and clusters.
• Experience in Ops-Manager installation and maintenance.
• Experience in BRS configuration. Configured backups on Ops-Manager BRS.
• Performed BRS backups and restore scenarios.
• Mongodb security enhancement using X509 and TLS authentication to comply with security standards
• Optimizing, monitoring, performance tuning and understanding of mongoDB and modeling data as required for application.
• Proactively analyzed performance of critical metrics graphed in Ops manager, and uncovered potential issues for existing mission critical production databases.
• Experience in sharding, replication and security maintenance of mongoDB’s.
• Python (Pymongo), UNIX shell scripting.

TECHNICAL SKILLS:

Operating Systems: AIX 7.1,6.1,5.1, 5.2, 5.3, RHEL 6.x, 4.x, 5.x, HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10; MAC OS X

RDBMS: Oracle 12c/11g/10g, Mysql

No-sql: Mongodb

Languages: SQL, PL/SQL, Python, UNIX Shell Scripting

Tools/Utilities: RMAN, OEM, EXP/IMP, expdp/impdp, mongodump, Central station

Tuning Tools: MongoStat, Mongoperf, Mloginfo, TKPROF, EXPLAIN PLAN, STATSPACK, ASH, AWR, ADDM

Other: Jira, SAN, TSM, EMC, NetApp, NetBackup,

WORK EXPERIENCE:

Confidential, Sunnyvale, CA

Mongo-Oracle DBA

Responsibilities:

• 24x7 production database and application support.
• Experience with administration of critical OTLP and large-scale multi-terabytes databases.
• Involved in planning and setup of DR systems for all the Production databases.
• Upgraded the Oracle 10,11g database to 12c version and also applied security patches and interim patches.
• Designed and implemented database backup/restore methodologies using RMAN.
• Performed Import and Export using Oracle Data pump utilities.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked on Data Guard Fail over and Switchover scenarios.
• Database user and role management.
• Administered and implemented database security policies like SOX/PCI standards.
• Implemented auditing, TDE and SSL setup.
• Extensively used AWR, ADDM, TKPROF and SQL Trace for database performance statistics.
• OEM Grid Control installation and configuration for monitoring and performance tuning.
• Extensively worked on configuring OEM UDM’s and Metric Extension,templates and configuring OEM targets.
• Proactive performance monitoring, and capacity planning for future database growth.
• RMAN backup & recovery, database optimization and security maintenance.
• Performed database Refresh from production to QA, UAT and development databases.
• Creation, configuration and monitoring mongodb replicaset and shards.
• Installation of MongoDB on bare metal and Virtual machines.
• Implemented Mongodb security standards using X509 and TLS authentication.
• Performed mongodb refresh using mongodump and Ops-Mgr BRS.
• Managing Mongo databases using Ops-Mgr monitoring.
• Worked on MongoDB database techonologies such as Sharding and replication.
• Configured high availability MongoDB replica sets across multiple data centers.
• Migrated Mongo database systems from No-SSL authentication to SSL authentication.
• User creation, maintenance for MongoDB database.
• Experience in analyzing chunk migrations, splitting and balancing across the cluster.
• Proactively analyzed performance of critical metrics graphed in Ops-Mgr.
• Installation, configuration and administration of MySQL Database.

Environment: MongoDb, Mongo Ops-Mgr and BRS, Oracle 12c/11g/10g, Data guard, Mysql, Red Hat Linux, HP-UX, Sun Solaris, IBM AIX,, SQL, PL/SQL.

Confidential

Oracle DBA

Responsibilities:

• Trained a team for 24x7 support for critical production databases.
• Performed Daily Heath check and generated reports for all Critical Databases
• Installation, configuration and administration of Oracle 12c, 11g databases.
• Created Oracle Standby Databases including Active Data Guard for High Availability and Disaster Recovery.
• Database Upgrades from 10g to 11g, 11g to 12c. Applying patches whenever required.
• Migrated databases from Linux, Sun Solaris to AIX.
• Creating table spaces, tables, and users for custom applications.
• Extensive knowledge on OEM.
• Involved in design and layout for the database structures and implemented them.
• Cold Backup, Hot Backups, Logical Backups and RMAN Backups (Incremental Backups).
• Design and implementation of backup and recovery procedures.
• Capacity planning and benchmarking.
• Rebuilding of Indexes, Partitioning of large table for better performance and management.
• Installation, configuration and administration of Golden Gate.
• Replication using Golden Gate, streams, Data guard.
• Managing OLTP/Data Warehousing Databases.
• Implemented SOX, auditing, TDE, and SSL setup.
• Developed PL/SQL Functions, Procedures Packages and Triggers.

Environment: Oracle 11g/10g/9i, Sun Solaris, Red Hat Linux, HP-UX,, OEM, SQL, PL/SQL,, RMAN, ASM, TKPROF, STATSPACK AWR, ADDM

Confidential

PL/ SQL Developer

Responsibilities:

• Worked on enhancing the existing pl/sql code.
• Code enhancements for power builder tool.
• PL/SQL programming - developed PL/SQL functions, procedures, packages and triggers.
• Partly supported testing phase.
• Evaluating and preparing System Documentation, Audit report.
• Impact analysis, High level and low level design documentation.
• Bug fixes and root cause analysis for the bug fixes.
• Imparting training to fresh recruits.
• Sending weekly update mails to clients.

Environment: Oracle 11g/10g, Swisslog, Power builder, IBM AIX, SQL, PL/SQL, TOAD, SQL* Loader