We provide IT Staff Augmentation Services!

Subject Matter Expert - Lead Dba Resume

SUMMARY

  • Over 10 years 4 months of IT experience wif emphasis on supporting and administering DB2 UDB Databases on Linux, AIX and Windows platforms wif good process knowledge.
  • Around 2 years of experience on supporting and administering MS SQL & MySQL databases.
  • Having Hands on Experience in using teh incident management tools like REMEDY, MAXIMO and E - TRACK.
  • Good Working Experience on handling production database issues and resolving issues as per client SLA.
  • Worked in Process-driven environment, by following processes like Problem Management and Change Management.
  • Expertise in installation of different versions of DB2 UDB on AIX, LINUX (RHEL v6 & v7), UNIX and Windows.
  • Expertise in applying fixpacks on existing DB2 versions.
  • Extensive experience in Migration of databases to new releases DB2 V10.1 and DB2 V10.5 from DB2 V9.7.
  • Good experience on building new DB2 Servers as part of RFS activities.
  • Experience in handling Production databases up to 8TB in partitioned environment / DPF environment.
  • Good Working Experience on IBM BCU’s up to 52 database partitions.
  • Worked heavily wif data movement utilities like MOVE, COPY, LOAD, IMPORT, LOAD, and EXPORT under high Volume conditions, between remote and local databases.
  • Having Hands on experience in exporting tables data and loading them into different databases and different schemas.
  • Expertise in taking ONLINE and OFFLINE database backups and good experience on recovering them if required.
  • Experience in implementing TSM Backup and Recovery strategies including TSM cross node recovery.
  • Worked on Database restores including redirected restores wifin production, staging and development environment as per user request.
  • Used DB2 utilities RUNSTATS, REORGCHK and REORG to enhance application performance.
  • Good Experience on handling SQL performance issues and good experience on taking necessary actions on long running queries.
  • DB2 High Availability cluster configuration using TSA & db2haicu utilities.
  • Setting up TSA HADR for failover situation and disaster recovery conditions.
  • Undertaking capacity planning and resource management and have extensive knowledge on Classic (Static) & Adaptive Compression techniques.
  • Proficient in daily support activities which include monitoring logs, monitoring thread activity, resolving lock waits, deadlock and backup failure issues.
  • Maintained Shell Scripts for Monitoring Databases alerts like long running queries, log space issues, file system space issues.
  • Opened several SEV1 PMRs wif IBM to troubleshoot and resolve critical issues.
  • Creating and Monitoring users, authorities and responsibilities and password management.
  • Monitor CPU, Memory, Paging space, Disk I/O and analyze those using topas, nmon and other tools.
  • Developed database security strategy to provide access to large number of users in production environment and implemented DB2 auditing to meet regulatory requirements.
  • Prepared several shell scripts in production database environment like monitoring long running queries, compressing DB2 diag logs and notify logs, tablespaces and file system free space reports, calculating indexes usage...etc.
  • Good experience in using tools like RUM, Metron, Precise and Maestro Jobs for database performance monitoring.
  • Handling incidents and change requests using maximo.
  • Experience in installing, managing, monitoring and troubleshooting on MS SQL Server 2012 and 2008 R2.
  • Good work experience on upgrading SQL Server 2008 R2 and 2012.
  • Good experience on database administration on Production Servers wif server configuration and maintenance wif outstanding troubleshooting capabilities.
  • Creating Maintenance plans and troubleshooting SQL Server Agent Scheduled jobs like Backup, Integrity, Optimization, and Log Shipping jobs regularly.
  • Monitoring disk space utilization, T-Log file size maintenance and capacity planning.
  • Good work experience on taking full and differential backups on production databases and restoring them in QA environments.
  • Backup & Restore of databases using TSM.
  • Taking care of disk space, backup & performance issues in SQL server.
  • Administering SQL Server High Availability and Disaster Recovery strategies.
  • Experience in implementing Clustering, Log Shipping, Replication and Mirroring for high availability solutions.
  • Administration and management of teh entire production, development and QA and environments.
  • Installed and configured MySQL in Linux.
  • Upgraded MYSQL from 5.5 to 5.6 as per client requirement.
  • Converted databases from MyISAM to Innodb storage engine for databases dat needed greater referential integrity.
  • Monitoring slow running queries and tuning.
  • Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
  • Increased database performance by utilizing MySQL configuration changes, multiple instances and by upgrading hardware.
  • Managing/Troubleshooting MySQL 5.0.22 and 5.1.24 in production and development environments on both Linux (5.0, 5.1) and Windows.

