PROFESSIONAL SUMMARY:

• Over 12.5 years of experience in IT has wide experience and knowledge in Oracle Database, PostgreSQL and MS SQL Server Database Administration
• Strong knowledge in AWS, Oracle Cloud Services and Exadata X5
• Extensive experience as a Database Administrator & Team\Project Lead.
• Worked successfully with diverse clients in Insurance, Life Science, Banking, Telecom, and Government Organizations (Bio - Rad Laboratories, Confidential & Confidential, Confidential Bank,).
• Experience in administrating and implementation of Oracle 12c, 11g, 10g RAC, Data guard, RMAN, Oracle Cluster ware/Grid infrastructure, Oracle Enterprise Manager Cloud Control 12c, 13c, Oracle Golden Gate.
• Installation, configuration and maintenance of SQL Server 2008,2012,2014, SQL Server Failover Cluster
• Supporting PostgreSQL 10.6 Databases
• Hands on DBA experience in managing day to day DBA Operations on IBM AIX, HP - UNIX, Sun Solaris and Windows NT/2003/XP and Contributor to Knowledge Sharing Forums by providing Technical Documents/White Papers.
• Successfully resolving Oracle Database problems and performance issues in conformance with SLAs, which involves in-depth knowledge of Oracle Database architecture, connectivity, Data guard, Clustering, backup/restore, database corruption, and security.
• Strong Experience in Oracle Database Upgrades and Patching.
• Resolving SQL Server problems and performance issues which involves strong knowledge of SQL Server architecture, replication, Log shipping, Mirroring, backup/restore, database corruption, and security
• Experience in handling BIG/Large Business Critical Databases and their Migrations upgrades and patching.
• Involved in POC’s (Proof of Concept Projects) related to Oracle Database, PosgreSQL and SQL Server to achieve business targets and implementations
• Deploy of bits from pre-production environments all the way to production to support various delivery schedules to meet business objectives.
• Managed availability of applications, systems, and servers in various environments.
• Attended workshops from Confidential on ‘Oracle 11g RAC’, Oracle Golden Gate’, ‘Oracle Cloud Appliance’ and ‘Oracle Database Appliance’.
• Good Interpersonal communication skills and Documentation Skills..

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 9.0/10.0, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x, SUSE Linux ES 10,11 and Windows 2008.2012,2014

Database: Oracle 12c,11gRAC/10gRAC/10g, Oracle Exadata X5-2 High Capacity MS SQL Server 2008,2012,2014 PostgreSQL DBA 10.6

Languages: SQL, PL/SQL, UNIX Shell Scripting, TSQL

DB Management: TOAD, Oracle EM Grid 11g, Oracle EM Cloud 12c, DB Artisan, SQL Developer

Cloud Technologies: AWS (Amazon Web Services)

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

DBA Support

Responsibilities:

• Responsible for supporting Oracle Databases Postgrs Databases,
• Working with various application support teams for day to day IT enablement to drive their business needs effectively.
• Responsible for coordinating with server support teams for various maintenance operations.
• Supporting POCs for new implementation projects.
• Participating in DR drill activities and review of DR documentations.
• Supporting DB Restores, Cloning/ DB Refresh, Upgrades, Patching Installations, Migrations, Backups and Performance tuning issues and activities.
• Drive delivery review meetings on ongoing projects with various support groups and stakeholders.
• Analyze database objects, Gather Statistics, Rebuild indexes
• Suppurating Databases using Oracle EM 12c Cloud control
• Configuring Oracle Dataguard
• Implementing Oracle RAC databases
• Supporting Oracle Golden gate

Environment:

• Oracle Databases 12c
• Oracle Data Guard
• Oracle EM Cloud Control
• Oracle RAC Databases 12c
• Oracle Golden gate 12c
• PostgreSQL 10.6
• AWS RDB Support

Confidential, Branchville, NJ

DBA Support

Responsibilities:

• Responsible for supporting Oracle, Oracle Cloud Databases, SQL Server and Netezza databases.
• Working with various application support teams for day to day IT enablement to drive their business needs effectively.
• Responsible for coordinating with server support teams for various maintenance operations.
• Guiding client about new technologies (cloud, database tools etc.) available in the market and providing required supporting information.
• Supporting POCs for new implementation projects.
• Participating in DR drill activities and review of DR documentations.
• Presentation on Oracle Cloud and Engineered Systems to various support groups.
• Developed Shell and PL/SQL scripts for various support activities.
• Supporting DB Restores, Cloning/ DB Refresh, Upgrades, Patching Installations, Migrations, Backups and Performance tuning issues and activities.
• Drive delivery review meetings on ongoing projects with various support groups and stakeholders.
• Analyze database objects, Gather Statistics, Rebuild indexes
• Installed and configure Oracle EM 12c Cloud control and configured agents over 200 servers
• Handling User tickets in Remedy tool with predefined SLA
• Involved in Oracle Cloud Migrations and Administrations
• Worked on Oracle Virtual Machines

