We provide IT Staff Augmentation Services!

Dba Consultant Resume

Plano, TX

SUMMARY:

Database Administrator with extensive experience in planning and migrating applications, scheduling jobs, installing systems, and supporting databases. Utilize excellent troubleshooting skills to improve performance and resolve Database and SQL issues. Adept at learning and applying new technologies, efficiently maintaining software databases and implementing new SQL procedures and functionalities.

PERFORMANCE PROFILE:

  • Over 13+ 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, 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 Confidential Data Studio, BMC Tools, 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 Confidential and collect the db2support, DB2DART (to verify architectural correctness of databases and objects), utilize CLI and db2trc for problem analysis and resolution.
  • 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.

EXPERTISE INCLUDES:

  • Technical Documentation
  • Project Management Disaster Recovery
  • Customer Support.

TECHNICAL SKILLS:

RDBMS: DB2 UDB 8.x/ 9.1/ 9.5/9.7/10.1/10.5 , DB2/ZOS V8,V9,V10,V11,SQL Server 2000/2005/2008 R2/2012/2014, Oracle 10g. 11g, 12c

Database Tools: Change Data Capture (CDC), Optim Performance Manager, DB2 Performance Expert, Erwin, ER/Studio, Rational Quest Central, TOAD, DB2 Connect, Event Monitor, Snapshot Monitor Data Architect, DB2 Replication Center, DB2 connect, BMC Tools and Quest Tools, Commvault, TSM, DB2 Federated Server, DB2 Information Integrator, DB2 Content Manager, DB2 Governor.

Application Server: Web Sphere, Web Logic, Rational, SMP/E, CICS/TS, VSAM, COBOL, C++, HTML, Computer Associates (OPS, TLMS, JOBTRAC),

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

DBA Consultant

Responsibilities:

  • Analyzed and created prospects for DB environment and capacity planning for DB2/SQL/Oracle DB’s.
  • Created, Analyzed DB infrastructure requirements for the client’s current data and the projected data for three years.
  • Involved in the database and application design reviews and designed and built the physical database structures using the logical model.
  • Determine project performance requirements, and plan for database backup & recovery, infrastructure, capacity, and health maintenance of databases.

Environment: Confidential DB2 V10.5, Aix, Infosphere Data Architect, DMS, Toad, Confidential Data Studio.

Confidential, New York, NY

Senior DBA/Team Lead Support

Responsibilities:

  • Database Physical and logical design, maintenance according to Business needs.
  • 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.
  • 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.
  • 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
  • Proficient in SQL query tuning.
  • Execute Commvault Backup/Restore TFS procedures for CMHC application customers and DBA troubleshooting with SQL server and DB2 LUW 10.5 Servers with QREP and Mirror environment Ottawa/Toronto.
  • DBA support for over 5 legacy applications over DB2 for z/OS V11 and Cobol programming.

Environment: DB2 UDB LUW 10.5, ERWIN and Redgate, DB2 UDB V9.1 EEE and EE, DB2 Connect Enterprise, DB2 utilities, Commvault, Azure, Windows 2012R2, 2012, 2008R2, 2003, MS-SQLServer 2014 / 2012 / 2008 R2 / 2008/2005, SSIS, SSRS,, SQL Azure, SQL Cluster.

Confidential

Remote Advisory Customer Support

Responsibilities:

  • Delivered customer support and remote assistance advisory DB2 in mainframe for z/OS v10 / v11.
  • Responded to questions from customer’s technical database administrator, on behalf of mainframe USA Confidential customers, ensuring high-level customer satisfaction with all Problem Management Report (PMR) calls.

DB2 Database Administrator

Confidential

Responsibilities:

  • Performed DBA for SQL Server 2008/2012, DB2 (z/OS / Linux, Unix, Windows).
  • 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/Linux and Windows. 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.
  • 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.
  • Tested 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
  • Analyze and create MONGODB resources with MDM V11, over Confidential InfoSphere Information Enterprise server 11.3 for Windows on Basic configuration.
  • Improved MDM/DB2/SQL performance and troubleshooting through InfoSphere architectures (MPP, SMP, distributed tiers) based on customer requirements .
  • Implemented and improved Windows scripts, Linux/Unix scripting to run SQL and DB2 SQL functions over Confidential WebSphere ND V7/V8.
  • Provided Level-3 customer relationship (CRM) support, MDM troubleshooting DDL / DML through stack trace analysis.
  • Led development and tested Master Data Manager (MDM) database objects for DB2 / Oracle RAC cluster / SQLServer, and Informix, contributing on six successful MDM releases. I help to test MDM and QREP/CDC features with MDM.
  • Developed and installed database assets for MDM on DB2 (z/OS), earning high customer satisfaction levels and increasing revenue by allowing Confidential customers to install MDM on mainframe.
  • Implemented/tested and certified DB2 database resources for Info-Sphere Master Data Manager Confidential product using Agile/DevOps technology for six successful releases.

Environment: DB2 UDB LUW 9.5/9.7/10.1/10.5 EEE/DPF, AIX 6.1,7.1. Linux, ERWIN, IDA, Q-Replication, Quest, WAS server 6.0, Data Stage, MDM, SQL server 2008r2, 2012, Oracle 9i - 12c versions.

Confidential

SQL DBA / Visual Basic Developer

Responsibilities:

  • Created Visual Basic module application (Web Page / JSP) for company webpage, resolving customer issues identified in previous versions.
  • Developed Vendor Audit Management (VAM) system for the Quality Management dept. on MS SQL Server 2005. Developed stored procedures with T-SQL and created ASP-pages with VBScript. Designed DTS/SSIS-data import solutions. The developed system was used by ~120 users across Nestle Canada and Nestle USA.
  • - Developed Marketing Consumer Relation Management system for marketing dept. Built MS SQL 2005 database, created T-SQL-scripts for the data de-duplication.
  • - Performed automated data loads with SSIS, provided data pulls according to the business requests.
  • - Planned, built and supported ~40 Prod instances of the MS SQL Server 2008/2005, installed patches and updates.
  • - Configured backup and performed restores. Performed performance tuning with SQL Profiler, improved the applications performance.
  • - Successfully implemented High Availability solutions - DB mirroring, Transaction Log shipping and backup replication processes.

Environment: Windows 2003/2000, XP, MS-SQL Server 2000, System Monitor / Performance Monitor.

Hire Now