We provide IT Staff Augmentation Services!

Senior Database Administrator/architect Resume

SUMMARY:

  • Dynamic and accomplished professional with 10+ years of experience in IT industry
  • Proactive decision maker, seeking to be a Senior Database Administrator/Program Manager/Delivery Manager with a well established and globally reputed organization.
  • Worked as the Primary DB2 for Z/OS Database Administrator in the Centralized Database Administration Team for Prudential and Lloyds Bank UK.
  • Efficient Team Leader with sound communication, interpersonal, negotiation and problem solving skills. Also very good analytical, leadership and multiple task managing capabilities.
  • Involved extensively in Performance Tuning of Application SQLs.
  • Good knowledge on IBM’s Performance Tools like Data Studio, Visual Explain and Platinum Detector for Z/OS
  • Sound knowledge on PLAN TABLE - and manual EXPLAIN, to survive in the world of No Performance evaluation tools
  • Worked with Data Modelling team to design Database objects for applications from scratch. Also to enhance existing relational databases.
  • Worked in IBM Websphere Replication Server for Z/OS. Setting up Capture, Apply tables for replication of data
  • Worked in Infosphere Q Replication for Z/OS - that replicates data from 4 instances to an Operational Data store.
  • Played a major role in the design of a Performance Monitoring System for DB2 applications
  • Involved in Performance Tuning of DB2 Queries and saved more than half a million dollars in CPU Time for Prudential
  • Planned, Designed and executed the DB2 Version 8 and Version 9 upgrade for DB2 Z/OS. Currently involved in DB2 V10 Migration
  • Primary DBA for a 24 x 7 mission critical application - with volumes ranging in 100-200 millions.
  • Acting as Senior DBA with good knowledge on Database, and supporting multiple application teams across Prudential
  • Acting as a Lead managing different applications to successfully deliver projects of various sizes.
  • Recommending efficient System solutions for
  • Critical Reports
  • Projects involving cleaning up of large amount of data.
  • Projects involving update of large amount of data
  • Performing Database Requirement Analysis, Database Design.
  • Maintained Database Security by providing proper authorities and privileges.
  • Developing Data Definition Language for implementation across End to End, QA, UAT and Production
  • Performing proactive Database Maintenance, Improving Space Utilization and thereby cost
  • Conducting volume testing, performance tuning
  • Providing periodical status report including plan, progress and risks to the stakeholders to ensure smooth progress of project activities.
  • Periodically monitoring & improving system performance.
  • Mentoring & training junior DBAs to attain overall project & organizational objectives.
  • Conducted business & system impact analysis, risk assessment, end-to-end effort estimation.
  • Translated business requirements into detailed specifications and managing design & development activities.

TECHNICAL SKILLS:

Database & Tools: DB2 for Z/OS, SPUFI, QMF,Platinum Detector,Data Studio, BMC Change Manager

Languages: COBOL, JCL, Rexx, ISPF Panels, VB.NET(Developed a small application)

Operating Systems: OS/390

File Management: VSAM, File-Aid

Communication: CICS, TSO/ISPF

Other Tools: Changeman, Strobe, Omegamon

Application Package: MS Office (Excel, PowerPoint, Word), MS Visio

PROFESSIONAL EXPERIENCE:

Confidential

Platform: Z/OS 390

Software/Tools: DB2 Utilities

Database: DB2 Z/OS V8, DB2 Z/OS V 10

Senior Database Administrator/Architect

Responsibilities:

  • Working as a DB2 Specialist/Architect and since this operational data store is in the receiving end, analyses the impact w.r.t DB2
  • Database Administrator for Development, SIT, ST, OAT Databases.
  • Involved in the Database Requirement Analysis, Database Design.
  • Creation of Database objects like Tablespace, Tables, Indexes, Views, Stored Procedure, Triggers implementation across Development, QA, End to End, User Acceptance databases.
  • Coordinating implementation of Database Objects in Production Databases
  • Running Backup - Image Copies, Unload at regular intervals or on an On Demand basis.
  • Restoring Database or specific tables, with Image Copies, Unload Files
  • Maintained Database Security by providing proper authorities and privileges.
  • Performing REORG, RUNSTATS, MODIFY and other maintenance activities for all the databases at regular intervals.
  • Analyzing Performance Problems for different application SQLs, using Plan Tables, Visual Explain, Detector etc.
  • Tuning the existing SQLs, Suggesting Indexes to save the CPU time and the Run Time.
  • Working on Tools like BMC Change Manager, CA Detector, SQL Explorer which helps in the definition and performance monitoring
  • DB2 Migration
  • Documenting the new features of DB2 V9, V8 based on the upgrade
  • Coordinating with application teams, to benchmark performance and functionality in lower version. Compare, analyse the performance in the upgraded version.

