INDRAJA SIRIPURAM
Overview
14
14
years of professional experience
Work History
Database Engineer -Tech services
Deutsche Bank
10.2023 - Current
- Supporting Prod, Dev, and Test environments of 19 and 12c databases.
- Working with development team to build internal tools for the Bank.
- Working on DR setup and switchover activities.
- Working on Cluster and database build in Exa cloud environments as per bank standards.
- Working on changes, Incidents, RITMs and service requests based on the requirement and adhering to the ITIL process.
- Working on automation scripts/tasks to run refresh every month based on the application team request.
- Working on call during priority incidents and weekend migration cutover activities.
- Working on migration activities from legacy systems to Exa cloud environments.
- Working on Performance issues during migration activity.
- Working on configuring backups as per bank standards.
- Working on database flashback and database restore whenever required by application teams.
- Adhering to ITIL process and supporting the environments.
- Planning and executing changes as per the oracle recommendations and bank requirement.
Senior Specialist - Cloud Services and Software
L&T Infotech
10.2021 - 10.2023
- Supporting Oracle Prod, Dev, and Test environments of 19 and 12c databases.
- Worked on Migrating Databases from PostgreSQL to oracle.
- Worked on Migration databases from MS SQL server to Oracle.
- Supported MS SQL server databases.
- Administer and optimize MS SQL Server databases for mission-critical applications.
- Implement Always On availability groups to ensure high availability and disaster recovery for enterprise databases.
- Designed and maintained complex T-SQL scripts, enhancing system performance, and reducing manual effort.
- Delivered real-time business insights using SSRS and integrated SQL Server data into Power BI dashboards.
- Install and Configure Oracle Gateway to fetch data from non-oracle DBs as per client requirement.
- Install and configure Oracle database as per client requirement.
- Worked on Performance issues during migration activity.
- Worked on DR setup and switchover activities.
- Worked on Refresh activities restoring backups from prod environment.
- Worked on configuring backups, maintenance scripts.
- Planning and executing Release updates (RU) on all environments.
- Understanding of network and storage concepts, technologies, and equipment.
- Investigated problematic SQL and PL/SQL using AWR, ADDM, ASH, dynamic performance views.
- Rewrote problematic SQL and PL/SQL, eliminated verbose code blocks.
- Created SQL profiles, SQL baselines for wrapped code blocks.
- Created required indexes and dropped unused indexes.
- Operating and troubleshooting Tivoli backup systems.
- Client: Honda and CITI Bank
Senior Analyst
Oracle India Pvt Ltd
07.2018 - 10.2021
- Providing 24x7 support.
- Supporting Prod, Dev, and Test environments of 19,12c and 11g databases.
- Supporting Exadata infrastructure.
- Planning and executing QFSDP on Exadata environments.
- System monitoring and alert.
- Worked on DR setup and switchover activities.
- Worked on Storage expansion, configuring new Exadata cells and adding them to ASM.
- Worked on configuring ZDLRA policies and DB backups.
- Installing, configuring, and provisioning Databases as per client standards.
- Worked on Service now tickets to implement ad hoc/planned tasks.
- Worked on DBA tasks like expdp, impdp,table reorg,hugepages, monitoring via OEM and manual scripts.
- Client: Nation Australian Bank (NAB)
Consultant
Genpact
06.2017 - 07.2018
- Providing 24x7 support.
- Supporting Prod, Dev, and Test environments of 12c and 11g databases.
- Supporting Exadata infrastructure.
- Worked on creating VMs and configuring VMs in Exalogic environment.
- Worked on Linux shell scripting to automate day to day activities.
- Worked on Hardware replacements.
- System monitoring and alert.
- Refreshing the lower environments from Prod backups.
- Performing Exadata Health Checks Smart Scans/Storage Indexes/Instance Caging.
- Worked on Database/grid upgrades from 11g to 12c.
- Worked on ZFS storage replication.
- Worked on Patching Exadata storage servers and Bundle patches on ASM and Oracle homes.
- Client: GE motors
Database Engineer
Birlasoft
07.2016 - 06.2017
- Providing 24x7 support.
- Supporting Prod, Dev, and Test environments of 12c and 11g databases.
- Supporting Exadata infrastructure.
- System monitoring and alert.
- Worked on Storage expansion, configuring new Exadata cells and adding them to ASM.
- Worked on creating VMs and configuring VMs in exalogic environment.
- Worked on Linux shell scripting to automate day to day activities.
- Worked on Hardware replacements.
- Refreshing the lower environments from Prod backups.
- Performing Exadata Health Checks Smart Scans/Storage Indexes/Instance Caging.
- Worked on Database/grid upgrades from 11g to 12c.
- Worked on Patching Exadata storage servers and Bundle patches on ASM and Oracle homes.
- Client: GE motors
Technical Analyst
Oracle India Pvt Ltd
08.2011 - 03.2016
- Supporting Prod, Dev, and Test environments of 12c and 11g databases.
- Supporting Exadata infrastructure.
- Managing Exadata Storage Cells through cellcli and dcli.
- Performing Exadata Health Checks Smart Scans/Storage Indexes/Instance Caging.
- Worked on Database upgrades from 11.2.0.3 to 11.2.0.4/12c.
- Worked on Patching Exadata storage servers and Bundle patches on ASM and Oracle homes.
- Installed oracle 11g silent installation and standardized according to client requirements.
- Providing 24x7 support.
- Restored data using import and export utilities.
- Worked on User management, tablespace management.
- Worked on Configuring targets in OEM.
- Troubleshooting many prod and non-prod database issues.
- Clients: Target, Novartis, Abott, GE, Cardinal Health
Timeline
Database Engineer -Tech services
Deutsche Bank
10.2023 - Current
Senior Specialist - Cloud Services and Software
L&T Infotech
10.2021 - 10.2023
Senior Analyst
Oracle India Pvt Ltd
07.2018 - 10.2021
Consultant
Genpact
06.2017 - 07.2018
Database Engineer
Birlasoft
07.2016 - 06.2017
Technical Analyst
Oracle India Pvt Ltd
08.2011 - 03.2016