Oracle database administrator Jobs in Columbia, SC

Job Description

Job Description

About defi SOLUTIONS :

It’s an exciting time to join defi!

defi SOLUTIONS is a pioneer in end-to-end, SaaS loan originations, servicing, and managed servicing solutions. Our customers include the highest-volume captive auto lenders, banks, credit unions, and finance companies in North America. We have more than three decades of experience helping lenders reduce time-to-market, streamline operations, and customize lending processes with proven, scalable performance. Learn more at defisolutions.com and follow us on LinkedIn.

Position Purpose :

The Lead Database Administrator is responsible for managing all operational aspects of production and non-production database environments across multiple data centers supporting defi SOLUTIONS. This role oversees daily database performance, backups, tuning, patching, and overall maintenance of all database systems.

You will collaborate with operational and engineering teams to define requirements, architect solutions, and deliver reliable database services. Additionally, you’ll work closely with Client Services, Relationship Management, and various development and technical teams to ensure the operational needs of both clients and internal users are consistently met.

This is a multifaceted role requiring strong communication, leadership, and technical expertise to maintain high availability, performance, and security across all database platforms. Participation with On-Call is a critical aspect of this role, ensuring 24 / 7 support and rapid response to production issues or outages.

Essential functions :

Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.

• Setup, configure and manage SQL Server Always On Availability Groups on virtual machines.
• Primary responsibilities include installation, configuration, security management, patching, upgrades, backups, restores, environment refreshes, performance tuning, routine maintenance, disaster recovery planning and alerting / monitoring.
• Support ongoing database maintenance tasks, many of which must be completed within defined maintenance windows to ensure system availability and compliance.
• Support both Azure and AWS SQL Enviornments
• Interact with clients, analysts, and other team members to resolve issues.
• Assist less experienced team members and assist in problem resolution as necessary.
• Critical On-Call support to participate in incident and problem management processes and provide support as needed to ensure system reliability and timely issue resolution.
• Stay Current on emerging technologies
• Collaborate with other members of the Operations Team to design and implement solutions
• Open and Escalate cases with Microsoft when required
• Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

Required education and experience :

Query Processing and Optimization

Reading and Analyzing Execution plans, table statistics, data distribution and execution times

Types, Maintenance and impact

Isolation levels, Locking mechanisms, deadlocks, etc.

Data Pages, filegroups, row / page compression, etc.

Backup types, Recovery Models, PITR, Disaster Recovery Planning, etc.

Authentication, Encryption, auditing, access requirements, etc.

Wait Statistics, Dynamic Management Views, Query Store, etc.

Database Consistency checks, statistics updates, index maintenance, log file management.

Preferred education and experience :

Additional eligibility requirements :

Travel required :

Affirmative Action / EEO statement :

defi SOLUTIONS is an Equal Opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status.