Muhammad Sultan

Master Consultant Oracle & DB* Database Administrator

Email: acwrbr@r.postjobfree.com Cell: 518-***-****

PROFESSIONAL SUMMARY:

Have over 10 years of focused experience in IT industry in various fields like banking, insurance, financial, retail and manufacturing. Extensive experience in relational database design, analysis, modeling, development, administration, implementation, trouble shooting and quality management. Comprehensive experience as an DB2 & Oracle DBA, proficient in IBM DB2 10.5,10.1, 9.7, 9.5 and Oracle 11g/ 10g/ 9i along with Training on Big Data Hadoop Technologies and Apps DBA Oracle FlexCube 12 Administration.

Professional experience in DB2 Installation, administration, performance tuning, backup & recovery with proven ability at Server side & Client side responsibilities.

DB2 10.5, 10.1, 9.7, 9.5 database administrator functions including, database object creation and alters implementation, reorgs, statistics collection and analysis.

DB2 Recoveries, performance tuning, schedule and manage maintenance of production application databases, disaster recovery testing.

Job scheduling utilities, and database management tools and utilities.

Experience monitoring DB2 Databases sizes ranges from 500MB – 50TB.

Problem determination and resolution for supported application databases and maintenance utilities.

Perform change management activities using standard change processes in support of application database related changes.

Use and learn standard DB2 utilities and DBMS related products to perform DBA tasks.

Professional experience in Oracle Installation, administration, performance tuning, backup & recovery with proven ability at Server side & Client side responsibilities.

Expertise in Oracle RAC, Replication, Standby databases, and database designing.

Expertise in handling 24X7 mission critical production databases, versions 11g/10g/9i primarily in AIX / UNIX based environments.

Successfully upgraded databases from 9i to 10g & 11g.

Expertise of Crontab to automate and schedule the various routine maintenance tasks.

Administration of GoldenGate (10.x/11.x/12.x) replication solutions to facilitate data flow between heterogeneous (SQL Server / DB2 and Oracle) environments.

Experience in Data warehousing and ETL.

Experience in Database Security and Auditing.

Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, and Data Migrations using export/import, benchmarking using load testing tools.

Training and Conceptual knowledge on Big Data Apache Hadoop Technologies.

Big Data basics knowledge and overview to key Apache Hadoop concepts and definitions.

Installation, Customization, Administration & maintenances of the Oracle FlexCube 12.0.15.

Creation and managing Oracle FlexCube Application Profiles, users, roles and accounts.

And the last but not the least TSM 5.5 Storage Library Administration.

MAJOR AWARDS &ACHIEVEMENTS:

IBM Certified Database Administrator - DB2 9.5 for Linux, UNIX and Windows:

IBM Certified Advanced Database Administrator - DB2 9.7 for Linux, UNIX and Windows:

Oracle RAC 11gR2 and Grid Infrastructure Certified Administrator:

Oracle 11g Database Administrator Certified Professional (OCP):

Oracle 9i Database Administrator Certified Professional (OCP):

Apache Hadoop Big Data Training from IBM.

Appreciation from Project Managers: Getting the title as “Solution Expert” and winning the Best Employee of the year award 05 times in IBM.

Worked as Team Lead in projects : ZONG Data warehouse and BI Project

IBM Unica Interact Training IBM Turkey: Held in IBM Istanbul Turkey from 04th March 2013 to 08th March 2013.

KEY STRENGHTS:

More than 100 full cycle implementation experience (DB2 10.5, 10.1 9.7 & 9.5)

Failover and High availability solutions (DB2 9.7/9.5/10.1/10.5)

Shell-Scripting (bash/ksh), batch scripting. Training of Users and Juniors, UAT, User Support, System Testing

Database Design skills, Knowledge of database normalization theory, STAR schema design, and data modelling techniques.

More than 100 full cycle implementation experience (Oracle 11g & Oracle 10g)

