Lead Database Engineer - Boise, United States - defi Solutions
Description
About defi SOLUTIONSdefi 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 services creates a flexible, configurable, and scalable platform that addresses lenders and borrowers' ever-evolving needs.
About the RoleThe Lead Database Engineer is responsible for all operational aspects of production and non-production database systems across multiple data centers utilized by defi SOLUTIONS.
You will oversee the day-to-day performance, backups, tuning, etc. of all our database solutions. 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 skills and strong leadership skills.Essential Job Responsibilities
Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.
Overall responsibilities include installation, configuration, security, patching, upgrades, backups, restores, refreshes, performance optimization, maintenance and disaster recovery.
Support all routine database maintenance tasks many of which require completion in defined maintenance windows
Setup and support DB alerting and monitoring.
Interacts with clients, analysts, and other team members to resolve issues.
Assist less experienced team members and assist in problem resolution as necessary.
Participate in incident and problem management and available on-call as needed
Stay Current on emerging technologies
Collaborates 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.
Required Qualifications
Bachelor's degree or equivalent work experience
10+ years' experience in an IT operations environment performing database administration.
3+ years of experience with Azure portal and all topics in Azure related to database maintenance
Expert in large database design (logical, physical, conceptual) for OLTP and data warehouse environments using the Microsoft platform.
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.
Preferred Qualifications
Knowledge and experience working on Azure Cloud, Azure SQL and SQL Managed Instance is a plus
Knowledge in Azure resources such as Storage Accounts, Blob Storage, Keyvault, Azure Active Directory
Additional Eligibility Requirements
An achiever, self-starter, and eager to learn
You'll have a proven track record of results as we'll expect you to act decisively, think big, and manage your time and your team's time to meet deadlines in a fast-paced, high-volume environment.
Travel required
Up to 10% travel
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.