Senior Database Administrator

Senior Database Administrator

Requirement/Must Have:

• 5+ years of experience as a Database Administrator in a 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.
• Strong problem-solving skills with a proven ability to manage and troubleshoot complex database, application, and data integrity issues.
• 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.

Responsibilities:

• Serve as Microsoft SQL Server Administrator, monitoring and optimizing database performance, including query tuning, indexing, and capacity planning.
• Manage database security, user access, encryption, and backup.
• Provide technical expertise for data administration, database programming, and the organization's Line of Business (LOB) applications.
• Mentor 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.