RAC Administration and Maintenance Tasks and Utilities

Hand Full Experience on the Recovery Manager (RMAN), ASM.

Expertise in TSM 5.5 Administrations, Data Backup and Retrieval, Tapes Library Management & Administration.

Physical Disk Storage skills, Disk hardware architecture and disk load balancing.

Change Control Management skills, Implementing change control and insuring that changes to the production database are properly coordinated.

Skill Set:

Functional

Operating Systems

Tools

DB2 10.5, 10.1, 9.7, 9.5 Administration

Oracle 11g, 10g, 9i Administration

Oracle 11g Exadata Administration

Apache Hadoop Big Data Training

TSM 5.5 Library Administration

AIX, Linux, Unix

Windows 10/8/7/XP/2008

Ascential Datastage 7.5

Toad (10.1/ 9.7/ 8)

Putty, Ultra Edit

MS Office 2013/2010/ 2007/ 2003

PL/Sql Developer

PROFESSIONAL EXPERIENCE:

Master Consultant DB2 & ORACLE: Oct 2015 –Present

Employer: Forsythe Technology:

Project Client: Western Union.

Western Union connects people and businesses around the globe by providing fast, reliable and convenient ways to move money.Our 160-year history and more than 500,000 Western Union Agent locations in more than 200 countries and territories strengthen our commitment to offering our services in every corner of the globe.

Project and Position held: DB2 & Oracle Data Center Migration:

Environment: 11gR2, RAC, ASM, 11gR2 Data Guard, Oracle OEM Grid Control 11gR2-12c, IBM AIX 5.3, 6.1,7.1, Red Hat Linux 5 & 6, Windows 2003-2008R2,IBM DB2 9.7, 10.1, 10.5

Responsibilities: Working as Master Consultant Oracle & DB2 DBA and providing consulting services to a wide variety of environments and database sizes, requirements, configurations and corporate cultures. The routine tasks include dealing with:

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.

Optimized the organization’s current data and database assets and recommended future initiatives. Optimized current strategies to enhance operational stability and availability of the database using operational best practices.

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.

Performed DB2 queries optimization and sql evaluation for optimal performance.

Used Reorg, Runstats, Export, Import and load utilities to facilitate Migration project.

Proficiently used DB2 utilities like DB2LOOK, DB2MOVE, DB2PD, DB2DART along with LOAD, UNLOAD, CHECK, COPY, and RECOVER etc.

Architecture and Analysis of Enterprise Content Management ECM Program using the ECM stack of solutions includes FileNet, Documentum, Lombardi, Kofax, Captiva, and WebSphere. Optimizes organizational goals through enterprise standards.

Design and develop system to extract existing TIFF images, COLD documents and associated metadata from the IBM Content Management System to IBM FileNet.

Architecture, design and develop system using templates for workflows using the IBM FileNet Content Management System for workflow and process capabilities.

Proficiently used third party monitoring tools like TOAD for DB2, IBM InfoSphere Optim Performance Manager to monitor and identify emergent problems, Diagnose the root cause of problems and isolate problematic components across applications, networks and databases.

Analysed new application requirements and associated database changes, Converted a new database logical design to physical design

Performed Storage capacity planning, created new databases and configured parameter tuning.

Created database standards and naming conventions, physical design of DDL changes and Implemented DDL changes.

Performance diagnosis setting up of performance monitoring troubleshooting database errors and automated repetitive and mundane tasks.

Managed database scheduled jobs, reacted to database user complains and Performed database security review.

Provided technical support to round Corner partners engaged in data migration.

Managed data migration program. Formulated existing processes and scripts. Enforced migration of data. Assisted Technical and Field Services group. Evaluated database structures and data movement.

Proficiently used Server and network tools like vmstat, netstat, iostat, nmon, smitty and topas etc.

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.

Knowledge in replication using Golden Gate, materialized views.

