Suresh Kumar Ch

PostgreSQL DBA:

• Backups and recovery.
• Scheduling crontab jobs and planning backups for PostgreSQL databases.
• Logical and physical backup.
• User management.
• Installing and upgrading PostgreSQL databases. Expertise in installing, configuring, securing, and managing PostgreSQL to ensure better performance and application availability.
• Performing data refresh activities from production to Dev/Test on a need basis.
• Ensure and maintain sound backup and recovery policies and procedures.
• Backup and restore the databases from the production to the test environment.
• Executing the scripts in the production environment.
• Expertise in implementing PostgreSQL security and database permissions.
• Perform a vacuum on the database, tables, and REINDEX to improve the performance of the database.
• Setting up high-availability configurations, such as primary and secondary setups, for PostgreSQL databases.
• Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.
• Worked on high availability, like replication (primary to replica).

Cloud (OCI) DBA

• Managing day-to-day operations by monitoring system health and performance.
• Applying Oracle suggested RDBMS/EM agent patches for known issues/bugs.
• Monitoring and resolving day-to-day issues in the RAC environment.
• Monitoring the critical Exadata data machines with Oracle Enterprise Manager.
• RAC Services Management
• Worked on various database PSUs and DB one-offs (bug patches).
• Supporting databases in the Exadata platform, patching, upgrading, and migration.
• Worked on ORACLE Exadata node (Exacs) patching.
• Patch PSU, one-off patches in RAC clusters.
• Monitoring and Managing the Oracle RAC (Quarter RACK, Half RAC, Full RAC) Databases.
• Applying Exadata Bundle patches on Grid and RDBMS homes.
• Managing the various critical database backups.
• Monitoring and managing the Oracle RAC application-specific RAC services.
• Maintenance of database sync between primary and standby databases.
• Performing various export and import tasks.
• Monitoring the database health using Kibana.
• Administering the Oracle Cluster using command-line utilities like SRVCTL, CRSCTL, etc.
• Developed various proactive DB monitoring Bash/Shell scripts.
• Backup and recovery using RMAN, troubleshooting, etc.
• Part of the interview panel.
• Implemented an automatic stats collection job, which reduced a lot of performance issues.

• Resolving various performance issues on critical production databases.
• Working on various Oracle best practices to make the environment stable.
• Planned, tested, and implemented the OEM 11g monitoring with OEM.
• Applied bug fixes and mandatory one-off patches when we encountered bugs at the database level.
• Working table reorganization to improve the performance of the database.
• Extensive DB monitoring through OEM 13C.
• Applied PSU patches to RDBMS and 11g GRID, 11g RDBMS homes every quarter.
• Investigate the slow performance of the Query/DB, which impacts application efficiency.
• Worked on various DB change requests.
• Managing RMAN backups.
• Performing trial recoveries to test the DR plan.
• Database backup and restore/recovery strategies (physical, logical, cold, hot backups).

• Designed and developed database structures (tables, indexes, views, sequences) to implement business rules, procedures, etc.
• Defining and implementing backup strategies, and handling critical recovery scenarios with RMAN.
• Table space management (System, User Data, User Indexes, Undo, Temporary).
• User account management.
• Patch PSU, one-off patches in RAC clusters.
• Managed User Privileges and Roles, and Database Auditing.
• Implementation of the Partitioning of Tables.
• Implemented external tables for data migration.
• Analyzing tables and schemas, collecting system statistics, reorganizing tables, and rebuilding indexes.
• Query writing for the application team's requirements.