TECHNICAL SKILLS

Operating Systems: IBM AIX 5.X, 6.X, 7.X,UNIX, Red Hat Linux 6,7, Solaris and Windows

RDBMS: DB2 UDB V 8/9.1/9.5/9.7/10.1/10.5 on LUW, DB2 UDB DPF V9.7, MS SQL Server 2008 R2 and 2012 and MySQL 5.5 and 5.6

Performance Monitoring Tools: RUM, Precise, db2top, db2pd, NMON

Tools: /Utilities: DB2 Client, IBM Utilities, DB2 Connect, BMC Remedy, Maximo, E-Track, Maestro

Languages: Shell scripting, SQL

PROFESSIONAL EXPERIENCE

Confidential

Subject Matter Expert - Lead DBA

Responsibilities:

  • Involved in production database migration from DB2 V9.7 to DB2 V10.5
  • Performed DB2 installation, de-installation, and configuration and install fix packs to keep DB2 at most recent level on LINUX, UNIX and Windows servers.
  • Designed logical and physical databases and database objects for DB2 UDB on Development, Test and Production environments.
  • Capacity planning - space management, ongoing maintenance of production and development environments.
  • Performed database recovery using restore and redirected restore.
  • Monthly attending database maintenance changes to implement REORGS & RUNSTATS on production database objects for better performance.
  • Appropriately analyze Maximo Incidents to obtain resolution or work around wif documentation if it is a critical issue (SEV-1, SEV-2 issues).
  • Involved in performance tuning, recommending SQL queries for better performance.
  • Developed automated scripts using Unix Shell to performing runstats, reorg, rebind, backup, load, export and other related to database activities.
  • Database utilities like db2relocate, db2move, admin-procedures, cursors, load, export, import.
  • Resolved and/or completed all service requests / incidents in time which we have in-queue in Maximo tool.
  • Exporting data into flat files and loading them in other schema tables.
  • Good experience on taking backups into TSM and recovering them when needed.
  • As a Database Administrator, prepared plenty of shell scripts in Linux and AIX database servers for monitoring & tuning DB2 databases.
  • Automated teh backups, Reorgs, Runstats, Space monitoring, monitoring teh size of teh tablespaces.
  • Involved in SQL performance tuning. Also applied teh db2advis on SELECT statements for index and RUNSTATS recommendations.
  • Used db2look, db2move table and import/export/load cursors utilities to move structure and data between databases.
  • Implemented High Availability Disaster Recovery (HADR) wif Tivoli System Automation for Multiplatform (Tivoli SA MP) using db2haicu utility on PROD and QA DB system.
  • Performed database system performance tuning by using Snapshot, Event Monitor, db2top, db2pd, db2 system views and OS commands (top, topas, nmon, vmstat, and iostat) and updating DB and DBM configuration parameters.
  • Analyze complex and long running SQL queries using Visual explain and other tools.
  • Applying Fix Packs to keep DB2 at teh most current level.
  • Extensively used different Data movement utilities like IMPORT, EXPORT, and LOAD utilities to load data.
  • Installing, configuring, administrating and securing SQL Server 2005\2008\R2\2012.
  • Monitoring and troubleshooting Databases.
  • Supporting Clustering, Log Shipping, Replication and Mirroring for high availability solutions.
  • Upgrading SQL Server 2005, 2008\R2 and 2012.
  • Monitoring server performance using Performance Monitor and SQL Server Profiler.
  • Monitoring Log shipping and troubleshooting teh errors.
  • Managed Logins, Users, Roles and User permissions.
  • Responsible for space allocation, backup strategies.
  • Experience in upgrading SQL Server 2005, 2008/R2 and 2012.
  • Installing, Upgrading and configuring MySQL 5.1, 5.5 and 5.6
  • Upgraded MySQL 5.5 to 5.6
  • Administration and management of production, development and QA and environments.
  • Installed and configured MySQL on Linux environments using RPM.
  • Good knowledge on MySQL database backup and recovery strategies and Replication and synchronization.
  • Working on Innodb storage engine tables, MYISAM storage engine tables and backing up, restoring in QA environment databases.
  • Expertise in moving tables from one storage engine to different.
  • Database security, creating users and managing permissions.
  • Involved in trouble shooting and fine-tuning of databases for performance and concurrency.
  • Supporting Multi-Master and Master-Slave replication process.
  • Managing database clustering on NDB technology.

