Mohammad Shahzad
Senior Dba Specialise in Db2 Luw, Redis, Postgresql, Mysql, Sql Server, Mongodb and Nuodb @Santander
Signup · Get unlimited contacts
WORK HISTORY
Senior Dba Specialise in Db2 Luw, Redis, Postgresql, Mysql, Sql Server, Mongodb and Nuodb @Santander
Day to day duties include the Project work, Manage changes from development through Test and into Pre-production and then to Production and supporting On-calls. My Role is also involved to support the long term large projects as well as building and configuring the environments, problem determination, managing production incidents and troubleshooting by using the relevant processes and liaising with customers and 3rd parties. Main Areas of expertise are given below: • DB2 V8.2 /9.5 /9.7 /V10.5 Administration (Database backups, restores and recovery procedures) • Setting up database Authorizations and Privileges for groups and Users for different levels of access • HADR Solution (High Availability Disaster Recovery) • TSA (Tivoli System Automation) configuration and troubleshooting • HACMP configuration and troubleshooting • Data warehousing techniques • Data Replication • Data Federation • Archiving of historical data from live database • Live databases monitoring on day to day basis • Architecture, planning and Designing of new databases. • SQL tuning and Quality Assurance. • Knowledge of database access plans (Standard & DPF), identifying improvements areas in SQL\'s, and query rewrites for performance • Database extraction for Management Information System • Shell scripts for various jobs system alerts, house keeping etc • Good understanding of AIX and Linux operating systems • Managing data across multiple environments (development, test, production) • Database migrations cross platforms, Fix packs deployments and Database version migrations from V 6 - V 8.2, V 9.7, V10.5 • Setting up database auditing to meet the industry standards and compliance. • Expert in using various database utilities in order to determine the problems and fixing issues like db2pd, db2dart, db2top, db2relocate, db2mtrk, db2look.
EDUCATION
University of Strathclyde
BSC Business and Software Development, Computer Science
ABOUT MOHAMMAD SHAHZAD
15+ years experience with DB2 database administration, supporting 24X7 high availability…
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.