• Recommend the best practices for the whole solution.• Design the solutions that match perfectly with an enterprise environment related to IBM ACH and FTM solutions.• Comply with every business and technical need. • Pick the technology stack and evaluate resources. • Inspect project limitations to analyze alternatives, run process re-engineering, and reduce risks as needed. • Act as an association between the sales and technical teams to convert the needs into results.• Analyze current technologies used within the company and determine ways to improve.• Document and monitor requirements needed to institute proposed updates.• Work closely with Information Technology professionals within the company to ensure hardware is available for projects and working properly.• Propose and establish framework for necessary contributions from various departments.• Account for possible project challenges on constraints including, risks, time, resources and scope.• Work closely with project management teams to successfully monitor progress of initiatives.• Provide detailed specifications for proposed solutions.• Define clear goals for all aspects of a project and manage their proper execution.• Lead the delivery of business-focused, technology-based solutions to meet a client’s business and technology strategy while maintaining high levels of billable time.• Ensure the conceptual integrity of IBM BPM solutions from a business / user perspective.• Cultivate highly functioning teams comprised of Perficient and client resources that recognize the value and expertise of of the IBM Business Process Management.• Produce high quality, key solution architecture deliverables such as business process / requirements documentation and conceptual solution architecture.• Mentor and provide solutions delivery expertise to less experienced team members.• Establish strong client relationships at all levels – executive, management and staff.

• Working with IBM community to turn ambiguous requirements into technical solutions ensuring a thorough understanding of sub-system/module–level requirements• Work autonomously from specifications and produce high quality, accurate, efficient and well documented Solution. Accurate estimating for their work given detailed requirements.• Maintenance and ‘bug fix’ development activities for existing applications. Construct and execute unit and system testing• Clear and early communication, in particular ensuring that line manager and/or relevant parties are kept informed of progress, issues and difficulties• Proactively work to mitigate risks, improve quality in an efficient manner and resolve problems that arise• Ensure adherence to best practice solutions across the team• Migration of DB2 databases from legacy servers / VM to new adopted IBM Cloud.• Data and Database synchronization using cutting edge IBM IIDR/CDC software.• Excellent knowledge on IBM BLU actionable compression• Organize end-user training and problem analysis for server, desktop, and IT infrastructure work.• Diagnose and repair IIAS sailfish appliance processing errors and implement solutions to improve efficiency.• Write and implement new server, middleware, and database standards.• Developed database performance matrix and use them to evaluate database performance and implemented advanced performance tuning strategies for databases based on the workload.• Analyse complex and long running SQL queries using Visual explain and other tools and optimize them using Design advisor and other tools.• Develop backup and recovery solutions for databases especially very large databases depending on their RTO and RPO.• Implemented usage of SAN Media Server with RAID level 5 for Very large database backups/restores.• Extensively used different Data movement utilities like IMPORT, EXPORT, and LOAD utilities to load data.• Bule Diamon PMR / Case handing.

• Design, Architecture and support of IIDR/CDC for mission critical applications using IBM MQ Server. • Skilled in CA/Replication - IIDR and end-to-end Latency along with Capture, apply, transport and point in time latency• extensive work on In-memory performance not limited to data that fits into RAM into IBM BLU• Excellent knowledge on IBM BLU actionable compression• Installation, administration and 24/7 production support for OLTP and Data warehousing databases.• Analyse and define clients business strategy and determine system architecture requirements to achieve business goals.• Formulate strategic plans for component development to sustain future project objectives.• Gather detailed business requirements and use cases and translate technical specifications into product requirements.• Create team strategies and establish project scopes of work; communicate project deliverable timeframes and benchmarks to clients.• Develop data architecture design to facilitate targeted customer analysis.• Suggest architectural improvements, design and integration solutions, and formulate methodologies to optimize object-oriented software and database development.• Organize end-user training and problem analysis for server, desktop, and IT infrastructure work.• Diagnose and repair IIAS sailfish appliance processing errors and implement solutions to improve efficiency.• Write and implement new server, middleware, and database standards.• Developed database performance matrix and use them to evaluate database performance and implemented advanced performance tuning strategies for databases based on the workload.• Analyse complex and long running SQL queries using Visual explain and other tools and optimize them using Design advisor and other tools.• Extensively worked with ETL teams in fixing data issues and handling monthly data purges.• Worked with ETL team in resolving the ETL cycle issues and performance tuning of long running queries.

