Lead DBA
Resume:
ALI NAWAZ AHMED J
H*B Visa
acn4h3@r.postjobfree.com
Stamped
in.linkedin.com/pub/ali-nawazahmed-jameel/a8/411/36b/
PROFILE
Versatile and highly motivated IT professional with approximately 4 years of experience in IBM DB2 and
Microsoft SQL Server Platforms as DBA with a large financial client.
PROFESSIONAL CERTIFICATIONS
Technical
IBM Certified Database Administrator- DB2 10 for Z/OS
IBM Certified Database Administrator- DB2 10.1 for Linux UNIX and Windows
IBM Certified Database Associate - DB2 10.1 Fundamentals, DB2 9 Fundamentals
IBM Certified Solution Advisor - Cloud Computing Architecture V3
IBM Certified Specialist - Midrange Storage Technical Support V3
Microsoft Certified Solutions Associate - Windows Server 2012, SQL Server 2012
Microsoft Certified Technology Specialist
- Administering and Deploying System Center 2012 Configuration Manager
- Server Virtualization with Hyper-V and System center 2012
-Implementing Microsoft Azure Infrastructure
VMware Certified Associate – Cloud Fundamentals, Datacenter Virtualization
Process
ITIL V3 Foundation
Domain
Loma Level 1(LOMA 281, LOMA 291)
Partner Accreditation
MongoDB for DBA’s, Red Hat Delivery Specialist.
TECHNICAL SKILLS:
Languages COBOL, JCL, SQL, C++
Databases DB2 V9,10 for Z/OS,DB2 V9.7,10.1 LUW (HP-UX), MongoDB, SQL Server 2012
Operating Systems Z/OS,HP-UX, Windows 7, Windows Server 2008/2012, RHEL 6, Suse Linux 11
DB2 (V9, V10), CICS (V4.1), IBM Utilities, VSAM, SQL Server 2012, Microsoft
Technologies
Azure
SQL Server Management Studio,Profiler,Perfmon,Activity Monitor,System
Monitor,SSIS
FILEAID, CHANGEMAN, JOBTRAC, OMEGAMON for CICS/DB2, TSO, ISPF,
Tools
$AVRS, CA Database Management Suite for Z/OS, CA OPS/MVS, IPCP, IBM Data
Studio, SPUFI, QMF, BMC Remedy, DB2 Connect, Visual Studio, SQL Server
Management Studio
Miscellaneous Ms-Office, Lotus notes
CAREER PROFILE
Nov 2012 –Till Date Tata Consultancy Services
Title USA-ILI-DBA-Core-Offshore
Position Lead Database Administrator, Server Administator
Responsibilities Team Lead for a team of 5 members
Responsibilities as Lead Database Administrator :
• Installed and configured DB2/SQL instances
• Executed database utilities on a daily basis
• Ensured DDL consistency across different environments
• Refined SQLs for programs yielding CPU cost/time savings
• Oversaw promotion and testing of code as it moves from QA, UAT, E2E and finally to PROD
• Resolved Database Production issues by doing Root-Cause Analysis and providing permanent
fixes
• Orchestrated upgrade of databases and various tools used on newer releases
• Facilitated learning sessions across teams for Improving Competency on Database technologies
• Chaired team meetings between Application team, Data Modelling team and System DBA’s for
improving processes
• Documented Process Improvement techniques and shared it across organisation
Responsibilities as Server Administrator :
• Provided system administration support, user account setup and Group policy setup for offshore
• Served as first point of contact for any Network/Server issues in offshore ODC.
• Facilitated patch upgrades and software upgrades.
• Audited all PC’s for software compliance.
Achievements
• Devised DASD space reduction for Database Objects by implementing Tablespace Compression and
automatic resizing of 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 SQLs of application programs to optimize performance resulting in less CPU
Consumption 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
Database Infrastructure and for maintaining Data in all Non-Production Environment.
Project Location TCS, Chennai, India
May 2011 – Nov 2012 Tata Consultancy Services
Title USA-GBTS-Offshore
Position DB2 Production Database Administrator/ CICS Administrator
Responsibilities
Responsibilities as DB2 Application Database Administrator :
• Maintained Production Databases and related objects.
• Performed yearly Archival and Migration activities for different applications.
• Planned and Formalized Disaster Recovery Tests.
• Developed periodic reports for Historical Tracking and Performance Improvement.
• Resolved Production Database Issues during office hours and during On-call support.
• Chaired change control meetings and coordinated change implementation.
Responsibilities as CICS Application Administrator :
• Designed CICS Regions and defined resource definitions for applications online need.
• Performed CICS regions and vendor tools upgrade (Omegamon, IPCP, Xpeditor and Hiperstation)
• Established ISC/MRO and MQ connections between regions.
• Controlled file allocation and de-allocation through batch and online.
• Controlling CICS regions 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 clients.
Project Location TCS, Chennai, India
EDUCATIONAL QUALIFICATION
Bachelor of Technology, Information Technology, 77% (May 2011), Anna University, Chennai
Higher Secondary, 88.87% (March 2007), St. Mary’s Anglo Indian Higher Secondary School, Chennai
High School, 90.6% (March 2005), St. Mary’s Anglo Indian Higher Secondary School, Chennai
Final Year Undergraduate Project
Knowledge Based Association Rule Mining Using Ontologies
• Proposed a new interactive approach to prune and filter discovered rules
• Used ontologies in a post processing task to improve integration of user knowledge and also proposed
Rule Schema formalism
PERSONAL DETAILS
DOB/Sex/Nationality December 23, 1989/Male/Indian
Passport Details J310471, Valid up to Jan 24, 2021
H1B visa stamped and valid till August 2017
Hobbies and Interests Actively participating in courses offered by MIT, Stanford, MongoDB and BigData
Universities to learn new technologies
I hereby declare that the details provided above are true to the best of my knowledge.
Contact this candidate