Kiran Bommareddy

*Perform Oracle database performance analysis and optimization, define bottlenecks and manage testing and production implementation
*recommendations for process improvements
*Perform Root Cause analysis
*Perform deep impact analysis of problems, projects or technical solutions
*Closely cooperate with vendors and external service providers
Develop and implement processes

* Used Explain Plan and Oracle optimizer hints to enhance performance of SQL statements.

* Performed the user requirements and troubleshooting activities and resolved connectivity issues. Implemented, administrated, and maintained daily backup and archived data on tape

* Created user accounts and system-level and user-level database objects.

* Rman Point in time recovery as per user request.

* Worked on One of the biggest benchmark indexes

* Worked on performance tuning issues

* OEM 13c Setup and implementation

* Worked on terabytes of DB's

* Strong Oracle databases and Oracle RAC Implementation Experience

• Managed systems and infrastructures by defining hardware requirements and planning storage capacity for databases.
• Eliminated downtime by accurately implementing Monitoring database.
• Installed, upgraded, configured and tuned systems and all associated middleware in LINUX and Windows environments.
• Tested programs and databases to identify issues and make necessary modifications.

• Participated in team-building activities to enhance working relationships.
• Worked flexible hours; night, weekend, and holiday shifts.
• Worked to maintain outstanding attendance record, consistently arriving to work ready to start immediately.
• Used coordination and planning skills to achieve results according to schedule.

• Wrote and maintained technical and functional specifications to document database intentions and requirements.
• Tested programs and databases to identify issues and make necessary modifications.
• Planned and implemented security measures to safeguard vital business data.
• Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.

• Built databases and table structures following architecture methodology for web applications.
• Coordinated with project management staff on database development timelines and project scope.
• Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
• Worked with customers to understand needs and provide excellent service.

· Worked on multiple databases Oracle DB2 and Sybase

· Created Data guard for oracle databases for high availability

· Worked on streams and golden gate

· Worked on Rman Refreshes from production to test databases

· Worked on logic backups for table refreshes

· Worked with different ticketing systems

• Created procedures for system monitoring, recovery, backup and optimization.
• Installed and configured software applications and tested solutions for functionality.