Santosh Anand
Summary
Four years’ experience as certified DB2/UDB DBA
Performed database system and SQL performance tuning by rewriting SQL and using Snapshot, Table Function, Event Monitor, and OS commands(topas, vmstat, and iostat), updating DB and DBM configuration parameters, using Explain Plain, db2exfmt, and db2expln tools, and running the reorgchk, reorg, runstats and db2rbind commands
Planned, designed, implemented, and promoted the physical databases, table spaces, tables, views, Indexes, Triggers, and securities into the Develop, QA, and Production environment by making procedure of shell scripts.
Implemented and managed DB2 Security using OS group and user ID, DB Authentication, DB Authorization, and database object privileges
Created, maintained and implemented Stored Procedures (COBOL, SQL) and Triggers in DEV, QA, and Production database system
Established backup and recovery strategies (Full, Online backup) using Korn shell scripts
Planned and implemented HADR (High Availability Disaster Recovery) environment by preparing Primary database and Standby database, configuring parameter, and cloning the primary database (backing up primary database and restoring to standby database)
Designed and implemented logical and physical database using CASE tools.
Planned, Designed, and implemented MDC, MQT, and Data partitioning for improving performance
Planned, designed and implemented backup schedules and procedures, and DB system
Monitoring system with Unix Shell scripts on the Develop, UAT, and Production environment
Built and managed data mart and large data warehouses on DPF (EEE) system
Developed and implemented backup(online, offline), runstats, reorg, rebind, and tablespace capacity monitoring report using Korn shell scripts on DEV, QA(UAT), and PROD system.
Overview
29
29
years of professional experience
Work History
East of NGEF
Tailor
American Express, made
07.2006 - 10.2007
Publishers
10.2007 - 08.2008
- MF-COBOL, PL1, JCL, DB2 UDB
AT&T Inc
08.2008 - 09.2010
- Environment : COBOL, PL1, ColdFusion
UnitedHealth Group
09.2010 - Current
New York Life – FUELS
09.2010 - Current
Education
COBOL - undefined
B.Sc. - Statistics
Gujarat University
MCA - undefined
Nirma University
DB2 Associate Exam 730 (DB2 Version 9) 2) DB2 UDB DBA Exam 731 (DB2 Version 9 - undefined
Skills
- Skillset:
- JCL, COBOL, PL/I, REXX, CLIST
- VASM, DFSORT, FileAid
- DB2, IMS/DB, IDMS
- R, SAS, SAS/STAT, SAS/SQL SPSS
- Shell Scripting, UNIX Utilities (GREP, SED, AWK)
- PowerShell, VBScript, VBA
- MS-EXECL,
- MS-PowerPoint, MS-WORD
- ColdFusion, JavaScript, HTML5
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
UnitedHealth Group
09.2010 - Current
New York Life – FUELS
09.2010 - Current
AT&T Inc
08.2008 - 09.2010
Publishers
10.2007 - 08.2008
Tailor
American Express, made
07.2006 - 10.2007
East of NGEF
COBOL - undefined
B.Sc. - Statistics
Gujarat University
MCA - undefined
Nirma University
DB2 Associate Exam 730 (DB2 Version 9) 2) DB2 UDB DBA Exam 731 (DB2 Version 9 - undefined
Similar Profiles
Fatima AmanFatima Aman
Kitchen / Floor Assitant at East Is EastKitchen / Floor Assitant at East Is East
Katy WaltersKaty Walters
RN Case Manager at East Texas Medical Center/ UT Health East TexasRN Case Manager at East Texas Medical Center/ UT Health East Texas
Jyoti SinghJyoti Singh
Restaurant Shift Manager/Server at East Is EastRestaurant Shift Manager/Server at East Is East
Cathy Mih TaylorCathy Mih Taylor
NA at NANA at NA
Danielle MarnerDanielle Marner
NA at Exploration Station (Pediatrics) | HCA Aventura (Med-Surg I, Psychiatry) | HCA Kendall (Med-Surg II) | HCA Mercy (Neuro) | Jackson Medical Center (Obstetrics- Maternity Unit) | Jackson Main (Leadership - ICU) | Northshore Medical Center (Oncology)NA at Exploration Station (Pediatrics) | HCA Aventura (Med-Surg I, Psychiatry) | HCA Kendall (Med-Surg II) | HCA Mercy (Neuro) | Jackson Medical Center (Obstetrics- Maternity Unit) | Jackson Main (Leadership - ICU) | Northshore Medical Center (Oncology)