Skip to main content
Adina Rafiq

Adina Rafiq

Database Analyst

Talent
PKMember since July 29, 2026
SQLVertica 9.1.0Python
·

Hire this person

Send a job offer directly to this candidate

SQLVertica 9.1.0Python

About

A strategic Computer Systems Engineer with natural leadership abilities, relationship-building acumen and passion for developing outstanding results. Looking to join a progressive organization where my skills and pragmatic abilities in Programming and web development are needed and that offers opportunities for advancement.

Experience

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

Education

Oracle Certified Professional - Techno ed (2016-04)

BSc - Computer Systems Engineering - University College of Engineering & Technology, The Islamia University of Bahawalpur (2015-01)

Intermediate - Computer Sciences - Punjab College (2011-01)

Matriculation - APWA High School (2009-01)

Skills

Database Analyst

Reviews

Related