Summary
Overview
Work History
Education
Skills
Professionalprojectexperience
Certification
Personal Information
Languages
Trainingssessions
Professionalsummary
Timeline
Generic
Bashistha Narayan

Bashistha Narayan

Bangalore

Summary

Result driven Database Administrator with expertise in DB2, MySQL, and Sybase. Proven track record of consistently meeting deadlines and exceeding expectations in high-pressure environments. Delivers exceptional results to delight customers and drive internal enhancements. Constantly seeks innovative strategies to achieve objectives.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Database Administrator

Kyndryl
Bengaluru
09.2021 - Current
  • Managed multiple databases running on different platforms Windows, Linux, UNIX on-prem and including cloud systems (AWS & GCP) .
  • Installed, configured, and maintained DB2,MySQL databases on LUW servers , AWS & GCP.
  • Migrated existing databases from one platform to another with minimal downtime.
  • Performed/maintained daily backups of the databases.
  • Developed and implemented database security measures to ensure data protection.
  • Created new tablespaces for applications to store their data in the database.
  • Configured user accounts, privileges, roles, profiles in the database server.
  • Ensured that all the stored procedures are optimized for better performance of the system.
  • Provided technical support for developers by creating views and indexes as per their requirements.
  • Developed scripts for automating routine maintenance tasks such as index rebuilds and statistics updates.
  • Performed regular health checks on all databases to ensure optimal performance levels are maintained.
  • Coordinated with other teams such as network administrators and system admins for resolving complex issues.
  • Assisted in disaster recovery planning by testing various backup strategies and scenarios.
  • Deployed patches and upgrades on a timely basis to keep up-to-date with latest software releases.
  • Conducted training sessions for junior DBAs regarding best practices related to database administration.
  • Participated in capacity planning initiatives to forecast future resource needs based on current trends.
  • Analyzed database applications and made necessary adjustments to parameters and architecture to improve performance.
  • Analyzed and developed technical and functional specifications for databases.
  • Provided support for complex issues related to software tools, applications and databases.
  • Created and monitored performance metrics to keep databases functioning at optimal capacity.
  • Defined database design specifications based upon project requirements.
  • Worked with software vendors to analyze and resolve software installation and ongoing support issues.
  • Developed data models and database designs to plan projects.
  • Supported end users in selecting, procuring and using software applications.
  • Established security controls to help protect client systems.
  • Aligned systems with business needs to enhance scalability of database structures and recommend improvements.
  • Solved complex analytical problems using statistical models from data.
  • Developed and implemented security initiatives to protect important company data.
  • Communicated with data architects, programmers and engineers to keep projects on track.
  • Partnered with project management teams on development of scope and timelines.
  • Supported planning for software development and purchases and coordinated implementation.
  • Collaborated with stakeholders to gather business requirements for enhancements and change requests.
  • Defined synchronization plan for patch management.
  • Analyzed and resolved complex database and system issues promptly.
  • Managed database security, backup, and recovery procedures to safeguard information.
  • Coordinated with development teams to optimize database queries and indexes.
  • Led database migration and upgrade projects to ensure smooth transitions.
  • Oversaw the installation and maintenance of database software and updates.
  • Evaluated and recommended new database technologies and tools to enhance productivity.
  • Conducted regular database capacity planning to accommodate business growth.
  • Provided technical support and training to end-users and junior DBAs.
  • Developed and enforced database administration policies and procedures.
  • Monitored database performance and implemented changes to improve response times.
  • Conducted performance tuning of database systems to ensure optimal efficiency.
  • Designed and implemented database systems to meet organizational needs.
  • Prepared and maintained detailed documentation for database architectures and procedures.
  • Participated in disaster recovery planning and testing to minimize data loss.
  • Automated routine database tasks to improve system reliability and reduce manual errors.
  • Optimized storage and archiving practices to manage database size and performance.
  • Wrote scripts and processes for data integration and bug fixes.
  • Developed redundant systems and procedures for disaster recovery and archiving to maintain data protection.

DB2 Database Administrator

