We provide IT Staff Augmentation Services!

Server Administration Resume Profile

3.00/5 (Submit Your Rating)

PROFILE

Technology enthusiast who likes to keep updated on latest offerings especially in Open Source world. 3 years of varied experience performing relational database administration/development, SQL Tuning, Production support for DB2 and CICS, Server administration.

Process

ITIL V3 Foundation

Domain:

Loma Level 1 LOMA 281, LOMA 291

TECHNICAL SKILLS:

Languages

COBOL, JCL, SQL, C .

Databases

DB2 V10 for Z/OS, MongDB, SQL Server.

Operating Systems

Z/OS, Windows 7,Windows Server 2008/2012, RHEL 6, Suse Linux 11

Technologies

DB2 V9, V10 , CICS V4.1 , IBM Utilities, VSAM

Tools

FILEAID, CHANGEMAN, JOBTRAC, OMEGAMON for CICS/DB2, TSO, ISPF, AVRS, CA Database Management Suite for Z/OS, CA OPS/MVS, IPCP, IBM Data Studio, SPUFI, QMF, BMC Remedy, DB2 Connect

Miscellaneous

Ms-Office, Lotus notes

CAREER PROFILE

Confidential

Position Lead DB2 Application Database Administrator

Responsibilities

  • Running IBM DB2 Utilities and CA Platinum Utilities
  • Periodical checking of all DDL's for consistency across different environments
  • Reviewing SQL's for all new programs, supporting promotion and testing of code as it moves from QA, UAT, E2E and finally to PROD.
  • Root-cause analysis of DB2 Production issues and providing permanent fixes.
  • Performing upgrade for databases and various tools used on newer releases.
  • Conducting learning sessions across teams for Improving competency on DB2
  • Co-ordinating sessions between Application team, Data Modelling team and System DBA's for improving processes.
  • Logging Process Improvement techniques in internal database and sharing it across organisation

Achievements

  • Reducing DASD Consumption for Database Objects by implementing Tablespace Compression and automatic resizing of VSAM datasets resulting in more than 15,000 savings per year
  • Replaced Traditional Image copies by Incremental Flash copies saving 10,000 per year
  • Fine tuning and rewriting the SQLs of application programs to optimize performance resulting in less CPU Consumption Activity resulted in saving more than 20,000 per year

About the Project

Client is one of the largest and most diversified financial services institutions in the world. My team, the Development DBA Group for the Individual Life Insurance is responsible for Developing and Administering the DB2 Database Infrastructure and for maintaining Data in all Non-Production Environment.

Confidential

Title USA-GBTS-Offshore

Position DB2 Production Database Administrator/ CICS Administrator

Responsibilities

  • Responsibilities as a DB2 Application Database Administrator includes:
  • Maintaining and upgrading Production Databases and related objects.
  • Performing yearly Archival and Migration activities for different applications.
  • Planning and Participating in Disaster Recovery Tests.
  • Creating periodic reports for Historical Tracking and Performance Improvement.
  • Hands-on experience in troubleshooting Production DB2 Issues.
  • Attending change control meetings and coordinate change implementation.
  • Responsibilities as a CICS Application Administrator includes :
  • Creating new CICS Regions and Defining Resource definitions for Applications online need.
  • Upgrading CICS regions and vendor tools Omegamon, IPCP, Xpeditor and Hiperstation in CICS systems on newer releases.
  • Establishing ISC MRO connections between regions for Intersystem communication.
  • File allocation and de-allocation through batch and online.
  • Controlling CICS region through schedules created by using SSM System Schedule Manager and monitoring the Performance of CICS regions using Omegamon
  • Troubleshooting CICS region issues and On-call support during off-hours.

About the project

Client is one of the critical groups for production management services for major global financial sector companies. We provided uninterrupted availability of applications for use by Business partners and availability of data and reports through the applications as and when required. Service provided includes all aspects of installation, coordination, monitoring, tuning, and expediting operation of both batch and on-line applications including databases for the enterprise.

Confidential

Training Basic Network/Server Administration

Specialized Training in Windows Server Administration.

Final Project

Successfully deployed a Server Infrastructure consisting of AD Server, DNS Server and Web Server in a Test Environment

We'd love your feedback!