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
Similar Profiles
Dnyaneshwar BhogilDnyaneshwar Bhogil
Trade and Transaction Analyst at Deutsche Bank Group, Deutsche BankTrade and Transaction Analyst at Deutsche Bank Group, Deutsche Bank
PRADEEP KUMARPRADEEP KUMAR
Assistant Vice President at Deutsche India Private Limited (Deutsche Bank Group)Assistant Vice President at Deutsche India Private Limited (Deutsche Bank Group)
Manoj Singh SolankiManoj Singh Solanki
Senior Analyst at Deutsche India Pvt. Ltd- Deutsche Bank GroupSenior Analyst at Deutsche India Pvt. Ltd- Deutsche Bank Group
Amit KulkarniAmit Kulkarni
Vice President at Deutsche India Pvt. Ltd, Deutsche Bank of India, DBOIVice President at Deutsche India Pvt. Ltd, Deutsche Bank of India, DBOI