Senior IT  Systems Engineer - Business Systems

J  o  b    D  e  s  c  r  i  p  t  i  o  n

Job Information

Title:

Senior IT  Systems Engineer - Business Systems

Market Range:

IT16

Approved Date:

1/16/2024 1:45:16 PM

FLSA:

Exempt

EEO Code:

PROFESSIONALS

Career Level:

P4

Career Level Description:

Professional Level 4

Job Code:

101007

Job Family:

Information Technology

Sub Family:

IT Business Systems

Primary Purpose

Lead role selecting, developing, administering, maintaining, and implementing policies and procedures for ensuring the security and integrity of the county's various business systems environments. Provides technical direction, review, development, testing, implementation, and support of applications to include upgrades and maintenance projects. Assists in budget preparation and acquisition of technology. Maintains a level of knowledge that is current with new technology and shares with others. Influences and collaborates with other IT teams, and vendors on software / hardware procurements. Provides technology training and materials to various system business and technical teams. Provides consultation and support to other IS and business staff as well as forming good relationships with County departmental staff, County vendors and partner agencies. Defines and supports best practices for development and maintenance of applications. Performs complex data integration, migration, interfaces, and scripting.  Documents complex procedures and troubleshooting procedures related to systems/networks software and hardware and works to simplify where possible.

•

Lead the research, planning, design, implementation, and management of complex business systems. Administers the business systems production and test environments on a day-to-day basis to ensure the stability, integrity, and efficient operation of the in- house information systems that support core organizational functions. This includes ensuring backups, security, patches, and change management. Develops and implements policies and procedures for ensuring the security and integrity of Wake County systems. Implements system architecture, data models and works with database engineers on designs, data access and table maintenance. Designs and builds interfaces and reports as required. Develops and lead strategies for data archive recovery. Implements change control procedures. Coordinates production scheduling with other technical staff. Serves as technical lead and consults with vendors, business owners and developers during projects and implementation. Manages licenses and upgrades in the systems environment. Performs planning, and facilitation of data migrations and scripting to manipulate data.

1

45%

•

Monitors system performance and resolves systems performance and, systems capacity issues, replication, and other distributed data issues. Performs and or coordinates / tests platform backups and installs. Provides continuous system platform monitoring often for multiple systems working as one, maintenance, and fine tuning of servers, tools, and systems to ensure the highest level of data availability, integrity, and security. Administers security, patches, configures replications, and monitors scheduled jobs and performance.

2

25%

•

Participates in project meetings and dialogs regarding system related project components. Provides realistic estimates of specific project related tasks to the project manager. Provides prompt and clear communication of project task status and any related issues in project meetings and through email and phone dialogs. Mentoring of Junior staff and contract staff. Is comfortable communicating across a wide audience including executive leaders. Provides technical platform design, support, and assistance. This includes development, system configurations, and performance monitoring / tuning.

3

20%

•

Stays current on system platform environment technology upgrades and changes to ensure a stable and scalable system platform for Wake County, and shares with others. Often takes training and certifications for specific system platform.

4

10%

Position(s) may perform other duties in addition to the above as assigned by management.

*IMPORTANT* In the event of an emergency, as determined by the County Manager or designee, participation in preparedness and response operations should be expected. Employee may be required to fill a temporary assignment in a role different from standard duties, work hours and/or work location in preparation for, during and after the emergency. Employee may also be required to participate in relevant exercises and regular preparedness training.

Career Level Dimensions

Career Level:

P4

Career Level Description:

Professional Level 4

•

Plans and manages execution of large projects that span a Division or multiple Work Groups OR works as an independent technical expert within a Medical or Scientific Discipline.

•

Works independently with minimal direction. Viewed as subject matter expert within discipline.

•

Provides measurable input into new processes, standards and/or operational plans that impact Division results.

•

Responsible for making moderate to significant improvements of processes, systems or standards to enhance performance of the Work Group.

•

Propose new ideas and creative solutions to existing problems and/or work areas.

•

Works to influence parties within and outside of the Work Group and Division regarding projects and procedures.  May have responsibility for communicating with external parties and senior leaders.

•

Typically responsible for providing guidance, coaching and training to other employees within Division or the Work Group.

•

May manage projects at this level, requiring responsibility for the delegation of work and the review of others' work products

•

Requires deep knowledge of discipline typically obtained through advanced education combined with extensive experience. Typically viewed as having a specialty within a discipline. May have broad knowledge of project management.

•

Within Medical or Scientific Disciplines, typically requires a doctoral degree and post-doctoral training.

Qualifications

•

