SUMMARY

• Around 9 years of experience in the field of Information Technology including Database Administration, all phases of the project Life cycle- Requirement gathering and Analysis, Database design, Database development, and Application development, Test, Implementation Support.
• Solid understanding of Oracle/DB2 database architecture and design.
• Responsible for managing DB2 V8.2, V9 on UNIX,AIX, WINDOWS platform.
• Supported production and development and testing databases.
• Performed Installation of Oracle/DB2 and configuration.
• Sound Implementation, configuration and maintenance of off-site Disaster Recovery planning using HADR and HACMP.
• Monitor databases for performance and tune accordingly.
• Worked with Raw devices and adding space to tablespaces with Raw devices
• Instance Upgrades to latest Fixpack levels for db2.
• Installing db2 clients on windows servers.
• Troubleshoot production issues as they occur.
• Experience with midrange tools: CRON, vmstat, topas, db2top etc
• Design/Implement backup and recovery solutions.
• DB2 High Performance Unload utility knowledge.
• Implementation of Backup and Recovery Strategies.
• Worked with Raw devices and adding space to tablespaces with Raw devices
• Instance Upgrades to latest Fixpack levels for db2.
• Installing db2 clients on windows servers.
• Experience with midrange tools: CRON, vmstat, topas, db2top etc
• Design/Implement backup and recovery solutions.
• DB2 High Performance Unload utility knowledge.
• Moved tables using ONLINE TABLE MOVE Procedure available in DB2 9.7.
• Monitoring and management of database server, memory, and space resources.
• Implemented Compression and saved space.
• Installed DB2 UDB and applied fixpak's to keep DB2 UDB at the most recent level
• Good understanding of DB2 Federated Database Technology.
• Expertise in production support activities including installation, configuration, deployment and support of critical applications.
• Planning, installation and configuration of DB2 database and related software, patch fixes and upgrades
• Schema and Security Management
• Performance tuning at server and application levels.
• On-call production support at least 2 weeks per month.
• Extensive Experience as DB2 UDB DBA in AIX, Solaris and Windows NT environment.
• Proficient in running utilities like COPY, LOAD, IMPORT, EXPORT, REORG, RUNSTATS, REBIND, REORGCHK and Setting constraints.
• Moved tables using ONLINE TABLE MOVE Procedure available in DB2 9.7.
• Monitoring and management of database server, memory, and space resources.
• Excellent business analysis skills and communications skills.
• Project experience includes Project Management, customer and user interactions.
• Ability to handle multiple tasks and work independently as well as in a team.
• Able to communicate effectively with multifunctional teams, programmers, and technical staff at all levels, and have strong written and verbal communication skills.

Technical Skills

RDBMS : DB2 V8.1, V8.2, V9, V9.5, V9.7, V10, Oracle 9i, Informix-7.3

Languages : Informix-4GL

Operating System : Tru64 UNIX, SCO UNIX 5.3, MS Windows, AIX 6

High Availability: HADR

Web technologies: Remote Desktop Connection, VNC, Putty, CITRIX

Tools and IDEs: Lotus Notes, TOAD for DB2, ftp, Putty, WinSCP

CONFIDENTAIL

Professional Experience

CONFIDENTAIL

Role:Database Administrator

CONFIDENTAIL .

Responsibilities:

• Involved in Database design, PERFORMANCE TUNING and troubleshooting the issues on DB2 and assisted the application developers.
• Used to interact with the users, Developers, data modellers, business analyst, storage management group, server groups and testers during the entire Project to go live.
• Good exposure on Administration, Implementation, tuning and maintenance of the Databases used by the applications, Data management policies and Procedures.
• Performed RUNSTATS, REORG, REBIND, BACKUP, LOAD, EXPORT, IMPORT and other related to database activities.
• Involved in installing DB2 UDB on AIX, created instances and databases on different servers and provided connectivity to development, test, staging and production databases.
• Strong UNIX analyst skills, UNIX Korn shell scripting.
• Recovered the databases as necessary from bad load inserts and backups.
• Created IBM problem tickets and applied and installed recommended changes.
• Restored the production database on to the Development and staging environments upon the request of developers using the ROLLFORWARD.
• Created and maintained databases, table-spaces, tables, views, and indexes and altered tables and added check constraints and referential integrity.
• Undertook database recovery, instance failure and other situations.
• Granting and revoking the access to the users and groups on the database and database objects.
• Restructured the file systems and made some standards in organizing the data.
• Configuring and fine tuning DB2 DBM and DB configuration parameters for better response throughputs.
• 24x7 Production support.

Environment: UDB V9.7, V9.5, V9, Oracle 10g, MySQL, Putty, HADR

CITRIX, Lotus Notes, TOAD for DB2, ftp, WinSCP

CONFIDENTAIL

Role :Database Administrator

Responsibilities:

• Involved in database design, performance tuning and troubleshooting the issues on DB2 and assisted the application developers.
• Used to interact with the users, developers, data modelers, business analyst, storage management group, server groups and testers during the entire Project to go live.
• Good exposure on administration, implementation, tuning and maintenance of the databases used by the applications, data management policies and procedures.
• Involved with the SWIFT project, responsible for the separation of Jaguar Land Rover JLR data from Ford databases.
• Installation and configuration of new database environment. Standalone/HA using HACMP .
• Liaison between Ford SMEs and JLR, in collecting necessary data from the servers which will be used for subsequent cloning.
• Instrumental in developing strategy for the Cloning db2 database from the present environment.
• Developed necessary documents for Low Level Design LLD for the databases.
• Planning and installation of DBMS Database Managers and fixpacks in production, development and test servers
• Support, administer and maintain DB2 environments running on WinNT/2000/Unix platforms.
• DB2 instance Documentation of installation, monitoring and maintenance related task for future reference database housekeeping activities
• Design the suitable backup policy for the business like hot /cold/logical backups. Backup schedules e.g. every day hot backup, weekly cold backups, monthly cold backups etc.

Environment: UDB V9.7, V9.5, V9, Oracle 10g, MySQL, Putty,CITRIX, Lotus Notes, TOAD for DB2, ftp, WinSCP

CONFIDENTAIL

Role : Database Migration Expert

Responsibilities:

• Migrating existing database environment to DB2 latest available version.
• Analyzing the method of transforming existing data into a format for the new environment and the loading of this data into other database structures.
• Analyze data and provide feedback/ solutions
• Analyze the taken stats on periodic basis the database level / instance level tuning Memory Tuning, Schema Tuning, I/O Tuning, as and when needed the capacity planning I.e. resources planning CPU utilization, I/O, Space Management, Scalability for smooth functioning of database over the period of time.
• Reviewing existing source environment and provide recommendations for improving performance of the migration process.
• Recreating source database functions, designing reports and maintaining client reporting interface for destination database.
• Providing necessary change and support documentation.
• Perform UDB Installs on new Database Servers
• Install/upgrades fixpack on IBM AIX Servers.
• Provide mentorship to developers and analysts in all aspects of database management, automation, troubleshooting, and problem resolution.
• Performed RUNSTATS, REORG, REBIND, BACKUP, CURSOR LOAD, EXPORT, IMPORT and other related to database activities.
• Moving tables to their own tablespaces and separating indexes.
• Writing new database procedures/functions/triggers and other database objects as and when needed.
• Modifying existing procedures/functions/triggers and other database objects as and when needed.
• Review, analyze, adjust capacity/performance
• Work with Developers on application related issues
• Assist Application DBA's with issues in development, QA and production servers for multiple applications in EE and EEE environment.

Environment: UDB V9.7, V9.5, V9, Oracle 10g, MySQL, Putty,

CITRIX, Lotus Notes, TOAD for DB2, ftp, WinSCP

CONFIDENTAIL

Role : Database Administrator

CONFIDENTAIL

Responsibilities:

• Managing offshore team of 6 and ensure off hour efficient support including weekends from offshore.
• Second tier System DBA for escalated issues with DB2 UDB environment.
• Drive intermediate Severity1 issues through to resolution
• Interact with IBM for resolving high level PMR issues
• Test and certify the new versions of software/ Fixpack on labs.
• Perform UDB Installs on new Database Servers
• Install/upgrades fixpack on IBM AIX Servers.
• Involved in the Upgrade from DB2 9.1 to DB2 9.7 FP2
• Assist Application DBA's with issues in development, QA and production servers for multiple applications in EE and EEE environment.
• Work in different environments like HA and Stand alone, while also maintaining the infrastructure.
• Screen intermediate usage problems for known issues and provide workarounds
• Review, analyze, adjust capacity/performance
• Analyze, devise, document, and advise on intermediate, attend architecture and design meetings, project-specific.
• Work with Application DBAs on issues
• Test, certify, document UDB software releases and fixpack
• Migration of instance/databases to latest version.
• Automate repetitive tasks via scripts
• Installation and configuration of new database environment. Standalone/HA using HACMP .
• Perform weekly health checks for many DB2 UDB instances.
• Working on decommissioning old IBM servers and upgrading the instances to new V8.2 servers.
• Migrations, Upgrades, Setting up new servers, Migration of instances from old servers to new servers.
• Provide support during off hours as per schedule.
• Implemented Compression on Partitioned MDC tables and saved space.
• Performed RUNSTATS, REORG, REBIND, BACKUP, EXPORT, IMPORT and other related to database activities.
• Moving tables to their own tablespaces and separating indexes.
• Experience with midrange tools: vmstat, topas, db2top etc.
• Performed regular Health Checks, Complying with the SLA.
• Implemented HADR and Failover.
• Installing db2 clients on windows servers.
• Worked with various teams in resolving Sev1 issues, working with db2 support, Investigating Root Causes and doing Root Cause analysis.

Environment: UDB V9.5, V8.1 and V9, Remedy, Oracle 10g, Putty,

CITRIX, Lotus Notes, TOAD for DB2, ftp, WinSCP

CONFIDENTAIL

Role: Database Administrator

