Madhu G Email & Phone Number

Prosper, Tx, Us

India

• Installing and configuring the PostgreSQL and Singlestore databases as per the business requirement.• Upgrading/migrating the databases from one version to another version and on-prem to cloud (AWS/Azure)• Resolving the sync issues between Primary and Read replica.• Deploying and configuring the Aurora PostgreSQL using AWS CloudFormation.• Migrating the data between schemas/databases in Aurora PostgreSQL.• Migrating the Oracle databases to Aurora PostgreSQL using AWS DMS and SCT.• Daily Monitoring the health check of PostgreSQL and Singlestore databases, pipelines and job status.• Monitoring and maintaining open-source postgres databases for their Optimal Performance and ensuring100% availability of the databases.• Configure repmanager(repmgr) for HA and DR.• Generating the profile for the query and analysing the query performance issues and database issues.• Develop the python scripts to automate the backups and stored procedures, and schedule them usingcrontab.• Develop the python scripts to check the backup status and validate the backups.• Analysing the memsql logs and identifying the issues of node failures.• Creating and modifying the functions, stored procedures, pipelines, tables and views in github and deploying via Jenkins.

India

• Designing and implementing the database architecture for Oracle, Aurora PostgreSQL, Singlestore, in Azureand AWS using GUI/CLI and with Shell/Python.• Co-ordinating with Network, Storage and backup teams and deploy the databases in Azure cloud as per theapplication requirements.• Migrate the databases from on-prem to cloud (AWS/Azure) using AWS DMS and SCT.• Install, configure, administer, and patch on premises, Amazon RDS, PostgreSQL, and Oracle.• Install and configure both enterprise edition of Postgres and open-source Postgres.• Monitoring and maintaining open-source postgres databases for their Optimal Performance and ensuring100% availability of the databases.• Implement database backup and recovery strategy.• Upgrade open-source PostgreSQL from 9.5 to 9.6, 9.6 to 10.3, 10 to 12.1 etc using pg_upgrade utility.• Creation of databases and configuration of rules in pg_hba.conf file.• Maintain data integrity and database performance, stability, and scalability.• Configure and replicate the databases using Goldengate• Develop the python scripts and deploy the resources in cloud using CloudFormation.• Working on query performance issues and providing the best tuning solution to the customers.• Analysing the Goldengate issues and providing the solution to the customers on replication issues.• Supporting data migration activities using XTTS/Goldengate methods and AWS DMS and SCT.• Providing the workaround solutions to the bugs without necessity of applying the patches.• Working on Cluster and Dataguard/Read replica issues and providing the appropriate solutions to thecustomers.

India

PostgreSQL:• PostgreSQL 9.6 installation and upgrade from 9.6 to 10 using pg_upgrade utility.• Proactively monitor the health of databases and make recommendations to optimize performance andefficiency.• Diagnose and resolve database, network, and firewall related issues.• Collaborate with various teams in developing system hardware layouts, configuring firewall rules, tuning, andload testing of mission-critical database systems.• Comply with database security standards.• Troubleshoot replication and HA/DR issues.• Produce scripts for maintenance and database housekeeping needs.• Resolves database performance issues, capacity needs, and security concerns.• Proactively ensure optimal availability and performance of the database systems.• Work with client on database projects and daily management.• Troubleshoot and resolve PostgreSQL issues while working concurrently working with multiple priorities.• Configuring and maintaining the data base in WAL mode.• Monitoring and checking the database backup and recovery process.• Creating and Managing users, roles, schemas and security.• Backup using pg_dump, pg_dumpall utility and restore using pg_restore utility setting up of Hot Standby.Oracle:• Building and Configuring Oracle, Oracle AWS RDS databases as per the business requirement• Managing Oracle Standalone/RAC Production and Dev/Test databases.• Daily Monitoring the databases, instances and listeners using Oracle Enterprise Manager Grid Control andMonitoring of alert log files for errors, trace files and archive log destination files.• Creating and monitoring the tablespaces, allocating tablespaces for users.• Creating/altering users with restricted access with required privileges.• Taking physical and logical backup using RMAN and DATAPUMP.• Performing Database Upgrade from 11g to 12cr1/r2 and 11gr2/12cr1/r2 to 19c.• Database Migration from 11g AIX to 12c Linux with TTS and 11g AIX to 12cr2/19c Linux with Goldengate.

India

• Managing Oracle RAC Production and Test clustered databases.• Providing 24*7 Offshore DBA support for the Client.• Daily Monitoring of alert log files for errors, trace files and archive log destination files.• Creating and monitoring the tablespaces, allocating tablespaces for users.• Taking physical and logical backup using RMAN and DATAPUMP.• Performing Database Upgrade from 10g to 11g and 12c.• Performing backup creation tasks of OCR and VOTINGDISK.• Applying the rolling patches in RAC databases.• Administering RAC databases using SRVCTL and CRSCTL utilities.• Monitoring the user sessions and take appropriate action to kill the inactive sessions.• Monitoring top resource consuming process on OS level.• Generating AWR and ADDM reports using the snapshots taken for the collection of database statistics.• Attending user's requests, monitoring & reporting in daily basis and maintain the SLA.• Daily monitoring the below activities: Availability of Databases, Instances and its listeners. Growth of Tablespace, Datafiles and Redo log files. Disk space and escalate to OS administrators for any disk space issues and inform the Client regarding the consequences of it. The existing DR site to make sure that they are in sync with production. Alert logs for errors and resolving them.• Adding/resizing/renaming Datafiles, analyzing tables and tablespace management.• Creating Database users, allocate to appropriate tablespace, assigning quotas, roles, privileges and profiles to users.• Archival Space monitoring and moving the Arch files to remote backup location.• Monitored system resource availability and responded to system memory and data issues.• Creation of oracle objects as per application/development team's request.

India

• Monitored all the activities of Prod, test and development databases.• Database security by creating users, roles and grants on objects.• Worked in 24x7 production environment and day-to-day support.• Adding/resizing/renaming Datafiles, analyzing tables and tablespace management.• Involved in updating procedures, functions, triggers, and packages based on the change request.• Built complex queries using SQL and wrote stored procedures using PL/SQL.• Used ref cursors and collections for accessing complex data resulted from joining of many tables.