Viswateja Pamidi

• I worked with the banking team to accomplish technical aspects of projects.
• Managed installation, upgrade, and deployment projects.
• Monitored and tested application performance to identify potential bottlenecks, develop solutions, and collaborate with developers on solution implementation.
• Managed and monitored installed systems for the highest level of availability.
• I served as an subject matter expert in meetings with stakeholders discussing project requirements related to the Oracle database .
• Provided technical support to end-users, troubleshooting database-related issues and offering guidance on best practices.
• Maintained up-to-date documentation on database systems, ensuring accurate records of configurations, processes, and changes made over time.
• Improved database performance by optimizing SQL queries and implementing indexing strategies.
• Collaborated with development teams to troubleshoot and resolve application issues, ensuring optimal performance and user satisfaction.
• Collaborated with vendor support personnel.
• Devised scripts and automation tools to improve system efficiency.
• Maintained high-availability systems through regular patching and proactive maintenance tasks, ensuring optimal performance at all times.

• I served as a mentor to junior administrators, fostering professional development and skill growth within the team.
• Led successful database infrastructure upgrade projects, reducing infrastructure costs without compromising performance or security standards.
• Ensured high availability of critical databases by implementing proactive monitoring and disaster recovery strategies.
• Optimized database performance by conducting regular maintenance and implementing best practices.
• Facilitated strong communication between IT departments and business stakeholders through clear reporting on key metrics related to database health and performance indicators.
• Established standardized procedures for routine database tasks, increasing overall productivity within the team.
• Implemented robust backup strategies to safeguard essential data against potential loss or corruption incidents.
• Resolved complex technical issues promptly, minimizing disruptions to the daily operations of the organization.

• Served as an subject matter expert in meetings with stakeholders discussing project requirements related to Oracle database integration.
• Improved database performance by optimizing SQL queries and implementing indexing strategies.
• Provided technical support to end-users, troubleshooting database-related issues and offering guidance on best practices.
• Applied scripting knowledge to in SAP BODS jobs automation.
• Implemented site-to-site VPN across OCI and AWS cloud.
• Built strong relationships with clients through consistent communication and proactive problem-solving efforts
• Mentored junior consultants, helping them enhance their skills and contribute more effectively to projects
• Developed custom solutions based upon clients' strict requirements

• Participated in disaster recovery exercises, testing contingency plans to ensure minimal impact on business operations during emergency situations.
• Managed user accounts within the Oracle Database environment, granting appropriate permissions while adhering to security protocols.
• Improved database performance by optimizing SQL queries and implementing indexing strategies.
• Provided technical support to end-users, troubleshooting database-related issues and offering guidance on best practices.
• Served as a subject matter expert in meetings with stakeholders discussing project requirements related to Oracle Databases integration.
• Coordinated with vendors for hardware and software upgrades, ensuring timely implementation of new features and improvements.

• Served as a subject matter expert in meetings with stakeholders discussing project requirements related to Oracle Databases integration.
• Provided technical support to end-users, troubleshooting database-related issues and offering guidance on best practices.
• Improved database performance by optimizing SQL queries and implementing indexing strategies.
• Managed user accounts within the Oracle Database environment, granting appropriate permissions while adhering to security protocols.
• Installed and configured Oracle Database in Linux and Windows environments.
• Optimized database performance through proper selection of instance types, storage options, and query optimization techniques in RDS environments oracle
• Migration of database to AWS RDS from on-premise.

· Analyzed post-go-live issues to resolve them by understanding issues and workaround till that issues fix and assisting during migration and Post migration.

· Handling regular DB Administration tasks like backup hot or cold/RMAN & non RMAN, creating schemas, managing users, assigning roles & privileges, space management.

· Support during migration and after migration. Analysis of post go-live issues and fix them, understanding issues and suggest workaround till the fix for issues are released.

· Tuning of the application using AWR REPORTS and TKPROF utility for performance enhancements, Application/Database tuning.

• Worked effectively in fast-paced environments.
• Demonstrated strong organizational and time management skills while managing multiple projects.
• Delivered services to customer locations within specific timeframes.
• Provided professional services and support in a dynamic work environment.
• Identified issues, analyzed information and provided solutions to problems.

· Management of Database Creation and Maintenance of Tablespace, Data Files, Undo, Redo Log Files, Temps, and Archive Log Files.

· Patching (PSU), Upgrade and Migration of oracle database

· Installation and management of an Oracle database environment with high availability.

· Experienced in RAC and data guard configuration, administration, and troubleshooting.

· Tuning of the application using AWR Reports and the TKPROF utility for performance enhancements and application/database tuning.

• Ensured compliance with ITIL best practices during incident management activities, promoting standardized processes across the organization.
• Ensured compliance with regulatory standards while executing change management activities.
• Worked well in a team setting, providing support and guidance.
• Assisted with day-to-day operations, working efficiently and productively with all team members.
• · Setup and maintain documentation and standards.