Shivkumar Mathpati

Highly skilled having PostgreSQL and DB2 DBA with 11+ years of experience seeking a challenging PostgreSQL DBA role within the financial services industry, leveraging expertise in database administration, replication, and security management to ensure optimal database performance and data integrity.

PostgreSQL and DB2 DBA at Wipro Technologies Pvt Ltd (2018-02 – Present)

Provided comprehensive DBA support for both PostgreSQL and DB2 environments focusing on ensuring data integrity and security within financial systems. Responsibilities include database installation, configuration, monitoring, and upgrade activities, with a strong emphasis on maintaining high availability.

• Administered PostgreSQL and DB2 databases on Linux and Windows platforms, ensuring high availability and optimal performance for critical financial applications.
• Designed and implemented robust PostgreSQL replication strategies, incorporating streaming replication and log shipping, minimizing downtime and ensuring data consistency.
• Developed and executed comprehensive backup and recovery procedures, including point-in-time recovery, to safeguard valuable financial data assets.
• Implemented stringent security measures, configuring authentication, authorization, and encryption protocols, thereby adhering to industry best practices.
• Optimized database memory configurations and fine-tuned SQL queries to enhance database responsiveness for efficient financial transactions.
• Proactively monitored database performance, identifying and resolving integrity, connectivity, and security issues, thus upholding seamless operational continuity.
• Improved database efficiency by fine-tuning SQL queries and optimizing memory configurations, resulting in enhanced performance of financial applications.
• Significantly enhanced data security by implementing strong authentication, authorization, and encryption protocols, aligning with industry best practices.

DBA at Magna Infotech (Quess Corp) Pvt Ltd. (2017-08 – 2018-02)

Provided database administration support for IBM DB2 UDB in a variety of environments, including managing databases, support infrastructure, and ensuring operational readiness for applications.

• Administered IBM DB2 UDB databases in AIX and Linux environments.
• Supported production, High Availability Disaster Recovery (HADR), and User Acceptance Testing (UAT) environments.
• Provided build support for UAT and production environments ensuring smooth deployments.
• Orchestrated the creation of new databases to meet expanding client needs.
• Successfully supported critical database environments, ensuring high availability and performance during peak usage periods.
• Contributed to efficient software releases through the provision of reliable build support.

DBA at Collabera Technologies Pvt Ltd (2016-11 – 2017-06)

Provided comprehensive DBA support for non-production environments, collaborating with development teams, managing database changes, and ensuring data availability. Client: HSBC

• Developed new databases, database objects, and users to support application development and business needs.
• Provided support for non-production environments, ensuring stable and reliable platforms for testing and development.
• Implemented and oversaw change requests, managing database modifications and enhancements.
• Installed DB2 databases on AIX and Linux operating systems, creating standardized and efficient database infrastructure.
• Maintained DMS table spaces and tables in DB2 databases, managing database storage and ensuring optimal performance.
• Implemented backup and recovery strategies, safeguarding data integrity and enabling business continuity.
• Utilized db2look to retrieve database DDLs, replicating database structures and ensuring consistency across environments.
• Participated in database provisioning and capacity planning, forecasting storage needs and optimizing resource utilization.
• Successfully implemented change requests, maintaining a robust and stable non-production environment.
• Effectively implemented backup and recovery plans, minimizing potential data loss and downtime.

DBA at Dibit Computing Systems Pvt. Ltd (2016-02 – 2016-10)

Administered DB2 databases for Bank of Maharashtra, focusing on data availability, security, and performance. Core responsibilities included database creation, object management, backup and recovery, and database tuning.

• Developed new databases, database objects, and users to support the application needs within Bank of Maharashtra.
• Administered DB2 databases on AIX and Linux platforms, managing dataspaces and tables to ensure optimal performance.
• Implemented backup and recovery strategies to secure database integrity and ensure business continuity.
• Utilized DB2 utilities (export, import, load) to manage and manipulate table data effectively.
• Extracted database DDLs using db2look and created consistent structures in target databases.
• Employed DB2 maintenance utilities (Reorgchk/Reorgs/Runstats) to maintain database efficiency.
• Streamlined database management, enhancing operational resilience and compliance within the Bank of Maharashtra's IT environment.
• Optimized backup procedures, contributing to data integrity and disaster recovery preparedness.

JUNIOR DB2 DBA at Aruman Software Technologies Pvt. Ltd. (2014-07 – 2016-01)

Supported development teams with database setup, performed routine administrative tasks, and assisted in the implementation of backup and recovery strategies.

• Established multiple databases for customer development teams, enhancing productivity.
• Employed utilities like db2look, db2move, export, import, and load to manage and transfer data efficiently.
• Conducted regular backups of critical databases, securing data integrity and availability.
• Executed database restorations with redirector restore, facilitating swift recovery processes.
• Developed stored procedures optimizing database operations and application performance.
• Enhanced development team efficiency by setting up and maintaining robust database environments.
• Contributed to data security, ensuring appropriate backups and restore capabilities.

MCA in Master of Computer Applications – Pune University (2014-04)