Subhendu Bagati
Bengaluru
Summary
A goal-oriented professional with over 16+ years of experience in Database Administration.
10+ Years of Experience in supporting various Amazon AWS/OCI implementations including EC2 (IaaS) and all RDS (DBaaS) offerings. AWS services includes provisioning, implementation, migration, heterogeneous conversions, ongoing database administration and support for Oracle, MySQL, Maria DB, PostgreSQL and Amazon Aurora. Strong in Amazon AWS costing, administration, monitoring and troubleshooting. Experience in data Migrations (DMS), ongoing data synchronization (Dataguard, DMS, Goldengate), backup and recovery (RMAN, EXPDP /IMPDP), geographic data replication (Region and Multi-Availability Zones), CloudWatch performance monitoring, system tuning and disaster recovery configuration and execution.
Overview
17
17
years of professional experience
6
6
years of post-secondary education
4
4
Certifications
Work History
Principal Architect
Karios Technologies
04.2024 - Current
- Migration from 19c to Oracle 19c using goldengate technology
- Database Support for Oracle,PostgreSQL,MySQL
- Design and Implementation of Backup/Recovery Strategy in AWS EC2 and S3 Environment for Huge Databases more than 40+ TB using AWS Backup Service
- Design and Implementation of Maintinence /Rebuild Indexes/Patching Strategy in AWS EC2 and S3 Environment for Huge Databases more than 40+ TB using AWS Snapshot Method and sync latest transactions using Goldengate Classic and Micro Services
- Successfully managed multiple high-profile projects simultaneously, demonstrating a strong ability to prioritize tasks and delegate responsibilities effectively.
- Improved project efficiency with thorough design reviews and coordination among multidisciplinary teams.
- Designed various Scripts for Monitoring and Alerting of Databases, Migration Task Monitoring,GG Alerting in case of failure
- OEM Integration with various Oracle Products
Staff Database Engineer
LogMeIn.Inc (Now Goto.Inc)
01.2021 - 03.2024
- Migrate On-prem 11g RAC Oracle Databases to Oracle 19c RAC using goldengate technology in OCI Cloud.
- Installation, Patching, Configure Dataguard, Maintain in OCI Cloud.
- Implement, Configure, Maintain Aurora RDS (AWS) and Read replicas
- Database administration of Cassandra and Couch Databases
- Work as part of a team and provide 7x12 DBA support to Production DB systems
- Capacity management for Oracle,PostgreSQL MySQL, Aurora Databases
- Implement MySQL, Primary-slave database for Datacenter Migration
- Migrate On-prem Databases to AWS RDS(Oracle to Aurora RDS)
- Implement, configure, Maintain ec2 instances for Cassandra databases
- Knowledge of Devops tools Jenkins, Terraform, git, bitbucket
- Monitor Databases using OEM 12c, OEM 13c, Solarwind, pagerduty, Splunk.
- Streamlined data processes for faster retrieval and analysis through the design of well-structured databases.
Technical Architect
Sonata Software
05.2018 - 01.2021
- Hands on experience in Database Migration projects (Oracle Exadata on premises to AWS Oracle RDS, Oracle RDS to Mysql Aurora RDS) which includes capacity planning, Database restructuring, Schema redesigning using Schema Conversion Tool, Migration/Rollback strategy with minimizing Application downtime and risk
- Hands on experience in KMS key management and cross account DB snapshot sharing
- Perform analysis and troubleshooting of Jobs/queries using RDBMS toolsets (AWR, ASH, Solarwind, OEM) provide performance improvement recommendations
- Provide DBA support during release and ensure flawless rollback strategies in place with minimal Application down time (Using AWS Backtrack, Flashback recovery point, Restore DB from pre-release backup functionality)
- Experience in Standard AWS RDS/EC2, setup Multi-AZ(HA) Implementation using Terraform, Jenkins for various Production, Test, Performance, Dev database environments
- Provide database solutions for Application development
- Experience in Database patching, Upgrade in AWS cloud environment
- Work with and educate our dev team to make good schema design choices and write efficient queries for development projects
- Assist Development and Support team with troubleshooting production issues there by achieving optimal operational goals
- Develop and improve procedures monitoring (Solarwind) and proactive intervention, preventing customer impact
- Expert in DB Tools/Utilities like Toad, Enterprise Manager, SQL Developer, RMAN, EXPDP/IMPDP, pgAdmin, MYSQL Workbench, mysqldump etc..
- Plan and take logical (expdp,pg_dump, mysqldump) and physical backups (Manual/Automated Snapshots, RMAN) for development databases, perform test restores ensuring all databases and associated logs are being backed-up
- Manage/administer production, development, test, performance databases
- Work as part of a team and provide 7x24 DBA support to business enterprise systems
- Working with the Application Development, and technical teams to implement changes to the computing environment
- Perform database administration activities such as storage management, backup, recovery, and performance tuning
- Provide proactive problem management to identify RCA and provide permanent resolutions
- Develop software and systems on test driven development and continuous integration practices, establish monitoring and automation processes
- Work closely with Devops, development, server and storage groups to ensure optimal performance and efficiency of database systems
- Develop system/Run books documentation for database activities and process.
- Collaborated with clients to determine project specifications and scope.
- Proactively monitored system performance trends to anticipate potential issues before they escalated into larger problems.
Specialist - DBA
Sungard A S
9 2016 - 04.2018
- Hands on experience on Database (Oracle/DB2/MySQL/PostgreSQL) migration from Client's Datacenter to AWS, Oracle Cloud environments as per client requirement
- Developed strong client relationships through consistent communication and attentive service.
- Followed all company policies and procedures to deliver quality work.
- Experience in Amazon Web Services (AWS), launching EC2 instances, Managing users and services using IAM, VPC infrastructure, S3 maintenance for instances, Route 53, RDS, Cloud Watch
- Attaching Volumes, backing up, upgrading storage to Database EC2 instances by taking snapshots/AMI
- Responsible for recovering DB's which involves various Database flavors(Oracle/DB2/MySQL/PostgreSQL) for client (around 3000 DB clients) whenever there is a disaster situation or during any DR test execution with in stipulated RTO
- Work as part of a team and provide 7x24 DBA support to Production DB systems
- Perform database administration activities such as Monitoring, health check, backup, recovery, and performance tuning
- Implement New Database setup in AWS/Oracle Cloud Environment as per Client requirements
- Implemented/Maintained dataguard, Physical standby active dataguard, snapshot standby, Logical standby with Oracle 10g,11g,12c and AWS/Oracle Cloud environment.
Infra Technology Specialist
Cognizant
08.2013 - 09.2016
- Operation Manager for Database, System Admin and Application Team
- Join escalation calls, Provide RCA for problem/incidents, Ensure SLA met, ensuring Weekly/Monthly Operational review with clients
- Manage Resources assignment and work allocation for ongoing and upcoming critical projects
- Hands on experience on Oracle Database migration from Client's Datacenter to AWS Environment
- Hands-on experience in Oracle Golden Gate installation, configuration, troubleshooting GG issues
- Hands on experience on AWS RDS and EC2 Provisioning
- Implemented Oracle 11gR2 RAC and Dataguard setup for one of the banking client BOA
- Implemented Recovery Manager (RMAN)
- Created Recovery Catalog and performed automatic full incremental backup, Tuned backup for performance by parallel channel allocation
- Performed complete and incomplete recovery using RMAN
- Production DBA Support and Maintenance (24X7)
- Setup OEM and various Metrics to Monitor DB environments.
Senior DBA
Wipro Infotech Limited
09.2012 - 07.2013
- Operation Manager for Database, System Admin and Finacal Application L1 Team
- Production DBA Support and Maintenance (24X7) for Indian Rural Bank Databases
- End of day Job DBA Support and ensure High availability and
- Ensure High availability, Performance of the Oracle RAC Databases during Quarterly, Half Yearly and Annual Interest Job runs flawless
- Maintain RMAN Backup and Dataguard Sites.
- Supported application development efforts by providing timely and accurate data extracts for analysis purposes.
- Established effective disaster recovery strategies, safeguarding critical business data from potential loss or corruption incidents.
- Collaborated with cross-functional teams to deliver database solutions that met business requirements.
- Served as a mentor for junior DBAs, fostering professional growth within the team.
- Implemented high availability solutions, minimizing data loss risks during unplanned outages.
- Streamlined backup processes for faster recovery times in case of system failures.
- Enhanced data security with the implementation of encryption protocols and access controls.
- Consistently achieved service level agreements through diligent performance tuning efforts and ongoing improvements.
Associate Database L2
Sapient Nitro
02.2011 - 07.2012
- Apply Database Change Request on Production Environment, Provide Support to Developers during Releases in Validating DBCR according to Customer Requirement
- Managing local and UAT Environment available to Developers for continuous application and new feature development as per the client requirement
- Hands-on experience in Oracle Golden Gate installation, configuration, troubleshooting GG issues
- Implemented/Administered Oracle 10g RAC 64 bit on Linux and AIX
- Upgrade Database 10.2.0.1.0 to 10.2.0.4.0 in single and RAC Environment with minimal Downtime through Oracle Golden gate
- Hands on Experience in Database Patching for Oracle RAC Databases
- Implemented/Configure and provide Database Administration for Mysql DB and its DR Site
- Implemented TDE and Wallet in Oracle RAC Environment
- Reorganizing the database at regular intervals to remove row migrations, fragmentation in the database using export and import utilities
- Developing, testing continuously monitoring and updating the Backup and Recovery strategy
- This strategy includes all types of backups like Logical (Export), Offline or Cold, Online or Hot Backups and RMAN
- Provide release/DBA support to development team and ensure DB environment availability for Testing, UAT, Performance
- As per the requests ensure Database refresh activity from production, ensure availability to team since there are various milestones in-line with delivery team
- Review Database change request developed by Development team with respect to Performance and ensure optimal code pushed to production.
Oracle DBA
NH Infomedia Pvt.Ltd
06.2010 - 02.2011
- Apply Database Change Request on Production Environment, Provide Support to Developers during Releases in Validating DBCR according to Customer Requirement
- Managing local and UAT Environment available to Developers for continuous application and new feature development as per the client requirement
- Hands-on experience in Oracle Golden Gate installation, configuration, troubleshooting GG issues
- Implemented/Administered Oracle 10g RAC 64 bit on Linux and AIX
- Upgrade Database 10.2.0.1.0 to 10.2.0.4.0 in single and RAC Environment with minimal Downtime through Oracle Golden gate
- Hands on Experience in Database Patching for Oracle RAC Databases
- Implemented/Configure and provide Database Administration for Mysql DB and its DR Site
- Implemented TDE and Wallet in Oracle RAC Environment
- Reorganizing the database at regular intervals to remove row migrations, fragmentation in the database using export and import utilities
- Developing, testing continuously monitoring and updating the Backup and Recovery strategy
- This strategy includes all types of backups like Logical (Export), Offline or Cold, Online or Hot Backups and RMAN
- Provide release/DBA support to development team and ensure DB environment availability for Testing, UAT, Performance
- As per the requests ensure Database refresh activity from production, ensure availability to team since there are various milestones in-line with delivery team
- Review Database change request developed by Development team with respect to Performance and ensure optimal code pushed to production.
Associate DBA
Trifin Technologies Pvt. Ltd
12.2007 - 06.2010
- Project/Client: Modi Group The project involved the maintenance of database complete Modi group Ltd
- This project required clear understanding of the workflow and the issues related to production in dynamic environment
- Apart of that a good understanding of functional user requirement for day to day activity
- Implemented/Configured Oracle 10G Standalone Database
- Responsible for providing DBA support to ERP team
- Ensure Daily Backups (Logical,RMAN) completed successfully
- Created new user accounts, profiles, roles and grant privileges
- Database links were created to access the data from remote databases
- Configure Listener on the server side and TNS Aliases on client side
- Troubleshooting daily upcoming problem
- Created and managed tablespaces, monitored the datafiles space, resizing and adding new datafiles etc.
Education
B-Tech - Computer Science and Engineering
Biju Patnaik University of Technology
Berhampur 04.2001 - 04.2007
Skills
Database Administration (Oracle, PostgreSQL, MySQL)
Cloud(AWS, OCI) Database Migrations
Replication Tools (Goldengate, DMS)
RAC, Exadata Concepts
Expert Problem Solving
Proof of concepts
Solutions Architecture
Reporting & Documentation
Capacity Planning
Query Optimization
Database Security
Performance Tuning
Training & Development
SLA & Escalation Management
Leadership quality
Willingness to learn
Certification
AWS Certified Solutions Architect - Associate
Personal Information
- Passport Number: Z2274590
- Date of Birth: 09/01/1983
- Gender: Male
- Nationality: Indian
Linkedinprofile
https://www.linkedin.com/in/subhendu-bagati-9b562234
Languages
English
Hindi
Awards
- Got DNA award by Sonata software limited in the month of January 2020(https://www.linkedin.com/posts/sonata-software_lifeatsonata-activity6623446160336093186-ri4T/)
- Certificate of recognition for outstanding contribution in 2017 towards making Sungard AS successful.
- "You make a Difference" certificate awarded by Sapient in year November 2011
- "You make a Difference" certificate awarded by Sapient in year June 2011
Timeline
Principal Architect
Karios Technologies
04.2024 - Current
Staff Database Engineer
LogMeIn.Inc (Now Goto.Inc)
01.2021 - 03.2024
Technical Architect
Sonata Software
05.2018 - 01.2021
Infra Technology Specialist
Cognizant
08.2013 - 09.2016
Senior DBA
Wipro Infotech Limited
09.2012 - 07.2013
Associate Database L2
Sapient Nitro
02.2011 - 07.2012
Oracle DBA
NH Infomedia Pvt.Ltd
06.2010 - 02.2011
Associate DBA
Trifin Technologies Pvt. Ltd
12.2007 - 06.2010
B-Tech - Computer Science and Engineering
Biju Patnaik University of Technology
04.2001 - 04.2007
Specialist - DBA
Sungard A S
9 2016 - 04.2018