Andy Singh Email & Phone Number

United States

• Configuring MySQL Backups.• Set up retention policy of backups.• Set up disaster recovery solutions.• Configuring MySQL monitoring using MEM.• Upgrade MySQL from 5.7 to 8.0.• On call support (24x7) for all assigned projects.• Design, Install, and configure MySQL MariaDB in Linux environment.• Configure High availability in MySQL environment using Master Slave replication• Working in the GCP environment for my current project, creating MySQL databases.• Worked on Galera Cluster and Group Replication.• Configuring OEM 12c, install agents, discover targets.• Upgrade 12c OEM to 13c OEM.• Oracle database upgrade from 12c to 19c.• Experience in configuring DataGuard.• Automated database backup jobs using RMAN and Datapump.• On call support (24x7) for all assigned projects.• Analyze AWR, ADDM and ASH reports. Tuning SGA.

Cleaveland Oh

• Design, Install, and configure MySQL MariaDB 10.2.11 in Linux environment.• Data Migration from MySQL 5.6 to MariaDB 10.2.• Configure MySQL group replication as HA solution.• Auditing MySQL databases using MySQL Enterprise Audit plugin.• Configure Perona XtraDBbackups and mysqldump.• Configure MySQL Enterprise Monitor and Monyog to monitor MySQL databases.• Diagnose MySQL performance issues using profiling and MEM.• MySQL router configuration for load balancing.• Upgrade 12c OEM to 13c OEM.• Oracle database upgrade from 11g to 12c.• Design, Install, and configure Oracle 12c RAC in Linux environment.• DataGuard Configuration• Automated database backup jobs using RMAN and Datapump.• On call support (24x7) for all assigned projects.• Analyze AWR, ADDM and ASH reports. Tuning SGA.• LOGON Trigger for Auditing purposes.

Phoenix, Arizona Area

• Monitor and fully analyze performance issues in production Oracle databases. • Participated in analysis and designing of Oracle Exadata Server.• Baseline backup and restore and maintain administration scripts using Korn shell.• Installed, configured and maintained Oracle 12c RAC on RHEL 6.0.• Work with developers on SQL code review, quality control, load testing and tuning.• Duplicate the non-production databases on Exadata server.• Partition large table by using Oracle range portioning.• Worked on different RAC related issue such as hang check, split brain, RAC recovery.• Setup/configured Physical and Logical standby databases.• Installed and configured MySQL on Linux and Windows environments.• Managing/Troubleshooting MySQL 5.5 and 5.6 in production and developer environments.• Assisted with sizing, query optimization, buffer tuning, backup and recovery.• Effectively configured MySQL Replication as part of HA solution.• Performance Tuning using and capacity planning using MySQL Enterprise Monitor.• Configure database backups using mysqldump and MEB.• Load balancing using MySQL router configuration.• Database performance by utilizing MySQL config changes and show engine status report.

Phoenix, Arizona Area

• Design, Install, configure Oracle 12c RAC in Linux environment.• Oracle 12c GoldenGate installation, configuration and troubleshooting.• Install Jagent, Veridata agent and Veridata Server 12c Rel 2 for Goldengate.• Configure DataGuard in shared ODA environment.• Oracle CDB, PDB, multi-tenant databases.• Configure OEM 12c, 13c, install agents, discover targets and add to OEM. • POC PostgreSQL 9.x and Cassandra for upcoming projects.• Patching using Opatch to Oracle RAC DB's in shared ODA environment.• Unix shell scripting to automate various jobs.• RMAN backup jobs with catalog setup.• Performance tuning and monitoring.• Install oracleasmlib, ASM RPM and configure ASM.• OEM VIP agent installation.• Install new OH using oakcli and patching to move DB to new OH in RAC env.• Database upgrade from 11g to 12c.• Move Oracle non-CDB to CDB.• Installing/Configuring and setup MySQL 5.6 in Linux environment. • Upgrade MySQL 5.5 to 5.6.

Phoenix, Arizona Area

Worked on Oracle 9i, 10g, 11g, MySQL 5.x, Galera Cluster, Percona XtraDB Cluster, SQL Server 2005, 2008, 2012 with all DBA responsibilities including database performance tuning, backup and recovery and Security of databases. • Oracle Database Migration to MySQL.• Move Oracle and MySQL from Datacenter to AWS.• Automated database backup jobs using RMAN and Datapump.• Tuning SQL statements by running Explain Plan, TKProf and with the help of Virtual Indexes.• Analyze AWR reports for database tuning.• Automated database monitoring and alerts with help of cronjobs / shell scripts.• Oracle database Installation on Solaris and Windows environment.• Setup OEM, install agents and add targets to OEM• Refreshing development databases with production for testing.• Upgraded Oracle 9i Database to 10g R2 on Windows Server 2003 and Solaris 10.• Review/Test PL/SQL code written by the Developers to make sure that it performed optimally before implementing to Production database.• Schemas creation, granting privileges, creating roles based on the user request.• Space Management using locally managed tablespaces.• On call support (24x7) for all assigned projects, • Database security using VPD, and monitor database logons using LOGON Trigger for Auditing.• Participated in establishing guidelines, documentation and project planning.• Database alert setup, configured dashboards using OPNET Panorama.• Installed and Configured MySQL 5.5 databases.• Upgrade MySQL Database from 5.5 to 5.6.• Configure MySQL replication for high availability.• Multi Master MySQL replication using Galera Cluster.• Configure MySQL Physical and logical backups.• Restored / Refresh MySQL databases using mysqldump.• SQL server database migration to MySQL.• Installed Configured DBVisit Standby tool to create standby database for Oracle SE• Configured Golden Gate replication from Oracle to Oracle and from Oracle to MySQL.

Andover Ma

Worked on Oracle database 10g and windows server 2003 as production support DBA.

Kansas

Worked as Oracle RAC DBA on 10g RHEL platform installed configured and production DB support including Recovery, Tuning and Security of databases.Upgrade and database replication using streams.

Boston

Worked as Oracle DBA on 8i, 9i with all kind of DBA responsibilities.