Summary
Overview
Work History
Education
Skills
Certification
Training
References
Badges
Timeline
Generic

MYNAME S

Atlanta

Summary

Accomplished Senior Database Administrator at IBM Corporation with expertise in IBM DB2 and a proven track record in delivering high-availability solutions. Adept at leading project teams and enhancing database performance, I excel in communication and analytical skills, ensuring optimal outcomes in complex healthcare environments.

Overview

21
21
years of professional experience
1
1
Certification

Work History

Senior Database Administrator

IBM Corporation
03.2022 - Current
  • Working as Senior Database Administrator for NASCO MidTier DBA group
  • Analyze and understand Business functional and non-functional requirements
  • Evaluate the existing NASCO Products Frameworks and implement them with required modification to modernize the database system
  • Responsible for delivering database solution to our customer in the Health Care claim processing sector
  • Work as technical subject matter expert around data engineering and architecture
  • Design and implement new architectural solutions for client
  • Responsible for effective communication between the project team and the customer
  • Provide day to day direction to the project team and regular project status to the customer
  • Responsible for Installation, Migration of products, Designing & Creating database Objects
  • Design and develop new databases to support Pega applications and its functionalities
  • Solving problematic issues at Database level and instance level
  • Writing scripts (shell, clp, Perl) to simulate and automate tasks

Senior Staff Software Engineer

IBM India Pvt. Ltd.
09.2016 - 03.2022
  • Working as Senior Database Administrator for NASCO MidTier DBA group
  • Analyze and understand complex Business functional and non-functional requirements
  • Evaluate the existing NASCO Products Frameworks and implement them with required modification to modernize the database system
  • Responsible for delivering database solution to our customer in the Health Care claim processing sector
  • Responsible for effective communication between the project team and the customer
  • Provide day to day direction to the project team and regular project status to the customer
  • Responsible for Installation, Migration of IBM products, Designing & Creating database Objects
  • Deployed the TSAMP automation cluster services across all model office and production environment of NASCO
  • Design and develop new databases to support Pega applications – Navigator & Ncompass
  • Support all the latest releases of DB2 V11, V10.5, V10, V9.8, V9.7, V9.5
  • Implementation of High Availability (TSA Cluster- Failover policies) and Disaster Recovery (HADR) configuration
  • Solving problematic issues at Database level and instance level
  • Writing scripts (shell, clp, Perl) to simulate and automate tasks
  • Use utilities like db2move, db2pd, export, import
  • Taking Backup, loading and unloading of data

Senior Database Administrator

07.2014 - 09.2016
  • Working as Senior Database Administrator for Master Data Hub application
  • Responsible for delivering database solution to our customer in the Banking sector
  • Responsible for effective communication between the project team and the customer
  • Provide day to day direction to the project team and regular project status to the customer
  • Responsible for Installation, Migration of IBM products, Designing & Creating database Objects
  • Support all the latest releases of DB2 V10.5, V10, V9.8, V9.7, V9.5
  • Analyze, gather requirements and write specification and functional design documents for enhancements, new solutions & line items
  • Work with QA to create test scripts and scenarios for enhancements, simulate test environment similar to customer environment

Senior Database Administrator

07.2012 - 07.2014
  • As a Senior Data Administrator responsible for Planning, Developing, Analysis, Database design, Unit Acceptance testing of next generation database solutions and Deployment for IBM customers - American Express (Amex)
  • Responsible for delivering database solution to our customer in the Banking sector
  • Responsible for effective communication between the project team and the customer
  • Provide day to day direction to the project team and regular project status to the customer
  • Utilize in-depth knowledge of DB2 database and other leading-edge IBM products and technology in conjunction with industry and business skills to deliver solutions to customer
  • Responsible for Installation, Migration of IBM products, Designing & Creating database Objects
  • Responsible for implementing recovery strategies
  • Responsible for implementing Cluster services (TSA, HACMP, RedHat Cluster services)
  • Working on all the latest releases of DB2 V10.5, V10, V9.8, V9.7, V9.5
  • Analyze, gather requirements and write specification and functional design documents for enhancements, new solutions & line items
  • Work with QA to create test scripts and scenarios for enhancements, simulate test environment similar to customer environment

Lead Database Administrator

IBM Labs
06.2008 - 07.2012
  • As a Senior Data Administrator responsible for Planning, Developing, Analysis, Database design, Unit Acceptance testing of next generation database solutions in IBM India Software Labs
  • Responsible for Installation, Migration of IBM products, Designing & Creating database Objects
  • Responsible for implementing recovery strategies
  • Responsible for implementing Cluster services (TSA, HACMP, RedHat Cluster services)
  • Working on all the latest releases of DB2 V10.5, V10, V9.8, V9.7, V9.5
  • Analyze, gather requirements and write specification and functional design documents for enhancements, new solutions & line items
  • Work with QA to create test scripts and scenarios for enhancements, simulate test environment similar to customer environment
  • Internal Quality Assurance (IQA)
  • Installing all the versions of DB2 V9.1 & above
  • Upgrade and Migrations of DB2 servers
  • Designing & creating database objects, Tablespaces, Tables, Views, Indexes etc
  • Tuning of queries and performance monitoring
  • Implementation of High Availability (TSA Cluster- Failover policies) and Disaster Recovery (HADR) configuration
  • Solving problematic issues at Database level and instance level
  • Writing scripts (shell, clp) to simulate and automate tasks
  • Use utilities like db2move, db2pd, export, import
  • Taking Backup, loading and unloading of data

