Database Analyst - Netsol Technologies Pakistan - Lahore, Pakistan
(2020-08)
Database Administrator - Aequitas Information Services Limited
(2019-09)
- Designed and developed ETL packages using SQL Server Integration Services (SSIS) to extract data from multiple sources, transform and validate datasets, and load data into SQL Server databases/data warehouses.
- Enhanced SQL query efficiency to ensure faster data retrieval and processing.
- Administered Oracle/MySQL and SQL Server databases, optimising configurations for improved system performance.
- Resolved SQL Server/MySQL/Oracle/PostgreSQL server issues to maintain database performance and reliability.
- Migrated SQL Server databases to MySQL using MySQL Workbench, ensuring data integrity throughout the process.
- SQL Server to MySQL Migration using Kafka
- MySQL to SQL Server Migration using SSMA
- SQL Server to PostgreSQL data migration through docker/pgAdmin and Python
- Schema Migration through AWS Migration
- Full stack Development using Python
- Led database team, coordinating with application owners to align database performance with organisational needs.
- Troubleshot database issues, conducting root cause analysis to ensure system reliability.
- Optimised performance and tuned Vertica database, enhancing overall system efficiency.
- Administration and Real-Time Monitoring of Vertica 9.1.0 Cluster Database.
- Installation/Configuration of Vertica Cluster Database.
- Database Migration of Vertica Database.
- Vertica Database Upgrade from 9.1.0 to 9.2.0.
- Storage optimization according to Vertica Architecture.
- Setting Retention policies, backup and recovery policies.
- Performed daily database maintenance tasks to ensure optimal performance and reliability.
- Administration of MySQL database.
- Session Level Monitoring of MySQL database.
- Database Migration of MySQL database.
- Configuration of Replication in MySQL database.
- Processed ad hoc requests from operations team to ensure timely response. initiated from operations team.
Application Database Administrator - NRSP Microfinance Bank Ltd.
(2017-04 - 2018-11)
- Administration of RAC databases and their performance optimization.
- Administered and maintained standby database, ensuring synchronization with primary site for real-time reporting.
- Monitored database performance proactively using EM, ADDM, AWR, ASH, and specialized DBA scripts to enhance performance insights.
- Sidat Hyder Financials database/application administration backups & recovery, tuning and maintenance.
- Taking/scheduling production database backups using RMAN and datapump.
- Resolving database and application issues by applying patches, bug fixes, scripts and Oracle supplied solutions.
- Oracle Fusion middleware 12c administration and tuning.
- Oracle business intelligence suite administration, maintenance and tuning.
- Flexcube 11 and 12 frontend administration and first level support delivery.
- Monitoring and execution of flexcube 11 & 12 EOD, EOM and EOY.
- Integrated flexcube database with Sidat Hyder for banking data consolidation to support reporting requirements.
- Monitoring and purging database, application and sun OS logs/alerts/messages by considering their retention settings.
- ATM terminals, transactions and ATM switch monitoring via ADC and core banking applications.
- Created comprehensive technical documents detailing system configurations and processes. including Hardening documents, SOPs and user manuals.
Information System Auditor - NRSP Microfinance Bank Ltd.
(2016-07 - 2017-04)
- Performed information system audits over 8 months, identifying key risks and compliance issues
- Expertise in planning, execution and reporting of audit assignments in the following areas: Change Management, Active Directory & Exchange, Alternative Delivery Channels
- Maintained audit working papers and developed audit plans to ensure thorough examination of systems
- Composed comprehensive audit reports detailing findings and recommendations for client improvement
- Conducted follow-up communications with clients to ensure all audit findings were addressed
Intern - PTCL
(2014-08 - 2014-09)
Completed 6-week summer internship at PTCL, focusing on core areas of telecommunications.
- Analysed UFONE Communication's services and operations to understand market position.
- Studied switching technologies in telecommunication networks, enhancing technical knowledge.
- Studied fiber optics technology used in telecommunications
- Studied principles of wireless communication technologies
- Pakistan Telecommunication Company Limited
