• Team Lead of the database team, overseeing database management, optimization, and ensuring data integrity across several projects.• Setup and maintenance of Patroni for HA with etcd and HAproxy servers for auto switchover and load balancing.• Configured and deployed Grafana with Prometheus along with alert mechanism for Real-time Database Monitoring Dashboard.• Effectively monitoring and maintaining 60+ Database/Monitoring/ETL servers to ensure optimal performance and seamless operations across the whole organization.• Managing multiple database projects from inception to completion.• Implemented Oracle Golden Gate from Oracle to Postgres for OTT.

• Deployed and migrated multiple MySQL databases for reporting of FAFEN (Free and Fair Election) during observation of nation-wide elections 2024 in Pakistan.• Deployed multiple Master-Slave Replication MYSQL Server for High Availability.• Deploying several real-time database pipelines for customer intimations.• Maintaining and developing data pipeline using Apache Kafka, Python and PL/SQL to automate the IVR process at server and Database level.

• Seamless real-time data streaming using Apache Kafka.• Skillfully orchestrate backup, recovery, replication, switchover, failover, encryption, and high availability setups.• Expertly manage/administer complex databases, including Oracle, PostgreSQL, and MySQL.• Ensuring high reliability through the proficient utilization of PostgreSQL extensions and tools, including but not limited to Postgres_fdw, oracle_fdw, ora2pg, pgbackrest, pgbadger, pg_partman, and so on.• Well-versed in ETL (Extract, Transform, Load) tools, specifically Apache Airflow. With this tool, I seamlessly extract, transform, and load data, enabling organization to derive valuable insights and make data-driven decisions efficiently.

• Gained proficiency in Oracle database versions 19c, 12c, and 11g, as well as PostgreSQL versions ranging from 9 to 15.• Developed several PL/SQL scripts for data porting/transformation.• Working on real-time data streaming along with data transformation in Python to fetch historical alarms.• Played a major role in SAP administration, backup etc.• Designing and developing a mechanism for database health checks.• SQL Query optimization in order to enhance query performance and resource utilization.