OFFICE OF INFORMATION TECHNOLOGY - MAINE IT COMPUTING INFRASTRUCTURE & SERVICES Opening Date: July 16, 2024 Closing Date: July 30, 2024 Job Class Code: 0172 Grade: 31 Salary: $77,094.16 - $108,692.48*/Annually (includes 15% recruitment & rentention stipend and eligibie 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 in Microsoft SQL Server, Windows Server Administration/Support, 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 a leadership role 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 * 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 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. 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 pays 85%-100% of employee-only premiums ($10,523.28-$12,380.40 annual value), depending on salary. Use this chart to find the premium 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 ($350.40 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, covering many aspects of wellness. Learn about additional wellness benefits for State employees from the Office of Employee Health and Wellness. 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.