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.

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.

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.

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.

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.