We provide IT Staff Augmentation Services!

Senior Dba Resume

Fort Worth, TX

SUMMARY

  • IBM certified Database Administrator with over 16+ years of IT experience in Database Administration as DB2 UDB DBA having extensive experience in installation, database development, implementation and maintenance of large databases.
  • Worked on UDB v8, V9.5, V 9.7. V 10.1 and V 10.5
  • Upgraded databases from V 9.7 to V 10.1.
  • Extensive experience in installation of DB2 UDB for LUW Administration tools like Database Studio, Optimum Database Administration, Control center, Command line processor, Configuration assistant, Script center, Alert Center.
  • Read and Write complex SQL queries and understand the business that necessitates that complexity.
  • Knowledge on database administration for Oracle 9i, 10g and 11g, with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
  • Setup backup and recovery procedures using oracle rman tools.
  • Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management and Security Administration.
  • Deployed shell scripts in multiple servers.
  • Performed SQL Tuning, DB/DBM parameter tuning and different levels of memory allocations
  • Written scripts to automate the jobs (REORG, RUNSTATS & BACKUP) to monitor daily activities.
  • Extensively worked on Performance Tuning, recommended SQL Queries for better performance using snapshot monitor, db2top, db2 index advisor and db2exfmt.
  • Enhanced application performance using runstats, reorgchk and reorg utilities.
  • Supported OLTP databases for transportation, end to end support of new builds and applications.
  • High availability (HA) and disaster recovery (DR) experience with DB2 HADR
  • Instance and database monitoring and tuning experience using the DB2 Health Center, Snapshot and Event monitors to monitor and optimize instance and database configuration parameters, table spaces, and buffer pools.
  • Database utility experience including reorg, runstats, rebind, export, import, load, auto - load, backup, restore and recover database utilities.
  • Database backup and recovery experience with online full and incremental backups, online and offline transaction log archiving, restore and roll-forward (including redirected restore), and recover database utilities.

PROFESSIONAL EXPERIENCE

Confidential, Fort Worth, TX

Senior DBA

Responsibilities:

  • Assisted in installation, management and tuning of Netezza databases and other records.
  • Performed backup and recovery functions of databases through third party devices and Netezza utilities.
  • Provided technical assistance for efficient performance and security functions of Netezza databases.
  • Implemented procedures for allocation of hardware resources and performance tuning methodologies.
  • Suggested enhancement methods, rollout and upgrades for maintenance of existing databases.
  • Executed processes for timely release of database changes as per assigned timelines.
  • Maintained system documentation of best database procedures, practices and standards.
  • Resolved database problems and issues by troubleshooting and responding to service requests.
  • Installed and configured DB2 V10.1 HADR environment
  • Experience in loading data into Netezza using NZLOAD utility
  • Experience in loading data between Netezza tables using NZSQL utility
  • High availability (HA) and disaster recovery (DR) experience with DB2 HADR
  • Supported Data Mart and Data warehousing environment.
  • Designing system storage structure and planning future storage requirements (design & analysis of file systems, logical volumes, raw containers)
  • Implemented instance level and database level configuration parameters for database concurrency, authentication, performance and allowing remote clients accessing server
  • Database objects creation & alteration (tables, indexes, views, stored procedures, functions, etc.)
  • Worked in data movement utilities IMPORT, LOAD, and EXPORT.
  • Tuned databases using tools like snapshot monitor, visual explain, Index adviser, db2expln, db2exfmt.
  • Federated database server creation in order to allow access of another databases (DB2 or non-DB2) inside a DB2 database.
  • Database performance tuning and troubleshooting & fixing problems faced by application developer
  • Query tuning for the problematic queries sent by application developer or identified during database monitoring
  • Exploring the use of Multi-Dimensional Clustering (MDC) & Materialized Query table to enhance the system performance if required.
  • Database backup & recovery (offline & online backups, Full, Incremental & Delta Incremental). Database cloning using redirected restores.
  • Developing tools using shell/AWK scripts to automate various database administration jobs.
  • Worked with database vendors and external support on issues such as upgrades, technical problems and solutions.
  • Administer the DB2 UDB Databases, including, backups and recovery in DPF.
  • Administer the udb security systems, including user administration and policies and procedures, review of user accounts and user roles.
  • Setup backup and recovery procedures using db2 restore and recover tools.

Confidential -Mclean, VA

Sr. DBA Consultant

