Business Systems Manager

Job Summary/Objective:

The Business Systems Manager plays a pivotal role in overseeing the organization's IT infrastructure and operations. This comprehensive position entails managing software and hardware integration, maintenance, and lifecycle management, alongside providing support for government-furnished equipment and databases. With a keen focus on ensuring seamless integration and functionality, the incumbent orchestrates comprehensive support for government-provided and company-issued equipment and databases. This role demands a deep understanding of IT systems, coupled with adept management skills to optimize technology resources in alignment with organizational objectives. Serving as a central liaison among stakeholders, the Business Systems Manager drives innovation and efficiency in IT operations while ensuring alignment with business needs and regulatory requirements.

Key Responsibilities:

• Oversee the administration and maintenance of SQL databases, including database design, population, optimization, and backup and recovery.
• Act as the primary point of contact for resolving IT-related incidents and service requests.
• Provide timely and effective support to internal stakeholders and end-users, troubleshooting technical issues and coordinating resolution efforts to minimize downtime and disruptions.
• Engage with local staff, contractors, and representatives from the National Guard Bureau (NGB) to understand their reporting needs, priorities, and objectives.
• Utilize the configuration capabilities of enterprise asset management (EAM) software to design custom reports.
• Establish scheduling options for recurring reports, ensuring timely delivery of critical information to stakeholders.
• Conduct testing and validation of custom reports to ensure accuracy, completeness, and reliability of presented information.
• Provide training and support to users on accessing, interpreting, and utilizing custom reports effectively.
• Implement continuous monitoring protocols to oversee the performance and availability of websites supporting operational activities.
• Utilize monitoring tools to detect and promptly respond to any issues or anomalies affecting website functionality.
• Conduct regular maintenance tasks to ensure the ongoing reliability and stability of websites, including updates, patches, and performance optimization.
• Coordinate scheduled maintenance activities during off-peak hours to minimize disruption to operational activities.
• Develop and implement contingency plans to mitigate the impact of unexpected website outages or disruptions.
• Provide oversight and management of the SQL database backends powering the websites, ensuring adequate maintenance to support storage and retrieval needs.
• Conduct regular monitoring and performance tuning of SQL databases to optimize query performance, minimize latency, and enhance overall system responsiveness.
• Conduct regular audits and assessments of SQL database configurations to ensure compliance with organizational policies, regulatory requirements, and industry standards.
• Implement strong authentication mechanisms to ensure access to website databases.
• Utilize encryption protocols to secure data transmission between clients and the database server, protecting sensitive information from unauthorized detection.
• Enforce strict password policies, including minimum length requirements, complexity rules, and regular password expiration, to mitigate the risk of unauthorized access to database accounts.
• Regularly audit database access logs and monitor for suspicious activities or unauthorized access attempts, promptly investigating and mitigating any security incidents.
• Design and maintain the Unclassified Local Area Network (LAN) with redundancy and fault tolerance mechanisms to minimize the risk of network downtime.
• Develop and implement an incident response plan to quickly respond and resolve network issues or outages.
• Maintain comprehensive documentation of network configurations, procedures, and troubleshooting guidelines to facilitate rapid response to network incidents.
• Continuously analyze network performance data to identify areas for optimization and improvement.
• Establish clear procedures for incident management, including escalation paths, prioritization criteria, and resolution timelines.
• Maintain web-based Open Database Connectivity (ODBC)-compliant databases.
• Upgrade the system as new technologies emerge to provide quality, real-time logistics support to supported teams.
• Monitor systems functionality to ensure system reliability.
• Maintain web-based open database Connectivity (ODBC) compliant databases.
• Upgrade systems as new technologies emerge to enhance real-time logistics support for supported teams.
• Monitor system functionality to ensure reliability standards are upheld.
• Operate a help desk and provide on-call technical support to teams.
• Coordinate maintenance activities for fielded equipment.
• Sustain a maintenance management system in compliance with DoD, Army, and NGB regulations.
• All other duties as assigned.

Minimum Qualifications:

• Ability to troubleshoot technical issues independently.
• Strong communication skills and ability to interact professionally with users at all levels of the organization.
• Strong analytical, problem-solving, and decision-making skills, with the ability to adapt to changing technology landscapes and business needs.
• Excellent communication, interpersonal, and leadership skills, with the ability to effectively communicate complex technical concepts to non-technical stakeholders.
• Strong understanding of Microsoft-based technologies.
• Demonstrated ability to effectively manage IT infrastructure, including hardware, software, and databases.
• Proven track record of identifying issues, analyzing root causes, and implementing effective solutions to optimize IT systems and operations.
• Ability to lead and motivate teams, foster collaboration, and drive innovation in IT systems and processes.
• Proven track record of successful project management and implementation of IT systems and initiatives.
• Dedication to understanding and meeting the needs of internal and external customers, ensuring high levels of satisfaction and service quality.
• Flexibility to adapt to changing technology landscapes, business needs, and regulatory requirements to maintain the effectiveness of IT systems.
• Strong attention to detail with a focus on accuracy and precision in all aspects of IT infrastructure management and operations.
• Deep understanding of DoD cybersecurity requirements.
• Knowledge of National Guard operations and DoD protocols.
• Ability to obtain and maintain necessary security clearances.
• United States citizen.

Required Education & Experience:

• Non-Military Personnel: Bachelor's degree in computer science, information technology, management information systems, or related field. Minimum of three (3) years' experience in computer science, information technology, management information systems, or related field.
• Prior Military Personnel: Senior Non-Commissioned Officer (NCO) with a minimum of ten (10) years' experience, or Company Grade Officer with minimum of three (3) years' experience in related field.
• Network Operating System MCSE certification plus experience with Microsoft Server 2008 R2 and Active Directory.
• Web creation experience using raw HTML coding.
• LAN/WAN experience using Cisco switches and routers.
• Experience with DHCP, DNS, and Domain Controllers.
• Proven experience in IT support and maintenance, including server and workstation management, website monitoring, and database administration.
• Demonstrated experience in supporting government-furnished equipment and databases, with a strong understanding of compliance requirements and security protocols.
• Proficiency in SQL and experience with database management systems.

Preferred:

• Non-Military Personnel: Master's degree in computer science, information technology, management information systems, or related field. Minimum of five (5) years' experience in computer science, information technology, management information systems, or related field.
• Prior Military Personnel: Senior Non-Commissioned Officer (NCO) with a minimum of fifteen (15) years' experience in related field, or Company Grade Officer with a minimum of five (5) years' experience in related field.
• Relevant certifications such as CompTIA A+, Network+, Security+.
• Microsoft SQL certification.

Competencies:

• Customer Support
• Compliance & Security
• Continuous Improvement
• Training and Development
• Risk Management
• Change Management
• Software Development Lifecycle
• Software Integration
• Troubleshooting skills
• Application Support
• System Administration
• Database Management
• Scripting and Automation
• Software Documentation
• Vendor Management

Physical Responsibilities:

• Proficient ability to sustain extended periods of seated work at a desk or workstation.
• Ability to move around the facility as needed to attend meetings, access equipment, and collaborate with colleagues.
• Occasional lifting and carrying of equipment or supplies.
• Awareness of safety protocols and procedures to ensure a safe working environment.
• Flexibility to work a rotating schedule as needed in the event of contingencies or as directed by management.

---