Maintained standby databases, in both local and remote locations, for fail-over purposes.

Implemented and maintaining database security (create and maintain users, roles and assign privileges)

Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.

Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.

Expert with OEM Event and Job Managers, Change Manager, Diagnostics & Tuning Packs.

Working knowledge of Oracle golden gate and Oracle streams.

Performed Backup & recovery test including offline backup process and database log purging.

DBA Team Lead Oracle & DB2: Jun 2015 –Sep 2015

Employer: HCL Americas Inc:

Project Location: Oncor Electric Delivery Company LLC. Dallas TX

Oncor is a regulated electricity distribution and transmission business providing reliable electricity delivery to consumers. Oncor operates the largest distribution and transmission system in Texas, delivering power to more than 3 million homes and businesses and operating more than 117,000 miles of transmission and distribution lines in Texas.

Project & Position held: DBA Team Lead Oracle & DB2:

Environment: 11gR2, RAC, ASM, 11gR2 Data Guard, Oracle OEM Grid Control 11gR2-12c, IBM AIX 5.3, 6.1,7.1, Red Hat Linux 5 & 6, Windows 2003-2008R2,IBM DB2 9.7, 10.1

Responsibilities: Working as DBA Team Lead Oracle & DB2 DBA and providing consulting services to a wide variety of environments and database sizes, requirements, configurations and corporate cultures. The routine tasks include dealing with:

Responsibilities as DB2 DBA.

Installation and configuration of the new DB2 9.7, 10.1 and 10.5 databases.

Created primary database storage structures (table spaces) once developers have designed an application.

Modified the database structure, as necessary, from information given by application developers.

Manage Backup, Security, and Controls of databases. Enrolled users and maintaining system security.

Controlled and monitoring user access to the database.

Monitored and optimized the performance of the database.

Responsible for support of DB2 databases as per company procedures and policy.

Engaged with application vendor support till problem resolution

Filled and close all assigned TTs correctly and keep DB documentation Files updated.

Restored DB and application server whenever required

Deployed Enterprise Content Management ECM Solution s ...Deployed ECM at County, State, Federal and Private Sector Project...Consensus Building in Complex Organization...Responsive to competing stakeholder requirements...Managed highly skilled teams executing strategy and maximizing efficiencies...Build consensus and establish direction at high levels of management...Coordinate multiple initiatives...Developing Cost Models for payback and ROI's...Design and management of ECM Enterprise Architecture...Design and management of ECM Enterprise Architecture.

Managed Storage & IO performance issues related to databases

Designing of logical and physical structure of database (storage parameters).

Ensured that work is in compliance with IBM DB2 License agreements.

Database tuning and manage Production & Development Environment

Responsible to plan, document and implement new data base management system software and release upgrades after approval from company.

Monitor the effectiveness and efficiency of data base systems operation and recommend and lead implementation of performance improvements for data base systems and user applications

Responsibilities as Oracle DBA.

As a Lead Database Administrator, I was Responsible for administration of over 100+ Oracle databases.

Lead the Team of 15 DBAs.

Designed and implemented Data Center migration for over 13 TB EDW databases.

We have converted Single Node Non-ASM Database to 2 Node RAC ASM Database. We achieved this using Data Guard.

Advanced Backup and Recovery using Oracle’s RMAN software; used offline/online for recovery in a production environment via Korn shell scripting.

Mentored other DBAs in effective use of RMAN software, and my scripts.

Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.

Supporting Data Warehouse Database i.e. over 100 TB in size.

Installation of Oracle & create clustered databases using AIX HACMP technology and Veritas Cluster on Solaris 9.

Enforced need of regular data purging processes from production, design and development, to deployment.

Implemented and maintained Oracle 10g Data Guard/standby databases for fail-over purposes.

Experience with ‘graceful’ switchover and switchback between primary and standby databases.

Replicated to a disaster recovery site for increased server manageability and availability.

