SUMMARY

• Performed On - prem to AWS migration using Schema Conversion Tool (SCT) and AWS Database Migration Service (AWS DMS)
• Automated the installation, configuration and support of PostgreSQL on AWS RDS wif terraform, Jenkins, and Git
• Setup a deployment pipeline for automated deployments to cloud databases
• Configured deployment pipeline for automated migration, configuration, upgrade and support for AWS RDS wif terraform, version control tools (Git) and continuous integration tool (Jenkins)
• Performed database migration from Oracle RDS to Aurora PostgreSQL wif database migration service
• Automated the provisioning, configuration, and support for AWS Redshift cluster wif multiple node
• Automated the creation of AWS PrivateLink for private connectivity between VPCs as an alternative to VPC peering
• Implemented Data warehouse solution wif RedShift and performed migration to RedShift
• Performed AWS Redshift cluster migration and CDC replication from RDS to Redshift
• Automated PostgreSQL RDS cross region replication setup, failover, and fail-back wif terraform, Jenkins, and Git
• Used Git for source control in a CI/CD workflow
• Tuned DMS to perform Large database migration wif LOBs from Oracle to Postgres in AWS
• Developed cloud replication and failover strategies to reduce time during migration or upgrade
• Developed custom as well as leveraged built-in monitoring and alerts for CPU usage, Event notifications, storage, backup, storage and failover events in the cloud
• Automated the provisioning, configuration of Aurora database wif multiple readers
• Performed database migration from MySQL on-prem to Aurora MySQL
• Automated deployments using DevOps tools like Terraform, and Jenkins
• Ensured databases in the cloud are encrypted-at-rest using key managements service
• Analyzed on-premises database environments such as Oracle or other commercial DB engines for conversion to open source engines like Aurora-PostgreSQL/MySQL
• Automated the provisioning, configuration and support of MySQL Database on AWS
• Configured deployment pipeline and performed automated cloud database maintenance and deployments via Jenkins, terraform and Git
• Setup and ensured high availability and fault tolerance strategy are available
• Leveraged monitoring tools CloudWatch, Datadog, PMM to monitor health, utilization, identify performance bottle neck and ensure maximum performance
• Automated the provisioning, configuration of Oracle Database on AWS RDS
• Performed database migration from Oracle RDS to Aurora PostgreSQL
• Build automation for database backup, failover, schema restore
• Set up various replication strategies and failover strategies in AWS
• Automated cloud database creation and deployments via terraform, Jenkins, and Git
• Planned and migrated large Oracle Database from On-prem to Cloud (AWS)
• Proactively monitored application related jobs and replication activities on both on-prem and in the cloud
• Planned, installed, configured, and supported high availability solution using Oracle GoldenGate replication
• Designed and implemented Disaster Recovery on critical Database running on Exadata Machines wif Oracle GoldenGate and ADGResponsible for Exadata post installation custom configuration of Compute nodes, Storage Servers and migrated Oracle database to Exadata platform wif Oracle GoldenGate and Active Data Guard
• Implemented subset of Data replication using Oracle GoldenGate Unidirectional, Broadcast configuration
• Responsible for implementing performance test on new environments and changes to existing environment wif Real Application Testing (RAT)
• Performed near zero downtime migration of Oracle databases using Oracle GoldenGate on Exadata GoldenGate from 11G to 12C/19C multitenant architecture
• Completed and updated Oracle Exadata Deployment Assistant (OEDA) for Exadata installation
• Provided support and worked wif Oracle resources during Exadata installation, configuration and expansion
• Implemented Grid Control monitoring for Exadata Compute nodes, Storage Servers, InfiniBand’s, Switches, ILOMS, PDU, and Management Switch
• Provided administrative support on Exadata leveraging its key features of Smart Scan, Smart Flash Cache, Storage Index, write-back and write-through, InfiniBand
• Implemented me/O Resource Management (IORM) to manage the me/O resources allocation on Exadata
• Setup Oracle GoldenGate Heartbeat tables and implemented OEM Grid Control monitoring for GoldenGate Instances
• Responsible for providing Oracle Exadata platform support for mission critical databases
• GoldenGate Grid Control set up documentation, and migration of mission critical Oracle databases to Exadata wif zero downtime using GoldenGate
• Configured NFS and ACFS mount in a RAC clusters for GoldenGate replication
• Planned, installed, configured, and supported Oracle, MySQL databases on EC2 Instance
• Proactively monitored, identified areas in databases dat needed to be improved in the application and database using AWR, ADDM, OEM Grid Control and resolved performance related issues via table partitioning, indexing, instance tuning
• Administration of Virtual Private Database (VPD) to protect client’s sensitive data from unauthorized access
• Performed database tuning/optimization, SQL tuning, use SQL Trace, explain plan for long running SQL queries, index creation for performance improvement and responded to trends in database system performance and resource utilization
• Performed Exadata post installation custom configuration including mounting on NFS files
• Configured, Managed Opscenter and resolved issues wif Cassandra database
• Performed Exadata Machine walkthrough and prepared both Commute nodes and Cell storage for database migration
• Implemented GoldenGate solution (Active - Active, Unidirectional and Broadcast Configuration) for data migration, reporting, transformation and recovery
• Proactively identified, troubleshoot and resolved live database system issues using tools like OEM, TOAD
• Configured backup on Amazon EC2 for Cassandra and maintained Cassandra in multiple data centers to ensure high redundancy and scalability
• Assumed ownership of database related problems; pursued problem resolution and performed root cause analysis