Environment: DB2 ESE Version 9.7/10.5, AIX 6/7, RHEL v6/v7, IBM Utilities, Websphere MQ, Shell Scripting, TSM, MS SQL, MySQL.

Confidential

Infrastructure TEMPPrincipal DBA

Responsibilities:

  • Provided 24x7 support.
  • Involved in production database migration as a part of ODS database migration.
  • Migrated databases from DB2 V9.5 to DB2 V9.7 on Linux and AIX.
  • Granted READ, WRITE privileges to users on database schema objects.
  • Deleting old Siebel repositories and purging data to get teh more free space on DMS tablespaces on DB2 Databases.
  • Daily Monitoring teh DMS tablespaces free space on each database for not reaching more than 90% tablespaces utilization.
  • Resolved and/or completed all service requests / incidents in time which we have in-queue in BMC remedy tool.
  • Performed database restore using redirect restore method in training database environments.
  • Exporting data into flat files and loading them in other schema tables.
  • Responding and resolving on Remedy Incidents as per client SLA.
  • Prepared shell scripts for database refresh processes and health check processes.
  • Prepared shell scripts for data quality queries which are required for Marriott Business team to validate teh data on regular basis.
  • Prepared shell script for terminate a Toad session which is creating Lock-Wait state applications in production database.
  • Created new indexes in development, test and performance databases to improve SQL performance. After tested by ECPG, I implemented teh same in production database.
  • Prepared shell scripts on production database for sending SRW SQL reports to development team as an auto generated mails.
  • Refresh all training production database environments from training development after completion of business validation.
  • Copied production database into test environment to test teh long running SQLs, to create test indexes and to load test data….etc.
  • Expertise on creating DMS tablespaces, altering teh tablespaces and adding containers into existing DMS tablespaces.
  • Implemented High Availability Disaster Recovery (HADR) wif Tivoli System Automation for Multiplatform (Tivoli SA MP) using db2haicu utility on PROD and QA DB system.
  • Used db2look, db2move table and import/export/load cursors utilities to move structure and data between databases. Relocate databases using db2relocate to different instance or locations.
  • Maintained Shell Scripts for Monitoring database alerts like long running queries, log space issues, file system space issues, HADR peer sync and more.
  • Analyzing buffer pool usage, catalog stats, objects design and providing suggestion to improve teh performance as teh part of daily activities.
  • Installing, configuring, administrating and securing SQL Server 2005/2008.
  • Administration and management of teh entire production, development and QA and environments.
  • Migrating SQL Server 2005 databases into SQL Server 2008 R2.
  • Monitoring and troubleshooting Databases.
  • Supporting SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
  • Installing, Migrating and configuring SQL Server 2008 R2 and 2012.
  • Performing full, differential and transactional log backups from production database and restoring them in QA environments.
  • Scheduling and monitoring Jobs in SQL server.
  • Monitoring Log shipping and troubleshooting teh errors.
  • Managed Logins, Users, Roles and User permissions.
  • Installed and configured MySQL on Linux and Windows environments.
  • Upgraded MYSQL from 5.1 to 5.5 as per client requirement.
  • Managing/Troubleshooting MySQL 5.0.22 and 5.1.24 in production and developer environments on both Linux (5.0, 5.1) and Windows.
  • Increased database performance by utilizing MySQL configuration changes, multiple instances and by upgrading hardware.
  • Assisted wif sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
  • Ensured production data being replicated into data warehouse wifout any data anomalies from teh processing databases.
  • Shell script is being used for some data migration and back end work management.
  • Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
  • Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
  • Converted databases from MyISAM format to Innodb storage engine for databases dat needed greater referential integrity.

