SUMMARY:

• Cloud Database Migration Specialist | Database Engineer
• Cloud Database Engineer Mysql Database Administration
• Terraform Enterprise OnPrem to Cloud Migration
• Aurora Database Administration Oracle Database Administration
• Database Security - OVD and OID Database Performance Tuning
• Real Application Cluster DynamoDB Administration

TECHNOLOGIES:

RDBMS: Mysql, Oracle and Postgres

Scripting: Shell Scripting and Python

Tools: Terraform Enterprise, Oracle Enterprise manager (OEM),App DynamicsSitescope,MONYog,SQL Developer,DB Artisan, Softerra LDAP browser,Postgres Enterprise Monitor

Cloud Solutions: EC2, S3, ELB, VPC, Lambda, Auto Scaling, CloudWatch, AuroraDB, DynamoDBRedshift, RDS, CloudFormation and Terraform Enterprise

Others: Dataguard,Rman,DDBoost,Quest Space Manager,Automatic Storage Management(ASM),GoldenGate

Appliances: Oracle Database Appliance

WORK HISTORY:

Cloud Database Migration Specialist | Database Engineer

Confidential

Responsibilities:

• Highly skilled in cloud database deployment,security and troubleshooting
• Responsible for architecting, designing, implementing and supporting of cloud based infrastructure and its solutions for databases
• Migrated Oracle and MySQL databases from OnPrem to Cloud on RDS and Aurora
• Performed numerous Mysql on-prem migrations using GTID
• Automated infrastructure deployment on AWS using Terraform Enterprise
• Setup Cross-Account and Cross-Region Mysql replication for Aurora
• Good experience on Terraform Enterprise and AWS Cloud Formation
• Experienced in creating multiple VPC’s and public, private subnets as per requirement and distributed them as groups into various availability zones of the VPC.
• Good scripting experience on Shell and Python for automation of database functions and extractions
• Maintained the monitoring and alerting of production and corporate servers using Cloud Watch service.
• Written Templates for AWS infrastructure as a code using Terraform to build staging and production environment: s.
• Mysql/Mariadb Databases:
• Managing multiple Mysql/Mariadb Databases in 24/7(Production) Enviroments
• Experience of Database Administration, design, development, maintenance and production support f relational databases, business applications, new server setup, MySql Server installation, upgrademigration.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and
• Database Consistency Checks using different Utilities.
• Performed numerous Mysql databases migrations
• Worked extensively on mysql Master-Slave replication
• Worked extensively on mysql online tasks like Table Optimization,Index creation, etc

Senior Database Administrator | Cloud Architect

Confidential

Responsibilities:

• Mysql/Mariadb Databases:
• Managing multiple Mysql/Mariadb Databases in 24/7(Production) Enviroments
• Experience of Database Administration, design, development, maintenance and production support f relational databases, business applications, new server setup, MySql Server installation, upgrademigration.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and
• Database Consistency Checks using different Utilities.
• Performed numerous Mysql databases migrations
• Worked extensively on mysql Master-Slave replication
• Worked extensively on mysql online tasks like Table Optimization,Index creation, etc
• Built multi-region slaves for mysql
• Performed mysql database and table recovery
• Oracle Databases:
• Managing multiple Oracle Databases in 24/7(production) multi-O/S Environments
• Good experience on Installing,Upgrading and configuring GoldenGate for different applications
• Configured GoldenGate downstream mining and integrated components for Active-Passive and
• Active-Active replication
• Extensive Oracle RAC experience on 10g/11g/12c databases on ASM
• Supporting different environment in Oracle 9i,10g,11g and 12c (RAC & Non-RAC) Databases of sizes from 50Gb to 70TB
• Performed lot of Performance Tuning activities on RAC and Single Instance Databases
• Implemented 11g Advance compression on big databases
• Performed many table recoveries using Flashback Table method
• Working extensively on Oracle Database Appliances(ODA) like Patching,upgrading and other maintenance activities
• Applying SAP Bundle Patches and other Database Patches on Oracle Databases
• Postgres Databases:
• Ensure night cron jobs for backups, reindexing & vacuuming & materialized views executed properly on 24/7/365 high availability Postgres production and development databases.
• Upgraded postgres servers to version 10.5 on Linux servers
• Review all PostgreSQL logs for problems.
• Optimize postgresql.conf for performance improvement.
• Install & configure Development and Production Postgres 10.5 databases

Senior Database Architect

Confidential

Responsibilities:

• Managing multiple Oracle Databases in 24/7(production) multi-O/S Environments
• Good experience on Installing,Upgrading and configuring GoldenGate for different applications
• Configured GoldenGate downstream mining and integrated components for Active-Passive and
• Active-Active replication
• Extensive Oracle RAC experience on 10g/11g/12c databases on ASM
• Supporting different environment in Oracle 9i,10g,11g and 12c (RAC & Non-RAC) Databases of sizes from 50Gb to 70TB
• Performed lot of Performance Tuning activities on RAC and Single Instance Databases
• Implemented 11g Advance compression on big databases
• Performed many table recoveries using Flashback Table method
• Working extensively on Oracle Database Appliances(ODA) like Patching,upgrading and other maintenance activities
• Applying SAP Bundle Patches and other Database Patches on Oracle Databases
• Mysql/Mariadb Databases:
• Managing multiple Mysql/Mariadb Databases in 24/7(Production) Enviroments
• Experience of Database Administration, design, development, maintenance and production support f relational databases, business applications, new server setup, MySql Server installation, upgrademigration.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and
• Database Consistency Checks using different Utilities.
• Performed numerous Mysql databases migrations
• Worked extensively on mysql Master-Slave replication

Senior Database Administrator|Database Architect

Confidential

Responsibilities:

• Responsible for smooth functioning of RAC databases by providing 24*7 support
• Responsible for daily backup monitoring and Performance tuning
• Responsible for space management and problem resolving Involved in patches & upgrades and migrations and configuration etc.

Database Administrator | Database Architect

Confidential

Responsibilities:

• Worked as a team lead and responsible for smooth functioning of RAC databases by providing
• 24*7 support, Daily backup monitoring Gathered the business requirements for migration of existing databases from 8i to 9i.
• Installed Oracle10g with RAC on Red Hat Enterprise Linux Advanced Server 4
• Responsible for working experience on Automatic Storage Management(ASM)
• Installed and Maintained Data Guard, Physical standby DB and RMAN in LINUX, SOLARIS and HPUX
• Involved in data migration between environments using Export/Import, Transportable Tablespace.

Database Administrator

Confidential

Responsibilities:

• Responsible for designing and gathering the hardware and software details requirement to setup the environment.
• Responsible for Installation and configuration of Oracle 10gRAC, backup strategies and designs.
• Implementation of DR sites etc.
• Responsible for databases migration and upgradation (around 20 databases migrated and upgraded).
• And implement Oracle software installations, upgrades, and patches.
• Planimplement, and troubleshooting Oracle backup, restore, and recovery provide technical assistance and guidance to application support staff and project teams.