Quantam Solutions provides IT solutions and consulting for various clients. We offer competitive hourly wages, health benefits, paid time off, and a 401(k) plan. We are currently seeking a Senior Database Administrator.

A public-sector retirement administration organization is currently seeking a Senior Database Administrator for its Division of Enterprise and Technology Services, Application Services Branch II. Located in Frankfort, Kentucky, the organization is responsible for the daily administration of three state-administered retirement systems with over $24.9 billion in combined assets. These systems have a membership of approximately 421,000 state and local government employees in the Commonwealth of Kentucky, including state employees, state police officers, city and county employees, as well as non-teaching staff of local school boards and regional universities.

The Division of Enterprise and Technology Services is staffed by 43 technology professionals divided among 7 branches. The Application Services Branch currently consists of 16 information technology professionals skilled in application development and database administration.

Key Responsibilities:

· Serve as Microsoft SQL Server Administrator, monitoring and optimizing database performance, including query tuning, indexing, and capacity planning. Managing database security, user access, encryption, and backups.

· Provide technical expertise for data administration, database programming, and Line of Business (LOB) applications, including mentoring development staff on SQL optimization and performance enhancements.

· Design, develop, modify, and maintain SQL Server Reporting Services (SSRS) reports; collaborate with business users and analysts to gather reporting requirements and deliver accurate, efficient reporting solutions.

· Troubleshoot and resolve complex production database, LOB, and data integrity issues; provide technical support to development teams and serve as a subject matter expert in data integration functions.

· Collaborate with developers, business analysts, and stakeholders to evaluate user requirements and support application development and data needs.

· Communicate complex technical concepts, processes, and solutions effectively to technical staff, non-technical users, vendors, and other state organizations.

· Perform other duties as assigned.

Preferred Knowledge/Skills/Abilities:

· Five (5) years of experience as a Database Administrator– Senior role.

· Extensive knowledge of Microsoft SQL Server Management software, Visual Studio, and Team Foundation Server.

· Knowledge of database design principles, data modeling, and data warehousing concepts.

· Experience with SQL Server Reporting Services (SSRS) and reporting tools Tableau and Workiva/Wdata.

· Solid problem-solving skills with a proven ability to manage and troubleshoot complex database, application, and data integrity issues.

· Skill in analyzing technical requirements and implementing effective database and application solutions.

· Ability to manage multiple priorities, meet deadlines, and adapt to changing business and technical needs.

· Ability to work independently and as part of a team.

#ind

Pay: $45.00 - $50.00 per hour

Benefits:

• 401(k)
• Dental insurance
• Flexible schedule
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Vision insurance

Work Location: Hybrid remote in Frankfort, KY 40601