Aws Cloud Services

PROFESSIONAL SUMMARY:

Having *+ years of experience as Oracle DBA along with PostgreSQL DBA.

Extensive experience on database administration for Oracle 11g,12c,18c and 19c.

Experience in migrating databases from on-prime to cloud.

Good experience on AWS Cloud services EC2, Auto scaling, IAM, RDS, CloudWatch etc.

Good experience in Oracle Software Installation by using Graphical method.

Experience in Oracle Database Creation through DBCA and Manual Method.

Creation of Database Users and by setting default tablespaces and temporary tablespaces, assigning quotas, roles, privileges and profiles to users.

Configuring Pfile and SPfile.

Extensive knowledge in Database Architecture.

Exporting and Importing database backups using EXP & IMP and EXPDP/IMPDP utilities.

Experience in Hot/Cold Backup and Recover the Database when required.

Experience in RMAN backup / Recovery scenarios.

Having good experience in applying Patches to the database.

Experience on database Upgrade from Oracle 12c to Oracle 19c in production environment.

Having experience in Cloning a database using RMAN.

Having Experience in schema refresh and Database refresh using Logical backups.

Performing regular activities like gathering statistics of Database, Rebuilding the Fragmented Indexes.

Having Experience on Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, SQL TRACE, AWR and ADDM &ASH reports.

Experience in configuring the Real Application Clusters (RAC).

Experience of scripting and automation.

Experience in utilizing Oracle migration methods such as Data Pump and Transportable tablespace.

Experience in writing Unix shell scripts.

Ability to handle incident management, Maintain SLA.

Good Experience in Exadata.

Experience in oracle Multitenant Container Database (CDB) and Pluggable Database (PDB).

Experience in oracle Goldengate.

Experience in monitoring and troubleshooting in GoldenGate.

Taking backups using the pg_dump and restoration using the pg_restore.

Upgrading the databases using pg_upgrade utility.

Experience in migrating data from Oracle to PostgreSQL.

TECHNICAL SKILLS:

Primary Skills : Oracle DBA & PostgreSQL DBA, AWS

Operating System : Red Hat Linux, Solaris, HP, AIX

Database : Oracle 10g, 11g,12c,18c,19c, PostgreSQL

Tools & Utilities : Data Pump, RMAN, DBCA, Data Guard, Putty

Languages : SQL

PROFESSIONAL EXPERIENCE:

IRI June 2021 to till date

Role: Senior Database Administrator

Responsibilities:

Installation, Maintenance, Administration of RAC and Standalone databases and applying patches.

Creating databases for PROD, UAT, DEV and TEST environments and creating standby databases.

Creation of database users and by setting default table spaces and temporary table spaces, assigning quotas, roles, privileges and profiles to users.

Monitoring and maintaining CRON jobs.

Good experience in configuring the Oracle Data guard. Extensive knowledge in switchover and failover in Physical Standby.

Having experience in converting Physical Standby to snapshot standby and converting back to snapshot to physical standby.

Cloning/ Refresh from PRODUCTION instance to TEST instances.

Implementing backup and recovery statistics using RMAN.

Gathering statistics on schema objects.

Setup in configuring of Data Guard Involved in switch over.

Installation and configuration in ASM.

Experience on generating AWR, ADDM and ASH.

Administrating RAC databases using SRVCTL and CRSCTL.

Knowledge in patching the RAC databases in Rollover manager.

Experience in RAC and Exadata.

Experience in oracle Multitenant Container Database (CDB) and Pluggable Database (PDB).

Good Experience in oracle Goldengate.

Good Experience in installation and configuration of PostgreSQL 11,10,9.6,9.5 in UNIX/LINUX and Windows environment.

Configuring and scheduling the weekend DB maintenance jobs Reindexing, Analyze, Vacuum, Vacuum full, Database and server reboots.

Taking backups using the pg_dump and restoration using the pg_restore.

Upgrading the databases using pg_upgrade utility.

Install and Configure PostgreSQL.

