SUMMARY:

• Confidential is an OCP 11g/10g/9i certified professional with multi database expertise having total 12+ years of experience in database administration Standalone and RAC with ASM storage management, installation, upgrade, migrations, RMan backup/recovery, performance tuning, database security and job automation using shell scripts and Autosys.
• Having extensive experience in Oracle and also in Netezza (Twinfin/Striper/Mako) and IBM Sailfish. Completed MongoDB .
• Very strong Analytical and problem - solving skills with in depth technical knowledge.
• Oracle database 11g to 12c Exadata migration.
• Extensive experience in managing Oracle 12c/11g/10g/9i (RAC, ASM, Data Guard and Non RAC database) on various platforms like Linux, Solaris, AIX, HP-Unix and Windows.
• Expertise in setting up Oracle RAC and managing, Security and one-off oracle patching, Cloning, Linux and Windows 32-bit to 64-bit migration, ASM Disk Group creation, disk addition/rebalance etc.
• Setting up and maintaining Standy (Dataguard). Resolve issues is Standby is broken.
• Shell Scripting: Writing shell scripts for automating jobs as required.
• Sailfish, migrating database from Netezza using DB Harmony/db migrate. Proficient with docker and ap commands, IIAS console. Working with IBM technician via PMR.
• Approx. 5+ Years of experience in Netezza database administration including NPS upgrade, PDA-OS patching, disk monitoring and failover, Groom, Vacuum Catalog, Backup/Restore, nz migrate, Resource Group management, User management, Database creation, working on PMR with IBM support. Knowledge of data distribution, GRA etc. Ability to understand SQL plan. mount/umount NFS storage for backups.
• Very efficient Confidential identifying hardware using nz responders, nzsqa, nzhealthcheck report, analyzing smart disk data, reading appliance health.
• Job management using Autosys and cron.
• Highly organized enthusiastic and motivated team player with leadership skills
• Well-developed communication and interpersonal skills
• Skillful Confidential fast track learning and adopting new technologies
• Have a mixed work experience of working Confidential both Onsite and Offshore.

TECHNICAL SUMMARY:

ORACLE: Oracle RAC 12c/11g,10g & 9i Database Administration, ASM, Data Guard, RMan Backup & Recovery exp/imp, data pump (expdp/impdp) Standby Creation and administration Performance tuning, Shell Scripting, Linux, Solaris, HP-UX, AIX & Windows

NETEZZA (IBM Pure Data for Analytics): Netezza Database administration including PDA-OS patching, NPS upgrade and disk failover etc. User, Group, Resource group and object management, Database setup, Backup/Restore, nz migrate, Groom database, Vacuum Catalog, Statistics management, identifying hardware issues and engaging IBM for resolution. Backup migration from NAS disk to NBU.

IBM SAILFISH: Database migration from Netezza to Sailfish Dbharmony, db migrate, docker and ap commands

NoSQL database: MongoDB knowledge

Operating Systems: Linux, Windows

Jobs automation: Autosys, crontab

Languages: Sqlplus, Shell Scripting

Operating System used: Linux, Solaris, HP-UNIX, AIX & Windows

DB Management Tools: OMS 12c, Toad for Oracle and Toad datapoint

Ticketing Tools: BMC Remedy, HPSM, iSupport, BMC RemedyForce, Jira Ticketing, Nexus, ITSM

PROFESSIONAL EXPERIENCE:

Confidential, Frisco, TX

Sr. DBA

Responsibilities:

• Create/Maintain RAC/Standalone DB (Primary and Standby) including production, dev, testing and staging.
• ASM Disk Group creation, disk addition/rebalance etc.
• Upgrade databases and test/apply CPU/PSU as planned.
• Provides technical support and help development team in troubleshooting databases related issues.
• Plan and implement backup, recovery and security of the Oracle database.
• Perform ongoing tuning of the database instances.
• Currently working on Netezza to Sailfish migration along with Netezza administration.
• Overall administration of Netezza Appliance from DBA perspective.
• NPS and PDA-OS upgrades.
• Performance monitoring and tuning of the Netezza system.
• Upgrade Netezza to the new releases.
• Create/Drop/Backup/Restore Netezza databases.
• Groom databases/Host Backups/Manual Vacuum of Catalog/Statistics management/Disk Failover’s/identifying hardware issues like SPU/Disk failures and working with IBM support.
• Self-failover disk and engage IBM only for replacement.
• Database security management. This includes placing access controls using Groups.
• Create/Drop Users/Groups/Resource Groups/all other database objects like Tables/Views etc.
• Create/Modify Shell Scripts for numerous purposes like backup/restore and wherever automation needed.
• Using Autosys for Job management.

Environment: Oracle 11g RAC, Red Hat Linux, Solaris, OEM 11g & 12C, Netezza (IBM Pure Data for Analytics) Striper, TwinFin, NZAdmin, IBM Sailfish (IIAS)Linux, Autosys, Toad, Nexus & ITSM

