Consultant / Db2 Database Administrator Resume
Austin, TX
SUMMARY:
- Over 8+ years of IT experience involving database administration at all phases of database development lifecycle i.e. design, development, implementation and maintenance and support of databases using DB2 V8.x/ 9.1/ 9.5/9.7/10.1/10.5 on AIX, Linux, Solaris, HP - UX and Windows.
- Migrated or upgraded DB2 UDB databases and installing Fix Packs to keep DB2 at most recent level.
- Involved in the database and application design reviews and designed and built the physical database structures using the logical model.
- Database monitoring and tuning experience using Snapshot Monitor, Event Monitor, Explain, Visual Explain, and Index Advisor performance tools.
- Implemented MDCs, MQTs, Replicated MQTs and Statistical Views in the Data Warehouses and Marts for the optimal performance.
- Experience on Database Partitioning Feature (DPF) for maintaining very large databases.
- Setup HADR/HACMP between primary and secondary servers to ensure High Availability.
- Worked with third party utilities and tools like Quest Tools, IBM Data Studio, BMC Tools, DBArtisan, Toad, Performance Expert and Optim tools etc.
- Experienced in database administration tasks like SQL coding, Stored Procedures, Triggers, Referential Integrity, Index strategies, and SQL Troubleshooting.
- Experienced in running DB2 utilities like EXPORT, IMPORT, LOAD, DB2MOVE, REORG, RUNSTATS and DB2LOOK.
- Extensive experience in writing Korn shell scripts to automate DB maintenance activities.
- Opened PMR’s to get the resolution from IBM and collect the db2support, DB2DART (to verify architectural correctness of databases and objects), utilize CLI and db2trc for problem analysis and resolution.
- Proficient in scheduling/maintaining CRON/Autosys jobs based on application requirement.
- Excellent Interaction with clients, functional and business analysts and department Managers and different levels of users and developers and experience with Software Development Life Cycle.
- Experienced in educating and mentoring the users and developers about the DB2 best practices.
- Provide 24x7 on call support for databases supporting mission critical applications and off-hours maintenance.
- Excellent communication and interpersonal skills and being able to work independently with minimal or no guidance.
TECHNICAL SKILLS:
RDBMS: DB2 UDB 8.x/ 9.1/ 9.5/9.7/10.1/10.5, DB2/ZOS,SQL Server 2000/2005, Oracle 10g.
Database Tools: Change Data Capture (CDC), Optim Performance Manager, DB2 Performance Expert, Erwin, ER/Studio, Rational Quest Central, Spotlight, IBM Query Patroller, TOAD, DB2 Connect, Event Monitor, Snapshot Monitor Data Architect, DB2 Replication Center, DB2 connect, BMC Tools and Quest Tools, Veritas NetBackup, TSM, DB2 Federated Server, DB2 Information Integrator, DB2 Content Manager, DB2 Governor, DB2 Foglight and Spotlight
Application Server: Web Sphere, Web Logic, JBOSS
Languages: Shell Scripting (Bash, Korn), SQL Programming, PL/SQL, .NET, C, Java
Operating Systems: SLES 10, 11 SP x, UNIX (AIX 7.1, 5.x, Linux, Sun Solaris 5.9, HP-UX), Windows XP/NT/2000, OS/390, z/OS
PROFESSIONAL EXPERIENCE:
Confidential, Austin, TX
Consultant / DB2 Database Administrator
Responsibilities:
- Database Physical and logical design, maintenance according to Business needs.
- DB2 Database performance tuning to identify and fine tune SQL queries for performance improvements. Improved query performance by keeping statistics up to date and tuning the database for sampling size and error conditions.
- Analyze queries, system performance tables, identify memory, disk Input/Output (I/O) issues
- Expertise in file system layout optimization, tuning DB2 memory structures
- Experience with DSM tool to identify and optimize top running queries
- Experience in identify logical data model optimization and tune data model by defining indexes that improve overall performance.
- Setup Federated Database environment between Databases by creating servers, wrappers, nicknames, User mappings and activated federated health indicators.
- Worked with a wide range of utilities which includes BACKUP, RESTORE, RUNSTATS, REORGS, EXPORT, IMPORT and LOADS
- Experience with RCAC and LDAP integration features
- Proficient in SQL query tuning.
Environment: IBM DB2 V10.5, Aix, Infosphere Data Architect, DMS, Toad, Clear Quest.
Confidential, Plymouth, MN
Sr. DB2 Database Administrator
Responsibilities:
- Providing the support for the critical databases, analyzing the database health and performance using the automated scripts and providing solution in case of any discrepancy .
- Providing the support for the application team by monitoring the databases during the new code releases and implementing the database level changes.
- Handling the capacity planning requirements for the production databases by procuring the minimum storage required.
- Monitored the performance by creating snapshots for slow running queries and analyzed the SQL access paths for checking the performance.
- Coordinating with offshore and client Onsite SMEs thru the weekly meetings on the new tasks and activities.
- Coordinated with the system administrators regarding the OS patching maintenance tasks and DB2 installations and migrations activities.
- Excellent Interaction with Clients, Functional and business analysts, department Managers, different levels of users and developers & experience with SDLC.
- Experienced in benchmarking the performance of the complex queries using snapshots and administrative views.
- Working towards the service improvement tasks by automation and proactive monitoring .
- Experienced in working on ETL batch jobs and troubleshooting the data movement issues.
- Create MQT tables to improve query performance and reduce the overhead of resource intensive aggregate operations.
- Setting up HADR environments on the DB2 servers using db2haicu and Tivoli System Automation on Multi-platforms.
- Developed automated scripts using Unix Shell and Perl for performing RUNSTATS, REORGCHK, REORG, REBIND, LOAD and other related to database activities and used cron for scheduling.
- Remotely administered and supported the production databases 24/7. This includes monitoring the database growth, checking for the performance bottlenecks, taking backups for disaster recovery and tuning SQL queries for better performance.
- Opened multiple IBM PMR tickets for the upgrade and performance issues and worked with the IBM support team for performance impacts and other issues.
Environment: DB2 UDB LUW 9.5/9.7/10.1/10.5 EEE/DPF, AIX 6.1, Linux, ERWIN, ER/Studio, TSM, Q-Replication, Quest Central, WAS server 6.0, Data Stage.
Confidential, Norwalk, CT
Sr. DB2 Database Administrator
Responsibilities:
- Responsible for software installation, database creation and maintenance, performance monitoring and tuning, backup and recovery, customer consultation, DBMS infrastructure creation and support, problem determination/resolution.
- Install DB2 UDB on AIX. Created instances and databases on different servers and provided connectivity to development and production databases.
- Create stored procedures, functions which cannot be migrated using MTK and compile, bind them to the databases.
- Determine project performance requirements, and plan for database backup & recovery, infrastructure, capacity, and health maintenance of databases.
- Run db2ckbkp utility to test the integrity of the backup image and check whether it can be restored.
- Automated backups (both online and offline), Reorgs, Runstats, Space monitoring, moving db2diag.log, monitoring size of table spaces by setting up a threshold.
- Work closely with Developers to create database objects (table spaces, schemas, tables, views, indexes, triggers, stored procedures etc) as per the requirement.
- Create Range- partitioned Tables and specify ranges Creating Tables and Indexes.
- Tune database and Database manager configuration for optimum performance.
- Creating EXPLAIN tables and running visual explain utility on SQL statements.
- Create MQT tables to improve query performance and reduce the overhead of data maintenance ops.
- Setup HADR/HACMP between primary and secondary servers to ensure High Availability.
- Work heavily with data movement utilities IMPORT, LOAD, EXPORT and Quest Central
- Develop scripts for regular maintenance activities like BACKUP, RUNSTATS and REORGS.
- Remotely administer the production database 24/7 through VPN connection. This includes monitoring the database growth, checking for the performance bottlenecks, taking backups for disaster recovery and tuning SQL queries for better performance.
Environment: DB2 UDB LUW 9.5/9.7 EEE/DPF, AIX 6.1, Linux, ERWIN, ER/Studio, TSM, Q-Replication, Quest Central, WAS server 6.0, Informatica.
Confidential, Chattanooga, TN
Sr. DB2 Database Administrator
Responsibilities:
- Installed Product base codes and maintenance Fix Packs (full and alternate) and upgraded instances and databases regularly.
- Expertise in Implementing LOGARCHMETH1, LOGARCHMETH2 & FAILARCHPATH to enable archival logging and Implications during recovery situations.
- Actively Monitored file systems for growth, added additional disk space for volume groups, created new file systems and allocate file systems to new databases.
- Opened PMR’s (Problem Management Request) to get the resolution from IBM and run db2support, DB2DART (to verify architectural correctness of databases and objects), utilize CLI and db2trc for problem analysis/resolution.
- Run db2mtrk to provide complete report of memory status, for instances, databases and agents.
- Run topas to check current CPU utilization, Memory usage and paging space.
- Installed and Upgraded DB2 Client on Servers/Workstations, Implemented DB2 Client on Desktops using SMS push and configured access to ODBC data-sources.
- Setup HADR/HACMP between primary and secondary servers to ensure High Availability.
- Used the Design Advisor to migrate from a Single partition to a multi partition database, created table spaces and specified partition options for file import and bulk load target operators.
- Expertise in SQL tuning, DB/DBM parameter tuning, different levels of memory allocations, various tools like export, import, load, autoloader and experience with all kinds of database snapshots.
- Developed automated scripts using Unix Shell and Perl for performing RUNSTATS, REORGCHK, REORG, REBIND, BACKUP, LOAD, PRUNING, TABLESPACE THRESHOLDS and other related to database activities and used cron for scheduling.
- Worked extensively with restores, redirected restores and Unicode conversions.
- Responsible for performance tuning, 24 x 7 support, analysis and resolution of database problems that occurs during the critical time processing .
Environment: DB2 UDB LUW 8.x/9.1 with DPF, AIX 5.3, Linux, Quest Central, BMC Tools, Q-Replication, SQL Replication, ER/Studio, DB2 Client, BMC Remedy.
Confidential
DB2 Database Administrator
Responsibilities:
- Manage production, staging, test and development DB2 UDB.
- Migrate DB2 UDB databases on AIX from V8 to V9 and updated to a latest level by installing Fix Pack.
- Assisted developers in creating stored procedures, functions, compiling and binding them to the database.
- Tuned databases using tools like snapshot monitor, visual explain, Index advisor, db2expln, db2exfmt etc.
- Created multiple databases across different environments using Redirected Restore.
- Regularly monitored databases for deadlocks, table spaces, long running queries using Snapshots and Event monitors.
- Setup Replication between Operational Database and Reporting Database.
- Expertise in SQL tuning, DB/DBM parameter tuning, different levels of memory allocations, various tools like export, import, load, autoloader and experience with all kinds of database snapshots.
- Created multiple Buffer Pools for optimal performance and allocation of resources.
- Configured database to enable I/O Parallelism and Intra-Parallelism for fast query retrieval and high performance.
- Extensively worked with data movement utilities like import, export, load and db2move for data migration between databases.
- Prepared backup and recovery strategies depending on SLA and implemented successfully.
- Converted business process functions into user defined functions and procedures.
- Provide on-call (24X7) support for all production databases.
Environment: DB2 UDB LUW 9.1, Linux, ERWIN 4.1 and Web Sphere 5.0, AIX 5.x, Windows 2003 Advanced Servers, SYBASE, DB2 UDB V8.2 EEE and EE, UDB V8 ESE with DPF, Windows 2000, DB2 Connect Enterprise, DB2 utilities.