CONFIDENTAIL is an international information technology services company serving a global client base, it delivers IT services throughConsulting Systems Integration, Managed Operations, and transactional services through Worldline, the European leader and a global player in the payments services industry. With its deep technology expertise and industry knowledge, it works with clients across different business sectors: Manufacturing, Retail Transportation Public Health Financial Services Telcos, Media Utilities. Project coctue comes under Managed Operations which supports all DB2 environments including Production, QA, development, and test for CONFIDENTAIL .

Responsibilities:

• Support production environments, configuration, testing, and performance tuning of all DB2 database environments. Verify the database support requests and execute them in timely manner as the business SLA's.
• Managing problem/project tickets queue and maintaining communication with business team members.
• Consult with problem/project ticket owners in resolving issues and executing scripts as per the requirements.
• Continuously monitor the request queue and prioritize tickets in the queue as per the guidelines from the management.
• Responsible for successful execution of the ticket, documenting status, providing feedback to the owner and closure of the tickets.
• Actively provide leadership and technical expertise to ongoing problem identification/resolution and root cause analysis process for database system environment:
• Provide mentorship to developers and analysts in all aspects of database management, automation, troubleshooting, and problem resolution.
• Participate as a team member in evaluating system resource utilization and storage usage/capacity, and makes recommendations to increase application performance to meet business and financial requirements.
• Support, administer and maintain DB2 environments running on WinNT/2000/Unix platforms.
• DB2 instance Documentation of installation, monitoring and maintenance related task for future reference database housekeeping activities
• Design the suitable backup policy for the business like hot /cold/logical backups. Backup schedules e.g. every day hot backup, weekly cold backups, monthly cold backups etc.
• Analyze the taken stats on periodic basis the database level / instance level tuning Memory Tuning, Schema Tuning, I/O Tuning, as and when needed the capacity planning I.e. resources planning CPU utilization, I/O, Space Management, Scalability for smooth functioning of database over the period of time.

Environment: DB2 8.1, AIX 6, Ticketing Tool USD,MS Outlook, TOAD for DB2, ftp, WinSCP

CONFIDENTAIL

Role: Database Administrator/Data warehouse Developer and Administrator

CONFIDENTAIL is a Software Solutions and Services organization offering Integration Solutions, Business Intelligence Solutions and Software Infrastructure Management Services. CONFIDENTAIL focuses on Banking, Insurance, Financial Services and Pharmaceutical sectors and develops products and solution templates for them. CONFIDENTAIL t provides Consulting Services, Software Products and Technology Services to many large Indian and Multinational clients. This project includes DB2 support for all clients based locally.

Responsibilities:

• Responsible for installing and managing DB2, Data stage, Alpha Blox and Web sphere on Windows platform.
• Source System analysis, Data Gap Analysis
• Dimension Modeling and Database Designing, Creation for Target database.
• Extraction, Transformation and Loading Data from Informix Source system into Target DB2 Database in DB2 using Data stage as an ETL Tool.
• Designing Cubes, Dimensions, and Measures using Alpha Blox.
• Designing development reports as per user requirement.
• Coordinate with developers and change management team to ensure smooth life cycle progress from development through testing and production implementation.
• Support, administer and maintain DB2 environments running on WinNT/2000/Unix platforms.
• DB2 instance Documentation of installation, monitoring and maintenance related task for future reference database housekeeping activities
• Design the suitable backup policy for the business like hot /cold/logical backups. Backup schedules e.g. every day hot backup, weekly cold backups, monthly cold backups etc.
• Responsible for the implementation of a Data warehouse setup.
• Responsible for troubleshooting production and test database related queries.
• Monitoring and tuning database performance.

Environment : DB2 8.1, IBM Data stage, IBM Alpha Blox, IBM Web sphere 6, DB2 8.1, AIX

CONFIDENTAIL

Role:Database Administrator

CONFIDENTAIL application built in Informix 4gl serves all administrational needs of Breach Candy hospital. This integrated information system designed to manage all the aspects of a hospital operation, such as medical, administrative, financial, legal and the corresponding service processing.

Responsibilities:

• Customizing Hospital Management System running on IBM Netfinity Servers.
• Monitor performance and changing performance requirements through application of Database tuning and performance optimization techniques.
• Creating, amending the database tables and structure for Informix and Oracle 9i databases in line with application requirement.
• Writing scripts to simply the system and database management
• System / Database performance management
• Backup and Restoration of data
• Uptime management of all applications and databases
• Coordinating software development activities and business users by providing reports using SQL
• Preparing Management Information System related reports for Audit purpose.
• Modification to the Hospital Management System to reduce errors

Environment: SCO UNIX 5.3, Informix 7.3, Informix 4gl, Java

• CONFIDENTAIL Role:Software Developer Responsibilities:
• Project Requirement gathering, analysis
• Preparing Software Requirement Specification, Conceptual Design Documents, and database design documents as per requirement analysis
• Creating, amending the database tables and structure for Informix databases in line with application requirement.
• Application development, testing and deployment
• Providing support and modification as per user requirement after deployment