Information Technology Consultant

Information Technology Consultant

Augusta , Maine , United States | Office of Information Technology | Full-time | Partially remote

Apply by : March 6, 2025

Apply

OFFICE OF INFORMATION TECHNOLOGY - MAINE IT

COMPUTINIG INFRUSTRUCTURE & SEVICES (SQL SERVER SENIOR ENGINEER)

Opening Date : February 6, 2025

Closing Date : March 6, 2025

Job Class Code : 0172

Grade : 31

Salary : $77,094.16 - $108,692.48 (includes 15% recruitment & retention stipend and eligible for an additional 5% training bonus)

Position Number : 005000608

MaineIT is seeking a highly talented individual who will represent our C.A.R.E.values in all that they do. At MaineIT we :

Practice Customer-focus, ensuring that our customers are heard, and their needs are met.

Hold ourselves to a high level of Accountability by being transparent with our stakeholders.

Maintain an effective level of Responsiveness by providing timely updates in a proactive manner.

Strive to provide Empathy driven, people-focused services by applying emotional intelligence skills and behaviors.

OVERVIEW :

The Department of Administrative and Financial Services (DAFS) Office of Information Technology (OIT) provides information technology support to over 13,000 employees. OIT oversees large scale enterprise applications that support the critical and diverse business needs of the State of Maine and its agencies.

ABOUT THE JOB DETAILS :

The Office of Information Technology is seeking an Information Technology Consultant with experience inMicrosoft SQL Server (required), Windows Server Administration / Support (required),Microsoft 365 and VMware. The Team within the Office of Information Technology offers professional and technical enterprise services to agencies. The Team resides within the Computing Infrastructure & Services Group, which supports a wide range of applications utilizing Windows Server, Azure, AWS, Microsoft 365, VMware, HPE GreenLake, Azure, Directory Services, SQL Server, IIS, Microsoft Power Platform, SharePoint, and other COTS products. The position is aleadership rolemanaging a team within the Infrastructure & Services group reporting directly to the Director / Deputy Director. Work is performed under limited supervision. This position is in Augusta. The CIS Group requires 24x7 server support. This position is required to participate in an On-Call rotation. The position will be responsible for supervising a team.

WHAT WILL YOU DO?

Senior SQL Server Engineer

Design, implement, and maintain database systems that are performant, scalable, resilient, and secure

Build logging, monitoring, alerting, and automation solutions to aid in the quick detection and resolution of production database issues

Develop robust data backup and restore processes that ensure we never lose data

Provide database development environments that allow for quick and easy testing of new features and expose bugs

Perform regular database upgrades, maintenance, and tuning

Primary technical oversight of SQL Server Team, Hosting Team, and Enterprise Messaging

Super vising technical teams

Responsible for overseeing all billing aspects within the Team

VMware administration and support

Microsoft 365 administration and support

Cloud Computing Azure and Amazon Web Services Platform administration and support

Respond to customer support escalations

Managing hardware and software upgrades

Planning and executing growth and expansion

Manage and troubleshoot licensing issues if they arise

Participate with budget process

Interface with Microsoft Premier Technical Support to resolve any open support cases involving on premise or Cloud based issues

Oversee implementation, develop, support, build, configure, and maintain Windows Server environments, both virtual and physical by the teams the position manages

Analyzes the business requirements of client agencies and forecasts nature and level of future service requirements to recommend information services and automation technology concepts capable of fulfilling projected needs

Participates with the development of technology roadmap for the group

WHAT WE NEED FROM YOU…

Required-Expert in SQL Server Administration and Support

High Availability

Clustering

Required-Expert in SQL Server Reporting Services Administration

Required-Expert in SQL Server Integration Services Administration

Required-Expert in SQL Server Analysis Services Administration

Required-Experience in Supervising a Technical Team

Required-Expert in Microsoft 365 in a corporate environment / government tenant

Experience in Microsoft Windows Server Administration

Experience working to resolve problems or in implementing new solutions

Experience using a ticket management system for work prioritization and daily workload management

Experience with Virtualization

Experience in VMware Administration and Support