IBM India Pvt. Ltd.
Bangalore
05.2016 - 09.2021
  • Support of 700+ servers with DB2 which is installed on AIX,Win & Linux environment
  • Account SME
  • Handling Production databases up to 12 TB
  • Innovative scripts for monitoring of db & carry out automated actions
  • Providing resolutions during high priority Incidents (P0/P1)
  • Providing suggestions in customer calls for new projects
  • Planning & implementations of new projects
  • Decision making & providing resolutions for long running issues
  • Providing RCA’s and preventions
  • DB2 Security checks and enhancements
  • Managing client’s DB2 server inventory
  • Guide Team Members during any issues
  • Migrations for DB2 databases hosting Complex/Critical applications
  • Installing Fix Packs on partitioned and non-partitioned environment
  • Server/DB migrations from AIX to LINUX
  • PROD Data Recoveries during accidental delete of records by application teams
  • PROD Corrupted TABLE recoveries due to hardware failures
  • POC’s for any new projects (TSA,DDBEA,NETCOOL)
  • Oncall supports

DB2/Sybase Database Administrator

GOLDMAN Sachs
03.2015 - 05.2016
  • Support of 1000+ servers with DB2,Sybase which is installed on AIX,Win & Linux environment
  • Handling Production databases up to 5 TB
  • Migrations for DB2 & SYBASE
  • Installing Fix Packs on partitioned and non-partitioned environment
  • Working in Process-driven environment
  • Monitoring Database performances
  • Providing L2/L3 level production support
  • Handling tablespace and filesystem space issues
  • Redirect restores of databases
  • Executing DDL and DML scripts as per customer request
  • Granting / revoking various authorizations to different Users/Groups
  • Creation and modifications of scripts for database related automation jobs
  • Working with data movement Utilities i.e
  • Import, export and load
  • Monitoring scheduled jobs like backup, reorg, runstats etc
  • Trouble shooting DB2,SYBASE problems using different tools and utilities
  • Monitor performance and proactively manage databases

DB2 Database Administrator

Capgemini
02.2012 - 03.2015
  • Support of 100+ servers with SAP on DB2 which is installed on AIX,Win & Linux environment
  • HANA db administration,refreshes, replication of db & failovers,Table merges/partitions
  • HANA POC for scaleout environment
  • Maintains more than 100 instances and 100 databases in partitioned and non-partitioned environment in TEST, DEV and PRODUCTION
  • Handling Production databases up to 20 TB
  • Migration from V9.7 to 10 for SAP environment and V9.1 to 9.7 for non-SAP environment
  • Installing Fix Packs on partitioned and non-partitioned environment
  • Working in Process-driven environment, by following processes like Problem Management and Change Management, Remedy etc
  • Monitoring Database performance on DPF environment
  • Providing L2/L3 level production support
  • Monitoring tablespace growth using standard scripts and working with trend analysis data
  • Handling tablespace and filesystem space issues
  • Online/Offline Table Moves
  • Value/Row compressions for Tables & indexes
  • Redirect restores of databases
  • Executing DDL and DML scripts as per customer request
  • Granting / revoking various authorizations to different Users/Groups
  • Creation and modifications of scripts for database related automation jobs
  • Working with data movement Utilities i.e
  • Import, export and load
  • Working with Data warehousing team to monitor LOAD operations and SQL performance tuning
  • Monitoring scheduled jobs like backup, reorg, runstats etc
  • Trouble shooting DB2 problems using different tools and utilities
  • Monitor performance and proactively manage all databases

DB2 Database Administrator

