Siva Prasad Orsu
Summary
An accomplished software professional with 9+ years of experience, specializing in innovative solutions for database needs. Proven expertise in managing large scale databases with a focus on efficiency and scalability.
Overview
10
10
years of professional experience
Work History
Senior Consultant DBA
Test Environment Support
06.2019 - Current
- Converted Physical Databases to Virtual from scratch using Delphix.
- Providing Database and Informatica job support.
- Created and updated database designs and data models.
- Set up and controlled user profiles and access levels for each database segment to protect important data.
- Created and implemented database designs and data models.
- Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
- Developed and updated databases to handle customer data.
- Set up and controlled user access levels across databases to protect important data.
- Built databases and table structures for web applications.
- Modified databases to meet needs and goals determined during planning process.
- Adhered to set schedules to test databases for flaws and reduce downtime.
- Utilized RDBMS tools and utilities to monitor, tune and optimize system performance.
- Implemented security measures to protect vital business data.
- Test Environment support includes supporting all the lower environments such as Stage, Development and QA
- Database refreshes and maintenance in all the lower environment whenever necessary
- Maintaining Databases like Oracle, MSSQL, DB2 of lower environments
- Running jobs in Informatica to sync the data in lower environments from Production/prod copy
- Using Ticketing tool ServiceNow for assigning works or raising concerns
- Using CA Workload Automation tool for triggering the jobs
- Using Ansible tool for recycling Apps whenever the Database refreshes or Database restarts occurs
- Using SSRS and MSBI tools to track all the Requests and Incidents
- Splunk for monitoring all the Apps and Databases
- Environment: Windows, Linux/Unix, IBM DB2.
- Worked effectively in fast-paced environments.
Database Administrator/Engineer
Production Support
09.2017 - 06.2019
- Worked on 11g and 12c RAC databases (have enough knowledge on CRS, ASM)
- Adding nodes and deleting nodes and monitoring performance related issues
- Created users & privileges with appropriate roles and levels of security
- Migrated databases between machines
- Installed patch sets and upgraded Oracle (RDBMS)
- Applying PSU patches on Standalone and RAC Databases on regular basis
- Performing database upgrades as part of new releases
Database Admin
Production Support
07.2014 - 09.2017
- Creating database using DBCA
- Creation and managing user accounts of users and granting roles, privileges and profiles
- Creating and managing the table spaces
- Configuring Database in Archive log mode.
Education
Bachelor of Science - Computer Science
Jagan's Degree College
Nellore04.2010
Skills
- Oracle
- MS SQL
- DB2
- UNIX/LINUX/Windows
- SQL, Python
- Commvault
- Delphix
- Informatica
Skills Profile
Windows, Linux/Unix, solaris, Production, Staging, Development and QA, Oracle 10g,11g,12c & SQL Server 2012/14/17,DB2, HTML, SQL, Replication Tools - IBMCDC, Attunity Ticketing Tool - ServiceNow Monitoring Tools - Argent, Manage Engine Performance Tool - SolarWinds, Team Building, Leading the Team whenever necessary, Adaptability, Strategic/Tactical Planning, Excellent Communication and Interpretation skills.
Training
- Attended the Azure-900 training.
- Attended seminars on Oracle.
- Enrolled and learning Python from Coursera.
- Learning Gen AI courses in Pluralsight.com
Timeline
Senior Consultant DBA
Test Environment Support
06.2019 - Current
Database Administrator/Engineer
Production Support
09.2017 - 06.2019
Database Admin
Production Support
07.2014 - 09.2017
Bachelor of Science - Computer Science
Jagan's Degree College
Similar Profiles
David C. ElkingtonDavid C. Elkington
Principal Training Specialist, Instructional Design & Development at Mission Support and Test Services (MSTS), DOE/NNSA ContractorPrincipal Training Specialist, Instructional Design & Development at Mission Support and Test Services (MSTS), DOE/NNSA Contractor
CHRISTINE WALKERCHRISTINE WALKER
Principal Safeguards and Security Specialist at Mission Support and Test ServicesPrincipal Safeguards and Security Specialist at Mission Support and Test Services
Courtney AnneseCourtney Annese
Engineer II at Mission Support and Test Services (MSTS)Engineer II at Mission Support and Test Services (MSTS)
Pradeep RoutraPradeep Routra
IT Senior Principal Consultant Saas, OCI, Sr. Principal DBA at Oracle USA IncIT Senior Principal Consultant Saas, OCI, Sr. Principal DBA at Oracle USA Inc
DEPANDER BHARDWAJDEPANDER BHARDWAJ
Senior Consultant, Role: MSSQL DBA at m2p fintechSenior Consultant, Role: MSSQL DBA at m2p fintech