Collaborated with clients to determine project specifications and scope.
Set up secure databases.
Provided technical leadership to team members during system design.
Reviewed clients' overall app and infrastructure estate, business priorities and success criteria to design transformation plans.
Provided current best practices and third-party solution alternatives when necessary.
Improved business productivity for clients by 100% by re-engineering and designing infrastructures.
Monitored and tested application performance to identify potential bottlenecks, develop solutions, and collaborate with developers on solution implementation.
Defined enterprise processes and best practices and tailored enterprise processes for applications.
Improved operations through consistent hard work and dedication.
Created plans and communicated deadlines to complete projects on time.
Developed and implemented performance improvement strategies and plans to promote continuous improvement.
Developed team communications and information for meetings.
Resolved conflicts and negotiated mutually beneficial agreements between parties.
Proved successful working within tight deadlines and fast-paced atmosphere.
Used critical thinking to break down problems, evaluate solutions and make decisions.
Participated in continuous improvement by generating suggestions, engaging in problem-solving activities to support teamwork.
Demonstrated respect, friendliness and willingness to help wherever needed.
Actively listened to customers, handled concerns quickly and escalated major issues to supervisor.
Led projects and analyzed data to identify opportunities for improvement.
Provided resources and skill sets to support DBA functions for applications.
Worked with customers and other third parties to support DBA functions.
Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
Liaised with system administrators to monitor, troubleshoot, triage and provide RCAs for incidents.
Reviewed database design to recommend enhancements or improvements.
Established working relationships across various departments to understand existing and emerging IT requirements.
Set up and controlled user access levels across databases to protect important data.
Developed automated processes to manage database backups to Veeam Storage.
IT Manager
Ramagundam Fertilizers and Chemicals Limited (Joint Venture of EIL,NFL and FCIL)
New Delhi, New Delhi
05.2019 - 10.2021
Guided organizational technology strategy and roadmaps.
Oversaw daily performance of 100 plus systems and immediately responded to Priority issues to keep network up and running.
Coordinated IT operations activities to deliver smooth flow of daily business needs.
Communicated with executive team and CEO to maximize development efficiencies and resolve technology issues.
Oversaw IT department operations and training.
Interacted and negotiated with vendors and contractors to secure products and services.
Customized and repaired technology based on staff requests especially in Payroll processing.
Updated senior leaders on progress and roadblocks.
Wrote policy, procedure and manuals governing internal IT use.
Understood key product management roadmap objectives and requirements to develop product technology strategy.
Processed RFCL Payroll in timely and accurate manner. Created and maintained employees' payroll records. Calculated wages and applicable deductions based on employee attendance and timesheet records.
Defined project scope, identify key milestones and plan key deliverables
Created statements of work, project plans, set time and budget estimates.
Prepared IT Budgeting and Forecasting
Technical Core Committee member for SAP ERP implementation at RFCL and currently looking after implementation along with Tech Mahindra & Deloitte (Project Consultant)
Principal Technical Consultant
Oracle India Pvt Limited
Hyderabad, Telangana
12.2017 - 05.2019
Experienced supporting WebLogic and FMW.
Skilled in cloning Oracle EBS including use of Oracle Rapid Clone utilities
Skilled using Oracle RMAN for backup and recovery
Patch, upgrade, maintain, clone and troubleshoot Oracle EBS 12.2, EBS DB and EBS MT components
Configure, maintain and troubleshoot all EBS 12.2 DBA areas, such as concurrent processing, OPP, SSO, forms servers, https servers, certificates, Workflow mailers, profile options, EBS DB parameters.
Configure, patch, install, maintain and troubleshoot WebLogic Servers
Configure, patch, install, upgrade maintain and troubleshoot Oracle Core Database
Configure, patch, install, upgrade maintain and troubleshoot Oracle RAC/Grid/ASM
Provide proactive performance monitoring and capacity planning;
SQL tuning with tools such as SQL Tuning Advisor, SQL T and SQL Optimizer
Perform Apps DBA tasks within OCI tenancy
Configure, patch, install, maintain and troubleshoot Oracle core databases and Oracle RAC version 12c and 19c
Analyzed root cause of tech stack related issues and provide solutions
Administered and maintained security policies and procedures;
Worked extensively in Linux and shell scripting for Apps DBA tasks
Advisory System Analyst
IBM India Pvt Ltd
Hyderabad, Telangana
04.2015 - 12.2017
Troubleshoot incidents reported by end-users to schedule system changes and identify permanent solutions.
Analyzed existing systems and databases and recommended enhancements to solve business needs
Developed and implemented performance improvement strategies and plans to promote continuous improvement.
Worked with development teams to use Stat Tool for 100's of change deployments by release or target environment using DevOps in ERP environment, without compromising compliance.
Oversight of database availability as well as monitoring performance. This includes reviewing production application and database performance reports on regular basis, identifying any potential performance bottlenecks including SQL, PL/SQL code execution and areas for improvement, identifying I/O, compute and memory bottlenecks and proactively working with Storage and UNIX teams to remediate before impact to Production database.
Automated JSP Files Deployment for Oracle iStore using Concurrent Program.
Lead Administrator
Wipro Technologies
Hyderabad, Telangana
04.2014 - 04.2015
Lead team of Oracle Application Database Administrator's and Supporting Finance & HRMS Functional & Development teams.
Perform database tuning and performance monitoring
Setup and maintain documentation and standards
Capacity Planning
Worked as part of team and provide flexible support when required
Performed general technical troubleshooting and gave consultation to development teams
Interface with Oracle Corporation for technical support.
Maintain Patch Management and Version Control
Maintained Strict Cloning calendar and completed 100's of cloning instances from Production backup.
Monitor application related jobs and data replication activities
Interviewing new DBAs for other teams. Monthly governance calls with customer on service review and road map of DBA
Technical Analyst
Oracle India Pvt Limited
Hyderabad, Telangana
02.2012 - 04.2014
Timely completion of Database and Application Refreshes
Troubleshooting issues related to Oracle EBS ERP Customers.
Ensuring timely completion of RFC’s (Request for Change) within SLA period.
Hands on experience in managing services in Oracle Apps R12.2, 12.1 and Oracle Database 19c, 12c in multi-client environment
Strong understanding of E-Business suite 12.1 and 12.2 architectures
Excellent knowledge of best practices being used in both Apps and Database areas
Good understanding of 19c CDB/PDB concepts especially in12.2 setting
Experienced in sizing and capacity planning
Supported more than 100 Customers on Oracle ERP and Completed 400 plus change requests
Consultant
HCL Technologies
Mumbai, MH
07.2010 - 02.2012
Monitoring and optimize performance of databases.
Supported Clients from North America and South America
Worked on scheduled refreshes on every week.
Fixed issues raised by users through Incidents
Resolved issues such as locking problems, connection problems.
Cloned 50 plus test, dev and other instances using BCV’s and Fracture-Split-Synch Technologies.
Associate Consultant
Sierra Atlantic Application Services Pvt Ltd, Consulting
Hyderabad, TG
11.2007 - 07.2010
Independent Contributor Apps DBA during entire implementation of Oracle ERP Implementation and Upgrade project
Performed six trials of upgrade including Pre-UAT, UAT, and Pre-Prod trials before upgrading Production
Worked at client location (Singapore) during Production upgrade
Installed R12 Oracle Application on two node system with concurrent, admin and DB on one node and forms & web on other node.
Upgraded Oracle applications from 11.5.10.2 to 12.0.6
Upgraded database from 9.2.0.5 to 10.2.0.4
Monitoring to ensure availability of all services related to Apps and Oracle instances
Pre-Patch Analysis of patches recommended by Functional teams.
Applied March CPC 2009 for Financials (Payables and Receivables) and July CPC 2009 for Procurement on 12.0.6 environment.
Education
Bachelor of Technology - Computer
Science & Engineering
Ramagundam Fertilizers and Chemicals Limited (Joint Venture of EIL,NFL and FCIL)
05.2019 - 10.2021
Principal Technical Consultant
Oracle India Pvt Limited
12.2017 - 05.2019
Advisory System Analyst
IBM India Pvt Ltd
04.2015 - 12.2017
Lead Administrator
Wipro Technologies
04.2014 - 04.2015
Technical Analyst
Oracle India Pvt Limited
02.2012 - 04.2014
Consultant
HCL Technologies
07.2010 - 02.2012
Associate Consultant
Sierra Atlantic Application Services Pvt Ltd, Consulting
11.2007 - 07.2010
Bachelor of Technology - Computer
Science & Engineering
Jawaharlal Nehru Technological University
05.2003 - 04.2007
Summary
Accomplished Technical Architect offering 14 years' experience in comprehensive design and development of infrastructure and architecture for Oracle ERP projects. Attentive collaborator and communicator from project conception to completion. Creative in devising solutions to improve business operations and meet clients' technical needs. Seasoned team leader possessing the technical and interpersonal skills to provide exceptional project deliverables.
Similar Profiles
Swetha PSSwetha PS
Paid Assistant at Srihari & CoPaid Assistant at Srihari & Co
Chief Development Executive at Srihari Global IISD Foundation – Educational ProgramChief Development Executive at Srihari Global IISD Foundation – Educational Program