Bachelor's degree in Computer Science, Information Systems, Computer Engineering or related field

•

Five years of experience in IT systems design and administration

•

Equivalent education and experience are accepted

•

Knowledge of the principles and practices of customer service to develop and maintain a high level of customer satisfaction with the services delivered by the department

•

Ability to work cooperatively in a team environment or independently

•

Excellent verbal and written communication, organization, and leadership skills

•

MS SQL server mirroring and Availability Groups or VMware clustering technology

•

Experience writing programs and scripts using the C# programming language / VB .Net or BASH

•

Analytical mind with advanced problem-solving aptitude

•

Working knowledge of Cohesity backup and recovery for MS SQL or Oracle

•

Working knowledge of MS SharePoint or Oracle

•

Working knowledge of Storage Array Network (SAN) technology

An individual must be able to perform each essential duty satisfactorily to perform this job successfully. The requirements listed above are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Competencies

Analysis

Examines data to grasp issues, draw conclusions, and solve problems.

Attention to Detail

Thoroughness in accomplishing a task through concern for all the areas involved, no matter how small. Monitors and checks work or information and plans and organizes time and resources efficiently.

Customer Service

Balances interests of a variety of clients, and readily readjusts priorities to respond effectively to pressing and changing demands for information, advice and assistance.  Anticipates and meets the needs of clients; achieves quality end products; and commits to continuous improvement of services.

Problem Solving

Builds a logical approach to address problems or opportunities or manage the situation at hand by drawing on one's knowledge and experience base, and calling on other references and resources as necessary.

Technical Expertise

Applies and improves extensive or in-depth specialized knowledge, skills, and judgment to accomplish a result or to accomplish one's job effectively.

Integrity

Act with honesty, transparency and respect in our interactions with co-workers and those we serve. Adhere, without exception, to laws, policies, procedures and professional standards.

Accountability

Establish high-quality standards for work. Add value. Measure results and hold self and others accountable for making progress toward desired outcomes. Take a logical and data-driven approach to decision-making.

Diversity

Believe that different backgrounds and experiences strengthen the organization and produce better results. Value inclusion across race, gender, age, religion, identity and experience, and strive to reflect in our workforce the diversity of our community.

Collaboration

Foster a work culture in which different ideas and opinions are encouraged and expected. Listen carefully and speak thoughtfully. Work together toward shared goals with mutual respect and cooperation.

Continuous Improvement

Continuously improve work processes and products. Provide a safe environment to be innovative and creative and try new things. When things don't go as planned, use it as an opportunity to learn, regroup and begin again. Provide time and resources for individuals to grow and develop both personally and professionally.

Wellness

Take proactive steps to be physically fit and healthy, emotionally strong, financially secure and socially fulfilled, while inspiring and empowering others to do the same.

Service Orientation

Commit to making a difference within the community. Actively engage in and enjoy our work. Deliver services that exceed expectations, with courtesy, politeness and sensitivity to the experiences, concerns and feelings of all co-workers and customers.

ADA Checklist

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions

Standard ADA Selection:

Office Environment

Standing

X

Walking

X

Sitting

X

Lifting/Carrying 0-10 pounds

X

Lifting/Carrying 10-20 pounds

X

Lifting/Carrying 20-50 pounds

X

Lifting/Carrying 50-100 pounds

X

Pushing

X

Pulling

X

Climbing

X

Balancing

X

Stooping

X

Kneeling

X

Crouching

X

Crawling

X

Reaching

X

Handling

X

Grasping

X

Fingering

X

Feeling

X

Talking

X

Hearing

X

Visual Perception

X

Repetitive Motions

X

Eye/Hand/Foot Coordination

X

Memorization/Concentration

X

Learning/Knowledge Retention

X

Preparing/Analyzing Numerical Figures

X

Use of Interfaced Commmunication Devices (Phone, Computer, Radio etc.)

X

Analyzing/Examining/Testing Data

X

Emotional/Behavioral Self-Regulation

X

Interacting with Others

X

Comprehension

X

Organization

X

Decision Making

X

Comprehension

Understand complex problems and collaborate to explore alternative solutions

Organization

Organize and prioritize individual work schedule to manage multiple tasks and/or projects

Decision Making

Make decisions that have significant impact on a department's credibility, operations and/or services

Communication

Communicate in-depth information for the purpose of interpreting and/or negotiating

Extreme cold

X

Extreme heat

X

Humid

X

Wet

X

Noise

X

Hazards

X

Temperature Change

X

Atmospheric Conditions

X

Vibration

X

Computers/Monitors

X