Responsibilities:

  • Extensive experience in installation of DB2 UDB for LUW Administration tools like Database Studio, Optimum Database Administration, Control center, Command line processor, Configuration assistant, Script center, Alert Center.
  • Responsibilities include disaster recovery, capacity planning, and Real Time monitoring, troubleshooting, and proactive maintenance.
  • Implemented HADR and High availability in DB2 UDB.
  • Strong in performance monitoring and fine-tuning of database for optimal performance of SQL queries using Visual Explain.
  • Data maintenance utilities used REORGCHK, REORG, RUNSTATS, BACKUP, RECOVER/RESTORE, LOAD, QUIESCE, IMPORT, EXPORT, DB2LOOK, IMPORT and INGEST
  • Read and Write complex SQL queries and understand the business that necessitates that complexity.
  • Knowledge on database administration for Oracle 9i, 10g and 11g, with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
  • Setup backup and recovery procedures using oracle rman tools.
  • Database Sizing, Table space Management and Rollback Table space Management, Transaction Management and Security Administration.
  • Deploying shell scripts in multiple servers.
  • Perform file system copy from production to non-production using TSM backup and recovering DB2 databases in non-prod environment.
  • Offshore Co-ordination, work allocation, mentoring junior DBAs, work review etc..
  • Developed streamlined process for reorgs on different types of table such as cluster, normal, MDC, SAP Cluster, volatile tables etc..
  • Developed and maintained compliance to database standards and procedures.
  • Created Databases and Instances in DB2 UDB and Oracle.
  • Fixpak installation and version upgrades.
  • Implemented Database partitioning and Archival logging in DB2 UDB
  • Database maintenance, backup, recovery, performance monitoring, tuning, maintenance of logs, problem identification and resolution, security and disaster recovery planning.
  • Used DB2 Advisory for optimizing the query.
  • Written shell scripts for monitoring the backup, Restore, Health monitoring.
  • Used Quest central for DB2 Monitoring, db2 performance monitoring etc...
  • Implemented backup compression technique and can support Time finder backups

Confidential -Jersey City, NJ

DBA Consultant

Responsibilities:

  • Provided 24X7 on-call support rotation with staff DBA’s, minimizing downtime of databases.
  • Installation of DB2 UDB EE and Fix packs on UNIX and Windows machines.
  • Install and configure DB2 UDB new releases, upgrades, and patches.
  • 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)
  • Changing instance level and database level configuration parameters for database concurrency, authentication, performance and allowing remote clients accessing server.
  • 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.
  • 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).

Confidential

DBA

Responsibilities:

  • Analyzed the existing legacy system, requirements gathering and source system analysis on data from various servers (internet log files from 45 different servers).
  • Provided physical DB2 database analysis and DB2 database modifications.
  • Conducted performance tuning and SQL EXPLAIN statement
  • Performed tuning and optimization of Data warehousing application. Lead performance testing (database related part) of the new application releases. Proposed and implemented numerous tuning recommendations that helped to improve application performance and scalability, end user response time, significantly decrease database and operating system resources consumption
  • Instituted new data definitions for system enhancements.
  • Creation and maintenance, and performance tuning. Including physical database design, and significant performance tuning of tables, indexes, and application SQL.
  • Loaded data using autoloader on 8(Including catalog node) database partitions (nodes), setting different prefetch sizes.
  • Bringing the database to supported mode as the logs were corrupted and IBM didn’t supported until we bring it to supportive mode.

Confidential

Database Analyst

Responsibilities:

  • Designed the logical and the physical data model for the Hewitt Associates data mart.
  • Capacity planning for the Hewitt Associates Data mart.
  • Generated the People soft SQL Script and running it against Hewitt Associates Data mart.
  • Extensive Performance tuning to optimize the mapping, session, source and target performance by eliminating bottlenecks
  • As a DBA, involved in Tuning Database/Application Engine for Hewitt Associates.
  • Installed People Soft tools (8.19) and HRMS (8.3) on udb/Solaris and created the PeopleSoft DEMO, SYS databases
  • Configured PS Application server, PS process scheduler, PS Tuxedo.
  • Involved in People tools up gradation and SQL tracing in Application designer.
  • Involved in analyzing the performance using tools like Quest Central, Load Runner.
  • Wrote Documentation and Production migration processes
  • Developed and Implemented Unit testing, UAT and System Integration testing
  • Involved in Postproduction support and enhancements

Confidential

Sr.DBA

Responsibilities:

  • As a senior DBA, involved in logical and physical database design of Operational Claims Management System.
  • Performed routine maintenance, database performance tuning and monitoring
  • Used Power Designer modeling tool for Physical/Logical Structure Design.
  • DB2Look utility is used to find all DDL and DML commands in the database
  • Used client application enabler the remote databases are monitored and tuned.
  • Snapshot monitoring was done to detect deadlocks, buffer pools, lock escalations.
  • Involved extensively in migrating data from NON STOP TANDEM using guardian, which gets the data in ASCII test format to DB2 on AIX and NT Systems.
  • Involved in writing scripts to trouble shoot triggers and stored procedures
  • Also worked on a project involved in porting data from AS/400 to UDB database
  • Created Visual Explain Access plans and tuning applications.
  • Designed and trained employees on transitioning from non stop tandem to UNIX environment.
  • Backup/Recovery scripts were written to backup the data.
  • Prepared monthly performance charts, troubleshooting and installation guides.
  • Presented project plans and also involved in preparing time estimates.
  • Involved in training members on database structure, configuration, processes and maintenance.

Confidential

DBA

Responsibilities:

  • Database Backup/Recovery on databases and file system backups. Redirect Restore to move application from Development, QA and Production
  • Advise Business Systems Analysts, technical managers and business users to help them define business requirements and objectives in the implementation of specific area advanced technologies.
  • Analyze past trends and make suggestions to meet future requirements with respect to capacity and performance.
  • Use tools like db2advise, db2look, db2move and db2adutl to monitor, analyze and make changes in the database.

Hire Now