Rezwan Ullah Email & Phone Number

Islamabad, Islāmābād, Pakistan

- Mysql upgrades, From 5.7 to 8.0.3x- Mysql administration and provide support to application team.- PostgreSQL installation and administration, Upgrades from 15 to 16- Greenplum upgrades, Greeplum migration from single instance to cluster- Skilled in Greenplum and MySQL administration, including high availability- Data migration from Mysql, MSSQL to Greenplum.- Expertise in automation, scripting, and issue resolution.- Strong background in Greenplum features like GPCC, Workload Management, and Query Tuning.- Implemented AlwaysOn on SQL Server 2016 for enhanced reliability.- Performance and query optimization- Designed and implemented logical replication solutions using PostgreSQL's native replication features to ensure data redundancy and high availability across global infrastructure.- Collaborated with development teams to design normalized database schemas and optimize complex queries using PostgreSQL's query planner and EXPLAIN ANALYZE for improved application performance.- Automated routine maintenance tasks, including backups, restores, and monitoring, using tools like pgBackRest, pg_auto_failover, and custom PL/pgSQL scripts.- Configured and managed high-availability clusters using Patroni with Citus extension for horizontal scaling of PostgreSQL databases.

• Upgrade Oracle database 11g to Oracle database 19 (In-progress)• Real-time data replication using Goldengate (Non-production)• Checking Alert log and other logs for errors & trouble shooting it accordingly.• Keep Monitoring Database active and inactive sessions.• Enrolling users, assigning roles and profiles, maintaining system security through monitoring user access to the database.• Monitoring the regular backups and free up the archive logs space.• Scheduled RMAN scripts for backup (full and incremental) and auto restore. Mysql installation and configuration. Mysql native replication with master and slave instances.- Administered PostgreSQL databases in a high-transaction environment for national telecom databases, focusing on connection pooling with PgBouncer and query parallelization. Performed daily database administration tasks in PostgreSQL environments, including user management, access control with row-level security (RLS), and monitoring using pg_stat_statements.- Implemented regular VACUUM and ANALYZE operations, along with autovacuum tuning, to optimize table statistics and reclaim disk space in large PostgreSQL databases.

Islāmābād, Pakistan

• Upgrade Oracle database 11g to 12c with 2 nodes RAC with almost zero downtime.• Manage all aspects of the OGG design, implement and support in development, UAT and production environments. • Upgrade Oracle Goldengate 12c to 19c.• Identify and resolve OGG problems occurring in all database environments including performance related issues (i.e. database & SQL tuning).• Setting up High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments.• Monitor and fully analyze performance issues in production Oracle databases by using AWR/ADDM• Daily development / testing environment baseline backup and restore, develop and maintain administration scripts.• Implemented DDL replication using GG.• Maintained all existing databases and new installations at current and stable production levels• Implemented database auditing and regularly monitored active user sessions. • Applied patches, quarterly patch security updates to existing Applications.• Analyze and troubleshoot failed backups.• Managed database backups/Recovery using RMAN.• Deploying the JAR Applications in PROD, UAT & DEV Environments. • Managing the disaster recovery systems.• Patching Database, Oracle applications and efficient troubleshooting of post-patch issues. - Installed and administered PostgreSQL instances, handling major version upgrades and fine-tuning configuration parameters to meet growing data needs.- Implemented point-in-time recovery (PITR) strategies using pg_basebackup and continuous archiving for seamless data synchronization between multiple environments.- Set up and maintained PostgreSQL streaming replication with hot standby for disaster recovery and high-availability purposes, ensuring minimal downtime during failovers using pg_rewind.- Optimized PostgreSQL query performance through intelligent partitioning, appropriate indexing strategies and query rewriting, significantly reducing query execution times.

Islamabad

Client: ZONG (China Mobile Company LTD)Responsibilities:ZONG EBS is implemented with a sophisticated architecture include EBS R12.2.4 (Multi node), Database 12.1.0 (Multi node).Isupplier DMZ (Multi node) on EXADATA server with Linux OS and also BI and Hyperion Application integrated with it.Responsible for the Administration, Configuration, Patching, Monitoring and maintenance of the environment including backup and restoration plans using Oracle Net Backup Appliance.ADOP patching activity. RAC to Non-RAC cloning with RMAN backup with EBS.Administer BI and Hyperion servers troubleshooting (Startup and Shutdown)

Islamabad

Inbox business technology is a fast growing Oracle consultancy firm who provides consultancy & support services of Oracle E-Business Suite & I am serving as an Associate Application DBA consultant & held for the following responsibilities:• Configured two nodes RAC (11gR2) on Solaris Sparc.• Configured two node RAC (11gR2) with ASM on OEL 5.4 on Exadata and Exalogic server.• EBS Cloning from RAC to RAC environment RAC to NON RAC,Non RAC to RAC• Configured Data guard on Test environment.• Oracle Fusion Middle Ware upgrade from 11.1.1.6 to 11.1.1.9• Configured Custom Top on EBS 12.2.4• ADOP patching cycle.• Database upgrade from 11.2.0.3 to 11.2.0.4 with EBS 12.2.4• Database upgrade from 11.1.0.7 to 11.2.0.4 with EBS 12.1.3• Platform Migration from Linux to Linux with EBS 12.2.5• Application Cloning on EBS 12.2.5• Applied web logic PSU patches on EBS 12.2.5• Configured Multiple EBS databases on same oracle home.• ProjectsMobilink OVAA (Largest ERP Implementation in Region)  Successful completion awarded.• Configured 2 Node RAC database on EXADATA with EXALOGIC VM EBS 12.2.4• ADOP patching cycle. • Database upgrade from 11.2.0.3 to 11.2.0.4 with EBS 12.2.4Mobilink SLA • Support Project with EBS R12.1.3, • Database 11.2.0.3 on Solaris 10 OS• Sparc T4 serversUniversity of Peshawar• End to End Implementation EBS R12.2.5 database 12.1.0.2.0• Upgrading EBS 12.2.4 to 12.2.5• Upgrading Fusion Middle ware 11.1.1.6 to 11.1.1.9• Installing EBS R12.2.5 with database 12.1.0.2.0 Jazz ERP SLA• My major involment in Jazz ( Mobile Telecom Company) ERP operations team, and deal with day to day issue.• e.g. workflow issue, patching, clonning, compiling, performance issues etc

Peshawar, Khyber Pakhtunkhwa, Pakistan

Responsibilities:-Responsible for ensuring availability and performance of the databases that support the system.Work with the team to ensure that the associated hardware resources allocated to the databases and to ensure high availability and optimum performance.To proactively monitor the database systems to ensure secure services with minimum downtime.Responsible for problem escalation to Oracle Development team and third parties as appropriate.Responsible for ensuring availability and performance of the databases that support the systemAdministers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.Plans and implements backup and recovery of the Oracle database.Provides technical support to application development team if requiredEnforces and maintains database constraints to ensure integrity of the databaseTroubleshoots with problems regarding the databases, applications and development tools

Bachelor Of Computer Science (B.S(Cs)), Computer Science, 3.28/4.0

Activities and Societies: Debate Team, DevelopmentsSoftware Engineering

Dae, Computer Hardware, A

Activities and Societies: Debate TeamComputer Hardware

Metric, Science, B+

Activities and Societies: Playing Cricket For SchoolScience