Participated in development of enterprise-wide security standard methodology, and ongoing deployment.

Installation of RAC and Managing RAC Environment efficiently and DBA support to Development Team.

Analyzed routine user problems, found root causes and defined the new/change requirements.

Coordinated User Acceptance Tests on UAT set before deployment on PROD environment.

Tech Lead Oracle & DB2 Database Administrator: Jun 2014 –June 2015

Employer: Tech Mahindra (Americas):

Project Location: Global Foundries, Malta NY

Tech Mahindra Limited is an Indian multinational provider of information technology (IT), networking technology solutions and business support services (BPO) to the telecommunications industry.[4] Tech Mahindra is a part of the Mahindra Group conglomerate.

Project and Position held: Technical Lead Oracle & DB2:

Environment: Oracle 10g,11gR2, RAC, ASM, Oracle 10g-11gR2 Data Guard, Oracle OEM Grid Control 11gR2-12c, IBM AIX 5.3, 6.1,7.1, Red Hat Linux 5, Windows 2003-2008R2,IBM DB2 9.7

Responsibilities: Working as Tech Lead Oracle & DB2 DBA and providing consulting services to a wide variety of environments and database sizes, requirements, configurations and corporate cultures. The routine tasks include dealing with:

As DB2 DBA Responsibilities:

Has over-all responsibility for all DB2 products in production and test environments. These include the DB2 software itself, monitoring tools.

Monitoring DB2 24x7 production servers for potential problems.

Applying 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.

Architecture, design and develop system using templates for workflows using the IBM FileNet Content Management System for workflow and process capabilities.

Assisting 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.

DB2 UDB for iSeries basics knowledge and overview to key iSeries UDB concepts and definitions, such as iSeries Navigator Database and SQL.

Developed and documented overall vision for DB2 in our environment.

Provided information to developers and operators on all components of DB2 that are of interest through the Web, Infoshares etc.

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, and the DB2 Users Group.

Responsibilities as Oracle DBA.

Architecting, planning, designing, developing, deploying and supporting RAC/ASM environment

Installing & configuring Oracle clusterware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole – bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of clusterware)

Testing and benchmarked the application prior to going into production to determine its effects on GES and GCS with special focus on load testing for interconnect traffic.

Upgrade of 10g R2 RAC to 11g R2 RAC

Migrated Non-ASM Single Instance to ASM RAC Instance.

Used BCV split/Data Guard technology to migrate over 13 TB Database.

Supporting Data Warehouse Database i.e. over 30 TB in size.

Experience in Oracle 9i/8i/8.x/7x – Installation, Migration and implemented new features.

Experience in capacity planning, space management, database upgrades/migration

Experience in working with RAID environment.

Experience in clustered databases using AIX HACMP technology and Veritas Cluster on Solaris 8.

Expert in ORACLE Database Administration including planning/implementing backup/recovery strategies using RMAN and without RMAN.

Senior Database Administrator: Jan 2013 – May 2014

Employer: Optimum IT Solutions Inc. Jericho NY

Optimum IT Solutions is an Oracle Gold partners that provides Database Management, remote DBA and Consulting services. I am working with a team of experts and provide Oracle database architecture, implementation and production support services to our clients in financial, retail, pharmaceutical, industrial, services and other sectors.

Project: Key Food Database Administration Support:

Environment: Oracle 9i,10g,11gR2, RAC, ASM, Oracle 10g-11gR2 Data Guard, Oracle OEM Grid Control 10g-11gR1, IBM AIX 5.3-6.1, Red Hat Linux 5, Windows 2003-2008R2,IBM DB2

Responsibilities: Working as Senior Oracle DBA and providing consulting services to a wide variety of clients having diverse environments and database sizes, requirements, configurations and corporate cultures. The routine tasks include dealing with:

As DB2 DBA Responsibilities:

Has over-all responsibility for all DB2 products in production and test environments. These include the DB2 software itself, monitoring tools.

