SUMMARY

• Around 7 years in the field of Oracle database administration & Operating systems.
• 2+ years in the field of NOSQL DATABASE(MONGODB) administration.
• Extensively worked on Oracle 9i, 10g, 11g & 12c versions.
• Provided 24x7 production support of development and production 10g/11g/12c databases on different Platforms.
• Expertise in different environments like SUN SOLARIS, Linux and Windows.
• Proficient in Database Administration activities such as installation, database creation, sizing, backup and recovery, performance tuning and capacity planning.
• Fulfilled DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database network connectivity).
• 11g/10g Real Application Clusters (RAC), ASM, CRS installation and maintenance
• Database backup concepts and options such as user - managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup. Implementing backup and recovery strategies.
• Used Explain plan and TKPRO, AUTO TRACE, AWR, ADDM, ASH for SQL Tuning; Performance tuning i.e. tuning SGA, I/O distribution and wit events causing DB time to be high.
• Analyzing and identifying, tracing application sessions using DBMS SQLTUNING package which is available from 11g onwards.
• Experience in Upgrading databases.
• Performed backups and tested crash recoveries using Cold, Hot backups and RMAN and also tested various recovery procedures.
• Plan, install, configure and perform upgrades of Oracle DBMS software on various platforms.
• Implementation of high availability solutions with Oracle 10g & 11g RAC, Physical and Logical Standby database, Data Guard, Materialized views, Bi Directional Streams Replication.
• Hands on experience with Installation, Configuration, Oracle Data Guard, Disaster Recovery and Patching, upgrading and administering Terabytes of Oracle Databases
• Refresh/Cloning of Database and applications for development and testing purpose.
• On call 24x7 Production Support Worked Confidential regular hours.
• Implemented Export and Import using original Export/Import method in Oracle 9i Databases and Data pump in Oracle 10g,11g and 12c Databases.
• Experience in setting up restore points using Flashback technology of Oracle
• Installation, configuration, upgrading and migration of Oracle software (10g, 11g &12c). Applying patches under UNIX, Linux and Windows platform.
• Work closely with developer, provides Oracle DBA support and technical support for multiple applications in DEV, TEST, UAT and PRODUCTION environments
• Unix Shell scripts for hot backups, SQL*Loader, export and import of database
• High Availability Solution like Oracle 10g/11gRAC, Advanced Replication, Oracle Streams, Oracle Failover using Active-Passive cluster and disaster recovery.
• Oracle Enterprise Management (OEM) with standard management, diagnostic, tuning, and change management packs to perform various administrative tasks. Setting-up and configuring Oracle Management Server (OMS) to monitoring database operation.
• As an Oracle DBA, I have handled major projects such as designing database, performance tuning, migration of oracle from lower version to higher version and platform to platform, applying patches for bug fixing to oracle software, setting-up proper backup policies using RMAN, designing automated backup architecture and disaster recovery, implementing advanced features of Oracle10g & 11g RAC database with +ASM.
• Solid experience in Nosql Database MongoDB
• Hands on experience on MongoDB Replica Set and Sharding
• Strong experience in Replication setup and managing replicaset
• Experience in performing Mongo DBA operational routines
• Performing Security measures, backups and restore backups
• Completed MongoDB DBA Training from MongoDB University

TECHNICAL SKILLS

File System: ASM, SAN/NAS

OS: SOLARIS, LINUX & WINDOWS

Databases: Oracle 12c, 11g, 10g, 9i, Standalone, RAC, NOSQL(MONGODB)

Languages: SQL, PL/SQL, Unix Shell scripts

Tools: Oracle Enterprise Manager(11g & 12c), Sqlloader, TOAD, DGMGRL, RMAN,CRS, SRVCTL,SQL Developer, MongoChef,Jenkins,Delphix-Jetstream

PROFESSIONAL EXPERIENCE

Confidential

Application DBA

Responsibilities:

• Responsible for the application schema in local environment (Capacity Planning, Tables, Views, Stored Procedures, Packages, Performance Tuning etc. specific to the schema)
• Lead Performance Tuning, Query Optimization initiatives and involved in troubleshooting and resolving performing related issues.
• Responsible for DB MOD changes
• Expertised and Hands-on experience on developing PL/SQL code as per the solution specifications
• Performed data Backup (export) and restore (import) for Development/ Test environments
• Database capacity planning/space management/entitlement management of the schemas etc.
• Coordinating all requests to Database Shared Services for the development environmentand interact with various stakeholders at different levels such as PMs, SAs, developers, testers etc.
• Worked in a fast paced Agile/Kanban/Scrum environment.

Confidential

DBA (ORACLE & MONGODB)

Responsibilities:

• Data base cloning using RMAN backups.
• Managing Oracle RAC databases, adding services, nodes and implementing load balancing.
• Implemented Data Guard for Disaster recovery system using Oracle 11g.
• Monitored RMAN backups and tested various RMAN recovery scenarios for production databases.
• Database installation and troubleshooting of RAC, managing disks and disk groups with ASM, use of Enterprise Manager Grid Control, Database Control(OEM), Backup and Recovery using RMAN.
• Successfully tested the Failover and Switchover from Production to DR & vice versa.
• Tuning & maintaining production as well as development databases.
• Cloning and refreshing the databases as per requirement of the development team.
• Rectified the poorly written SQL & PL/SQL statements and resolved the performance Issues
• Creation of the database.
• Defragmentation of objects, volume estimation of tables and indexes.
• SGA Tuning, re-organization of oracle datafiles.
• Installation of oracle software.
• Maintenance of development database server, Creation of users, Creation of tablespaces, setting the user security.
• Creating users and their profiles.
• Taking Backup & Recovery of Database Using Logical (Export & Import) & Physical (Online & Offline) Backup
• Monitoring the CPU usage, IO statistics, CPU time to identify any OS level performance killers.
• Installation and configuration of MongoDB
• Understanding of CRUD operations and queries to achieve it
• Configuration Replication setup for data replication
• Addition/Deletion of Nodes & RS chaining in Replica set
• Backup/Restoration of Database through Mongodump/mongorestore utility
• Understanding of Database/Collection/Document
• Index creation and managing it
• Creating Capped and TTL collection
• User Management - creating users, assigning roles, managing permissions
• Optimizing database/query performance
• 24×7 production support experience and solved production problems

Environment: Oracle 11g, 12c, RMAN, Oracle Enterprise Manager, RAC, MONGODB

Confidential

ROracle & MONGODB DBA

Responsibilities:

• Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader
• Creating and managing Oracle Grid control jobs
• Installing and managing OEM agents, scheduled alerts to collect different metrics.
• Analyzing AWR reports and tuning the databases
• Export and Import of database objects to copy from one database to another database with use of Datapump (expdp/impdp)
• Schema and database level refresh using logical backup of the Production.
• Collecting the statistics of the database and tuning the resource consuming sql statements..
• Development and Testing Environment Database refresh using production database backup.
• Daily DBA activities like Performance Tuning, Database auditing and managing user groups, Database security, OS space monitoring, User creation and profiling.
• Creating, altering the tables, views and PLSQL objects as per the development team requirement.
• Monitoring, modifying, troubleshooting DBA portal jobs as per the business Requirement.
• Configured physical standby databases.
• Tested the scripts on Development and UAT databases before releasing on production and then released successfully on Production as part of the RFC.
• Trouble shooting the errors on the client’s side.
• Managing of Tablespace for different user by granting quota on Default & Temporary Table spaces.
• Managing Redo log files in archive log mode.
• Tuned the databases to reduce fragmentation
• Creation of database indexes on certain tables to improve query performance highly testing the same in the development environment.
• Extensively involved in maintaining & updating the database documentation.
• Consistently met 100% response and resolution SLA.
• Worked as an on call DBA and supported 24/7 machine critical Databases.
• Installation and configuration of MongoDB
• Understanding of CRUD operations and queries to achieve it
• Configuration Replication setup for data replication
• Addition/Deletion of Nodes & RS chaining in Replica set

Environment: Oracle 9i, 10g, 11g & RAC

Confidential

ORACLE DBA

Responsibilities:

• Monitoring of DB and Resolve DB alerts and warnings.
• Good understanding on Stand-alone & RAC Architecture.
• Monitor the instance and plan for future availability of storage on user’s table space.
• Creating the users with necessary privileges, roles and fixing user account issues.
• Database health monitoring using traces files and alert.log files.
• Resolve Listener Issues, setting up network configuration, adding entries to tnsnames.ora.

Environment: Oracle 9i, 10g, 11g

Confidential

PLSQL Developer

Responsibilities:

• Extensive experience in developing all Oracle PL/SQL schema objects such as Tables, Views, Indexes, Constraints, Sequences, Synonyms, Cursors, Stored Procedures with Exception handling, Functions, Packages, Triggers, Indexes and Materialized Views, User Defined data types, Nested tables and PL/SQL Collections for various business critical processes.
• Used EXPORT and IMPORT utilities to copy data between different schemas in Databases.
• Hands on experience in PL/SQL Collections, Ref Cursor, Hints, Bulk collect and Packages
• Solid experienced and knowledge in SQL Query Tuning and SQL loader.
• Experience in SQL Query tuning and good knowledge of key Oracle performance related features such as Execution Plans and Indexes.
• Involved Explain plan and investigate the performance issues.

Environment: Oracle 9i, 10g, 11g