Vacancy caducado!
Operations Database Administrator
About defi SOLUTIONS:
defi SOLUTIONS partners with captives, banks, credit unions, and finance companies of all types and sizes to allow lenders to focus and transform their operations. The company’s comprehensive suite of originations, servicing, and analytics solutions together with technology-enabled processing services creates a flexible, configurable, and scalable platform that addresses lenders and borrowers ever-evolving needs. defi SOLUTIONS combines the expertise of defi SOLUTIONS and the former Sagent Auto Lending with the backing of Warburg Pincus, Bain Capital Ventures and Fiserv.
Position Purpose:
The Operations Database Administrator is responsible for all operational aspects of production and non-production database systems across multiple data centers managed by defi SOLUTIONS, Fiserv and other third party service providers. You will oversee the day to day performance, backups, tuning, etc. of all our databases. Additionally, you will work with operational and engineering experts to define requirements, solutions and deliverables. Additionally, you will work with Client Services, Relationship Management and various development and technical teams to ensure the operational needs of our clients and internal users are met. This role is multi-faceted, requiring a candidate with strong communication skill and strong leadership skills.
Essential Job Responsibilities:
-
Develop, review and enhance Microsoft SQL stored procedures and triggers, applying advanced programming techniques (i.e. denormalization, indexes, etc.) to optimize runtime performance and improve scalability.
-
Design database applications for converting, archiving, extracting or replicating data for vendor, customer and system interfaces.
-
Actively identify and refine system architecture and design, evaluating and recommending techniques, technologies and products related to database systems.
-
Develop and implement SQL procedures and automated scripts that support various development and production database environments.
-
Perform routine database maintenance tasks and monitoring.
-
Develop and maintain SQL programming standards.
-
Train and mentor application programmers to effectively develop using SQL.
-
Interacts with clients, analysts, and other team members to resolve issues.
-
Assist less experienced team members and assist in problem resolution as necessary.
-
Performs other duties as required
The above statements are intended only to describe the general nature of the job, and should not be construed as an all-inclusive list of position responsibilities.
Required Qualifications:
-
Associates degree in Computer Science, IT or a related field or equivalent work experience
-
5 years experience in an IT operations environment performing SQL Server programming and administration.
-
Expert in large database design (logical, physical, conceptual) for OLTP and data warehouse environments using the Microsoft platform.
-
Knowledge and experience working on Azure Cloud, Azure SQL and SQL Managed Instance is a plus
-
Experience installing, configuring, backing up, restoring, monitoring and tuning Microsoft SQL Server databases.
-
Experience using SQL Server Agent to develop and schedule administration jobs, alerts and groups.
-
Experience with maintaining high availability SQL environments and Disaster Recovery Strategies.
-
Effective analytical, communication, interpersonal and problem-solving skills.
-
No management experience is required.
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.
Vacancy caducado!