Environment: DB2 ESE Version 9.5/9.7, AIX 6/7, RHEL 6/7, Shell Scripting, Veritas, MS SQL 2008 R2 and MySQL 5.6.

Confidential, US

Sr. Database Administrator

Responsibilities:

  • Involved in production database migration as a part of CI Go-Live.
  • Involved in Production R1 Go-Live and Production R2 Go-Live.
  • Involved in CI conversion Go-Live.
  • Worked on databases migration from DB2 V9.5 to DB2 V9.7.
  • Performed database restore using redirect restore method in training database environments.
  • Converting all Marriott properties into CI as per weekly conversion process.
  • Exporting data into flat files and loading them in other schema tables.
  • Worked on Marriott CI (Consolidated Inventory) and handling DB2 databases as a database administrator.
  • Responding and resolving on Remedy Incidents as per client SLA.
  • Appropriately analyze Remedy Incidents to obtain resolution or work around wif documentation if it is a critical issue (SEV-1, SEV-2 issues).
  • As a conversion DBA, Every Sunday attending system change and converting franchised properties into CI.
  • Prepared shell scripts on production database for getting user details and SQL details if teh user executing a bad query which is running more than 30 minutes.
  • Prepared shell scripts for killing long running SQLs to reduce CPU utilization in database servers.
  • Prepared shell scripts for database refresh process and health check processes.
  • Prepared shell scripts for data quality queries which are required for Marriott Business team to validate teh data on regular basis.
  • Using Real User Monitor tool & precise tool daily we are checking how many users are accessing CI database and how much CPU utilization is taking place for production database.
  • Extracting RUM reports and providing detailed summary to application team.
  • Backing up custom indexes information before column activation done by Siebel Admins and creating missing indexes after completion of column activation.
  • Saving and recreating database custom indexes for Siebel application DDL Sync process.
  • Daily Monitoring teh DMS tablespaces free space on each database for not reaching more than 90% tablespaces utilization.
  • Monthly attending database maintenance system changes as per client request and doing REORGS & RUNSTATS on production database objects for better performance.
  • Weekly attending CI database conversion system changes as per client request to convert properties into CI production database.
  • Expertise on creating DMS tablespaces, altering teh tablespaces and adding containers into existing DMS tablespaces.
  • Applied Fixpacks for upgrade teh DB2 Version from V9.5.2 to V9.5.3 on Solaris & Linux.
  • Granted READ, WRITE privileges to users on database schema objects.
  • Supported all types of Administrative tasks.

Environment: DB2 ESE Version 9.1/9.5/9.7, AIX 5.x/6.x,AIX 7.x UNIX, RHL 5, WINDOWS, DB2 connect, Veritas.

Confidential, Chicago

System engineer DBA