Experience with DNS

Experience with Budgeting

Knowledge of Azure Administration and Support

Knowledge of AWS Administration and Support

Knowledge of current information services / automation technology systems and capabilities

Knowledge of Exchange

Knowledge of information security best practices, in dealing with sensitive data (PII, PHI, etc.)

Knowledge with Mobile support and configuration within InTune

Knowledge of technical security best practices

Knowledge of Microsoft Power Platform

Knowledge of proper computer system data security / backup procedures

Ability to understand and contribute to functional requirements and translate them into technical design and development projects

Ability to clearly document features, technical specifications, and infrastructure requirements for self-produced technical work and job processes

Ability to train and mentor personnel in all phases of computer utilization and application

Ability to communicate effectively

Ability to balance the work of multiple projects in an agile environment

Ability to troubleshoot and solve complex technical computer problems

Ability to perform work requiring lifting and / or physical exertion may be required

Must be able to continuously monitor industry trends, technologies, and standards and be able to research, recommend, and apply new technologies as they emerge

PREFERENCE WILL BE GIVEN TO APPLICANTS WHO HAVE :

Expert level SQL knowledge and experience

Expert level SQL administration involving reporting, integration, and analysis

Expert level knowledge and experience working in a Microsoft 365 team environment

Experience supervising a technical team

MINIMUM QUALIFICATIONS :

• A minimum of 10 years of a combination of related post-secondary education, technical certifications, or technology related work experience. Related training, internship experience etc. may be credited as related experience on a month-per-month basis.

The selected candidate will be required to pass the required background checks(fingerprinting may be required) as a condition of employment.

This position is not eligible for visa sponsorship or STEM OPT extensions.

Benefits of working for the State of Maine :

No matter where you work across Maine state government, you find employees who embody our state motto—"Dirigo" or "I lead"—as they provide essential services to Mainers every day. We believe in supporting our workforce's health and wellbeing with a valuable total compensation package, including :

Work-Life Fit – Rest is essential. Take time for yourself using 13 paid holidays, 12 days of sick leave, and 3 weeks of vacation leave annually. Vacation leave accrual increases with years of service, and overtime-exempt employees receive personal leave.

Health Insurance Coverage– The State of Maine pays85%-95%of employee-only premiums ($11,196.96 - $12,514.32 annual value), depending on salary. Use this chart to find thepremium costs for you and your family, including the percentage of dependent coverage paid by the State.

Dental Insurance– The State of Maine pays 100% of employee-only dental premiums ($387.92 annual value).

Retirement Plan– The State contributes the equivalent of 13.29% of the employee's pay towards the Maine Public Employees Retirement System (MainePERS).

State employees are eligible for an extensive and highly competitive benefits package (https : / / www.maine.gov / bhr / state-jobs / compensation-benefits) , covering many aspects of wellness. Learn about additional wellness benefits for State employees from theOffice of Employee Health and Wellness (https : / / www.maine.gov / bhr / oeh / ) .

Note : Benefits may vary somewhat according to specific collective bargaining agreements and are prorated for anything less than full-time.

There's a job and then there's purposeful, transformative work. Our aim is to create a workplace where you can learn, grow, and continuously refine your skills. Applicants demonstrate job requirements in differing ways, and we appreciate that many skills and backgrounds can make people successful in this role.

As an Equal Opportunity employer, Maine State Government embraces a culture of respect and awareness. We are committed to creating a strong sense of belonging for all team members, and our process ensures an inclusive environment to applicants of all backgrounds including diverse race, color, sex, sexual orientation or gender identity, physical or mental disability, religion, age, ancestry, national origin, familial status or genetics.

If you’re looking for a great next step, and want to feel good about what you do, we’d love to hear from you. Please note reasonable accommodations are provided to qualified individuals with disabilities upon request.

Thinking about applying?

Research shows that people from historically excluded communities tend to apply to jobs only when they check every box in the posting. If you’re currently reading this and hesitating to apply for that reason, we encourage you to go for it! Let us know how your lived experience and passion set you apart.

Salary : $11,197 - $12,514