Environment:

• Oracle Databases (11g, 12c)
• Oracle Data Guard
• Oracle Cloud Databases
• Oracle EM Cloud Control
• SQL Server Instance (2012,2014,2016):268 (Including Cluster Instances)
• Mark Logic 9.1
• OS: AIX 7.1, Windows 2008R2,2012,2014

Confidential

Oracle and MS SQL Server DBA Support and DBA Lead

Responsibilities:

• Responsible for supporting Oracle, SQL Server Databases.
• Handling customer DBA Support escalations and strives to proactively prevent escalations in future.
• Supported Oracle 11g, 10g Databases on UNIX and Linux operating systems.
• Configured Data guard for business critical databases.
• Installed and configured Oracle EM 12c Cloud control and configured agents over 150 servers.
• Solved various Backup and Recovery issues.
• Responsible for Oracle performance tuning activities and solved critical performance issues.
• Ensured uptime and SLA compliance for numerous databases.
• Worked with various application support teams for day to day IT enablement to drive their business needs effectively.
• Proactively identified potential database issues and drives resolution to avoid customer impact and facilitates continual improvement.
• Developed shell scripts for RMAN backups, and other database activities.
• Implemented RMAN Backup configurations using catalog database with NetBackup.
• Supported SQL Server DB Restores, Cloning/ DB Refresh, Upgrades, Installations, Migrations, Backups, Configuring log shipping, Mirroring and Performance tuning issues.
• Documented support process for all services covered in the contract.
• Upgraded databases from 9i,10g to 11g.
• Performed Test Database Refresh/Cloning activities.

Environment:

• Oracle Databases (10g,11g, RAC)
• Oracle Data Guard
• EM Cloud Control
• SQL Server Instance (2008,2008R2,2012, 2014)
• OS: AIX, SUSE Linux, Windows 2008R2,2012

Confidential

Team Lead

Responsibilities:

• Responsible for supporting Oracle Databases in Datacenter.
• Worked as team lead for the team of 4 Database Administrators.
• Supported Oracle 10g and 11g Databases on Solaris operating systems
• Implemented Oracle RAC, Grid Control and Data Guard.
• Supported various Datacenter and Database Supported activities.
• Implemented Disaster Recovery Environment.
• Responsible for monitoring the RMAN, COLD, HOT and Export Backup of about databases in the datacenter.
• Involved in all the process of System Development Life Cycle (SDLC) for implementing a project.
• Responsible for coordinating different vendors have application hosted in datacenter.
• Developed Shell and PL/SQL scripts for various support activities.
• Reorganized the tables using DBMS REDEF Package
• Recovering the database using HOT, COLD, and RMAN backups.

Environment:

• Oracle Databases (10g,11g, RAC)
• Oracle Data Guard
• EM Grid Control
• MS SQL Server 2008
• OS: SUN Solaris, Windows 2003,2008R2
• Oracle Application Server

Confidential

Oracle Database Support

Responsibilities:

• 24/7 Shift based Oracle Databases Support.
• Supported Oracle Databases and solved various database performance issues.
• Involved in Oracle DB Upgrade Project.

Environment:

• Oracle Databases (10g,11g, RAC)
• OS: SUN Solaris, Linux, AIX, HP Unix

Confidential

Responsibilities:

• Responsible for migrating existing 8i Database to 10g Database.
• Configuring Oracle RAC, Web center, Oracle Internet Directory and Oracle Discussion Forums

Environment:

• Oracle RAC Database with ASM (Oracle 10g)
• OS: Windows 2003

Confidential

Responsibilities:

• Responsible for gathering client requirements and building oracle environment
• Implemented Oracle 10g RAC and Data Guard Environments.
• Developed Shell Scripts for RMAN backups and alert log monitoring.
• Documented implementation and support process for all services covered in the project.
• Provided support and executing different configuration change activities like Public, Private, Virtual IP change configuration, changing ocr, voting disk locations of existing Oracle RAC Database with minimum downtime.
• Managed the activities correlated with designing backup policy for newly implemented Databases.
• Preparing and submitting the documents on business continuity plan for oracle databases
• Schemas refresh using Export/Import. Creating the database, table spaces, tables, indexes, settings privileges and user logins for prod/dev/test databases.
• Restore and Recover, Cloning and Duplicating databases using scripts as well as with RMAN

Environment:

• Oracle RAC Databases with ASM:
• Oracle Data guard:
• OS: IBM AIX, GPFS