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, and deletion; Oracle Replication; Control user access to resource & information; Audit Database Operations/Object.• 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.• Configured and supported replication and log shipping in both SQL Server 2008 and 2012.• Windows Patching for Power BI and SQL servers.• Automate SSIS jobs for BI data warehouse DB and cubes refresh.• Implemented and configured SCOM Servers for monitoring SharePoint, DB servers, APP servers and resources alert.• Proficient in Database Management by Installation, Configuration, Administration, Tuning, Migration and Service/Production Support of Database; Database Backups & Recovery issues; Data migration, modification, and deletion; Replication; • Implementation of Audit logs in MS SQL server databases through custom DB triggers.• Configure custom email alerts to send DB performance, CPU utilization and Index fragmentation and Daily SQL Jobs Status report.• Managing Atlas mongo DB NO SQL databases in high availability environments.

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 performance of the Database through Database Tuning – Tuning Applications, Tuning Memory, and Tuning Disk Usage.• 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.• Implementation of High Availability solutions with Oracle RAC, Golden Gate, Physical and Logical Standby Databases (Data Guard). Auditing database operations & object for improvement in performance and for better manageability• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.

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.• Maintain documentation such as functional specification, technical designs, unit test report and unit test case reports.• Deploying bug fixes as per service level agreement.• Planning Backup/Restoration Strategy, Planning and scheduling Backups RMAN, taking Logical Backups (with Export/Import Data pump utilities).CLIENTS INCLUDE/PROJECTS IMPLEMENTED • BAIC CHINA Role: Release Manger/ DBA/Developer• Development of contract management system for car leasing.• Managing team, coordination with client and monitoring issues. • Designed and developed many Performance Measurement Dashboards/Reports that are Dynamic & Interactive with intuitive drilldowns such as Location, Navigations for Installments of Loan of a Business, drill-across & drillable charts (bar-charts, pie-charts, radars, and bubble-charts).• Performing Optimization, Backup & Recovery for client Database.• PACCAR MEXICO Role: Senior Consultant• Development of financial accounting module of car financing application.• Understand business requirements and implemented as per business process.• Developed business logic's for activation of Contracts, Disbursements, and receipts and Installments of business user.

• 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.• Deploying bug fixes as per service level agreement.CLIENTS INCLUDE/PROJECTS IMPLEMENTED • World Vision DAFCustomization of Donor and Fundraising • Blackbaud CRM 2.93 and SQL Server 2008 • University of California - USACustomization of Constituents, Batches and Naming Formats.• Blackbaud CRM 2.93 and SQL Server 2008• PLAN- Australia National OfficeCustomization of Sponsorship Module.• Blackbaud CRM 2.93 and SQL Server 2008• Vogelbescherming – EuropeCustomization of Information Fulfillment process.• Blackbaud CRM 2.94 and SQL Server 2008• ROBI Telecom - BangladeshIntegration and Personalization of Siebel and Oracle EBS R12• Oracle EBS R12 and Siebel 8.1

• 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.• Technical support and knowledge transfer of new releases, updates and post production issues.• Develop and maintain best practices for the successful design and deployment of oracle application solutions.• Business process and user acceptability testing with business users.• Configure and Customize Oracle EBS R12 & OBIEE 11g applications.CLIENTS INCLUDE/PROJECTS IMPLEMENTED • Defence SectorOracle Logistic Management System (Financial & Supply Chain): Oracle EBS R12 automates end-to-end financial & supply chain processes. It includes both B2B and B2C. Major functionalities include the following: • Oracle General Ledger• Oracle Order Management• Oracle Inventory Management• Oracle Enterprise Asset Management• Oracle Purchasing

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.• Concurrent manager administration. Oracle Apps Sys admin functions, cloning of Oracle EBS.• Oracle 10g form based Application deployment on Application Servers.• Develop & Personalize BI Publisher Reports, Concurrent Programs, AME, Workflow, Forms, Framework pages, Oracle public API’s, PL/SQL packages, procedures, functions, triggers and views.• Implementation of Real Application Clusters at NIB for load balancing of their new core banking solution – TEMENOS and for loan management system - FINONE. All implementations were done on RHEL operating systems.• Investigate and resolve complex problems through research and technical analysis.

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