Responsibilities:

  • Provided 24x7 support.
  • Worked on installation of different versions of DB2 UDB on AIX 5.3.
  • Involved in moving schemas from source database to target database.
  • Performed Restore of teh OFFLINE database backup images wif REDIRECT RESTORE method on Linux and Solaris zones.
  • Involved in SQL performance tuning as per client request. Also applied teh db2advis on SQLs for index and RUNSTATS recommendations.
  • Apply fix packs, monitor IBM maintenance releases and communicate them to business.
  • Develop database security strategy to provide access to large number of users in production environment.
  • Involved in capacity planning and space management. Worked on space estimate and table space design to accommodate large amount of data in data warehouse environment.
  • Created, maintained, and monitored archive, recovery and data retention strategy for all databases servers.
  • Create, maintain, and monitor backup jobs; Ensure backup jobs are able to support of documented SLAs.
  • Maintain archival strategy, logging strategy for point in time recovery.
  • Coordinating wif development team for SQL Optimization, SQL Analysis and Streamlining.
  • Maintain documentation of database infrastructure and software assets.

Environment: DB2 ESE Version 8.2/9.1/9.5, AIX 5.x, 6.x, UNIX, RHEL 5, WINDOWS and Toad.

Confidential

System engineer DBA

Responsibilities:

  • Provided 24X7 on call support for production servers.
  • Applied V9.1 Fix Pack 4.
  • Administration of more than 100 DB2 UDB database servers
  • Worked heavily wif data movement utilities IMPORT, LOAD and EXPORT under high Volume conditions, between remote and local data bases.
  • Worked on Database restores including redirected restores wifin production, staging and development environment as per user request.
  • Used RUNSTATS, REORGCHK and REORG to enhance application performance
  • Resolved all types of frequent load issues for application and ETL Teams
  • Performed problem determination for production and simulation databases using integrated db2diag.log for database level and/or instance level problems.
  • Used problem determination tool (db2pd) to identify problem applications or long running SQL
  • Extensively involved in performance tuning, recommending SQL queries for better performance.
  • Capacity planning - space management, ongoing maintenance of prod and development environments..
  • Performed database recovery using restore and redirected restore.
  • Developed automated scripts using Unix Shell to performing runstats, reorg, rebind, backup, load, export and other related to database activities.
  • Used db2look, db2move table and import/export/load cursors utilities to move structure and data between databases.
  • Tuning database by enabling Self Tuning Memory management (STMM).
  • Checking DB performance bottlenecks and fixing teh same.

Environment: DB2 ESE v8/9.1/9.5, RHL, UNIX, AIX, WINDOWS, HTML, PUTTY.

Confidential

Database Administrator

Responsibilities:

  • Developed and maintained production, staging, test and development V 8.2 DB2 UDB ESE databases on AIX, Solaris and Windows.
  • Performed SQL tuning, DB/DBM parameter tuning, different levels of memory allocations, various tools like export, import, load, auto loader and experience wif all kinds of database snapshots
  • Creating and Monitoring Users, authorities and responsibilities and password management
  • Enhanced application performance by running RUNSTATS, REORGCHK and REORG utilities
  • Monitored and managed disk space, I/O contention
  • Designed and implemented backup and restore procedures
  • Monitored databases using database monitors, snapshot monitoring and event monitoring
  • Generated reports of database structure using DB2LOOK Utility
  • Recovered data to a prior point in time using ROLLFORWARD command
  • Implementing capacity planning and partition table/index for very large and fast growing tables
  • Tuned application, database and system for best performance
  • Day-to-day attending to teh user queries in sorting out database problems
  • Coordinating wif user departments and attending their requirements for smooth functioning
  • Developed document dat provides an overview of teh physical and logical design of teh database environment implemented.
  • Upgraded instances regularly wif latest Fix packs and alternate Fix packs
  • Worked extensively wif restores, redirected restores and Unicode conversions
  • Setup and monitored replication between operational database and reporting database
  • Migration of data base from V8.2 to V9.1 and to V9.5
  • Administration of more than 10 DB2 UDB database servers
  • Worked heavily wif data movement utilities IMPORT, LOAD, and EXPORT under high Volume conditions, between remote and local data bases.
  • Used RUNSTATS, REORGCHK and REORG to enhance application performance.

Environment: DB2 ESE v8.2, RHEL, UNIX, AIX, WINDOWS, HTML, PUTTY.

Hire Now