OBJECTIVE

• An analytical and result oriented Oracle / SQL Server Administrator, AWS migration consultant, PostgreSQL and Aurora DBA with 14 + yrs. of experience in Banking & Insurance, Telecom and Manufacturing industries. Possess hands - on experience in Implementing, supporting and developing mission critical databases, disaster recovery and high availability solutions on various database technologies including SQL Server, PostgreSQL and Aurora in on-premises and AWS cloud infrastructures

SUMMARY

• Thorough hands on expertise on Oracle 18c, 12c, 11g R1, R2, 10g, 9i, 8i, 7.3 databases on variety of operation systems like Enterprise Linux, Solaris and Windows Environments
• Performed planning, installing, and upgrading Oracle 18c, 12c 11g R1, 11g R2 and 10g databases to meet variety of business needs.
• Active involvement in database upgrades, applying Patches ( PSU and CPU) across enterprise databases to enforce Database environment integrity and security standards
• Install, configure and manage RAC for 10g, 11gR2 and 12c databases
• Monitor and Troubleshoot Cluster services, Cluster Registry
• Create, Manage and configure ASM Disk Groups
• Planned and Implemented Disaster recovery using Data guard / Hot Standby
• Configure database backups, Database duplication, and DB cloning using RMAN
• Involved in Database Performance tuning and analyzing AWR, ASH and ADDR reports on regular basis to resolve performance bottlenecks
• Prepare and implement Golden Gate parameter files for Extraction and Replication
• Implemented High availability using Golden Gate Replication such as bi-directional replication and broadcasting
• Monitoring, Troubleshooting and fixing golden gate errors
• Use OEM utilities like Memory Advisors, SQL advisors, Segment Advisors, and ADDM
• Working knowledge on SQLServer 2008 and SQL server 2012.
• Creating, Configuring and Monitoring SQL Server 2008 and 2012 databases
• Architected client applications to transform their in house datacenter to AWS Cloud using EC2, VPC, S3, Route 53, Auto-scaling, Elastic load balancing, RDS, SQS, SNS in both Public and Private Cloud.
• Design and perform moving oracle on-premises databases to AWS Cloud infrastructure to reduce the operational costs.
• Designed and implemented Migration proof of Concept from oracle to other open source databases like ProgreSQL, Aurora
• Implementing Strong IAM multi factor authentication and Best practices on AWS instances between public and private clouds using many AWS services like VPC, EC2, S3 (Glazier for archival), Auto-scaling, load balancing,
• .Setup and Montior AWS infrastructure using Cloud watch and Cloud trial for monitoring and logging purpose.
• Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases in on-premises and AWS RDS environments
• Created instances in AWS as well as migrated data to AWS from data Center using snowball and AWS migration service
• Worked on migrating existing infra to cost effective and highly available AWS cloud infrastructure. Enhanced the storage options by migrating the data to cloud S3, EBS using AWS snowball.
• Hands on experience in Performing backup, recovery, and upgrading of PostgreSQL databases.
• Configuring and monitor log analyzing tools like pgbadger.
• Performance Monitoring and maintenance of database using the bloat repot with minimal downtime.
• Database migrations from Oracle to PostgreSQL using migration tools like EDB Portal, ora2pg, AWSSCT.
• Working with applicaition team to develop strategy to migrate databases from Oracle to PostgreSQL.

TECHNICAL SKILLS

• Oracle 7.3 / 8i / 9i / 10g / 11g, 12c, 18c RAC, Data Guard and SQL Server 2000
• Enterprise Linux, Solaris 8 /9/10, HP-Unix 9.2.0, Windows 2000, 2003
• Remedy, Mercury BAC, Bridge Clarify, TOAD, Putty, DBArtisan, PgAdmin4
• GoldenGate and SQL Server replicaitons
• PostgreSQL, MySQL, Aurora

PROFESSIONAL EXPERIENCE

Confidential - Burlington, MA

Sr. Oracle DBA

Responsibilities:

