Sandeep P. Email & Phone Number

Muscat Governorate, Oman

• Configured and Implemented SQL Server 2014 to 2019 Clustering and Always on Availibility Groups with Log Shipping and Replication.
• Responsible for operating Real Application Cluster database, Logical Standby Data Guard and Oracle Streams for synchronization filtered data to satisfy end user requirements.
• Proficient in Database Management by Installation, Configuration, Administration, Tuning, Migration and Service/Production Support of Database; Database Backups & Recovery issues (RMAN); Data migration, modification.
• Migration of existing Oracle ASM storage from EMC to IBM storage.
• Experience in Reporting Services, Power BI (Dashboards), SSRS using MS SQL server and in supporting services.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Muscat, Masqaţ, Oman

Managing SQL, Oracle, My SQL databases in high availability environment.Installation and Configuration of Real Application Clustering, data guard always on in up to date technologies.Performance TuningBackup & Recovery

Muscat Governorate, Oman

• Evaluates database teams, identifying strengths, problem areas, and developing plans for improving performance.
• Upgrade old versions of Oracle/MS SQL Server databases in to new versions.
• Expertise in Performance tuning the production database towards optimal performance based on the changes in the database storage structures due to application change requirements. Monitoring and optimizing the.
• Replication enables with Royal Oman Police and Ministry for voters data through Oracle Streams.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
• Responsible for multiple strategies for backups, performance tuning and monitoring of Microsoft & Oracle databases.

USA

• Implementing business logics in leasing and car financial applications.
• Resolving client and internal database issues and perform general technical troubleshooting and give consultation to development teams.
• Performing functional and performance testing of application and database optimization.
• Developing database objects stored procedures, database triggers, packages etc.
• Technical support and knowledge transfer of new releases, updates and post production issues.
• Develop and maintain best practices for the design and deployment of application solutions.

• Analyzing client needs and business requirements to determine feasibility of design within time and constraints.
• Review, to the extent possible, change in code and the environment that will affect system performance.
• Consult with customers about software system design and maintenance.
• Provide recommendations to management concerning issues of programmer productivity and software development management.
• Configure and Customize Siebel, Blackbaud CRM applications.
• Maintain documentation such as technical designs, unit test report and unit test case reports.

• Collecting business requirements and writing solution design documents.
• Develop & Personalize BI Publisher Reports, Concurrent Programs, AME, Workflow, Forms, Framework pages, Oracle public API’s, PL/SQL packages, procedures, triggers and views.
• Investigate and resolve complex problems through research and technical analysis.
• Developed Item conversion program for assigning Items to Item category set and Categories.
• Imported Items from legacy system into Oracle EBS R12 through Oracle Interfaces & API's.
• Technical review of designed solution and business process verification.

Pakistan

• Collecting business requirements and writing solution design documents.
• Providing DBA and Apps DBA services for Critical 24 x 7 clients like NIB, HBL banks.
• Accountable for multiple strategies and Oracle Recovery Manager to perform backups.
• Troubleshooting RMAN and related components, and operating system errors related to RMAN
• Implementation of security policies to secure database using the Oracle Database features.
• Installation of Oracle E-business suite (11i/12) on UNIX family. Application and database patching of EBS. Migration of 11i EBS 9i Database to 10G.

Pakistan

• PSO CRM,Develop Fleet,Corporate,Loyalty (Oracle Forms & Reports).
• Analysis and resolution of issues occurred in CRM application.
• Executing database replication process at customer premises and monitor replication process. Coordinate further with database lead for troubleshooting on event of replication failure.
• For daily customer queries on issues and requirement related to system coordinate with team lead and timely provide feedback to customer for resolution of issues.
• Accessing replicated database at customer location and create ad hoc reports as per customer requirements.

Bachelor'S Degree, Computer Science

Intermediate, Pre-Engineering

Matriculation, Science

(SSC) - 1st Division