PROFESSIONAL EXPERIENCE

Technology Consultant

Confidential, Atlanta, GA

Responsibilities:

• Implemented and provided support for Oracle RAC, 11g, Oracle Clusterware 12c, Oracle GRID/RAC 11gr2 and networks for HA architecture
• Planned, installed, configured, and supported high availability solution using Oracle GoldenGate replication
• Designed and implemented Disaster Recovery plans and solution for Oracle databases.
• Maintained and supported Client’s databases including daily monitoring, resolved performance related issues via table partitioning, indexing, instance tuning and performance analysis using ADDM, analyzed AWR report
• Implemented and supported highly available RAC clusters for companywide single sign on application,
• Experience in capacity planning/management, monitoring of database space and estimating growth requirements
• Implemented Database backup and recovery and logical (Hot/Cold) backups Oracle backup utility such as RMAN
• Managed high availability solution centers using Oracle Real Application Clusters (RAC) wif several nodes.
• Provided KT (Knowledge Transfer)/ workshop sessions to Clients technical and customer management team
• Designed and implemented database security schemas (grant/revoke/users access) installed routine security related patches
• Evaluated clients Oracle database requirements and develop optimal solutions to address their needs
• Tuned the database and handled Incident tickets to meet Clients Service Level Agreement (SLA)
• Troubleshoot database issues, rebuilt indexes and gatheird/update statistics of tables to improve the performance.
• Efficient in sending daily operational report to the top management regarding the whole operation of the day, including any hitches and making recommendations
• Experience in maintaining referential integrity in application SQL, stored procedures, and triggers.

Oracle Database Administrator

Confidential

Responsibilities:

• Performed database migration, export and import for database, table and tablespace refresh
• Regularly reviewed space capacity and perform tasks to manage space usage through archiving or increasing disk space
• Monitored Oracle trends for hardware usage and user load (OEM, AWR report)
• Performed status checks, monitored Alert log, Trace files and database upgrade from Oracle 10g to 11g
• Maintained Oracle replication between source and target Oracle databases
• Analyzed performance issues and provided recommendations based on tested results or problems experienced in production
• Promoted changes through multiple test and production environments
• Worked closely wif all functional groups to assure a smooth implementation and to ensure compliance wif all corporate adopted system standards and procedures
• Implemented and provided on-call support for Oracle database, Oracle GoldenGate and Active Data Guard issues
• Developed and implemented Archiving, backup and recovery strategies
• Set up and managed database security by creating new users, roles, profiles, and provided required user privileges in development, test, training and production environments

Oracle Database Administrator

Confidential

Responsibilities:

• Led the effort dat provided collaboration reports to Accenture, client leadership, and project teams for video-enablement program, this effort contributed to the reduction of travel expense for some of the clients
• Implemented new installation of GoldenGate; Initial load, direct load, exp/imp wif SCN
• Setup Oracle GoldenGate for logical replication
• Implemented high availability solutions wif Oracle RAC, Physical and Logical Standby database
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases. This include checking if the Listener is running, optimal running of all databases, Unix error messages, disk space availability, document problem resolutions
• Managed physical database design and implementation, database security implementation and monitoring. Used change management processes to prevent production disruptions and outages.
• Monitored and supported Backup and Recovery (point in time recovery) using RMAN, Data pump (Import and Export) utility
• Monitored Oracle trends for hardware usage and user load (OEM, AWR report)
• Wrote and modified Stored procedures, complex SQL queries for data extraction from SQL Server

IT Analyst

Confidential

Responsibilities:

• Created and monitored standby databases and ensured minimum downtime
• Provided assistance in establishing and maintaining sound backup and recovery
• Assisted in the performing database tuning and performance monitoring.
• Assisted in performing backup and recovery of database and tablespaces
• Monitored backup operations and schedules manual backups as needed.