• Planning, installing, and upgrading Oracle 10g, 11g R2 and 12c databases( Single and Multi Tenant Architecture.
• Performing database refresh of Dev / QA Database from Production using RMAN backups and export/Import and incorporate and support Application teams.
• Applying CPU patches and other oracle recommended patches on Dev/QA and Production environments
• Handling and resolving Golden Gate Unique constraint collusions
• Update and generate the golden gate definition files to support application changes.
• Use OEM utilities like Memory Advisors, SQL advisors, Segment Advisors, and ADDM.
• Configure database backups, Database duplication, and DB cloning using RMAN
• Perform database migration across various platforms
• Creating, Configuring and Monitoring SQL Server 2008 and 2012 databases
• Refreshing Dev/ QA Database from Production using RMAN backups and export/Import
• Working with applicaition team to develop strategy to migrate databases from Oracle to PostgreSQL in AWS
• Participated and contributed to develop POC for oracle to PostgresSQL migration.
• Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases in on-premises and AWS RDS environments
• Involved in datacenter migration activities using Manual and Automation mode.
• Designing and deploying scalable, highly available, and fault tolerant systems on AWS
• Lift and shift of an existing on-premises application to AWS
• Selecting the appropriate AWS service based on data, compute, database, or security requirements
• Identifying appropriate use of AWS architectural best practices

Confidential - New York City, NY

Sr. Oracle DBA

Responsibilities:

• Planning, installing, and upgrading Oracle 10g, 11g R2 and 12c databases to meet variety of business needs.
• Configure and Monitor multiple RAC nodes.
• Create and Manage Disks and Disk Groups using ASM such as adding/ dropping storage.
• Refreshing Dev/ QA Database from Production using RMAN backups and export/Import and incorporate new releases/changes in DEV and QA environment.
• Applying CPU patches and other oracle recommended patches on Dev/QA and Production environments.
• Use OEM utilities like Memory Advisors, SQL advisors, Segment Advisors, and ADDM.
• Planning and Implementing Disaster recovery using Data guard / Physical Standby. install and configure Golden gate software and replication using mgr, extract, replicate and PUMP processes.
• Analyze and troubleshoot Golden gate replication errors using 'ggserr log' file.
• Manage and Handling and resolving Golden Gate Unique constraint collusions
• Update and generate the golden gate definition files to support application changes.
• Write and implement cron jobs to monitor the Golden Gate mgr, replication, and pump processes.
• Configure and setup golden gate replication from Oracle to SQL Server for data warehouse environments
• Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases in on-premises and AWS RDS environments
• Performing backup, recovery, and upgrading of PostgreSQL databases.
• Performance Monitoring and maintenance of database using the bloat repot with minimal downtime.
• Database migrations from Oracle to PostgreSQL using migration tools like EDB Portal, ora2pg, AWSSCT.
• Hands on experience in supporting and assisting data warehouse projects.

. Confidential - Weehawken, NJ

Lead Oracle DBA

Responsibilities:

• Planning, installing, and upgrading Oracle 10g, 11g R2 and 12c databases to meet variety of business needs.
• Configure and Monitor RAC nodes.
• Create and Manage Disks and Disk Groups using ASM
• Refreshing Dev/ QA Database from Production using RMAN backups and export/Import and incorporate new releases/changes in DEV and QA environment.
• Monitor and Manage Database through OEM
• Create, Manage and Patch databases using OEM grid.
• Use OEM utilities like Memory Advisors, SQL advisors, Segment Advisors, and ADDM
• Planned and Implemented Disaster recovery using Data guard / Hot Standby
• Configure database backups, Database duplication, and DB cloning using RMAN
• Create, Manage and configure ASM disks and Disk Groups.
• Perform database migration across various platforms
• Planning and Implementing Disaster recovery using Data guard / Physical Standby install and configure Golden gate software and replication using mgr, extract, replicate and PUMP processes.
• Analyze and troubleshoot Golden gate replication errors using 'ggserr log' file.
• Handling and resolving golden gate collusions.

Confidential, Princeton, NJ

Lead Oracle DBA

Responsibilities:

• Managing team of off-shore DBAs
• Preparing and presenting Enterprise level database performance reports to Leadership.
• Developing and implementing shift roster to the entire DBA team
• Participate and engage other teams like Storage, Network and System administrators in an event of high severity calls
• Prepare and present root cause analysis for Sev 1 and Sev 2 calls.
• Planning, installing, and upgrading Oracle 10g, 11g R1 and 11g R2 databases to meet variety of business needs for the databases
• Develop and implement best practices using Project management and ITIL best practices.
• Configure and Monitor RAC nodes.
• Create and Manage Disks and Disk Groups using ASM
• Refreshing Dev/ QA Database from Production using RMAN backups and export/Import and incorporate new releases/changes in DEV and QA environment.
• Monitor and Manage Database through OEM
• Use OEM utilities like Memory Advisors, SQL advisors, Segment Advisors, and ADDM
• Create, Manage and configure ASM Disk Groups.
• Planned and Implemented Disaster recovery using Data guard / Hot Standby
• Configure database backups, Database duplication, and DB cloning using RMAN
• Create, Manage and configure ASM disks and Disk Groups.
• Writing and recommending Oracle best practices to improve the operational efficiency.
• Planning and Implementing Disaster recovery using Data guard / Hot Standby
• Implemented High availability using Golden Gate Replication such as bi-directional replication and broadcasting.