Position Summary: The Database Administrator plays a key part in maintaining server availability/uptime. In this role, a person will be responsible for performance tuning misbehaving systems as issues arise, helping maintain the SQL Servers (patching and installing), and ensuring backups/maintenance is working. This role is the owner of all SSRS reports in use, and responsible for maintaining current reports and creating new ones. This position is part of a highly collaborative environment working with other skilled professionals which include business analysts and software developers to ensure data integrity, optimize database performance, and support business intelligence initiatives.

CSI employees are engaged daily in the company’s culture, committed to our core values and have a passion for excellence in order to successfully drive and support the company’s goals, vision and mission.

Employee Core Value Vision:

• Goal setting (personal and professional)
• Customer centric focus (internal and external)
• Risk taker: willing to step out of comfort zone
• Recognizing failures and applying lessons learned
• Positive approach to conflict to avoid stagnation within the organization
• Continuous personal and professional development
• Question and challenge the status quo when necessary

The job functions listed are a guideline and may require updating as changes occur.

Primary Functions

• Install and maintain MS SQL Servers
• Plan, manage and optimize SQL server HA/DR policies and procedures
• Create/migrate, refresh and deploy databases
• Create and maintain database replication plans
• Create and maintain database backup, maintenance and restore plans
• Create automation for repeating database tasks
• Monitor and troubleshoot performance related issues
• Test disaster recovery scenarios
• Create tables, views, stored procedures, functions, and report queries related to database administration
• Develop, adapt, troubleshoot, and maintain SSRS SQL Forms and robust SQL reports.
• Develop and maintain documentation for database processes and procedures
• Work with third party vendors as required.
• Assume other database duties as assigned.

Corporate Functions

• Comply with all federal, state and local laws applicable to position and employment generally
• Comply with all company policies, procedures and expectations to the benefit of the organization and co-workers
• Productively and positively contribute to our goal of maintaining a safe, healthy, productive and enjoyable workplace
• Performs other duties as assigned by the manager.

Position Requirements:

Education/Training & Experience

Experience with Epicor MS SQL databases and MS SSRS report builder required

Bachelor’s degree in Computer Science, Information Technology, or related field or 6+ years experience in MS SQL database administration

Strong proficiency in SQL programing skills with the ability to write complex queries, stored procedures, views, and triggers.

Experience with database optimization and performance monitoring and tuning

Competency using Project Management software and Microsoft applications including Word, Excel, PowerPoint, Teams, and Outlook.

Excellent problem-solving and analytical skills.

Strong communication and teamwork abilities.

More than 40 hours per week may occasionally be required in order to achieve the productivity necessary for this position. Overnight travel, Saturday, Sunday and holiday hours may occasionally be required but are not anticipated with this position.

CSI Professional Performance Competencies:

Appearance: Presents themselves in a manner consistent with CSI brand, demonstrating pride in the role and the company.

Takes Pride in Work: Able to connect the impact of the current role to the overall mission of the organization, recognizing that others count on their work and, therefore, carefully and thoroughly finishes tasks.

Conscientious: Recognizes that others count on them to perform in their role including being at work at agreed on times. Makes best use of resources and company tools. Thoughtful of others’ feelings and job requirements. Does not violate the of others. During interactions with others will protect the dignity of the prospect.

Cooperative: Able to settle differences between others by arranging for or bringing about, through discussion, settlement of terms concessions, when appropriate. Able to give and take challenges, adjust differences and restore relationships. Diplomatic; not unyielding or resolute without good reason and able to articulate reasons to an audience beyond oneself.

Decision Making Skills: Objectively evaluates all aspects of any situation and the efforts of other people. Determines causes of events and speaks about those causes without attacking the dignity of others. Makes sound judgments. Thinks clearly and logically. Sensible. Does not act without due consideration of causes and effects on others including CSI People, Customers, and Suppliers.

Delegator: Able to choose correct person to empower and entrust with one of his or her responsibilities. Able to make requests, demands, give instructions and direct with authority. Receives respect.

Encourager: Inspires other with courage, confidence, assistance, and challenge. Is eager to perform duties and optimistic about their outcome. Rallies, strengthens and emboldens others. Is not inactive, depressed, low in spirits, dejected or overly critical. Does not behave or speak in ways which attack the dignity of others. Can openly discuss failures of self and others with lessons learned as the outcome.

Initiative: Begins work on time. Enjoys achieving and exceeding standards; sets goals above the standard. Ready and able to initiate action. Voluntarily attempts to solve non-routine job problems as they occur.

Independent: Does not have to be managed or directed by others or subject to their authority in order to accomplish objectives or requests. Self-governing. Maintains a balance of seeking and accepting guidance and direction from higher authority as well as mentors.

Innovative: Uses imagination and creativity to determine improvement in methods and procedures. Offers suggestions that improve productivity and/or the profit to cost ratio.

Organized: Arranges environment in a systematic manner to achieve objectives. Willing to give ideas on how to better the system in place and help implement the idea.

Persistent: Determined to accomplish tasks or goals. Works through obstacles with little or no direction. Capable of collaborating with a variety of individuals having conflicting agendas, and persuading others to accept a specific opinion or action.

Stress Handler: Able to handle mental tensions, pressures, urgencies and important situations. Able to prioritize multiple activities to finish tasks on time.

Time Manager: Controls, uses, and directs time well to succeed in accomplishing responsibilities. Able to set priorities. Must be accountable for your time.

Verbal/Nonverbal Communication: Expresses self in positive manner and interchanges thoughts, information and feelings orally. Pleasant. Agreeable and amiable in behavior and manner. Is considerate, courteous, respectable, and well-mannered. Kind. Is not hostile or harsh.

Written Communication: Expresses self in positive manner. Interchanges thoughts, information, and feelings effectively to others. Written communications are clear, factual, thoughtfully structured, and grammatically correct.

I have read and understand the MS SQL Database Administrator description and can perform the primary functions with or without reasonable accommodation. I understand that this is not a contract for employment.

______________________________________________ _______________________________

Signature of Employee Date

_____________________________________________ ________________________________

Signature of Supervisor Date