Nirmal Dileep
Mainframe Database Administrator
Cochin
Summary
Dedicated IT professional with history of meeting company goals utilizing consistent and organized practices. Skilled in working under pressure and adapting to new situations and challenges to best enhance the organizational brand.
Overview
14
14
years of professional experience
6
6
years of post-secondary education
3
3
Certifications
Work History
Database Administrator /Developer
TATA Consultancy Services- Client : US based Utility company
06.2017 - Current
- Ensure integrity, availability and performance of Various RDBMS database systems by providing Development,technical support and maintenance.
- Experience in constructing database triggers,stored procedures,Tables,views ans masks.
- Has implemented Enterprise Data warehouse for the customer.
- Assist in capacity planning, space management and data maintenance activities for database system.
- Monitor database performance and recommend improvements for operational efficiency.
- Assist in implementation of new features and program fixes in databases.
- Support the application developers in SQL review and optimization and stored proc creation.
Database Administrator
TATA Consultancy services- Client: US based Credit card company
11.2014 - 05.2017
- Perform database enhancement and modification as per the requirements including design,development and enhancement.
- Perform/Review database recovery and backup tasks on daily and weekly basis.
- Developed and review DB objects like Dynamic SQLs,Stored procedure and Triggers.
- Maintain database security and disaster recovery procedures.
- Perform troubleshooting and maintenance of multiple databases.
- Oversee utilization of data and log files.
DB2 Developer/DBA
TATA Consultancy Services-Client :UK based major telecom company
08.2010 - 10.2014
- Developed and executed complex application modules using Shell script,COBOL,REXX and JCL.
- Monitor databases regularly to check for any errors such as existing locks and failed updates.
- Evaluated and implemented enhancement design solutions to improve cost, quality and performance of software applications.
- Manage database logins and permissions for users.
Education
Bachelor of Technology - Electronics And Communication Engineering
Federal Institute of Science And Technology
Kerala,India 05.2005 - 06.2009
Higher Secondary - Computer Science
Sacred Hearts Higher Secondary School
Cochin,India 05.2003 - 07.2005
High School Diploma -
C.C.P.L.M High School
Cochin,India 04.2001 -
Skills
Database : DB2 LUW,SQL server DB,DB2 mainframe,IMS
SQL,COBOL,Shell script
ZOS administration
Oracle DB
ZVM
Languages
English
Excellent
Hindi
Very Good
Malayalam
Excellent
Certification
IBM DB2 for zOS DBA Certification
Software
IBM DB2 Admin tool,BMC DB2 Admin tool
IBM log Analyzer, RC Migrator, QMF,DB2 automation tool,
CA7, TWS, Tivoli output Manager, Control D
SSMS,Oracle SQL developer,Toad
Timeline
Database Administrator /Developer
TATA Consultancy Services- Client : US based Utility company
06.2017 - Current
Database Administrator
TATA Consultancy services- Client: US based Credit card company
11.2014 - 05.2017
DB2 Developer/DBA
TATA Consultancy Services-Client :UK based major telecom company
08.2010 - 10.2014
Bachelor of Technology - Electronics And Communication Engineering
Federal Institute of Science And Technology
05.2005 - 06.2009
Higher Secondary - Computer Science
Sacred Hearts Higher Secondary School
05.2003 - 07.2005
High School Diploma -
C.C.P.L.M High School
04.2001 -
IBM DB2 for zOS DBA Certification
DP-900: Microsoft Azure Data Fundamentals
AZ-900: Microsoft Azure Fundamentals
Similar Profiles
Nilesh KhunteNilesh Khunte
SENIOR MANAGER - OPERATIONS AND INSURANCE DOMAIN CONSULTANT at TATA CONSULTANCY SERVICES (CLIENT -LEADING EU INSURANCE COMPANY)SENIOR MANAGER - OPERATIONS AND INSURANCE DOMAIN CONSULTANT at TATA CONSULTANCY SERVICES (CLIENT -LEADING EU INSURANCE COMPANY)
Shrikant KateShrikant Kate
SAP FICO Consultant and Scrum Master at Client: American Audio Equipment Manufacturing Company. Employer: Tata Consultancy ServicesSAP FICO Consultant and Scrum Master at Client: American Audio Equipment Manufacturing Company. Employer: Tata Consultancy Services
Jerin MathewJerin Mathew
Cloud Infrastructure Engineer at TATA Consultancy Services (TCS) Client: VerizonCloud Infrastructure Engineer at TATA Consultancy Services (TCS) Client: Verizon