Awais U.-Senior DB2 Database Administrator | SQL Development, Scripting & Automation
Check rate
Experience
AI Data Quality Specialist
Workada
- Evaluate AI-generated responses for factual accuracy, relevance, completeness, logical consistency, and adherence to established guidelines.
- Perform data labeling, classification, and annotation across project-specific assignments.
- Identify inconsistencies, inaccuracies, and quality issues through systematic evaluation and validation.
- Apply standardized quality criteria to support reliable AI evaluation and data annotation outcomes.
- Leverage analytical thinking and data quality principles to provide structured feedback and support continuous improvement.
Senior Consultant — Database & Infrastructure
ELM Company
- Regularly write complex data retrieval queries and stored procedures supporting 50+ clustered DB2 LUW (UDB) production databases (110+ instances, 50+ TB of data) within a 24/7 on-call rotation maintained continuously for over 10 years.
- Interpret business requirements from application and business teams, producing functional and technical design documentation for database changes and new development.
- Automated recurring DBA scripts, health checks, and maintenance jobs using Python and Linux Shell (Bash) scripting, scheduled via cron and Windows Task Scheduler — cutting manual run effort from hours to under a minute.
- Improved query performance up to 2x through SQL optimization, locking/concurrency troubleshooting, and buffer pool tuning across DB2 DPF (partitioned) environments; performed ongoing capacity and growth forecasting.
- Designed and executed disaster recovery plans and HADR/TSAMP-based automated failover across 35+ database clusters against strict recovery point/time objectives.
- Configured DB2 SQL Replication and, as part of a team, an active-active Qlik Replicate solution for real-time cross-site data synchronization between geographically separate DB2 LUW sites.
- Defined and implemented access controls and data-at-rest security via DB2 Native Encryption
- Supported enterprise LDAP/SSO/IAM frameworks for authorization governance and audit compliance.
Achievements:
- DB2 Migration & Upgrade Program: Led multiple DB2 migration and upgrade cycles across 35+ of clustered databases, ensuring minimal downtime and seamless transitions
- High Availability & Disaster Recovery Implementation: Designed and enforced data governance, retention, and integrity frameworks, ensuring compliance with enterprise security and audit standards
- Enterprise LDAP Architecture: Built and managed high-availability LDAP infrastructure supporting 30M+ users with enhanced scalability and uptime.
Technical Consultant — Database & Security
Royal Cyber Inc.
- Monitored and enhanced database security controls using automation and alerting, improving threat detection and audit response times.
- Deployed and administered IBM Tivoli Access Manager (TAMeB) WebSEAL junctions and configured IBM Federated Identity Manager (TFIM), enabling secure authentication, authorization, and identity federation across enterprise applications.
- Designed and implemented SSO and reverse-proxy web security solutions, improving access efficiency, system governance, and audit readiness.
Associate Engineer
Systems Limited
- Performed system backups and recovery operations, identified and resolved network/security bottlenecks, and provided technical support to end-users, ensuring data availability and policy compliance.
Industry experience
See where this freelancer has spent most of their professional time.
Experienced in Information Technology.
Business area experience
See which departments and functions this freelancer has contributed to most.
Experienced in Information Technology, Customer Service, and Quality Assurance.
Summary
Senior DB2 UDB (LUW) Database Administrator with 15+ years of experience writing complex data retrieval queries and stored procedures, and administering large-scale, mission-critical DB2 environments. Strong hands-on background in Linux Shell scripting and Python for operational automation, with a consistent track record interpreting business requirement and producing functional and technical design documentation. Known for accuracy, quick turnaround on deliverables, and strong time management across multiple concurrent priorities.
- DB2 Migration & Upgrade Program: Led multiple DB2 migration and upgrade cycles across 35+ of clustered databases, ensuring minimal downtime and seamless transitions
- High Availability & Disaster Recovery Implementation: Designed and enforced data governance, retention, and integrity frameworks, ensuring compliance with enterprise security and audit standards
- Enterprise LDAP Architecture: Built and managed high-availability LDAP infrastructure supporting 30M+ users with enhanced scalability and uptime.
Skills
- Database Development: Db2 Udb (Luw) Complex Data Retrieval Queries, Stored Procedures, Sql Optimization, Dpf Environments
- Scripting Languages: Linux Shell Scripting (Bash), Python; General Object-Oriented Programming Concepts From Cs Background
- Job Scheduling & Automation: Cron (Rhel), Windows Task Scheduler — Automating Recurring Dba Scripts, Health Checks, And Maintenance Jobs.
- Analysis & Documentation: Interpreting Business Requirements, Producing Functional & Technical Design Documents, Detail-Oriented Quick Turnaround.
- Database Administration: Ha/Dr (Hadr, Tsamp), Backup/Recovery, Performance Tuning, Capacity Planning, Replication (Db2 Sql Replication, Qlik Replicate)
- Security & Access Control: Iam, Ldap, Sso, Access Control Policy Design, Auditing & Compliance.
Languages
Education
COMSATS University
Master of Science · Project Management · Islamabad, Pakistan
University of Karachi
Bachelor of Science · Computer Science · Karachi, Pakistan
Certifications & licenses
Certified Data Management Professional – Associate (CDMP)
Couchbase Certified Professional Administrator
IBM Certified Advanced DBA — DB2 10.1 for Linux, UNIX and Windows
IBM Certified Database Administrator — DB2 10.1 for Linux, UNIX and Windows
IBM Tivoli Access Manager for e-business V6.1.1 Implementation
IBM Tivoli Directory Server v6.3 Implementation
ISO 8000 Master Data Quality Manager
Microsoft Azure SQL Administration; Power BI Fundamentals
Statistics
Experience
Global experience
Expertise
Qualifications
Frequently asked questions
Have questions? Find more information here.
Awais is based in Saskatoon, Canada and can operate in on-site, hybrid, and remote work models.
Awais speaks the following languages: Urdu (Native), English (Advanced).
Awais has at least 16 years of experience. During this time, Awais has worked in at least 4 different roles and for 4 different companies. The average length of individual experience is 4 years and 11 months. Note that Awais may not have shared all experience and actually has more experience.
Based on recent experience, Awais would be well-suited for roles such as: AI Data Quality Specialist, Senior Consultant — Database & Infrastructure, Technical Consultant — Database & Security.
Awais's most recent position is AI Data Quality Specialist at Workada.
In recent years, Awais has worked for Workada and ELM Company.
Awais is most experienced in industries like Information Technology.
Awais is most experienced in business areas like Information Technology, Customer Service, and Quality Assurance.
Awais has recently worked in industries like Information Technology.
Awais has recently worked in business areas like Information Technology and Quality Assurance.
Awais holds a Master in Project Management from COMSATS University and a Bachelor in Computer Science from University of Karachi.
Awais has 8 certificates. Among them, these include: Certified Data Management Professional – Associate (CDMP), Couchbase Certified Professional Administrator, IBM Certified Advanced DBA — DB2 10.1 for Linux, and UNIX and Windows.
Awais is immediately available full-time for suitable projects.
Daily rate distribution
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.
The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.
Calculated based on our freelancers’ daily rates as of 29 Oct 2026. Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
Similar freelancers
Discover other experts with similar qualifications and experience
André G.
Alexander Z.
Antoine L.
Pierre G.
Carsten L.
Stefan M.
Dirk B.
Stefan C.
Jürgen K.
Arne H.
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a AI Data Quality Specialist
Hiroshi K.
Monica C.
Faizan A.
Lisa A.
Robin L.
Eric B.
Klaus F.
Izabela K.
Josphat G.
Whitney L.
Nearby freelancers
Professionals working in or nearby Saskatoon, Canada
Soroush S.
Ian D.
Deepak Y.
Adedoyin M.
Ralf S.
Cecilia P.
Samuel M.
Carla S.
Francisco M.
Monalisa A.
