Database Administrator III
At Exeter Finance, we are committed to helping customers find the right financing for their next vehicle purchase. By building strong relationships with our customers and network of dealer partners we are able to give options that make sense, getting customers behind the wheel of their car. Every team member is integral to our success. Whether you’re at a servicing center helping customers with their loans, in the field building relationships with dealers, or supporting the company from its corporate offices, you'll enjoy a nurturing, invigorating and positive work environment.Our vision is to be a premier finance company and lender of choice known for its People, Performance and Service.Job DescriptionJob SummaryThe Database Administrator III is responsible for database availability, performance, replication, and backups within multiple database environments that operate 24/7/365. The DBA will monitor performance for both on-prem and Azure databases providing process improvements based on KPIs and metrics created using industry best practices. The DBA will support release cycles that occur throughout the SDLC process. DBA III will assist in cross-training junior DBAs.Essential Functions
Monitor and analyze space usage, system performance and tune/recommend query improvements, maintain data integrity and availability. Provide Gap Analysis, Metrics, KPIs, Performance Dashboard, Configuration Management, and Documentation of systems.
Manage deployment packaging, testing, and implementation. Collaborates with application and data development, data architecture, and other IT teams to ensure releases are delivered with repeatable and auditable processes.
Manage Change, Incident, Problem and Service Management processes related to database activities and implementations.
Document, standardize, and automate deployment processes. Design/build tools and frameworks that support deploying and managing customer applications, including batch and real-time data processing.
Cross-training and support with team members. Create/Follow checklists, automation routines and processes for system validation, maintain a constructive and positive team environment that promotes openness, information sharing, problem-solving and support for common team goals. Assists in reducing maintenance cost while meeting or exceeding business objectives.
Ensures all database servers are backed up meeting Recovery Point Objectives, including Recovery Time Objectives and Disaster Recovery testing. Perform recovery exercises as needed.
Ensures compliance with Exeter’s policies & procedures, safety, state and federal laws, regulations, and standards.
Other duties as assigned.
Education and Experience
College Degree or equivalent in Computer Science or a related field of study or equivalent work experience
Five to Seven (5-7) years of related experience in SQL Server Database Administration
Proficient knowledge and use of SQL Server 2016 through 2019 and proficient knowledge of Azure SQL database and Azure Synapse
Proficient knowledge of SQL Server environment administration, deployment automation techniques, release management, server virtualization, storage snapshots and cloning, environment refresh/synchronization techniques, and data masking/scrubbing/tokenization
Able to troubleshoot database performance and service outages related to all database touch points, database objects, storage, and connections. Basic analytical skills and the ability to solve problems in an efficient, maintainable, and flexible way
Proficient knowledge of SQL Server, T-SQL, Stored Procedures, Triggers, Views, Execution Plans, SQL Server Management Studio (SSMS), and SQL Server Integration Services (SSIS)
Experienced in release management, troubleshooting, and supporting SQL Server environments, Availability Groups, Database Objects, and Replication
Able to document best practices for queries, configurations, databases, connections, and security
Working knowledge in tools utilized for Change, Incident, and Problem Management using ITIL framework
Implemented, administered, migrated, and maintained SQL Servers in Windows, VM, and Azure Platforms
Able to develop scripts using PowerShell, CommandShell, or other code to automate Standard SQL Server builds, monitoring, inventory, or open-source automation tools (OctoDeploy, Chef, Puppet, Ansible, Jenkins, etc.) to automate Standard SQL Server builds, monitoring, inventory, and research
Strong verbal and written communication skills to interact with leadership, peers, and customers
Self-motivated with strong team, interpersonal, and communication skills
Exhibit desire to learn technologies and continue career growth
Ability to work flexible hours as required by business priorities
Experience in any of the following is preferred:
Azure: Synapse, SQL Database, Managed Instance, DevOps
Admin: SQL Server Management Studio (SSMS), Visual Studio, Azure Data Studio
Orchestration: ActiveBatch or other enterprise scheduling tools
Monitoring: Sentry One or other database monitoring tools
Availability: Always On Availability Groups or other High Availability and Clustering solutions
ETL: SQL Server Integration Services (SSIS), Azure Data Factory
Reporting: SQL Server Reporting Services (SSRS), Power BI
Exeter Finance LLC is an Equal Opportunity Employer.Individual compensation packages are based on various factors unique to each candidate including skill set, experience, qualifications and other job-related reasons. 97,100.00 USD-$133,550.00At Exeter Finance, we are committed to helping customers find the right financing for their next vehicle purchase. By building strong relationships with our customers and network of dealer partners we are able to provide options that make sense, getting customers behind the wheel of their car. Every team member is integral to our success. Whether you’re at a servicing center helping customers with their loans, in the field building relationships with auto dealers, or supporting the company from its corporate offices, you will enjoy a nurturing, invigorating and positive work environment.We offer individually tailored compensation packages with competitive salary and benefits, plus training and development opportunities, team member recognition and awards, and so much more.As an equal opportunity employer, we’re committed to hiring talented people, including veterans and military family members, who share our commitment to deliver outstanding customer service where we value our people, performance and service by exhibiting a Culture of Excellence.If you are a California consumer and would like information about our online and offline privacy practices, please see our “California Consumer Privacy Statement” available here (https://res.cloudinary.com/govimg/image/upload/v1670513113/5b74966e98f5e27ebbf48fa8/Exeter%20Finance%20CPRA%20California%20Consumer%20Privacy%20Statement%20Final.pdf) .