SUMMARY

• ­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­­Motivated, goal oriented professional with 11.8 years of IT consulting experience in Oracle and MsSQL Database Administration and Database Architecture.
• Expert Oracle and MsSQL Server Database Consultant to achieve tangible results by developing strategies, creating roadmaps and implementing solutions.
• Align with cutting edge technology like AWS cloud for on - premise and off-premise datacenter migration needs.
• Always Maximizing returns by automating database process and activity.
• Improve business processes to reduce costs and enhance performance.
• Engenders trust through reliability, work ethic, concern and listening skills.
• I am ready to give my best for the project and the company.
• Database Cloning Disaster Recovery Planning Performance Tuning Database Design IT Service Management
• Business Continuity Database Deployments ITIL Management Database Migration Database Patching Resource Management Database Upgrade

TECHNICAL SKILLS:

Database Experience: Installation & Configuration of Oracle and MsSQL Server, Oracle RAC, Database Server Tuning and sizing, Application SQL Tuning, Backup/recovery techniques, Golden Gate Replication, PL/SQL, SQL* Loader, Oracle and MsSQL Server Migration, Dataguard, Oracle Upgrade, Mirroring.

DBA Tools: DBCA, Oracle Enterprise Manager, TOAD, SQL *Loader, Export / Import, RMAN, Performance tuning (Tracing, Statspack, AWR Reports), Apache Web server, Remedy, Exceed, PL/SQL Developer, TOAD, WINSCP, Humming Bird, Quest Software for Oracle-Toad 8.6.1 and 9.5, Putty, VI Editor, Oracle Enterprise Manager, Capacity Planning, Oracle Replication/Oracle Streams, OEM (Oracle Enterprise Manager), Control M, SQL Navigator, RMAN, DBCA, DBUA, CRS, RAC, HP Service Center and Remedy

RDBMS: Oracle 8.x,8i,9i,10g,11g, 12c, MsSQL Server 2008R2/2012/ 2016

Programming & Scripting Lang: SQL, PL/SQL, XML, UNIX Shell Scripting, C++, Oracle

Operating Systems: Sun Solaris OS 8.8/8.9/8.10 , UNIX (HP UX 9.x/10.20/11.0, AIX 5.x,4.x), Windows NT 4.0, WinXP, AIX 5.3, Linux, RHEL4, RHEL5

Hardware: Sun Fire 15K, Sun Fire 6800, Sun V480, V240, Sun Ent 6500 / 450, HP, IBM AIX series Server, Exadata / Exalogic

Replication: Golden Gate replication 11, Oracle Data Guard 9i, 10g, 11g & 12c

DBA DevOps Tool: Jira, Confluence, GitHub, Redgate, Hipchat, DBMaestro & Datical

PROFESSIONAL EXPERIENCE

Confidential, Malvern, PA

Senior Oracle and MsSQL DBA

Responsibilities:

• Upgraded and migrated around 20+ databases from 10g/11g and 11g/ 12c using RMAN, Active Duplicate, exp/imp, hot backup and BCV, exadata techniques.
• Expertise in Real Application Cluster (RAC) Setup & Administration. Upgraded RAC databases from 11gR2 to 12gR2. Add or Remove Node from RAC.
• Completed critical production database oracle 12c installation with upgrade of the database from 11g to 12c on the ASM file system.
• Completed the setup of 3 Node Oracle 12c RAC database with HA Dataguard Solution.
• Completed Migrating on-premises oracle Database to Confidential RDS database cloud.
• Expertise in Installing, Configuring, Managing and Trouble-Shooting ORACLE 11g/12c databases in different Operation systems Linux, Sun Solaris, HP-UX, Windows.
• Taken care of the alerts created in Ms SQL Server in case of Jobs failures. Proactively implemented the alert monitoring for new server builds.
• Installed SQL Server 2012 in Windows Clustered environment and managed security logins and worked with Windows authentication, SQL server authentication and mixed modes.
• Performed backup in SQL server 2012 and Worked on performance tuning and tweaked SQL queries by adding indexes for better performance
• Administered SQL Server 2012 & 2016 and created new database and jobs for different projects.
• Completed the 20+ TLS Inflight and At-Rest encryption for the Oracle and MsSQL server Database at NAS/Server File System and Data Transmission.
• I have worked on the creation of the database, tables, schema in the SQL server 2008.
• Worked on the database mirroring, failover clustering and setup high availability for the SQL Server database.
• Completed Migrating on-premises MsSQL Database to Postgress in Confidential cloud.
• Oracle 11g (R1 and R2) installation on all major UNIX flavored operating system like RHEL, Oracle Unbreakable Linux (OUL), and WINDOWS.
• Database migration from MSSQL/Sybase to Oracle 12c for the production system.
• Experience with Oracle Grid Control, and Oracle 12c and 13c Cloud Control.
• Support and worked in nightshift support at the active RAD production data center of Confidential .
• Implemented Oracle data guard physical standby setup for the Oracle production environment.
• Actively worked on the new DevOps Tool like Jira, Confluence, Puppet, GitHub and Hipchat for FastIT.
• Migrated and upgraded around 30 business critical database from 11g to 12c.
• Implemented backup strategies with hot, cold & Oracle exp/imp utility using UNIX shell scripts, RMAN backups
• Performed database duplication of Oracle 11g to 12c on UNIX, Linux, RHEL4, and Solaris.
• Worked closely with Oracle support by raising sev1 and Sev2 tickets for business critical known and unknown issues and bugs and thus providing the fix.
• We have worked with all the ITIL Process and framework for the projects.

Environment: Oracle 9i/10g/11g/12c, Solaris 5.8/5.9/5.10 , Linux x86/ SUSE Linux Enterprise Server 8/9/10 and 11, Red hat, Linux on NAS storage, RMAN, Dataguard, DG Broker, OEM 12c and 13c, EXP/IMP, EXPDP/IMPDP, Oracle Golden Gate replication, Oracle RAC, Exadata, Oracle Streams, Jira, Confluence, GitHub, Puppet, Control - M, MsSQL server 2008/2012/2016 , Service Now, AWS, Windows XP, Oracle ID Vault, Redgate, DBMaestro,Puppet, GitHub, Python, Power Shell, TOAD 6.0, AWS, Lambda, Aurora, Snowball, RDS, PostgreSQL, Confidential cloud

Confidential, Collegeville, PA

Lead Oracle DBA

Responsibilities:

• On-Site Lead Oracle DBA for 200 oracle databases for 110+ applications for platforms like Argus safety, Quality Centre, Siebel etc. to ensure their proper support and 24/7 availability.
• Completed Argus production database oracle 11 to 12c migration and upgrade on the ASM file system.
• Have hands on experience in creating physical standby databases, and involved in converting physical to snapshot standby.
• Completed Migrating on-premises Oracle to Aurora PostgreSQL Utilizing AWS Database Migration Service (DMS)
• Migrated and Upgraded critical oracle database from 8i/9i, 10g/11g and 11g/ 12c using RMAN, exp/imp, hot backup and BCV, exadata techniques to get Oracle licensing support.
• Expertise in Setup & Administration of Golden Gate replication 11.
• Lead oracle DBA on Empirica /Signal Detection DB Migration from zfs storage to ASM Oracle Super Cluster storage.
• Worked to convert Oracle database from On-Prem datacenter to AWS Cloud in new technology like Postgress and MsSQL database.
• Worked on the migration of the critical production Argus safety database from normal server to the oracle supper cluster.
• This was with conversion of data from zfs storage to ASM file system.
• Upgraded Oracle Grid Control from 12c to 13C (Red hat Server)
• Support for the target setup and Agent install for the Oracle Grid Control, and Oracle OEM 12c Cloud Control.
• Worked closely with Application team for the Critical P1 and P2 tickets for business critical issue and bugs and thus providing the fix quickly.

Environment: Oracle 8i/9i/10g/11g/12c, Red hat, Linux on NAS storage, Ms SQL Server 2000/2005/2012 , RMAN, Dataguard, DG Broker, OEM, EXP/IMP, EXPDP/IMPDP, Oracle Golden Gate replication, Solaris 5.8/5.9/5.10 , Linux x86/ SUSE Linux Enterprise Server 8/9/10 and 11, Shareplex Replication, Oracle Super Cluster, Exadata, Oracle Streams, Oracle Cloud, AWS, Lambda, Arora, Snowball, Postgress, MySQL, Casandra.

