SUMMARY:

• Over 10 years of IT experience as a Database Administrator having hands on experience in database architecting, administration, production support, installation, configuration, Migrations, Upgrades, applying patches, performance tuning, backup and recovery, cloning, space management, database security, auditing, TAR support, Unix shell scripting and documentation.
• Good knowledge on Database administration for Oracle 12c, 11g, 10g, 9i and 8i, with experience in large scale database environment and mission critical large OLTP, OLAP, DSS and DWH systems.
• Experience in NoSQL Database MongoDB.
• Experience in MS SQL Server 2008 database administration.
• Experience on configuring Mongo databases and replica sets on AWS and configured Ops Manager for monitoring Mongo databases.
• Experience on installation of Oracle Databases and Data guard setup on AWS.
• Experience on MongoDB Replica Set, Replication setup and managing replica set
• Experience in performing Mongo DBA operational routines, Performing Security measures, and backups and restore backups.
• Good working experience on database encryption like Oracle TDE, Vormetric, HPE Volt.
• Good experience in managing Oracle databases running on MS - Windows, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.
• Hands on experience in Oracle 12c/11g/10g RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation, Grid Installation).
• Extensive experience in Data guard configuration, implementing and maintaining physical standby, Logical Standby and snapshot standby Databases (Data Guard), Configured on AWS
• Extensive experience in performing Disaster Recovery in SRDF, ZERTO, Switch Over/Switch back and Snapshot standby.
• Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.
• Experience in setup Oracle Enterprise Manager (OEM) 12c & Grid Control (11g) for database monitoring/performance/diagnostics.
• Experience in Database Backups RMAN (Full/Incremental backups) and in traditional hot/cold backups and experience in writing/editing UNIX Shell Scripts.
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces.
• Good experience in PATCHING AND UPGRADATION and Migrations. Expertise in upgrading Oracle Development and Production databases from 8i to 9i, 9i to 10g & 11g, 10g to 11g, 11g to 12c.
• Excellent experience in cloning oracle databases for development and testing.
• Experience in Capacity planning & bench marking.
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Expertise in RDBMS Tools like SQL Loader, Import/Export, Data Pump, RMAN.
• Ability to manage global projects, virtual teams, and matrix management experience.
• Come up with pro-active analysis of performance improvements, process improvements and recommend the same to the business.
• Other responsibilities include estimating project time on tasks, schedule and costs, measuring and monitoring results to deliverables, risk and issue identification, change management and providing training as well as documentation for end users..
• Manage BAU activities, escalations, resolving issues. Manage projects around planning, estimation, budgeting. Managing the project risk log, escalating and reporting as required to the Senior Management.
• Very well versed in managing teams working in 24 x7 in shifts supporting Production, Test and Development environment.
• Leading a team of DBAs by assigning, and providing assistance as required and ensuring that the tasks are completed within SLA.
• Hands-on Project Management with strong background of technology in Oracle Database environment.
• Other Experience:
• Experience in Automation tools like JENKINS, JIRA, ARTIFACTORY and ANSIBLE.
• Configured Database Startup, Shutdown, Patching and database creation using ANSIBLE.
• Experience on tools like Ops Manager, OEM, Axibase, Ignite, Toad, SQL Developer.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr. Oracle DBA

Responsibilities:

• Working experience on enable Oracle TDE on oracle 11g and 12c databases in EMEA, APAC and NAM region globally.
• Working experience on Enable Vormetric encryption on oracle 11g and 12c databases in EMEA, APAC and NAM region globally.
• Working experience on Enable HPE Volt encryption on oracle 11g and 12c databases in EMEA, APAC and NAM region globally.
• Working experience on NoSQL Database MongoDB.
• Working experience on configuring Mongo databases and replica sets on AWS and configured Ops Manager for monitoring Mongo databases.
• & Oracle Databases and Data guard setup on AWS.
• Experience on MongoDB Replica Set, Replication setup and managing replica set
• Experience in performing Mongo DBA operational routines, Performing Security measures, backups and restore backups.
• Hands on experience in Oracle 12c/11g/10g RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation, Grid Installation).
• Working experience on Migration of database from lower versions to 12c.
• Extensive experience in Data guard configuration, implementing and maintaining physical standby, Logical Standby and snapshot standby Databases (Data Guard), Configured on AWS
• Experience in performing Disaster Recovery in SRDF, ZERTO, Switch Over/Switch back and Snapshot standby.
• Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.
• Experience in setup Oracle Enterprise Manager (OEM) 12c & Grid Control (11g) for database monitoring/performance/diagnostics.
• Experience in Database Backups RMAN (Full/Incremental backups) and in traditional hot/cold backups.
• Installation and Configuration of Oracle 9i, 10g and 11g on all UNIX flavors.
• Up-gradation of oracle database server from oracle 9i to 10g & 10g to 11g.
• Applying patches for grid & oracle home 11gR2 & 12c
• Very well versed in managing teams working in 24 x7 in shifts supporting Production, Test and Development environment.
• Leading a team of DBAs by assigning, and providing assistance as required and ensuring that the tasks are completed within SLA.