• Design, Architecture and support of HADR for mission critical applications using DB2 HADR with TSA. This includes design of 2 node cluster with NFS tiebreaker and 3 node cluster with a 3rd node arbitrator.• Subject Matter Expert for DB2 HADR.• Installation, administration and 24/7 production support for OLTP and Data warehousing databases.• Design and implementation of star/snowflake schemas, Hash partitioning, Range partitioning, MDCs, MQTs as part of data warehouse implementation.• Installations, In-place and Side-by-Side Migrations of DB2 ESE and DPF databases.• Installation, Migration and administration of DB2 WebSphere Federation Server (Information Integrator) which is used to access data sources Oracle, MS SQL Server, Sybase etc. and DB2 Connect gateways used to access DB2 ZOS Subsystems.• Developed database performance matrix and use them to evaluate database performance and implemented advanced performance tuning strategies for databases based on the workload.• Analyze complex and long running SQL queries using Visual explain and other tools and optimize them using Design advisor and other tools.• Extensively worked with ETL teams in fixing data issues and handling monthly data purges.• Worked with ETL team in resolving the ETL cycle issues and performance tuning of long running queries.

• Developed & maintained naming standards for database objects such as tablespaces, tables, indexes & views.• Participated in database migration reviews and playing leadership role.• Assisted in product installation & reviewing initial installation options.• Provided functional guidance to the systems programmers & the operators.• Evaluated & tested DBMS related software.• Developed operational procedures for ETL processes along with BI & reporting.• Supported, monitored & tuned the database subsystems & instances in standalone and HA environment.• Participated in selecting database management support tools like Optim, Toad and RazorSQL.• Developed & implemented database administration policies & procedures including subsystem or instance security guidelines.• Provided assistance in the development of the conceptual & logical database design • Defined & created the database objects and user objects (i.e., tables, views, indexes, etc.)• Assisted application developers in functional prototyping.• Carried out application performance tuning and testing.• Developed all necessary/ required database utilities.• Recommended/ developed backup/recovery procedures for application tables/indexes.• Supported application programmers in the testing of database applications.• Provided technical assistance to other team members.• Provided input to the CMS & Citrix/Project capacity planning function.• Provided ongoing database support/review in the CMS & Citrix production environment.• Developed stored procedures, scripting, SQL, and optimizing SQL and rigorous performance tuning.

Taking care of the RDBMS running on IBM DB2 11.1, 10.5,10.1, 9.7, 9.5 and Oracle 12C, 11g/ 10g and performing following duties along with team management. • Established compatibility with third party software products by developing program for modification and integration.• Developed and implemented complex Internet and Intranet applications on multiple platforms.• Coordinated with systems partners to finalize designs and confirm requirements.• Provided continued maintenance and development of bug fixes and patch sets for existing web applications.• Diagnosed and troubleshooted UNIX and Windows processing problems and applied solutions to increase company efficiency.• Ensured network, system and data availability and integrity through preventative maintenance and upgrades.• Provided documentation on start-up, shut down and first level troubleshooting of processes to help desk staff.• Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access.• Streamlined and enhanced the corporate accounting and operations system.• Managed creative projects from concept to completion while managing outside vendors.• Developed work-flow charts and diagrams to ensure production team compliance with client deadlines.• Independently designed and executed company catalog for infrastructure support and development.• Aligned office departments and increased inter-department communication and data sharing.• Supervised and provided direction for six technical direct reports regarding network activities.• Provided methodologies for object-oriented software development and efficient database design.• Recommended architectural improvements, design solutions and integration solutions.• Developed data architecture design to enable analysts to perform targeted customer analysis.

