Summary
Overview
Work History
Education
Skills
Hobbies and Interests
Accomplishments
Languages
Timeline
Generic

Vikas Singh

Hyderabad

Summary

Multi-talented database administrator with several years of expertise in designing, testing and coding database solutions in various environments. Motivated self-starter consistently meets deadlines and succeeds in high-pressure environments.

Overview

11
11
years of professional experience

Work History

Lead Database Administrator

Fidelity Investments
Bangalore
02.2022 - Current

Database Administrator

Broadridge Financial Solution
01.2020 - 02.2022

Fidelity Investments
01.2018 - 01.2020

IBM India
01.2017 - 01.2018
  • Multiple projects

Wipro Technology
01.2014 - 01.2017
  • Citi Bank

Education

Bachelor of Computer Application -

Osmania University
India

Intermediate -

Board of Intermediate
Telangana

SSC -

State Board
Telangana

Skills

Legacy Platforms:

  • Core competency in DB2 Mainframe DBA and LUW DB2
  • Good knowledge of IBM Maintenance and Housekeeping Utilities like Load, Reorg and Runstats
  • Good knowledge of backup and recovery strategy on db2 zos
  • Experience on designing objects in different domain
  • Good knowledge on QREP / CDC / HVR replication products
  • Good knowledge on working of application programs and performance tuning
  • Worked on REXX tools to support project work and automation
  • Have experience on problem solving in production, application development and testing support
  • Worked extensively on data refresh activity on prod and dev environment
  • Experience on supporting DBA activities during version migration, tool upgrade
  • Worked on various products and tools like CA Platinum, CA Insight, Detector
  • Worked on performance tuning and application issues during development
  • Resolving production job abends and issues, locking issues and contentions
  • Worked DB2 LUW database administration
  • Good experience in DB2 Fix pack installation, DB2version upgrade
  • Experience in maintaining file system, regular data cleanup and archiving strategy
  • Experience on DB2 offline and online Backup and Recovery strategy
  • Experience on resolving performance issue on database
  • Experience in maintaining Database Configuration Parameters, Tuning Database and Instance level parameters
  • Troubleshooting database issues using db2diag, db2pd, Snapshots
  • Generating DDL using DB2LOOKutility
  • Monitoring query performance by using db2top, monitoring queries
  • Worked on MS sql server database for various project related testing

Cloud:

  • Experience on AWS platform and services
  • Experience on aurora Postgres database administration on AWS

Automations:

  • Experience in coding tools and generating reports using python scripting
  • Worked on various API to generate reports
  • Worked on Tableau / Power BI tools for dashboard and reporting

Hobbies and Interests

Sports, Reading Books, Web Surfing

Accomplishments

  • Walk of Fame
  • Awarded Wipro Walk of Fame for best new Recruit in August2016.
  • Awarded manager choice award on multiple occasions.

Languages

English
Proficient
C2

Timeline

Lead Database Administrator

Fidelity Investments
02.2022 - Current

Database Administrator

Broadridge Financial Solution
01.2020 - 02.2022

Fidelity Investments
01.2018 - 01.2020

IBM India
01.2017 - 01.2018

Wipro Technology
01.2014 - 01.2017

Bachelor of Computer Application -

Osmania University

Intermediate -

Board of Intermediate

SSC -

State Board
Vikas Singh