Confidential, St. Petersburg, FL

Sr. DBA

Responsibilities:

• Netezza database administration including regular User management - using NZSL user creation, drop user including mass drop using automation, change objects ownership, Group and Resource Group maintenance etc.
• Database creation, Backup/Restore, Groom, Manual vacuum of Catalog, working with IBM support for issues disk replacement, patching, and system upgrade.
• Created shell script to purge old backups based on the table purging so that those backups for which data is available in tables are not purged.

Environment: Red Hat Linux, Netezza database, NZAdmin, NZSQL, AutoSys, Remedyforce, Jira

Confidential, Westlake Village, CA

Responsibilities:

• Create/Maintain RAC/Standalone DB (Primary and Standby) including production, dev, testing and staging.
• ASM Disk Group creation, disk addition/rebalance etc.
• Upgrade databases and test/apply CPU/PSU as planned.
• Provides technical support and help development team in troubleshooting databases related issues.
• Plan and implement backup, recovery and security of the Oracle database.
• Perform ongoing tuning of the database instances.
• Netezza database administration like User/Group/Resource group etc
• Database setup, Backup/Restore/ Cloning, Groom, Manual vacuum of Catalog, working with IBM support for issues like disk replacement and other hardware failures, patching, and system upgrade.
• Worked on shifting Backup/Restore operations from NFS disks to NetBackup.

Environment: Oracle 11g RAC, Red Hat Linux, Solaris, OEM 11g & 12C, RMAN, Netezza, NZAdmin, NZSQL

Confidential

Sr. DBA

Responsibilities:

• Create/Manage RAC/Standalone DBs (Primary and Standby) for production, Dev, testing and staging envs.
• ASM Disk Group creation, disk addition/rebalance etc.
• Upgrade databases and test/apply CPU/PSU as planned.
• Provides technical support and help development team in troubleshooting databases related issues.
• Plan and implement backup, recovery and security of the Oracle database.
• Perform ongoing tuning of the database instances.
• Netezza database administration including regular User management - using NZSL user creation, drop user/database, change objects ownership etc.
• Database creation, Backup/Restore/ Cloning, Groom, Manual vacuum of Catalog, working with IBM support for issues disk replacement etc.

Environment: Oracle 11g RAC, Red Hat Linux, Sun Solaris, OEM 11g & 12C, RMAN, Netezza

Confidential, San Ramon, CA

Sr. DBA

Responsibilities:

• Helping team for day to day DBA activities as well as planning
• Involved in RAC setup and configuration of the database.
• Upgrade database from 11.1.0.7 to 11.2.0.2.
• Applying security patches on all databases.
• Migrated databases on Linux & Windows from 32 bit to 64-bit OS platforms using cold backup.
• Created Dataguard Standby setup.
• Alternate restore of database using RMan from tape Confidential different data center as per client requirement.
• Space mgmt., troubleshoot alerts, performance monitoring/tuning using tools like AWR/ADDM reports.

Environment: Oracle 10g, 11g Sun Solaris, AIX, HP UX, Red hat Linux, Windows 2000 Server, BMC Patrol, RMAN

Confidential, San Ramon, California

Onsite coordinator (DBA)

Responsibilities:

• Client interaction on planning the work and co-ordinate with offshore for successful & error free execution. Planning include database upgrade, patching, migration in consultation with application team
• Upgrade database from 10.2.0.4 to 11.1.0.7.
• Clone databases from production to production to development-test as per client need.
• Worked on migrating databases on new servers during Lease Roll process.
• Involve in database outage meetings as DBA representative.
• Interact with various groups like SA, storage, backup monitoring and the Central command center.
• Daily activities like general administration, space management, troubleshooting, handling DB alerts, performance monitoring and tuning using database tools like AWR/ADDM reports.

Environment: Oracle 10g/11g, Sun Solaris, AIX, HP UX, Red Hat Linux, Windows 2000, OEM, BMC Patrol, RMAN

Confidential

DBA

Responsibilities:

• Apply DST (Daylight Saving Time) patch on production & development databases.
• Upgrade databases from 9.2.0.4 to 9.2.0.8 & 10.2.0.4.
• Database cloning from production to production or production to development/test as per client need.
• Migrate databases on new servers during Lease Roll overs.
• Daily activities like general administration, space management, troubleshooting, handling DB alerts.
• Involved in process improvement, tech/non-tech documentation resulting in increase in productivity and timely of targets.
• Database backup/recovery, security, monitoring, troubleshooting and resolution of issues, monitoring data growth and system utilization.

Environment: Oracle 9i/10g, Sun Solaris, AIX, HP UX, Red hat Linux, Windows 2000 Server, BMC Patrol, RMAN