Responsibilities as DB2 DBA.• Performed analysis of legacy data, data models, and advised project manager on the best way to migrate and manipulate client data on QA, Dev, UAT and Production environments or data warehouse repositories.• Participated in establishing processes, best practices, and database management solutions including development standards, backup/recovery, quality control, DR/failover, monitoring, maintenance, etc. for IBM DB2 LUW. • Provides leadership during system unavailability and triages high severity situations. • Performed Database and server migration from DB2 9.7 to latest versions of DB2 10.5 along with latest Fixpacks.• Implemented High Availability and Disaster Recovery techniques by implementing HADR in multiple standby with multiple databases.• Proficiently used DB2 utilities like DB2LOOK, DB2MOVE, DB2PD, DB2DART along with LOAD, UNLOAD, CHECK, COPY, and RECOVER etc.• Performed Storage capacity planning, created new databases and configured parameter tuning.• Provided technical support to round Corner partners engaged in data migration.Responsibilities as Oracle DBA.• RAC and standalone Installation and implementation of the Oracle 11gr2 & 12c on AIX, Sun Solaris & Linux.• Installation and implementation of the Oracle grid infrastructure 12c.• Proficiently used TOAD, sql developer and putty for access and monitoring purposes.• Managed the databases for over 100TB size.• Implemented the automated Hot Backup scripts for the Daily full backup created in Korn Shell. • Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals. • Upgradation from Oracle 10g to Oracle 11g.• •Expert with OEM Event and Job Managers, Change Manager, Diagnostics & Tuning Packs.• Performed Backup & recovery test including offline backup process and database log purging.

Project: Global Foundries Malta, NY Database Administration Support:Environment: IBM DB2 10.5, 10.1, 9.7, Oracle 10g,11gR2, RAC, ASM, Oracle 10g-11gR2 Data Guard, Oracle OEM Grid Control , IBM AIX 5.3-6.1, 7.1, Solaris 10, Red Hat Linux 5, Windows 2003-2008R2• DB2 Servers Installation, Configuration and Administration.• Monitors DB2 production servers for potential problems. • Applies upgrades along with Business System Services to DB2 in test and production. • Migrating from test to production, and implementing batch schedules with the appropriate DB2 utilities. • Performs all structural changes to DB2 databases. • Works with Security Administration to insure that proper security is in place for DB2 data. • Develops and documents overall vision for DB2 in our environment. • Analyze and correct problems that occur in the DB2 environment. This includes support for the batch environment. • Administer the data server on which DB2 resides: monitor disk space and the DB2 log, backups, protect the integrity of the data. • Installation, configuration, administration and tuning of Oracle 10g and 11gR2 Single Instance and RAC databases.• Database Upgrade/migration from 10gR2 to 11gR2.• OEM Grid control installation, configuration and administration.• Proactive and Reactive Database Health checks and server reviews for client database and suggesting changes.• Oracle 10g-11g Dataguard setup and administration.• RMAN Backups setup and recommending performance improvement during hot backups.• Proactive Monitoring, identifying areas that need to be improved in the application and database using Statspack, AWR, ADDM, and 10g OEM Grid Monitoring.• Data warehousing and ETL.• Performed backups and tested crash recoveries using conventional cold, hot & RMAN backups.• Performance tuning using ExplainPlan, STATSPACK, SQL_TRACE, TKPROF, ADDM.