Monitoring DB2 production servers for potential problems.

Applying 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.

Assisting 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.

Reviewing all data models for technical accuracy. This includes the enforcement of all modelling and naming standards.

Performed all structural changes to DB2 databases.

Worked with Security Administration to insure that proper security is in place for DB2 data.

Provided information to developers and operators on all components of DB2 that are of interest through the Web, Infoshares etc.

Analyze and correct problems that occur in the DB2 environment. This includes nightly 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.

Provided assistance for interfaces which access DB2. Provided assistance for interfaces which access DB2.

Serve as an overall DB2 resource and keep abreast of new developments in the DB2 world through journals, newsgroups, the Web, and the DB2 Users Group.

Responsibilities as Oracle DBA.

Installation, configuration, administration and tuning of Oracle 9i to 11gR2 Single Instance and RAC databases.

Database Upgrade/migration from 9i to 10gR2 and 11gR2.

OEM Grid control installation, configuration and administration.

Proactive and Reactive Database Health checks and server reviews for client database and suggesting changes.

Write and maintain generalized scripts to create databases, to get definition of the existing databases, to monitor and maintain databases and their alert logfiles and listener log files, startup scripts, shutdown scripts, RMAN backup and restore scripts and export & import scripts.

Oracle 10g-11g Dataguard setup and administration.

RMAN Backups setup and recommending performance improvement during hot backups.

Data warehousing and ETL.

Creating DBLINKS.

Performed backups and tested crash recoveries using conventional cold, hot & RMAN backups.

Performance tuning using ExplainPlan, STATSPACK, SQL_TRACE, TKPROF, ADDM.

Basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, Data Migrations using export/import, benchmarking using load testing tools.

IBM Global Business Services Islamabad Pakistan

Senior Oracle Database Administrator: Mar 2009 - Jan 2013

IBM Global Services is one of the world's largest IT consulting services organizations. IBM Global Services has large technology expertise in its own proprietary technologies and other major vendors like Oracle and Microsoft.

Project: CMPak Data Warehouse Administration Support:

Environment: Oracle 10gR2, IBM Assencial DataStage 7.5, IBM AIX 5.3, IBM P590/595 Servers

Responsibilities: I was providing 24/7 support for data warehouse database (100TB) and providing assistance in Daily batch operations while performing Following activities:

As a Lead Database Administrator, I am Responsible for administration of over 300 Oracle databases.

Leading the Team of 15 DBAs.

Upgraded 10.2.0.4 Two Node RAC ASM Database to 11g R2 Two Node RAC ASM

Advanced Backup and Recovery using Oracle’s RMAN software; used offline/online for recovery in a production environment via Korn shell scripting.

Mentor other DBAs in effective use of RMAN software, and my scripts.

Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.

Data center Migration using Data Guard.

Oracle Goldengate replication Administration.

Knowledge on install and configuration of Goldengate

Providing daily routine database administration services.

Performance tuning of Production and development databases.

Backup and recovery implementation using RMAN (Level 0/1 Offline and Online Incremental backups).

Logical backups implementation using datapump for critical tables.

Providing support to data warehouse ETL team and development of Unix shell scripts for batch operations.

Applying Latest Patchset on Database Servers.

Automatic Archival of old table partitions for database space reuse.

Operating system performance monitoring and liaison with IBM support for OS related issues.

AIX administration including Os users creation, volume groups creation and management, LPAR’s physical resources management (memory, cpus) using HMC console.

System snapshots collection for problem troubleshooting, Resizing mount mounts etc.

Project: Ufone EAI Middleware DB2 9.5 Upgrade to DB2 10.5:

Environment: IBM DB2 10.5,10.1, 9.7, 9.5, IBM AIX 6.1, 7,1, IBM P780/P795 Servers, IBM WAS 8.5

