Title: Oracle DBA

Location: Remote

Company Description:

Sapiens International Corporation (NASDAQ and TASE: SPNS) is a leading global provider of software solutions for the insurance industry, with a growing presence in the financial services sector. We offer integrated core software solutions and business services, and a full digital suite for the property and casualty/general insurance; life, pension, and annuities; and reinsurance markets. Sapiens also services the workers’ compensation and financial and compliance markets.

Our portfolio includes policy administration, billing, and claims; underwriting, illustration and electronic application; reinsurance and decision management software. Sapiens’ digital platform features customer and agent portals, and a business intelligence platform. With a 30-year track record of delivering to more than 600 organizations, Sapiens’ team of over 4,000 operates through our fully-owned subsidiaries in North America, the United Kingdom, EMEA, and Asia Pacific. For more information: www.sapiens.com.

Responsible for supporting, coordinating and maintaining the databases by installing, configuring, troubleshooting, upgrading, performance tuning, backup/restore, security, auditing, production support, migration the databases.

Responsible for the administration of 12c/18c/19c ORACLE databases on prem and AWS cloud, RAC, OEM. Experience with Microsoft SQL Server (2008 or greater) or PostgreSQL is a plus.

Installation of new software: Install / assist with the installation of new versions of ORACLE/SQL server software (RDBMS & Application server). Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

Independently analyse, solve, and correct issues in real time, providing problem resolution end-to-end.

Refine and automate regular processes, track issues, and document changes

Assist developers with complex query tuning and schema refinement.

Provide 24x7 support for critical production systems.

Perform scheduled maintenance and support release deployment activities after hours.

Share domain and technical expertise with team members.

Identify, suggest and promote best practice in existing areas.

Requirements:

• Degree/Diploma or Master’s in computer science or Information Technology
• 4+ years of proven experience in ORACLE/ MSSQL Database Administration and Maintenance.
• 3+ years’ experience in the Insurance/Financial industry, preferred
• Experience in ORACLE management and ability of troubleshooting DB and Performance issues.
• Identifying and resolving incidents and address to user problems/concerns.
• Experience in Database monitoring and tuning using TKPROF, EXPLAIN PLAN, OEM and custom scripts.
• Hands on experience in DB backup/recovery process using RMAN.
• Experience in using Data pump, Export /Import, Sqlplus and SQL Loader.
• Knowledge of PL/SQL is a must, T-SQL - Plus.
• Experience in backend design and development
• Knowledge of Windows and Linux environments
• Knowledge of networks and PC operating systems
• Extensive technical and design knowledge
• Good administrative and applicative knowledge
• Proficient & competent in communication, accountability, decision making, intrapersonal & interpersonal skills
• Experience in Data Migration among various RDBMS
• Cloud working experience AWS preferred, Azure is a plus.

Sapiens is an E-Verified & Equal Opportunity/Affirmative Action Employer, M/F/D/V.