Subramanyam Swamy
Chennai
Summary
A Determined Database Administrator with overall 7+ years of experience and relevant 4 years of experience as PostgreSQL DBA with required understanding in PostgreSQL Architecture, Database Backup & Recovery, User and Role Management, Performance Tuning, Database Upgrade and able to assist and provide strategic support to clients on projects involving extensive use of PostgreSQL.
Overview
8
8
years of professional experience
Work History
PostgreSQL DBA
Cognizant Technology Solutions
09.2022 - Current
- Installing and configuring PostgreSQL from source or packages on Linux machines.
- Monitored and managed the client connectivity using pg_hba.conf file and Managing of Postgresql.conf file.
- Creation of users and assigning roles & permissions to the users.
- Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
- Experience in Vacuum, Vacuum Full and Reindex in Production Database for Maintenance Activities.
- Experienced in Backup & Restore using pg_dump and pg_dumpall Binary tools.
- Experienced in Full Backup using pg_basebackup setting up WAL archiving, Point in time recovery.
- Monitoring the bloat report on every table and performing Index rebuilding to enhance the performance.
- Explain and Explain Analyze to identify and fine tune sql queries for performance improvements.
- Knowledge in Setup and maintenance of Postgres master-standby clusters utilizing streaming replication.
- Worked on Streaming Replication for PostgreSQL Server High Availability.
- Experience on upgrade of postgres databases.
PostgreSQL DBA
DXC Technology
08.2019 - 09.2022
- Performing logical backups using pg_dump, pg_dumpall and pg_restore utilities and restore specific objects and schemas.
- Monitoring databases to optimize database performance and diagnosing any issues.
- Providing response for all system / database issues on 24x7 schedule responding to critical events and situations outside normal work hours.
- Work with development and operations teams to tune production queries for optimal performance.
- Review new database schema changes.
- Creation of databases and configuration of rules in pg_hba.conf File.
- Created database security policies that prevented unauthorized access, reducing DBA workload by 80
Mainframe Db2 DBA
IBM
07.2016 - 08.2019
- Required ability to craft and alter DB2 objects (Database, Tablespace, Table, Index etc. ) based on requirements.
- Knowledge on running REORGs, RUNSTATS, performing Backup and RECOVERY of Objects and other utilities based on requirements.
- Refreshing Data from one region to another using LOAD utility under data sharing environment.
- Experience working on tools such as SPUFI, CA Platinum, Omegamon, IBM DB2 ALU log analysis.
- Experience in working ticketing tools such as Service Now, BMC Remedy.
Education
Microsoft Certified: Azure Data Fundamentals DP900 -
Microsoft
2021
Bachelor of Science - Computer Engineering
Saveetha Engineering College
Chennai, India05.2016
Skills
- TECHNICAL SKILLS:
- RDBMS : PostgreSQL, AWS, Mainframe Db2
- Operation Systems : Linux, Windows
- Replications : Binary and Object level replications
- High Availability : WarmStandby, Hotstandby, Streaming replication
- Industry Knowledge: Database Administration, Database Performance Tuning, Database Security, Database Backup & Recovery, Database Replication, Database Clustering, Implementing Security Measures, indexes management
- Soft Skills: Communication, Problem Solving, Teamwork, Leadership
Languages
English
Tamil
Telugu
Hindi
Timeline
PostgreSQL DBA
Cognizant Technology Solutions
09.2022 - Current
PostgreSQL DBA
DXC Technology
08.2019 - 09.2022
Mainframe Db2 DBA
IBM
07.2016 - 08.2019
Microsoft Certified: Azure Data Fundamentals DP900 -
Microsoft
Bachelor of Science - Computer Engineering
Saveetha Engineering College
Similar Profiles
PRAKASH NARAYANA VIGNESH BPRAKASH NARAYANA VIGNESH B
Business Analyst- Technical Lead at Cognizant technology SolutionsBusiness Analyst- Technical Lead at Cognizant technology Solutions
Raja RathinamadasamyRaja Rathinamadasamy
QA Manager at Cognizant Technology SolutionsQA Manager at Cognizant Technology Solutions
Josephine Arockiya Rani SJosephine Arockiya Rani S
Technical Lead -AWS at Cognizant Technology Solutions, CTSTechnical Lead -AWS at Cognizant Technology Solutions, CTS