OBJECTIVE:

Gain Expertise and provide an excellent quality IT support as a DATABASE ADMINISTRATOR in multiple technologies with a strong inclination towards value added work practices contributing to the growth of the Organization.

AREAS OF EXPERTISE:

Oracle (9i/10g/11g/12c) database core administration role involving:

• Installation and Configuration of Oracle Grid/ASM/Database 10gR2, 11gR2 and 12c
• Installation and Configuration of Oracle Client 9i, 10g, 11g and 12c
• Installation and Configuration of Oracle OEM Grid 11g and 12c
• Implementation and Configuration of Standby/Dataguard11gR2 and 12c
• Troubleshooting Logical Standby and Streams configuration 9i, 10g and 11g
• Upgrade of CRS/Database from 9i to 10g to 11g to 12c
• PSU/CPU Patching of CRS/Database of 9i, 10g, 11g and 12c
• Platform Migration from Windows to Linux with RMAN and EXP/IMP
• User Creation/ User Access Privileges management, Database Security and Audit management
• Space management at Operating system and database level.
• Database Backup and Recovery Administration with RMAN, EXP/IMP, EXPDP/IMPDP, Hot/Cold backups
• Database Refresh with RMAN, EXP/IMP, EXPDP/IMPDP and Cold backup method
• Database performance monitoring/tuning, SQL query tuning through ASH, AWR, ADDM reports, Toad and OEM

Oracle GoldenGate 11gR2/12C Administration:

• GG installation and configuration
• GG troubleshooting and Performance Tuning

Exadata Database Machine Administration:

• Exadata software and hardware maintenance of the Database/Storage servers, and Network/Infiniband switches
• Provide and implement performance and tuning recommendations of all Exadata components
• Implement backup and recovery/disaster recovery strategies for Exadata
• Configure Exadata to meet internal security requirements
• Leverage Oracle Enterprise Manager as the centralized proactive maintenance solution for Exadata to report on performance, provide metrics, monitoring and alerting
• Maintain policies and standards for allocation of computing resources
• Install/Upgrade/Patch and maintain Exadata infrastructure system availability in multiple environments
• Manage issue resolution in coordination with internal teams or external vendors/Oracle Support

MongoDB Database Administration:

• MongoDB installation, upgrades and configuration
• MongoDB management and troubleshooting operational issues
• MongoDB backup/restore
• MongoDB redundancy, availability, scaling, replication Clustering and Sharding
• MongoDB consolidation and migration of databases to new hardware and platforms
• MongoDB CRUD operations, collection and indexes/aggregation framework
• Maintain automation scripts in Shell and Perl Scripts

TECHNICAL SKILLS:

Operating Systems: Unix - Linux, HP-UX, IBM-AIX, Sun-Solaris,Windows- Server 2003/ XP

Software Packages: MIS Tools - Remedy and Peregrine, HP Openview, MS Office

Languages/DB: Oracle DBA-8i/9i/10g/11g/12c/RAC/ASM/Dataguard/Shareplex

Misc Tools: Toad, Benthic Golden, Hummingbird Exceed, Stratavia, CIGWIN, NGS Squirrel, GRD, ITG, CyberArc, VNC, Xming, SAS, R-STUDIO, MATLAB, etc.

WORK EXPERIENCE:

Confidential, New Jersey

Senior Database Administrator

Responsibilities:

• Working for the client Alphahire, with a team size of about 5 people on 30 Linux servers, 6 of them deployed on AWS-RDS
• Installation/Upgrade/PSU Patch of Oracle Server/ASM/ Database 11gR2
• User, password, space and storage management
• OEM CLOUD 12c - configured RMAN backups, Alerts, Notifications, Agents Installation
• Oracle Dataguard configure, troubleshoot
• Database Performance and SQL query tuning with sql queries, AWR, ADDM, OEM
• Creating and administering databases, users, tablespaces, database objects
• Backups and Recovery Management - Database Backups with Imp/Exp, Datapump, Rman and Database restore/cloning /refreshes, Schema refreshes
• Creating/scheduling jobs with Crontab, OEM.

Confidential

Technology Lead

Responsibilities:

• Attained the Master’s Degree in Business Intelligence:
• Professional Skills and Research Methods
• Data Analysis
• Databases for Enterprise
• Business Intelligence
• Technology Entrepreneurship
• Data Mining
• Advanced Databases
• Applied Advanced Statistics
• Project - Evaluation of NoSQL Databases (MongoDB, Cassandra, HBASE)

Confidential

Technology Lead

Responsibilities:

• Worked on a Banking project with a team size of about 50 DBA’s and more than 5000+ Linux servers (RHEL, CENT OS and Ubuntu).
• Apply PSU Patch on 11g GI/Database home
• Server maintenance work related to Operating System patching which involves shut down and start up Clusterware, databases and services
• On-call support for production databases related to multiple issues
• Provided support for Oracle GoldenGate 11gR2
• Gather and examine process evidence with GGSCI
• Troubleshoot with methods and tools like Knowledge Documents, Documentation, Showsyntax, Parameter, Logdump.
• Diagnose the cause and troubleshoot problems related to extraction, replication, missed transactions, mapping, synchronization, SQLEXEC, file maintenance.
• Identify issues related to slow start-ups, network, disk.
• Monitor lag and statistics.
• Perform tuning of Manager, Extract, and Replicat.

Principal Consultant DBA (ORACLE DBA )

Responsibilities:

• Worked for the client’s production, development, stage and qa databases almost all on 11gR2, RAC on 200+ linux 5.9 servers. We had a team of about 10 people working from Bangalore and USA.
• Provided infrastructure support for
• Configured housekeeping scripts including ADR PURGE on all the servers
• Configured, scheduled and troubleshoot RMAN and DD BOOST backups with crontab and OEM12C
• Creation of databases, adding instance and install Oracle Client 11gR2
• Configured RMAN catalog resync scripts on all the servers
• Backup and Refresh Schemas, Tables with Datapump
• For Online support, worked on issues related to Schema creation, reset User passwords, grant permissions, monitor failed backups, alert log errors, clusterware errors, archiver, dataguard/standby errors etc
• Shareplex replication troubleshooting
• For another Project, done Installation and configuration of EM GRID 11Gr2 and Oracle Grid/ASM/Database 11gR2, moving of databases to RAC and setup, configuration of Physical Standby and Dataguard.

Confidential

Senior ORACLE DBA

Responsibilities:

• Worked for Dell’s client CORELOGIC, it’s a Migration project comprising Oracle 11g Software Installation, Configuring ASM storage, creation of databases, applying of PSU patches and migrating 9i, 10g and 11g databases on Solaris to Linux.
• Oracle 11g 11.2.0.3 Software Installation
• Configuring ASM storage
• Creation of databases and applying PSU patches
• Migrating 9i, 10g and 11g databases on Solaris to Linux

Confidential

Technical Services Specialist (ORACLE DBA)

Responsibilities:

• Worked for the client TELSTRA, comprising documentation and correspondence with the client related to applying of PSU and CPU patches on 9i, 10g and 11g databases
• Worked on PSU Patching of 10g and 11g databases
• CPU Patching of 9i databases

Confidential

Module Lead (ORACLE DBA)

Responsibilities:

• Worked for the client GE Medical Systems, with a team size of about 35 people on 5000+ mostly Linux servers. Provided L3 support comprising of activities for RAC, ASM (9i/10g/11g) databases
• Installations of Oracle Server Software/Client Software 10g/11g
• CRS/ASM/Database CPU/PSU Patch on 9i/10g11g
• Table, Schema, Database refreshes with IMP/EXP, Datapump and RMAN
• Database Migrations from different platforms and different Charactersets
• Physical Standby/Logical Standby databases troubleshooting
• OEM Grid control - configured RMAN backups, Manage Users and Roles, Performance tuning etc
• User, password and space management activities
• Table reorganizations and Index rebuilding, and other Performance activities
• Security scanning through NGS Squirrel tool etc

Senior Systems Engineer (ORACLE DBA)

Responsibilities:

• Worked for IBM, for the client Excel Energy, with a team size of about 12 people on 300+ mostly AIX servers
• Database CPU patching on 9i/10g
• Installation of Oracle Software 9i/10g
• Database upgrade from 9i to10g
• User, password and space management activities
• Creating Change Requests and Support Call tickets
• OEM Grid control - configured RMAN backups, Agent Installation
• Oracle Streams troubleshoot
• Database Performance and SQL query tuning with tools like Statspack, AWR, ADDM, OEM
• Reporting activities related to password expiry, change meeting, audit review, high risk review, Teradata daily statistics, user transfer and termination, gsd331 permissions audit etc.
• Checking system storage requirements for the databases (health checks) DB growth capturing.
• Installing Oracle server software, Upgrades from 9i to 10g with DBUA/manual
• Creating databases, users, tablespaces, creating and administering database objects by monitoring, analyzing, rebuilding, reorganization. Other tasks such as running DDL and DML statements for a user, bulk data loading rhrough SQL*LOADER
• Space management issues related to tablespaces and at Operating system level by resizing, renaming and adding datafiles, adding/clearing the space on the mount point
• Administration of all database objects, including tables, indexes, constraints, views etc
• Monitoring and optimizing the performance of the database with Statspack, AWR, ADDM and OEM
• Taking Backups (Hot/Cold, Imp/Exp, Datapump, Rman) and restoring (whenever required) the database, Database cloning / refreshes, Database Migration, Schema refreshes, archives management
• Creating and scheduling jobs through Crontab, DBMS Scheduler.
• Data validation and fixing block corruption with RMAN