DANIEL LEWIS

3886 Masonic Drive
Bozeman, MT 59718
(123)-748-7255


CAREER SUMMARY
  • Senior DBA Professional with expertise on IBM MVS zOS DB2 and IMS mainframe platforms and proven success in evaluation, installation, customization, maintenance, reorganization and recovery.
  • Knowledge of physical database design and experience in modifying PSBs and DBDs, creating databases, tablespaces and indexes per development specifications.
  • Mentored junior DBA’s and managed 14 technical professionals in areas of performance management, rating, scheduling, adherence to corporate policies and procedures, training and development.
  • Proven success developing results oriented team using leadership, problem solving, and interpersonal and organizational communication skills.
EDUCATIONAL QUALIFICATIONS
Course (Stream)/ Examination
Institution/University/School
Year of Passing
Performance
Bachelor of TechnologyAnna university201480%
HSCSAMS Higher Secondary School201084%
SSLCVetri Higher Secondary School

2008

80%

SKILLS
  • Platforms: IBM Mainframe MVS zOS
  • Languages: SQL, DDL, DCL, DQL, REXX, CLIST, SAS
  • DBMS: IBM IMS zOS DB and DC V9
  • RDBMS: IBM DB2 zOS V8
  • IBM IMS HA Tools: Copy, Reorg, Recovery, Index Builder, Change Accum, Pointer Checker, DBRC, Omegamon
  • IBM DB2 Tools: Unload, Load, Copy, Reorg, Recovery, Check.
PROFESSIONAL EXPERIENCE

 

Mainframe Programmer Analyst
XYZ Companies

January 2016 – Present
Worcester, MA

  • Assisted in installation, maintenance and support for DB2 and IMS database systems.
  • Provided assistance for research, planning and execution of new database upgrades and patches.
  • Conducted detailed research and development activities to support new technology for groups.
  • Prepared technical documentation for policies and standards based on database management.
  • Formulated procedures for tasks such as database configuration, capacity planning and performance tuning.
  • Coordinated with application development teams for resolution of issues relating to database performance and functionality.
  • Automated processes for implementation and testing of data backup and recovery plans.
  • Worked with technical teams for operational support of Oracle and SQL server databases.

 

IMS DBA
ABC Technologies

November 2014 – January 2016
Hudson, OH

  • Supported technical team members for installation, configuration and maintenance of DBMS software applications.
  • Assisted in development and implementation of relational databases for overall enterprise.
  • Formulated effective procedures for maintenance and improvement of DB performance and scalability.
  • Coordinated with technical teams for database security, diagnostic maintenance and permissions.
  • Automated processes of all database systems by utilization of scripts and stored procedures.
  • Provided technical assistance for monitoring and selection of software products for data management.
  • Participated in support service, query and analysis to ensure efficient database access processes.
  • Conducted problem analysis and resolution of problems relating to application software products.
ADDITIONAL INFORMATION

Proficient in working with software and utilities:

  • MVS
  • TSO
  • JCL
  • SAR

Efficiently managed database operations:

  • Performance tuning
  • Database Backup and Disaster Recovery
  • Security management

Sound knowledge of:

  • LEAN methodologies
  • Data models and dictionary
  • Database architecture concepts

Strong capability to perform:

  • DB2 command line creation and execution
  • DB2 performance tuning
  • Database scripts