ZAIN MAHMOOD

CONSULTING PERFORMANCE ANALYST II – DNB, NORWAY (CURRENT)

Technical Consultant for 220 TB Enterprise Data Warehouse environment

• Manage end-to-end oversight of Cloud Warehouse, CIM, Backup/Recovery, and Performance optimization for Norway's largest financial institution, maintaining 99.9% system uptime
• Optimize critical business queries and workload distribution, reducing processing times by 35-70% and transforming week-long executions into hours.
• oStrategically managed 100TB+ of database storage with 15% improved utilization, including optimization of 4,000+ database objects reducing resource consumption by 30%.
• Resolve 200+ service tasks and 50+ incidents quarterly through ServiceNow with 97% SLA compliance, serving as primary technical liaison at DNB Headquarters.
• Coordinate cross-functional technical teams to address system challenges and implement changes
• Provide 24/7 critical support through on-call and evening shift rotations
• Optimize workload distribution and query performance, reducing processing times by 35%
• Work directly onsite at DNB Headquarters in Bjorvika, Oslo, serving as primary technical liaison

PERFORMANCE ANALYST – AXFOOD, SWEDEN (2023 – 2024)

Lead performance analyst for 90 TB Teradata-on-AWS Data Warehouse Environment

• Implemented space optimization initiatives that reclaimed 7.8 TB (11% of system capacity) within 6 months
• Enhanced Data Science team productivity by eliminating session failures through workload management optimization
• Developed predictive space forecasting models that prevented system crashes and guided capacity planning
• Architected development environment for ETL migration and managed access control for migration teams
• Mentored and trained junior DBA while simultaneously leading performance optimization efforts
• Created and executed monthly Continual Improvement Plans that systematically enhanced system efficiency
• Collaborated with management to identify upsell/renewal opportunities worth $500K+ annually

Received two Excellence Awards for restoring customer trust and delivering exceptional service

SENIOR DBA – MOBILY, KSA (2021 – 2023)

Primary database administrator for 215 TB enterprise data warehouse

• Spearheaded successful implementation of SLES Linux upgrade, Backup System upgrade, and QueryGrid installation
• Led successful LDAP integration project, transitioning 800+ users from password authentication to LDAP
• Implemented automated purging solutions and compression strategies that reclaimed 60+ TB of space
• Delivered cumulative 100+ hours of system performance improvements through query optimization techniques
• Mentored 15+ team members on database administration best practices and designed disaster recovery strategy

Awarded Excellence Award for critical query optimization that reduced runtime from 5 hours to 2 minutes during disaster recovery

Won Project Team Award twice and secured $840,000 contract renewal against competitor bids

DATABASE ADMINISTRATOR – LÄHITAPIOLA, FINLAND (03/2021 – 06/2021)

• Managed critical pre/post-migration operations during enterprise system upgrade
• Mentored graduate trainee and new hire while simultaneously managing project deliverables
• Conducted comprehensive system resource analysis that identified optimization opportunities
• Delivered detailed technical reporting and resolved complex system change requests

BACKUP ADMINISTRATOR – GJENSIDIGE, NORWAY (2020 – 2021)

• Orchestrated all backup and recovery operations using Teradata DSA and Netvault
• Managed media infrastructure, tape rotations, scheduling, and comprehensive reporting

DBA AND APPLICATION CONSULTANT – MBLL, CANADA (2019 – 2020)

• Enhanced database performance through shell scripting automation, statistics collection, and query tuning
• Implemented physical design improvements and space optimization strategies
• Managed ETL operations including scheduling, error resolution, and performance reporting

BIG DATA TRAINEE CONSULTANT – VOLVO CARS, SWEDEN (2018–2019)

• Implemented test Hadoop system through comprehensive research on configuration, setup, and security
• Established SSL for Apache Ambari server and enhanced data security by converting HTTP to HTTPS
• Documented enterprise-grade procedures as proof of concept for client implementation
• Technologies Deployed: HDFS, Hive, Kerberos, Apache Ranger, Ambari