Database Administrator

09.2006 - 05.2008
  • As a Data Administrator responsible for Application development support & Production support for all Amex databases
  • Worked as Application DBA & Production support DBA for American express customer
  • Extensive production Support was provided for all UDB instances in AMEX-IM
  • Assisting Application teams in fixing database issues
  • Debugging and Root Cause Analysis
  • Production Support and trouble shooting
  • Extensive production Support was provided for all UDB instances in AMEX-IM

Application Developer & Junior Database Administrator

Infinite Computer Solutions
06.2005 - 09.2006
  • Worked for US Customer MEDCO – Pharmacy Benefit Management
  • Analyze the requirement
  • Preparing design document
  • Participated in the Code and Test cases review
  • Ensuring the quality standards is met
  • Unit Testing
  • User acceptance testing
  • Production Support and trouble shooting
  • Handled UAT and production issues
  • Internal Quality Assurance (IQA)

Technical coordinator

Unique Minds Infotech
08.2004 - 05.2005

Education

Bachelor’s - Mechanical Engineering

Visveswaraiah Technological University (VTU) BMS College of Engineering
Bengaluru, India
01.2003

Skills

  • IBM DB2
  • IBM PureData System for Operational Analytics
  • IBM Netezza
  • MongoDB
  • Cassandra
  • PostgreSQL
  • AWS
  • Microsoft Azure
  • Linux
  • Unix - AIX
  • HP-UX
  • Solaris
  • Windows
  • IBM Infosphere Optim performance Manager
  • IBM Optim Merge Backup
  • BMC Patrol
  • IBM Infosphere Data Replication tool
  • IBM Infosphere Data Architect
  • IBM Data Studio
  • Db2 Toad
  • TSA
  • PowerHA
  • UNIX - Shell Scripting
  • SQL
  • Perl
  • Python
  • Basic Java
  • Big Data
  • R programming
  • DB2 HADR
  • Database administration
  • Database procedures
  • Database structure principles
  • Database design
  • Healthcare
  • Banking
  • Scripting
  • Subject Matter Expert
  • Leadership
  • Analytical skills
  • Organizational skills
  • Communication skills
  • Project management
  • Coordination skills
  • Database security practices
  • Performance tuning
  • Disaster recovery plans
  • Data warehousing
  • ETL tools
  • Agile
  • Scrum
  • Time management
  • Interpersonal skills

Certification

  • AWS Certified Cloud Practitioner
  • AWS Certified Solution Architect – Associate
  • AWS Certified Database – Specialty
  • Azure Cloud Fundamentals – AZ900
  • IBM Certified DB2 11.x Advanced Database Administrator
  • IBM Certified DB2 11.x Database Administrator
  • IBM Certified DB2 11.x Foundation
  • IBM Certified DB2 10.1 Advanced Database Administrator for Linux, UNIX, and Windows DB2 Universal Database V10.1 Family - Exam – 614
  • IBM Certified Database Administrator for Linux, UNIX, & Windows V10.1 Family - Exam – 611
  • IBM Certified Database Associate DB2 Universal Database V10.1 Family - Exam – 610
  • IBM Certified DB2 9.7 Advanced Database Administrator for Linux, UNIX, and Windows DB2 UDB V9.7. Exam – 544
  • IBM Certified DB2 9.7 Database Administrator for Linux, UNIX, and Windows Upgrade DB2 UDB V9.7. Exam – 546
  • IBM Certified Database Advanced Database Administrator for Linux, UNIX, and Windows DB2 UDB V9.1. Exam 734
  • IBM Certified Database Administrator for Linux, UNIX, & Windows – DB2 UDB V9.1. Exam 731
  • IBM Certified Database Administrator for Linux, UNIX, & Windows – DB2 UDB V8.1. Exam 701
  • IBM Certified Database Associate DB2 Universal Database V8.1 Family - Exam – 700

Training

  • Microsoft Azure Data Engineer
  • Python Programming
  • AWS Certified Solution Architect
  • PostgreSQL
  • Quality Management Systems
  • Database Management Systems
  • Testing & Debugging
  • Object Oriented Methodology
  • Effective presentation
  • DB2 Mainframes Training
  • DB2 UDB Training
  • DB2 PureApplications Training

References

Available upon request

Badges

  • IBM License to lead – First line Manager
  • IBM Enterprise Design Thinking Practitioner
  • IBM Recognized Teacher/Educator
  • IBM Mentor Badges

Timeline

Senior Database Administrator

IBM Corporation
03.2022 - Current

Senior Staff Software Engineer

IBM India Pvt. Ltd.
09.2016 - 03.2022

Senior Database Administrator

07.2014 - 09.2016

Senior Database Administrator

07.2012 - 07.2014

Lead Database Administrator

IBM Labs
06.2008 - 07.2012

Database Administrator

09.2006 - 05.2008

Application Developer & Junior Database Administrator

Infinite Computer Solutions
06.2005 - 09.2006

Technical coordinator

Unique Minds Infotech
08.2004 - 05.2005

Bachelor’s - Mechanical Engineering

Visveswaraiah Technological University (VTU) BMS College of Engineering
MYNAME S