PROFSSIONAL 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.
• Extensive knowledge on Database administration for Oracle 12c, 11g, 10g, 9i and 8i, with experience in very large scale database environment and mission critical large OLTP, OLAP, DSS and DWH systems.
• 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 using ASM, Grid Installation).
• Extensive experience in Data guard configuration, implementing and maintaining physical standby, Logical Standby and snapshot standby Databases (Data Guard), streams and Golden Gate.
• 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.
• Extensive experience in Database Backups Confidential (Full/Incremental backups) and in traditional hot/cold backups.
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces.
• Good experience in writing/editing UNIX Shell Scripts.
• Good experience in PATCHING AND UPGRADATION. Expertise in upgrading Oracle Development and Production databases from 8i to 9i, 9i to 10g & 11g, 10g to 11g, 11g to 12c.
• Good experience in Migrating database from lower versions to higher versions like 9i to 10g, 11g and 12c.
• Experience in Flash-Back Technology.
• Experience in Database Refresh and patch management and in Database cloning with Confidential and manual methods.
• Experience in Backup and recovery with Veritas net backup.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
• Excellent experience in cloning oracle databases for development and testing.
• Experience in Capacity planning & bench marking.
• Excellent experience in performance tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports.
• Replication using Oracle golden gate, Streams and Materialized Views.
• Proficient in Migration from 8i/9i and 10g to 11g and 12c.
• Performed backups and tested crash recoveries using conventional hot & cold backups and Confidential
• Skilled in developing Confidential scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Excellent Troubleshooting skills in OS level and Database level.
• Expertise in RDBMS Tools like SQL Loader, Import/Export, Data Pump, Confidential
• Providing best security practices for Oracle 10g, 11g and 12c. This included securing access to default accounts, securing the network using encryption, enabling DB auditing.
• 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.
• A strong understanding of current technology and value these technologies bring to the organization.
• Create and enforce DB development standards sops, policies, metrics and processes.
• Create and enforce architectural standards, security, high availability, replication, storage, configuration 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.
• Experience in Automation tools like JENKINS, JIRA, ARTIFACTORY and ANSIBLE.
• Configured Database Startup, Shutdown, Patching and database creation using ANSIBLE.
• Performed proof of concept for data guard on AWS.
• Knowledge on MONGO Database.

PROFESSIONAL EXPERIENCE:

Confidential, Hoboken, NJ

Database Administrator

Responsibilities:

• Resolving the priority tickets.
• Good working knowledge in the part of change tasks and RFCs.
• 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.
• Involving in Service improvement plan.
• Planning database activities, Attending CAB meetings.
• Explaining Risk registry to client related to databases risk.
• Assisting development team with suggestions related to database performance improvement of for Database related issues.
• Working experience in database storage level cloning for testing’s.
• Up-gradation of oracle database server from oracle 9i to 10g & 10g to 11g.
• OCR and Voting disk backup and recovery.
• Applying patches for grid & oracle home in 10g, 11gr & 12c
• 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 Confidential backup.
• Refresh schemas from production to dev, test and stage databases by using exp/imp and expdp/impdp utilities.
• Backup & Recovery using Confidential .
• Experience in handling 10g and 11g RAC databases.
• Administration of RAC Instances using SRVCTL Utility.
• Working experience on Configuration of RAC using Shared Storage.
• Working experience on Data guard (Standby Database).
• Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers.
• Creating roles, profiles, privileges and assigning roles to users.
• Managing resource Management files like data files, online redo log files, control files, and allocating logical storage structures like table spaces, segments and extents.
• Managing the Table space management.
• Monitoring growth of tables and undertaking necessary re-organization of Tablespaces and Indexes when required.
• Ensuring proper online and offline backup, periodical reading and checking of backups taken.
• Good presentation and technical documentation skills.
• Working experience 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

Database Administrator

Responsibilities:

• Resolving the priority tickets.
• Good working knowledge in the part of change tasks and RFCs.
• 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 Confidential backup.
• Refresh schemas from production to dev, test and stage databases by using exp/imp and expdp/impdp utilities.
• Backup & Recovery using Confidential .
• Experience in handling 10g and 11g RAC databases.
• 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.
• Managing resource Management files like data files, online redo log files, control files, and allocating logical storage structures like table spaces, segments and extents.
• Managing the Table space management.
• Monitoring growth of tables and undertaking necessary re-organization of Tablespaces and Indexes when required.
• Ensuring proper online and offline backup, periodical reading and checking of backups taken.
• 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

Database Administrator

Responsibilities:

• Installation of oracle 10g and 11g on Red Hat Enterprise Linux.
• Managing Production, Test and Development database in 24x7 environments.
• Creating snapshots for the filers and volumes in NetApp 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

Database Administrator

Responsibilities:

• Installation of oracle 8i,9i and 10g 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 Confidential .
• Backup and recovery through Confidential .
• 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.