Confidential, Wilmington

On-Site Core Oracle DBA

Responsibilities:

• Oracle DBA consultant for more than 110+ oracle databases (9i/10g/11g) to ensure their availability round the clock.
• Expert in administrating the healthcare normal and sox databases.
• Migrated and upgraded around 20+ business critical databases from 9i to10g and 10g to 11g.
• Worked on the managing the transaction logs, backup compression, maintaining the database and event forwarding in MS SQL database 2008.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Upgraded 13+ Critical RAC environments from oracle 10g to 11g Version.
• Authored S.O.P. for database duplication, disaster recovery, Golden Gate configuration
• Configured MS SQL Server 2008 in-built log shipping from primary server (New York, NY) to DR server (Ashburn, VA) and also SQL Server 7.0 log shipping manually using scripts.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
• Worked on setup and administration of 3-node RAC 10g. Worked on non-RAC database migration from non-ASM to ASM.
• Strong programming skills with the Unix/Linux shell language.
• Provided 24x7 on-call supports for Production databases and also resolved critical issues.
• Created and Manage Oracle 12c Databases on Linux/Unix and completed Golden Gate installations.
• Performed testing for various Oracle 12R1 new features like Active Data Guard, Adaptive Query Optimization, SPM, and RMAN Active Duplicate.
• Involved in migrating non-RAC databases to Oracle 12c RAC environment on ASM.
• Converted single instance database to RAC Database using R-CONFIG.
• Applied patches to Oracle Databases using Opatch utility and upgraded databases manually.
• Involved in migrating HP-Unix databases from 10g to 11g, and 11gR1, 11gR2 to Oracle 12c Linux.
• Extensively used tool and utilities like OEM, AWR, ASH, TKPROF, and STATSPACK for performance analysis and troubleshooting.
• Knowledge in handling and Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database using OEM.
• Duplication of Databases from Production RAC to test RAC using RMAN active cloning.
• Performed Tuning of various SQL Queries to improve the performance of the database.
• Setup and administered Golden Gate replication with the troubleshooting the various issue.
• Taking periodic Backup of the Database and the software using RMAN and supporting VERITAS - Netback up Team.
• Maintained catalog server and registered databases in catalog server.

Environment: Oracle 9i/10g/11g/12c with RAC, ORACLE 10g, SQL, PL/SQL, Toad, Pl/SQL Developer, Shareplex, Erwin, And O/S: RHEL 4.2, HPUX, GoldenGate, VMware, Windows 2003, And OEM.

Confidential

Oracle Database Administrator

Responsibilities:

• Oracle DBA Responsible for administrating and maintaining around 200+ databases within the organization.
• Good exposure and worked on L1 and L3 tasks of Sybase and SQL databases.
• Partitioned several large tables (200GB-2TB) gaining huge application performance improvement
• Involved in SQL tuning by generating explain plan, ADDM, AWR and TKPROF.
• Involved in Extensive PL/SQL Performance Tuning which includes creating indexes, analyze, explain plan, optimizer hints
• Implemented 12c new features for building Active Data-guard and tablespace point time recovery.
• Configured Dataguard-broker and involved in registering of databases in Dataguard broker using utility DGMGRL.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Environment: Oracle 8i/9i/10g/11g, Solaris 5.8/5.9/5.10 , Redhat, Linux x86/ SUSE Linux Enterprise Server 8/9/10 and 11, Linux on NAS storage, RMAN, Dataguard, DG Broker, OEM, EXP/IMP, EXPDP/IMPDP, Shell Scripting.

Confidential

Junior Database Administrator

Responsibilities:

• Installing & configuring Oracle 11g, 12g RAC, 9i on Linux & RHEL.
• Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day - to - Day activities).
• Expertise in Installation, upgrade and patching of databases from Oracle 8i, 9i, to Oracle 10g & 11g.
• Implemented Disaster recovery for production databases using Dataguard.
• Creation of additional tablespace, Users and management of their. Rights & privileges and Expertise in Performance and Security audits
• Created user accounts, roles and granting required access permissions and privileges to the database based on the application they are accessing.
• Taking Backup of Database Using Logical (Export & Import) & Physical (Online & Offline).