oracle pl sql.

7-10+ years of SQL Server database engineering/development experience including utilizing stored procedures, functions, triggers, and queries.Advanced knowledge of Transact-SQL (T-SQL).Experience in using NoSQL storage technologies such as Azure Cosmos DB.Have performed migration of SQL Server/Databases to Azure environment.Solid experience with MS SQL Server recent versions including Azure SQL, in a DBA capacity.Thorough knowledge of SQL Server installation, configurations, troubleshooting and performance tuning skills required.Experience in database upgrade/migrate, patching, backup recovery of large databases.Expert in database normalization, Back-up / Restore, data import / export, troubleshooting, database objects authorization, DTS; and objects creation such as tables, views, user created data types, indexes, stored procedures, cursors, and triggers.Experience in performance tuning, trending, capacity planning, query optimization, and database consistency checks.Experience with operational excellence, troubleshooting, and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, security issues.  

Exp: 5 to 10 years• Good Experience in Core HR. Identify business requirements and map them to Oracle FusionAbsence Management or Oracle HCM Cloud Time and Labor OTL or HCM Benefits and Oracle payroll• Identify business requirements and map them to Oracle Learning Management• 3 years or more of relevant Fusion experience in Benefits modules and rest of the experience in EBSBenefits/OAB• Identify functionality Fit and gaps and develop solutions to gaps.• Configure Oracle Fusion Absence Management/benefits/payroll/OTL based on customer requirementsand document application set-ups.• Functional troubleshooting in Core HR and Absence Management/benefits/payroll/OTL modules toidentify setup issues and resolve the issues.• Interact with the project team members responsible for developing reports, interfaces, dataconversion programs, and application extensions.• Testing and validating various technical components for the issues and work them to resolutions andclosure.• Support clients with the execution of test scripts and resolve Issues raised in the variousimplementation phases.

Essential Skills: Proficiency knowledge on Acquring process SHould be aware of Settlement and staging process with Banks and Scheme Knowledge on Incoming/Outgoing files to VISA, Master , Rupay and AMEX Scheme Added advantage to have knowledge on Interchange Cost calculation based on Scheme Manual Process orientation and clarity of thoughts Establishing relationships and maintaining contacts with people from a wide variety ofbackgrounds. Demonstrates effective oral and written communication skills Explore to Visa / MasterCard online / offline certifications will be added advantage Should be Analytical and methodical Ability to think out of the box Excellent attention to detail and must be able to report any problems as quickly and accurately Able to work under pressure Capability to handle Team with minumum 5 resource Sound knowledge of Payments Domain, Payment/switching, banking and finance domain Experience with Jira test management tool. Experiences in designing, describing and document test cases Understanding the Process of SDLC, Bug Tracking, Ticketing 19)Experience in multiple full release project life cycles 20) Ability to interact and coordinate with employees at different levels, different groups, anddifferent geographical locations within the company 21) Addressing issues of Apps and Web Server related to Merchants & Interchanges & POS EDCterminal.Technical Must Have Skills: Strong experience on Oracle/PLSQL Development. Banking or Payments career background is an added advantage.