Taking database backup backups using the pg_dump & dump all.

Creation of users, roles as per the requirement from application users.

Doing deployments, execute scripts in UAT, Staging, Production systems.

Taking base backups using the pg_basebackup tool upon requirement.

Upgradation of PostgreSQL from version 9.6 to 10 using pg_upgrade tool.

Upgradation of PostgreSQL from version 10 to 11 using pg_upgrade tool.

Configuration of streaming replication between the Production and DR sites.

Monitoring Backup jobs and verifying the status for the same.

Performing periodic maintenance activities by vacuuming and reindexing.

Create required SOPs as needed to support PostgreSQL.

Performing switchover and switch back activities.

Testing failover scenarios in staging environment.

Good experience on AWS Cloud services EC2, Auto scaling, IAM, RDS etc.

WEGMANS/NTT Data Feb 2019 – Jun 2021

Role: Senior Database administrator

Responsibilities:

Creating, granting and monitoring user access rights and privileges and roles.

Installation, Maintenance, Administration of RAC and Standalone databases and applying patches.

Creation of database users and by setting default table spaces and temporary table spaces, assigning quotas, roles, privileges and profiles to users.

Configured grid infrastructure for standalone databases as well as managing and troubleshooting issues related to ASM.

Applying interim and PSU patches to RAC and standalone databases on quarterly basis to PROD, CERT, DEV and TEST environments.

Configuring, Maintaining and troubleshooting physical standby databases and fast start failover configurations.

Worked on standby database issues, rebuilding standby databases, switch over and failover activities.

Performed Duplication of production databases to DR, CERT, DEV and TEST environments using different duplicate techniques.

Worked on standby database issues, rebuilding standby databases, switch over and failover activities.

Configuring different strategies for PROD, DR, CERT, DEV and TEST environments and troubleshooted issues related to backups.

Performed restore and recovery of corrupted data blocks, Data files etc.., in all environments.

Performed Duplication of production databases to DR, CERT, DEV and TEST environments using different duplicate techniques.

Implemented Oracle Recovery Manager (RMAN) for streamlined backup and point-in-time recovery.

Configured Oracle Real Application Clusters (RAC) for high availability and load balancing.

Implemented Oracle Data Guard for standby database and disaster recovery readiness.

Orchestrated failover and switchover operations to ensure minimal downtime during outages.

Experience in installation and configuration of PostgreSQL.

Experience in upgrading PostgreSQL servers from lower versions to higher versions.

Experience in taking the backups using pg_dump, psql and performing the restorations when required.

Database upgradation using pg_upgrade utility and pg_dump/pg_restore for backup and restore activities.

Working closely with development and QA team and assisting them with sql deployment as part of weekly release process.

Yes Bank/Clover Infotech Sep 2014 – Feb 2019

Role: Database administrator

Responsibilities:

Creating tablespaces and monitoring their growth and resizing or adding more datafiles to database or tablespaces for space related issues.

Creating Users, Roles, Profiles and granted privileges and permissions to appropriate users.

Moving data between databases using utilities like Export /Import and Transportable Table spaces.

Reorganizing the Tablespaces on scheduled basis.

Implementation of Backup and Recovery Strategies using RMAN.

Monitoring the alert log files regularly.

Gathering statistics on schema and schema objects.

Rebuilding indexes which are fragmented.

Experience in user managed cloning.

Experience in Exp/Imp and Data pump utilities.

Experience in configuring physical standbys.

Experience in generating AWR, ADDM reports.

Good Experience in installation and configuration of PostgreSQL 11,10,9.6,9.5 in UNIX/LINUX and Windows environment.

Taking backups using the pg_dump and restoration using the pg_restore.

Upgrading the databases using pg_upgrade utility.

EDUCATION & CERTIFICATION:

Bachelor of science and Computers with an aggregate of 70% in the year 2009-2012 from Acharya Nagarjuna University.

Certified AWS solution architect associate.

Contact this candidate