SUMMARY:

• A Database Administrator specializing in IBM DB2 UDB with overall 5 years of experience in various aspects of DB2 UDB including physical and logical design, performance monitoring, maintenance, query analysis, optimization, backup and recovery, replication and migration.
• Extensive experience in utilities and tools used for database monitoring (DB2 traces, online performance monitors, reports, EXPLAIN, DB2 catalog queries, Db2 DPF), data movement and organization (LOAD, UNLOAD, REORG), data consistency utilities and catalog manipulation utilities (RUNSTATS, MODIFY).
• Expertise in application development support activities including database design, optimizing SQL queries, building complex SQLs, dynamic SQLs and triggers, effective binding of packages and plans, concurrency planning, data refreshing and database objects migration across regions.
• Extensively worked with DB2 Explain, Runstats, REORG and other ONLINE and Offline utilities. Experienced in (24 x 7) Production Support
• Proven excellence to work in a team in achieving common objectives along with personal ones.
• Installation of DB2 UDB EE and Fix packs on UNIX and Windows machines.
• Design, Creation and maintenance of databases for highly demanding environments.
• Replication and Migration of databases across heterogeneous platforms.
• Performance tuning of databases including query tuning and optimization.
• Understanding of database access and ability to assist developers in implementing efficient SQL code.
• Establish standards, controls, and procedures to ensure data integrity and security.
• Developing strategies to manage large data volume growth of Enterprise Data warehouse.
• Backup and Recovery of databases and High Availability Disaster recovery (HADR).
• Determine and provide assistance with the methods used to format, load or update data.
• Provide 24X7 production support, problem resolution and recovery processes during an outage resolution.
• Ability to work independently or as an effective team player.

PROFESSIONAL EXPERIENCE:

Confidential

IT Analyst

Responsibilities:

• Install and configure DB2 UDB new releases, upgrades, and patches.

Confidential

Technology Analyst

Responsibilities:

• Install and configure DB2 UDB new releases, upgrades, and patches.
• Scripting, design/analysis, installation, monitoring, maintaining, troubleshooting, and tuning UDB environments.
• Analyze DB2 UDB Event Monitor information, physical design, performance characteristics of tablespaces, physical I/O rates, and table access activities.
• Proactively monitor performance, diagnose problems and tune queries and database.
• Assisting with the creation and modification of primary database storage structures (tablespaces) and primary objects (tables, views, indexes).
• Implement data security guidelines while making data available to those authorized to have access.
• Create and maintain documentation such as Functional design documents, detailed design documents, data flow diagrams, data entity relationships documents for all the internal projects.
• Interface with business analysts & developers with regards to application, logical & physical database design, create and maintain logical entity relationship diagrams, transform logical models into physical data models.
• Changing instance level and database level configuration parameters for database concurrency, authentication, performance and allowing remote clients accessing server.
• Provide 24X7 on - call support to troubleshoot issues with the Production schedule.
• Perform capacity planning and analysis and implement required changes on the database server

Environment: DB2 V9.7, V10.5

Confidential

Associate DBA

Responsibilities:

• Provide onsite support for all database administration work that has been handed over to offshore team.
• Provides level 2 support which includes table spaces, database partitioning.
• Perform database software installations including and database creation and configuration.
• Database Backup/Recovery of databases, including Redirected Restore.
• Implement a library of homegrown scripts to automate the scheduling and notification of periodic maintenance jobs, including REORG, BACKUP, RUNSTATS, LOAD, IMPORT, etc.
• Monitor DB2 UDB processes and logs for any anomalies, provide corrective actions.
• Provide assistance to the development team on performance tuning, resolving locking solutions, assist data modeler with SQL scripts
• Implement and test HADR performance for production environments.
• Analyze application SQL for performance improvement opportunities and work with DB2 support on problems and questions.
• Taking Snapshots and gathering other information related to the database and the system during stress tests or performance tuning.
• 24X7 on-call support and problem resolution.

Environment: DB2 V9.7,10.5.   BMC Remedy, Redwood CPS

Confidential

Jr-DBA

Responsibilities:

• Administration and management of the entire development, QA and production environment.
• Works on level 3 tasks with application teams which includes database design also.
• Installed and configured databases on Linux and Windows environments.
• Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• Increased database performance by utilizing config changes, multiple instances and by upgrading hardware.
• Worked with the engineering team to implement new design systems of databases used by the company.
• Effectively configured database Replication.
• Designed databases for referential integrity and involved in logical design plan.
• Developed stored procedures, triggers.
• Proficiency in Unix/Linux shell commands.
• Created data extracts as part of data analysis and exchanged with internal staff.
• Documented all servers and databases.
• Supporting management with different database related decisions.
• Handling Release management and user acceptance.