Confidential, Newark, NJ

Senior Database Administrator

Responsibilities:

  • Database Administrator for Development, Quality Assurance, End to End and User Acceptance Databases.
  • Involved in the Database Requirement Analysis, Database Design.
  • Database objects like Tablespace, Tables, Indexes, Views, Stored Procedure, Triggers implementation across Development, QA, End to End, User Acceptance databases.
  • Coordinating implementation of Database Objects in Production Databases
  • Running Backup - Image Copies, Unload at regular intervals or on an On Demand basis.
  • Restoring Database or specific tables, with Image Copies, Unload Files
  • Maintained Database Security by providing proper authorities and privileges.
  • Performing REORG, RUNSTATS, MODIFY and other maintenance activities for all the databases at regular intervals.
  • Analyzing Performance Problems for different application SQLs, using Plan Tables, Visual Explain, Detector etc.
  • Tuning the existing SQLs, Suggesting Indexes to save the CPU time and the Run Time.
  • DB2 Migration
  • Documenting the new features of DB2 V9, V8 based on the upgrade
  • Coordinating with application teams, to benchmark performance and functionality in lower version. Compare, analyse the performance in the upgraded version.

Confidential

Database Administrator/Team Lead

Responsibilities:

  • Database Administrator for Development, Quality Assurance, End to End and User Acceptance Databases.
  • Involved in the Database Requirement Analysis, Database Design.
  • Database objects like Tablespace, Tables, Indexes, Views, Stored Procedure, Triggers implementation across Development, QA, End to End, User Acceptance databases.
  • Coordinating implementation of Database Objects in Production Databases
  • Running Backup - Image Copies, Unload at regular intervals or on an On Demand basis.
  • Restoring Database or specific tables, with Image Copies, Unload Files
  • Performing REORG, RUNSTATS, MODIFY and other maintenance activities for all the databases at regular intervals.
  • Maintained Database Security by providing proper authorities and privileges.
  • Analysis, Design and SQL Coding
  • Worked in all phases of Software Development Life Cycle
  • Involved in Analysis of Business Requirements, Project Estimation and Resource Planning.
  • Involved in Preparing System Design Document, Installation Guidelines and Detailed Test Plan.
  • Involved in high-level design for major projects.

Confidential

Application Team Lead

Responsibilities:

  • Worked as a Tech Lead
  • Involved in the Database Requirement Analysis, Database Design.
  • Worked as a Module Leader and lead a team of 10 associates.
  • Worked as a Module Leader for Production Core Remedy Fix team.
  • Involved in Analysis of Business Requirements, Project Estimation and Resource Planning.
  • Involved in Preparing System Design Document, Installation Guidelines and Detailed Test Plan.
  • Involved in high-level design for major projects.
  • Development of new Mainframe Application Programs(CICS-DB2 and COBOL-DB2)
  • Review the work items developed by the team members
  • Development, Testing and Documentation of all the projects.
  • Coordinating the Business Requirements, Delivery with the Onsite Team.

Confidential

Developer

Responsibilities:

  • Worked as a Team Member
  • Involved in the Database Requirement Analysis, Database Design.
  • Involved in Analysis of Business Requirements, Project Estimation and Resource Planning.
  • Development/Enhancement of Mainframe Application Programs(CICS-DB2 and COBOL-DB2)
  • Development, Testing and Documentation of all the projects.
  • Coordinating the Business Requirements, Delivery with the Onsite Team.

Hire Now