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.
