SHAHBAZ CHOWDHRY

Client: STC

Singlestore DBA :

• SingleStore Database Management
  Involved in Installation, configuration, upgrades, and cluster management for SingleStore DB.
• Performance Tuning & Query Optimization
  Indexing strategies, memory management, execution plan analysis.
• High Availability & Disaster Recovery
  Redundant architecture design, replication,DR Drill, backup/restore strategies.
• Automation & Monitoring
  Automation using scripts, monitoring with Trusight, Grafana, and SingleStore Studio.
• Security & Access Control
  Role-based access, data encryption.

Oracle DBA

• Managing around 10 to 15 Oracle Databasealong with two 120 TB six-node RAC databases on Exacc Servers.
• Ensuring seamless functionality for the Active Active Dataguard system.
• Facilitated Dr Drill procedures for maintaining Active Dataguard readiness.
• Monitoring Performance of database on OEM
• Storage Management - Adding & Resizing Datafile, creating tablespaces
• User Management - Managing users
• Setting up different roles/privileges, profiles for users
• Controlling and monitoring user access to database
• Managing Health-check reporting for databases
• Installation of Data-guard and managing its performance
• Managing physical/logical backups using RMAN/expdp/impdp utility
• Working on automation scripts for production databases

Oracle Golden Gate

• Managed over 20 source connections using Microservices/Classic Golden Gate on both GUI and ggsci platforms.
• implementing alterations to schemas within Golden Gate replicated tables.
• Engaged in Dr Drill activities on the source/target sides within Golden Gate.

Oracle DBA

• RDBMS Installation on Linux, AIX, Windows and Configuring Production/Test databases
• Storage Management - Adding & Resizing Datafile, creating tablespaces
• Setting up different roles/privileges, profiles for users and controlling and monitoring user access to database
• Handled over 20 to 30 Clients databases
• Managing Health-check reporting for databases
• Installation of Data-guard and managing its performance
• Managing physical backups using RMAN utility
• Managing logical backups using data-pump utility
• Working on automation scripts for production databases
• Recovery Management

MS SQL Server DBA

• Installation, Upgradation of Production/Test Environment.
• Storage Management and role management.
• Enabled replication for Single instance and performed DR DRILL.
• Performing Healthcheck and maintaining the database.