Qaisar Mahmood

Database Architect consultant

Divogue

Nov 2023 - Current (3 years)

• Administration of Company's All Production and Test Databases based on AWS (oracle, MySQL, SQL Server, Mongo, PostgreSQL). • Implements data models and database designs, data access Methods. • Prepared High Availability, Scalability and Disaster Recovery Plan and SOPs. • Database and Query Optimization. • Oracle Database Development. • Support all application teams during deployment and provide them quick solutions if required.

Database ARCHITECT

NorthBay Solutions

Aug 2021 - Nov 2024 (3 years 4 months)

• Database Migration (SQL Server to AWS Aurora PostgreSQL, Oracle to AWS Redshift) • Database Administration on AWS RDS (MSSQL, Oracle, MySQL, PostgreSQL) • Database migration from on-premises Oracle to AWS Redshift. • Well versed with AWS service VPC, Lambda, RDS, DMS, SCT etc. • Snowflake database development.

C

Member Technical Staff

Center OF Advanced Research AND Engineering (care Pvt. Ltd.)

Jun 2019 - Jul 2021 (2 years 2 months)

• Online Mail System (OAS) Schema Designing for the large size organization. • Database Migration from MySQL to Oracle 12c. • Installation, Configuration and Administration of 3 nodes Multi-Master Oracle Golden-Gate Replication. • Configuration of Active Data-Guard for all three sites. • Performance tuning of Oracle and MySQL Databases. • Developed Data warehouse architecture. • ETL from heterogeneous databases to oracle database.

Team Lead DBA

Wi-Tribe

Oct 2014 - May 2019 (4 years 8 months)

• Administration of Company's All Production and Test Databases (oracle, MySQL, SQL Server). • RAC and Data guard administration • Oracle BRM installation, administration, Performance tuning. • Perform bill-run Activities on Oracle BRM. • Oracle BRM database Migration from single Instance to RAC and Vice-versa. • Lead Billing Team. • Operational support to frontend users (sales and Contact Center Represented), Invoicing Verification • Administration of oracle (E-business suit) ERP database. • ERP Cloning, Patching, Enforce Security Policies and Procedures. • Switch and Radius Databases Administration. • Share Point Database User management and Backups. • MySQL installation, Database creation and Management. • Database Up-gradat

V

Database Architect

Virtellegence

Jul 2014 - Sep 2014 (3 months)

• MySQL database architecture, Modeling, Designing. • Prepared High Availability, Scalability and Disaster Recovery Plan and SOPs • Database Administration, Performance Tuning, Query Writing, Reporting • MySQL Clustering • Linux Installation and system Administration • Design DR Solution.

T

Database Architect consultant

Tele-Taleem

Sep 2013 - Sep 2014 (1 year 1 month)

• Propose and implement a complete database plan for Tele-taleem project for OLTP and OLAP. • MySQL/Maria database architecture, Modeling, Designing. • Configuration of MySQL replication for 2 nodes and Galera Cluster for 3 Node replication. • Prepared High Availability, Scalability and Disaster Recovery Plan and SOPs. • Database and Query Optimization.

P

Sr. DBA

Pakistan Revenue Automation Ltd. (PRAL)

Jan 2013 - Jun 2014 (1 year 6 months)

• Maintaining the databases on UNIX and Windows Platform. • Administration and implementation of policies and procedures for ensuring the security and integrity of the company database. • Implements data models and database designs, data access Methods. • Resolves database performance issues, database capacity issues, • replication, and other distributed data issues. • Tuning of different databases on UNIX, windows, Linux platform. • SQL tuning and indexing. • Installation and configuration of oracle Database on windows, Linux platform • Oracle 11g RAC installation and administration. • Configuration of Active data guard on 11g.

About

Detail

Timeline

Résumé

Qaisar Mahmood

About

Detail

Behavioral traits