Confidential

Sr. Oracle DBA

Responsibilities:

• Resolving the priority tickets.
• Creating SR when support required from ORACLE for unknown bugs.
• Installation and Configuration of Oracle 9i, 10g and 11g on all UNIX flavors.
• Implementation and automation of backup and recovery strategies.
• Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers.
• Upgradation of oracle database server from oracle 9i to 10g & 10g to 11g.
• OCR and Voting disk backup and recovery.
• Applying patches grid & oracle home in 10g & 11gr2
• Configuring and Maintenance of Network services (Listener and TNS Configuration
• Responsible for database creation using dbca & manually
• Managing Oracle Instance, Schema Objects.
• Database backups using Hot/Cold Backup and Import, Export.
• Hot and cold cloning of the database.
• Refresh database from production to dev, test and stage databases by hot backup, cold backup and RMAN backup.
• Refresh schemas from production to dev, test and stage databases by using exp/imp and expdp/impdp utilities.
• Backup & Recovery using RMAN.
• Administration of RAC Instances using SRVCTL Utility.
• Knowledge on Configuration of RAC using Shared Storage.
• Knowledge on Data guard (Standby Database).
• Creating roles, profiles, privileges and assigning roles to users.
• Up gradation of oracle database server from oracle 9i to oracle 10g.
• Good presentation and technical documentation skills.
• Knowledge on ASM databases, ASM instances.
• A team player with concern for quality at all levels and ability to perform under stress.
• Availability to 24x7 on-call support on rotation basis for Production systems.

Confidential

Oracle DBA

Responsibilities:

• Experience in MS SQL Server 2008 database administration.
• Extensively worked on Dynamic Management Views in SQL Server 2005.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Installation of oracle 10g and 11g on Red Hat Enterprise Linux.
• Creating snapshots for the filers and volumes in Confidential technology.
• Refresh database from production to dev, test and stage databases by using NDMP, Snap mirror and Flex clone methods.
• Refresh schemas from production to dev, test and stage databases by using exp/imp and expdp/impdp utilities.
• Planning and performing daily, weekly and monthly Cold, Hot Backups and Snapshot backups.
• Administration of RAC Instances using SRVCTL Utility.
• Knowledge on Configuration of RAC using Shared Storage.
• Knowledge on Data guard (Standby Database).
• Administered all Database Objects like Tables, Views and Indexes.
• Designing and Managing of Physical and Logical structures of the Database.
• Assisted in tuning SQL statements in the applications.
• Support and advice the development teams on database related issues.
• Creating database Instances using appropriate INIT.ORA parameters for efficient database operations.
• Involved in user management by assigning appropriate roles and privileges.
• Played an important role in migrating the database objects from Test database to Production database.

Confidential

Oracle DBA

Responsibilities:

• Installation of oracle 8i, 9i on Red Hat Enterprise Linux.
• Designing and Managing of Physical and Logical structures of the Database.
• Managing Developing, Test Database in 24x7 environments.
• Planning and performing daily, weekly and monthly Cold and Hot Backups.
• Working knowledge on RMAN.
• Backup and recovery through RMAN.
• Performing full exp/imp database.
• Administered all Database Objects like Tables, Views and Indexes.
• Creating database Instances using appropriate INIT.ORA parameters for efficient database operations.
• Involved in user management by assigning appropriate roles and privileges.
• Management of Tablespaces such as dropping/creation and modification of storage parameters for disk optimization, coalescing tablespaces regularly in case of fragmentation and Analyze the statistics periodically and taking remedial action.
• Resolving Incidents rose by Clients and give 24*7 production supports.