IBM India Pvt. Ltd.
06.2009 - 02.2012
  • The scope of activities included database administration of internal as well as external customers’ systems database
  • Primarily responsibility was as DB2 UDB Database administrator which includes Creation and setup of databases on newly built servers as well as already existing servers, performing security health checks, installation and testing of DB2 Maintenance scripts for all the databases, database migration, DB2 upgrade, applying fix packs, troubleshooting, maintenance of backup, recovery , performance tuning of databases , Creating databases objects as per requests etc
  • On development, test and production servers
  • Worked on more than 10 RFS projects
  • Support of 650+ servers where DB2 Database is installed on UNIX, AIX, Linux and Windows environment
  • Maintains more than 500 instances and 1200 databases in TEST, DEV and PRODUCTION Environment
  • Handled Production databases up to 1 TB
  • Worked in Process-driven environment, by following processes like Problem Management and Change Management, ITIM tool, SA&D tool etc
  • Implemented HADR, DR environment, db2audit, db2governor,net search extenders
  • Given POC for readable standby HADR db, DB2 Connect with ACR (Auto Client Reroute)
  • Updating DB/DBM cfg parameters based on the requirements
  • Implemented database policy for backing up data on daily basis
  • Trouble shoot DB2 problems
  • Very Good exposure on HADR , HACMP , Migration from V8 to V9.5,V9.7 Installing Fix Packs
  • Migration of SMS to DMS tablespaces
  • Excellent oral and written communication skills as well as the ability to interface with peers, management, vendors
  • Strong planning and project management skills, self-starter able to work under minimal supervision
  • Presently working as a Team Lead for above stated accounts

Education

Bachelor of Engineering (B.E) - ECE

Pune University
Pune, Maharashtra, India

Skills

  • Database Development
  • Linux Operating System
  • Disaster Recovery
  • Database Management
  • Data Security
  • Data conversion and migration
  • Systems administration
  • Database analysis
  • Continuous Process Improvement
  • Database locking
  • Code debugging
  • Relational Database Management
  • Database Administration
  • Performance Tuning
  • Root Cause Analysis
  • Capacity Planning
  • Backup and recovery

Professionalprojectexperience

  • IBM India Pvt. Ltd., FCA, 05/2016 - Present, Support of 700+ servers with DB2 on AIX, Win & Linux, Account SME, Handling Production databases up to 12 TB, Innovative scripts for monitoring of db, Providing resolutions during high priority Incidents (P0/P1), Planning & implementations of new projects, DB2 Security checks and enhancements
  • GOLDMAN Sachs, 03/2015 - 05/2016, Support of 1000+ servers with DB2, Sybase, Handling Production databases up to 5 TB, Providing L2/L3 level production support, Monitoring Database performances
  • Capgemini, WB (Warner Bros.), 02/2012 - 03/2015, Support of 100+ servers with SAP on DB2, HANA db administration, refreshes, replication of db, Handling Production databases up to 20 TB
  • IBM India Pvt. Ltd., Manulife, RMIS-IAMSA, IGA-CANADA, Manulife-Canada, RMIS-Mexico, IBM-CANADA, 06/2009 - 02/2012, Database administration of internal and external customers’ systems, Support of 650+ servers with DB2, Handled Production databases up to 1 TB

Certification

  • IBM Certified for Exam 730, DB2 UDB V9.1 Family Fundamentals
  • IBM Certified for Exam 731, DB2 UDB V9.1 Database Administration for Linux, Unix and Windows

Personal Information

Date of Birth: 09/23/82

Languages

  • English
  • Hindi
  • Marathi

Trainingssessions

  • Replication
  • HADR
  • DB2 Monitoring and Maintenance Tools
  • GDF
  • Manage Now
  • Lotus Notes
  • SA&D Tool

Professionalsummary

DB2 Database Administration, SYBASE Database Administration, HANA Database Administration, Shell/Perl Scripting, 24X7 Production Support, Database Implementation and Maintenance, Team Player, Detail-oriented, Analytical, Self-driven, Excellent Organizational Skills, Communication Skills, Presentation Skills, PROJECT STAR, RECOGNITION

Timeline

Database Administrator

Kyndryl
09.2021 - Current

DB2 Database Administrator

IBM India Pvt. Ltd.
05.2016 - 09.2021

DB2/Sybase Database Administrator

GOLDMAN Sachs
03.2015 - 05.2016

DB2 Database Administrator

Capgemini
02.2012 - 03.2015

DB2 Database Administrator

IBM India Pvt. Ltd.
06.2009 - 02.2012

Bachelor of Engineering (B.E) - ECE

Pune University
Bashistha Narayan