Salary : $73,934.00 - $77,631.00 AnnuallyLocation : Louisburg, NCJob Type: Full TimeJob Number: 202200418Department: Information TechnologyOpening Date: 12/17/2024Closing Date: 1/16/2025 11:59 PM EasternGeneral Statement of Duties The Franklin County IT Department is currently recruiting for a skilled and detail-oriented Business Systems Administrator with a strong background in Database Administration to join our team. In this role, you will be responsible for managing, optimizing, and supporting critical business systems and databases to ensure optimal performance, availability, and security. You will collaborate with cross-functional teams to ensure seamless integration of business applications, streamline processes, and provide technical expertise for ongoing system improvements.Work includes implementing and maintaining technical application solutions and applying appropriate technology to projects with broad organizational scope. Work involves the planning, development, maintenance, and monitoring of a database system with multiple applications consisting of diverse data sets. Employee participates in the development of solutions for various problems to include maintenance, modification, or development of inter-related applications and solutions including troubleshooting problems with hardware, networks, and software, as well as ensuring new system applications are consistent with the database software format. Work is performed under the general supervision of the Information Technology Director and is evaluated through conferences, records, and reports. Duties and Responsibilities/Knowledge, Skills, Abilities
- Business Systems Administration:
- Administers and supports enterprise business systems (e.g., ERP, CRM, HRIS, etc.), ensuring they operate efficiently and meet business needs.
- Monitors system performance and resolves issues related to hardware, software, and network infrastructure.
- Implements system updates, patches, and new features to keep business systems current and secure.
- Works closely with key business stakeholders to identify and address system enhancements, workflow automation, and process optimization opportunities.
- Maintains system documentation, user guides, and SOPs (Standard Operating Procedures) for business system usage and administration.
- Installs, upgrades, and maintains software products/versions for the County's ERP system.
- Database Administration:
- Manages and maintains relational databases (e.g., SQL Server, MySQL, PostgreSQL) to ensure data integrity, availability, and security.
- Performs database backup and recovery, tuning, and optimization for improved performance and reliability.
- Implements and enforces database security policies, including user access controls, encryption, and data masking as required.
- Designs and executes database migrations, schema changes, and data import/export operations.
- Troubleshoots and resolves database performance issues, application-related database errors, and connectivity problems.
- Plans, develops, maintains, and monitors a database system which contains multiple applications consisting of diverse data sets and provides concurrent accessibility of the database to multiple users.
- System Integration & Automation:
- Integrates business systems with other internal and external applications, ensuring seamless data flow and process automation.
- Develops and maintains scripts, batch processes, and automation workflows to streamline recurring business tasks.
- Collaborates with developers and IT teams to support system upgrades, new implementations, and integration projects.
- Installs and maintains virtual servers.
- Technical Support & Troubleshooting:
- Provides second- and third-tier support for escalated technical issues, particularly those related to business systems and databases.
- Works closely with rest of Information Technology staff to troubleshoot and resolve issues in a timely manner.
- Performs root cause analysis for recurring issues and suggests improvements to avoid future problems.
- Documentation & Training:
- Maintains accurate system configurations, change logs, and maintenance records.
- Assists in the creation and delivery of training materials for end users to ensure they can efficiently use business systems and databases.
- Provides ongoing user support and training on system functionality, best practices, and troubleshooting.
Knowledge, Skills, Abilities
- Strong knowledge of enterprise business systems (e.g., ERP, CRM, HRMS, etc.) and their integration.
- Considerable knowledge of principles and techniques of complex database administration including programming and systems analysis.
- Working knowledge of a variety of Operating System platforms on Servers Windows 2012 Server, Windows 2016 Server, UNIX, and Linux.
- Working knowledge of a variety of Operating Systems platforms on Workstations, Windows 10.
- Considerable knowledge of effective project management methods.
- Ability to recognize, analyze, and provide solutions to complex programming problems.
- Ability to detect and correct system failures and report programming failures.
- Hands-on experience with database management systems (e.g., SQL Server, MySQL, PostgreSQL, Oracle, etc.).
- Proficiency in database optimization, backups, performance tuning, and disaster recovery planning.
- Familiarity with scripting languages (e.g., PowerShell, Python, Bash) for automation tasks.
- Experience with cloud platforms (e.g., AWS, Azure, Google Cloud) is a plus.
- Strong understanding of security best practices for both systems and databases, including encryption, access control, and compliance requirements (e.g., GDPR, HIPAA).
- Excellent problem-solving and troubleshooting skills with the ability to think critically under pressure.
- Strong communication and interpersonal skills, with the ability to work collaboratively across teams.
- Certifications related to systems administration or databases (e.g., Microsoft Certified: Azure Administrator Associate, Oracle Certified Professional).
- Experience with business intelligence (BI) tools and reporting systems.
- Familiarity with ITIL or other IT service management frameworks.
- Knowledge of DevOps practices and continuous integration/continuous deployment (CI/CD).
Desirable Education and Experience
- Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent experience).
- Minimum of 3-5 years of experience as a Business Systems Administrator or Database Administrator.
Other Information Must possess a valid North Carolina driver's license upon hire.Franklin County offers a competitive benefits package designed to encourage and support your health, well-being and productivity. Benefit options include medical and dental insurance; elective supplemental insurance options such as short-term disability, vision, and voluntary term life; local government retirement; 401(k) with a 4% employer contribution (no employee match required); generous paid leave that includes 13 county-observed paid holidays per year; an employee wellness program inclusive of a county sponsored gym and an employee assistance program.For more information about Franklin County benefit options please click here