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.