Responsibilities: Working as IBM DB2 DBA and providing consulting services to a wide variety of clients having diverse environments and database sizes, requirements, configurations and corporate cultures. The routine tasks include dealing with:

Fixation of all issue aroused during the upgrade process.

Backup of the databases before and after the Upgrade.

Preparation of the complete DB2 upgrade plan for Aix 7.1.

RDBMS parameters setting as required running DB2 smoothly.

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.

Reviews all data models for technical accuracy. This includes the enforcement of all modelling and naming standards. Performs all structural changes to DB2 databases.

Upgrade documentation and other deliverables to client and training.

Ensure integrity, availability and performance of DB2 database systems by providing technical support and maintenance.

Monitor database performance and recommend improvements for operational efficiency.

Assist in capacity planning, space management and data maintenance activities for database system.

Perform database enhancement and modification as per the requirements.

Perform database recovery and backup tasks on daily and weekly basis.

Identify and recommend database techniques to support business needs.

Assist in implementation of new features and program fixes in databases.

Maintain database security and disaster recovery procedures.

Perform troubleshooting and maintenance of multiple databases.

Monitor databases regularly to check for any errors such as existing locks and failed updates.

Oversee utilization of data and log files.

Manage database logins and permissions for users.

Experience developing stored procedures, scripting, SQL, and optimizing SQL

Project: MCB - Oracle FlexCube 12.0 Implementation:

Environment: Oracle 11gR2, Oracle FlexCube 12.0, IBM WebSphere Application Server 8.5, IBM HTTP Server 8.5, AIX 7.1.

Responsibilities: Working as Oracle Apps & Core DBA the routine tasks include dealing with:

Installation, Administration & maintenances of the Oracle 11gR2.

Installation, Customization, Administration & maintenances of the Oracle FlexCube 12.0.15.

Creation and managing Oracle FlexCube Application Profiles and users.

Creation and managing Oracle FlexCube Application roles and accounts. Hardware sizing.

Setup of Production Test and DR environments.

Understanding the bank’s Business processes / operations, prior to walking the bank through Oracle.

LEXCUBE system functionality and understanding the customization required to Oracle FLEXCUBE functionality.

Identifying Project roles and responsibilities and agreeing on a communication plan.

Periodic reporting to assess progress and report potential risks affecting the project.

Mentoring of operational know-how to the bank to maximize the benefits of the solution (Oracle FLEXCUBE and Integration Platform).

Installation, Customization, Administration & maintenances of the WebSphere Application Server (WAS 8.5) Installation, Customization, Administration & maintenances of the IBM HTTP Server 8.5 on AIX 7.1.

Project: Ufone Unica Interact Implementation:

Environment: Oracle Exadata X2-2, IBM WAS 7.0, IBM Marketing Platform 8.5, IBM Unica Campaign 8.5, IBM Unica Interact 8.5, IBM HTTP Server 7, AIX 6.1.

Responsibilities: Working as Oracle DBA the routine tasks include dealing with:

Configuring Interact optional offer serving features.

Monitoring and maintaining runtime environment performance.

Installation, Administration and maintenances of the Oracle 11g.

Maintaining users and roles.

Maintaining data sources.

Partitioning of the Large tables and Indexes.

Database Backup and Housekeeping mythologies.

Project: Ufone EAI Middleware DB2 9.5 Database Administrator:

Environments: DB2 10.5,10.1, 9.7, 9.5, IBM AIX 5.3, 6.1, 7,1, IBM P780/P795 Servers, IBM WAS 7.0, 8.5

Responsibilities: Working as DB2 DBA and providing consulting services to a wide variety of clients having diverse environments and database sizes, requirements, configurations and corporate cultures. The routine tasks include dealing with:

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.

Reviews all data models for technical accuracy. This includes the enforcement of all modelling and naming standards.

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.

Maintain database security and disaster recovery procedures.

Resolve any database issues in accurate and timely fashion.

Monitor databases regularly to check

Contact this candidate