Database Administrator

Jefferson Capital Systems - Sartell, MN

Full-time

Sartell, MN

Securities, Commodity Contracts, and Other Financial Investments and Related Activities

About the position

Jefferson Capital is seeking a Database Administrator who is highly motivated and flexible, with a strong passion for SQL. The role involves implementing and supporting SQL Server setups and associated components, ensuring security best practices, and collaborating with developers to enhance database functionality and performance. The ideal candidate will have a broad technical knowledge and the ability to manage multiple responsibilities within the IT department.

Responsibilities

• Implementation and support of SQL Server setup and all associated components such as Database Services, Analysis Services, Integration Services, and Reporting Services.
• Set-up and support of SQL Replication, Log Shipping, and/or other technologies used to provide HA environments for SQL Server.
• Work closely with SQL and Application Developers to assist with database design, process design, and other items impacting SQL functionality and performance.
• Ensure security best practices are being followed.
• Monitor SQL system usage, performance, and data storage; identify problem areas and provide suggestions for mitigating issues.
• Establish, execute, and support SQL Server backups.
• Manage SQL Server migration, upgrades, and patches as required.
• Research and identify issues, suggest possible solutions, and follow through to an effective resolution.

Requirements

• College degree in a related field preferred or equivalent related experience.
• 3+ years experience with MS Windows operating systems in a corporate networked environment.
• 3+ years experience with SQL Server with demonstrated management of a SQL environment containing multiple SQL servers.
• Familiarity with information security in a highly regulated industry.
• Familiarity and experience with a variety of security concepts, practices, and procedures.
• Knowledge of and experience with storage environments, redundant disks, and connectivity including Local disk, NAS, SAN, RAID, Fiber, and iSCSI.
• Proficiency in writing Powershell scripts to automate common database admin tasks.
• Strong communication skills and the ability to influence through both written and verbal interactions with a variety of audiences.
• Ability to work independently and as a member of a team.
• Ability to maintain productivity while multi-tasking in a fast-paced environment.