Job Description Summary Responsible for monitoring and supporting associated hardware, software, Linux operating system and Oracle databases. Assists in maintaining, configuring, and installing associated system upgrades. Applies expertise of database environments to upgrade, maintain, and improve application processing efficiency. Implements and monitors automation of systems and batch processing. Ensures processes, system backups and procedures are updated. Systems Support Specialist II is distinguished from Systems Support Specialist I by their applicable experience and responsibility for performing more complex database and application administration for a variety of systems. Job Description
Essential Duties and Responsibilities - Performs application administration, installation, configuration, and maintenance to apply upgrades/updates to the core systems and databases and ancillary business systems and applications including but not limited to; DNA, UX, Mulitpoint, tMagic, DNA Contact, and CMC.
- Serves as the system administrator to install, maintain, and apply upgrades/updates to the Application Manager automation database and application.
- Establishes, manages, monitors, and configures batch processes involving scheduling, parameters, and updates of critical business processes. Performs root cause analysis of error messages, aborted jobs, system time outs and other processing problems which could negatively impact Credit Union operations. Contacts business owners and external vendors to resolve problems as warranted.
- Monitors the operational status of assigned servers and related hardware, software, and databases in the Data Center. Takes corrective action to resolve problems promptly or consults with supervisor on actions to be taken.
- Assists in the administration of the Linux, Oracle, SQL, and Windows server environments for core processing systems. Applies and tests the database system updates, hot fixes and patches. Monitors and reports on database health and performance.
- Performs database backup processes and monitors to ensure their successful completion to maintain core process system availability and maintain a high level of system performance.
- Maintains automation schedules to perform daily, weekly, and monthly processing and reporting; monitors the operational status of Core Processing system hardware, software, Linux OS, SQL, and Oracle databases. Ensures that batch processing jobs run as scheduled and are completed accurately.
- Processes and tests SQTs, SQL scripts, new batch jobs, and other procedures in the test environment and provides viable feedback to internal and external Development staff, reports test results. Implements and automates approved changes to the production environment.
- Coordinates testing with third party vendors to implement upgrades and new software enhancements to assigned system and databases.
- Assist in maintaining and updating connections and security keys for all secured file transfer sites.
- Develops, maintains, updates, and communicates procedures.
- Coordinates and executes Change Management requests to move projects into the production environment.
- Provides on-call technical assistance and support 24/7 on a variety of issues involving computer software and hardware troubleshooting. Informs users of system-wide issues and resolutions; documents work performed in helpdesk software and performs maintenance to network and business systems.
- Creates ad hoc SQL for Application Manager and Helpdesk and others as needed.
- Assist in configuring and maintaining test servers and applicable software applications; monitors database health and runs purges; monitors server and database back up processes to ensure successful completion.
- Monitors the Credit Union's electronic channels including ATM, ITM, online banking, and voice response to ensure service availability to Credit Union staff and members.
- Performs user applications support in assigned areas of functional responsibility; research, analyzes, troubleshoots, makes recommendations, and/or resolves a wide variety of system problems; instructs users on method for resolving issues and problems; acts as liaison with vendors and escalates problems when vendor support is required for resolution.
- Maintains records of work performed; assists in maintaining an inventory of supplies for the department.
Company Wide Expectations - Maintains a professional image and demeanor at all times, consistently demonstrating Credit Union RISE Values and adhering to the Code of Ethics.
- Delivers friendly, caring service to internal and external members.
- Complies with all applicable State, Federal and NCUA rules and regulations and all Credit Union policies and procedures.
- Follow all physical and online security procedures and maintain strict confidentiality of all member information.
- Completes all required regulatory and compliance training and maintains required knowledge of Credit Union products and services.
- Works scheduled hours and maintains punctuality.
- Performs other related duties as assigned or requested.
EDUCATION/EXPERIENCE Minimum Qualifications To perform this job satisfactorily, an employee must be able to carry out each essential duty competently. The requirements listed below are representative of the education, experience, skills and abilities required. An equivalent combination of education and experience may be considered.
Education Requirements 4 Year / Bachelor's Degree - Computer Science or closely related field - Required
Experience Requirement - 2 Years - Responsible data center operations experience, preferably in a distributed environment similar in size, scope, and complexity to that of the Credit Union - Required
- Experience with SQL scripting and Oracle and SQL databases - Preferred
- Experience with Windows and Linux operating systems - Preferred
- Technical helpdesk experience - Preferred
SKILLS/ABILITIES - Practices, methods and terminology applicable to monitoring and operation of data center hardware and software including standard scheduling, backup and control processes.
- Applicable hardware and software characteristics, operating environments, commands and structures as they apply to assigned responsibilities.
- Methods and techniques of troubleshooting to determine causes of computer hardware and software problems and device errors and failures.
- Uses a variety of scripting languages to meet automation needs.
- Effectively apply internal and external customer service practices and processes to meet quality service standards and achieve member satisfaction.
- Learn and apply information, on a wide range of Credit Union products, services and regulatory compliance requirements, in order to assess member situations and develop solutions.
- Resolve problems utilizing advanced knowledge and experience.
- Communicate in a professional manner and deliver information clearly and effectively. Actively listen to questions, opinions and ideas of others. Use tact and diplomacy in sensitive and confidential situations.
- Use correct English including spelling, grammar and punctuation.
- Operate computers and use business software and other standard office equipment.
- Understand and follow written and oral instructions.
- Set priorities and manage one's own time effectively.
PHYSICAL DEMANDS Physical Demands Disclaimer The physical demands described here are representative of those that must be met by employees to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Physical Requirements - Intermittent standing, sitting, walking, bending and climbing.
- Using hands repetitively to handle, feel or operate computers and other standard office equipment.
- Reaching with hands and arms.
- Intermittent lifting and carrying up to 25 pounds.
WORK ENVIRONMENT Work Environment Disclaimer An employee in this job will experience the following main work environments, others not listed may also be encountered on occasion;
Work Environment Works in a general office environment. Provides on-call technical assistance on a 24x7 basis. Redstone Federal Credit Union is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran status or status as an individual with disability. All qualified applicants will not be discriminated against on the basis of disability. We are proud to be a Drug-Free and Tobacco Free Workplace.