Environment:DB2 10.1, 9.7,10.5 Oracle 10gR2, 11gR2, IBM Assencial DataStage 7.5, IBM AIX 5.3, IBM P590/595 Servers, data studio, OPM, OEMClient: Ufone (PTML)Pak Telecom Mobile Limited (PTML) is a wholly owned subsidiary of Pakistan Telecommunication Company Limited (PTCL) that started its operations in January 2001 under the brand name Ufone.My DB2 DBA Responsibilities Include: - I have over-all responsibility of all DB2 products in production and test environments. These include the DB2 software itself, the TMON monitoring tool, and the Platinum tools we have purchased (Plan Analyzer, and Database Analyzer). - Monitors DB2 production servers for potential problems. - Applies upgrades along with Business System Services to DB2 in test and production. - Along with Business Systems Services, installs and maintains software used for supporting and monitoring DB2. - Assists all development work on DB2. This includes helping with application development, designing and creating database objects, - migrating from test to production, and implementing batch schedules with the appropriate DB2 utilities. - Performs all structural changes to DB2 databases. - Works with Security Administration to insure that proper security is in place for DB2 data. - Develops and documents overall vision for DB2 in our environment. - Provides information to developers and operators on all components of DB2 that are of interest through the Web, Infoshares, or other mediums. - Analyze and correct problems that occur in the DB2 environment. This includes support for the batch environment. - Administer the data server on which DB2 resides: monitor disk space and the DB2 log, backups, protect the integrity of the data. - Serve as an overall DB2 resource and keep abreast of new developments in the DB2 world through journals, newsgroups, the Web, the DB2 user Group.

Client: CMPak PakistanChina Mobile Pakistan (CMPak) is a 100% subsidiary of China Mobile. The pioneering overseas set up of China Mobile came through acquisition of a license from Millicom to operate a GSM network in Pakistan. My Oracle DBA Responsibilities Include: - Installation, configuration and upgrading of Oracle server software and related products - Evaluate Oracle features and Oracle related products - Establish and maintain sound backup and recovery policies and procedures - Take care of the Database design and implementation - Implement and maintain database security (create and maintain users and roles, assign privileges) - Perform database tuning and performance monitoring - Perform application tuning and performance monitoring - Setup and maintain documentation and standards - Plan growth and changes (capacity planning) - Work as part of a team and provide 7x24 support when required - Perform general technical trouble shooting and give consultation to development teams - Interface with Oracle Corporation for technical support. - Patch Management and Version Control- Interact with the users and consultants for identifying any Gaps in implementation and provide support in filling the gaps-Creates and maintains all databases required for development, testing, education and production usage. -Performs the capacity planning required to create and maintain the databases.- Performs ongoing tuning of the database instances.- Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database. - Plans and implements backup and recovery of the Oracle database.- Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle.

Project: Avis & Budget Car Rental Group USA.Environments: IBM DB2 9.5, Oracle 9i, 10g, Linux 5.3, AIX 5.1, Tivoli Maestro Scheduler, Putty, Toad, and Brio QueryResponsibilities as DB2 / Oracle DBA.• Installation, Administration & maintenance of the IBM DB2 9.5.• Installation, Administration & maintenance of the Oracle 10g & 9i.• Deploying Logical backup scripts using exp and datapump utilities on both windows and Unix environments• Writing Unix Shell scripts for different database monitoring tasks.• Providing 24/7 support to client databases. Coordinating and executing maintenance tasks on weekends and on-demand.• Creating PMR / SR with IBM and Oracle Support on any issue as and when needed.• Setup and maintain documentation as standards for future usage.• IBM DB2 performance and Monitoring using tools Toad, Data Studio.• Proactive Monitoring, identifying areas that need to be improved in the application and database using Statspack, AWR, ADDM, OEM Monitoring.• Daily monitoring of tablespaces and adjusting space by adding datafiles.• Daily monitoring of alert log files and checking and correction of errors found.• Monitoring of any privileges given to users which violated the security of the database.• Creation of new partitions and runstats & analyzing the tables.• Creation and maintenance of new tablespaces and assigning quota on those tablespaces to users.• Applying any required patches and fixing database issues.• Deployment of the complete batch on RAC servers and manual execution of jobs for testing.• Participated in database stress test session along with DBA group.