Shruthi Hassan Appu
Bangalore
Summary
Accomplished Senior Database Administrator with a proven track record at Deliveroo, enhancing database performance and automating deployment pipelines. Expert in PostgreSQL, AWS RDS, and Python automation, I've significantly improved system scalability and security. Skilled in collaboration and innovative problem-solving, I've led successful migrations and optimizations, demonstrating exceptional technical and teamwork abilities.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Senior Database Administrator
Deliveroo
Bangalore
08.2023 - Current
- Platform: AWS RDS, Aurora (PostgreSQL), Python Automation, Terraform, Git
- Developed and managed database solutions, ensuring high availability and scalability using AWS RDS Aurora.
- Automated deployment pipelines using Terraform for infrastructure as code.
- Built scripts in Python for automating backups, disaster recovery testing, resource management, bulk slack notification, RDS rightsizing
- Optimized database configurations and implemented query performance improvements.
- Collaborated with the engineering team for seamless database upgrades and migrations.
- Ensured database security by implementing robust access controls and monitoring solutions.
- Blue/Green major DB Upgrades , Minor version upgrade, logical replication
- Involved in DR -Gameday for testing the disaster recovery scenario in Stage environment
Senior Database Administrator
Meckalyn Consulting
Bengaluru
02.2020 - 08.2023
- Platform: PostgreSQL (10 and 11), Azure services, Automation.
- Day-to-day database administration of all DB servers.
- Ensure uptime for all database servers.
- Upgrade the database from Postgres 10 to Postgres 11 using the pg_upgrade and pg_dump methods.
- Work with the Global Operations team to fine-tune alerts and improve proactive monitoring.
- Troubleshoot DB issues and provide Root Cause Analysis (RCA) to avoid them in thefuture
- Provide complete automation solution for DB recovery, failover, and migration using Shell and Ansible.
- Work with thetheDevelopment team to evaluate new DB products
- Participate in feature development meetings and take ownership of DB-related work
- Perform SQL code review for ELT and other queries to ensure only optimized queries go to production.
- Maintain and manage all database servers (Backup, Performance Tuning, Query optimization)
- Migration of on premises/VM PostgreSQL instances to Azure Paas Single server Postgresql
- Establish and control security policy for access control in DB servers.
- Custom procedures using PgSQL
- Setup proactive monitoring using shell and schedulers
- Audit existing MySQL/PostgreSQL DB instances
- Partition Table management using Partman extensions in the PostgreSQL database
- Deploy DB jobs through Kubernetes/Docker management
- Setup and Manage Logical replication
- Wal-g replication
Senior Database Administrator
Dataxu
Bengaluru
05.2015 - 08.2019
- Platform: MySQL, PostgreSQL, AWS-RDS(PostgreSQL/MySQL), Greenplum
- Day to day database administration of all DB Servers
- Ensure uptime for all database servers
- Work with Global Operations team to fine tune alerts and improve on proactive monitoring
- Troubleshoot DB issues and provide Root Cause Analysis (RCA) to avoid it in future
- Provide complete automation solution for DB recovery, failover, switchover, migration using shell, ansible and Jenkins
- Work with Development team to evaluate new DB products
- Participate in feature development meetings and take ownership of DB related work
- Perform SQL Code review for ELT and other queries to ensure only optimized queries goes to production
- Maintain and manage all database servers (Backup, Performance Tuning, Query optimization)
- Migration MySQL and PostgreSQL instances to AWS-RDS
- Train in-house new joiners/Dev team on different DB technologies like Greenplum/Oracle/PostgreSQL/AWS etc
- And optimization techniques
- Established and control security policy for access control in DB Servers
- Custom procedures using PLpgSQL
- Setup proactive monitoring using shell and schedulers
- Audit existing MySQL/PostgreSQL DB instances
- Capacity planning and projections
- Configure Cloud Watch Alerts
- Established user access control in PostgreSQL/Greenplum, Work load management (WLM), resource queue implementation
- Recover down segments, Incremental Backup setup in Greenplum
Database Administrator 2
Intuit
Bangalore
07.2012 - 05.2014
- Pro-actively proposed and implemented improvements to ensure that the system is running smoothly like monitoring system usage, DB usage, Creating and Managing Users/Tablespaces/tables/indexes, RMAN cloning as in when required
- Provided assistance to application developers and users regarding database access and data queries and also troubleshooting assistance as required
- Have taken ownership of more than five product databases including prod and non-prod DB servers for an end to end DBE activities
- Have done DB character set change for PROD DB using csscan method during maintenance window for 4 servers
- Good in managing DB servers on VCS cluster configuration like VCS start, stop, group failover, status check and administrative commands
- Technically update on Golden Gate for Upcoming project and implemented/tested its activity on test database
- Have given many technical presentations on database architecture, ASM, Streams, RAC to the Dev/App ops, QA and performance team
- Have been involved in Database Engineering activity for many of the projects owned by me and for new project/requirement comes to the team
- Worked on many challenging tasks like converting non partition table to partition table online for huge tables, creating shell script for data monitoring with different requirements, writing plsql script for purging/update huge volume of records, switchover/failover database during outages
- Worked on datacenter DB migration live for production database with zero down time
- Implemented and maintained Physical standby database
Senior Database Administrator
Oracle India Pvt ltd.
10.2011 - 07.2012
- Installed and Configured Oracle 11g R2 RAC (Using ASM and Non-ASM) and Data guard database
- Implemented 12c Grid control and added all Triton production/development/stage databases, applications/middle tier targets for monitoring and Notifying alerts
- Created user defined monitoring (UDM) i.e
- Custom shell script for disk/tablespace Usage and alert log error monitoring
- Implemented and Managed Streams on schema level and related issues
- Documented the same
- Monitored and Resolved runaway processes, long running processes, hanging issues and excessive redo generation
- Have been involved in Database Engineering team discussion for any new project/requirement comes to the team
- Created and Croned Automation script for SQL loader to load and notify alert after successful/error, supporting multiple files of any extension/file format
- SQL tuning using AWR/Explain plan/TKPROF etc
- Apply Oracle patch using Opatch utility
- Performed Backup and Recovery using Datapump
- Full DB/Schema Refresh before Development patching on Stage/Dev DB
- Partitioning a huge table like Range, Hash and also interval Partition (11gNF)
- In-complete Full DB recovery when there was a wrong patch applied on production using RMAN
- Technical Problems solution and peer reviews
- To ensure smooth production deployment
Mindtree India pvt lmt
01.2010 - 07.2011
- Company Overview: Client Yahoo India
- Managed day-to-day production, development, stage and test databases like creation and maintaining users/group/objects/grants/tablespaces
- Pilot testing of Oracle 10g/11g database involves installation, configuration, maintenance and exploring new features of Oracle11g
- Worked with Storage admins to perform snap backup, snap mirroring and Flex clone
- Identifying high scanned queries and tuning them accordingly whenever request is raised by QA
- Supported 7x12 production on-call and Oracle support process for technical request through Meta link and other support procedures
- Upgraded search systems from 10.2.0.4 to 11.2.0.2 for more than 20 databases including prod/non-prod DB's
- And have applied PSU patch using Opatch utility
- Also have good experience on applying rollback patch on 24x7 production RAC databases as part of bug fixers
- Scheduled OEM monitoring to notify an Critical/Warning alerts to emails
- Including SQL, HOST UDM setups
- Implemented/maintained Physical and Logical Standby databases on 11g/10g using MAA technology
- Pilot testing of Oracle 10g/11g database involves installation, configuration, maintenance and exploring new features of Oracle11g
- Implemented /Maintained Schema level bi-directional replication
- Have worked on RMAN using Active Database 11g NF /cold cloning
- Involved in switchover and failover of DB's maintenance and tested
- Added Node and Deleted Node to 3 node RAC for the as and when required
- Proficient in using 10g features like Data pump, Flash-Back, Recovery, Resumable Tablespace Management, Log Miner, Transportable Tablespace, Recycle bin
- Monitoring and resolving runaway processes, long running processes, hanging issues and excessive redo generation and also Monitored dbms_jobs/Schedulers running and re-scheduled the failed jobs according to the timing
- Clear communication and documentation of technical specifications
- Worked/involved with Database engineering team for development new patches deployment
- Client Yahoo India
Cambridge Technology India Pvt Ltd
01.2008 - 01.2010
- Company Overview: formerly known as Qsoft Systems and Solutions
- Visit Client places and involve in discussion for their requirement
- Installing/ configuring server on different OS platform as per the requirements
- Migrated 9i database from windows to Linux server and end to end solution provider if client faces any DB level critical issues
- Troubleshooting performance issue
- Setting up/testing backup scripts on the client side
- Have done corporate and Inhouse training on ORACLE DBA concepts in a client location like Wipro/CTS/HP/Mahindra/GE
- Experienced in moving OCR and voting disk files from one ASM diskgroup to another ASM diskgroup/ Non-ASM to ASM database/Add and Delete RAC node/Switch over and failover Physical standby database/Grid Installation/Monitoring Setup
- Formerly known as Qsoft Systems and Solutions
Education
BE - E&E
Adichunchanagiri Instuite of Technology
Chickamagalur, Karnataka01.2007
2nd PUC -
MES SSM PU College
Chickamagalur, Karnataka01.2004
SSCL -
St. Joseph Higher Primary school
Chickamagalur, Karnataka01.2002
Skills
- PostgreSQL
- Greenplum
- Terraform
- Git
- Cloud Formation CLI
- AWS RDS
- AWS Aurora
- EC2
- S3 management
- IAM
- VPC
- Unix Shell Script
- Ansible
- Jenkins
- Replication
- WAL-E archive
- WAL Streaming
- AWS-RDS
- Ansible
- Sql
- Plsql
- Phython
- Cloud Watch
- Custom made shell scripts
- AWS lambda
- Azure Cloud - Single/Flexible PostgreSQL server
- Azure Postgres
- Automation
- Installation
- Migration
- Major version upgrades
- Minor version upgrades
- Performance tuning
- Partitioning
- High Availability
- Backup
- Recovery
- Archive
- WALG
- WALG Streaming
- Logical replication
- Disaster Recovery
- PITR
- Load balancing
- Query optimization
- Vacuuming
- Oracle RAC
- Dataguard
- DG broker
- Golden GATE
- ASM
- RMAN
- EXPDP
- IMPDP
- TKPROF
- AWR
- Logminer
- OEM
- 11g
- 12c
Certification
- OCP DBA 9i, Oracle
- OCP DBA 10g, Oracle
Personal Information
Date of Birth: 04/06/86
Visa status
USA - B1 VISA, 2028
Timeline
Senior Database Administrator
Deliveroo
08.2023 - Current
Senior Database Administrator
Meckalyn Consulting
02.2020 - 08.2023
Senior Database Administrator
Dataxu
05.2015 - 08.2019
Database Administrator 2
Intuit
07.2012 - 05.2014
Senior Database Administrator
Oracle India Pvt ltd.
10.2011 - 07.2012
Mindtree India pvt lmt
01.2010 - 07.2011
Cambridge Technology India Pvt Ltd
01.2008 - 01.2010
- OCP DBA 9i, Oracle
- OCP DBA 10g, Oracle
BE - E&E
Adichunchanagiri Instuite of Technology
2nd PUC -
MES SSM PU College
SSCL -
St. Joseph Higher Primary school
Similar Profiles
Aroub AbuazizahAroub Abuazizah
Escalation Specialist at DeliverooEscalation Specialist at Deliveroo
Bence AcsBence Acs
Delivery driver at DeliverooDelivery driver at Deliveroo
Anchal MehdirattaAnchal Mehdiratta
Growth Account Manager at DeliverooGrowth Account Manager at Deliveroo