Business Systems Analyst 3(N-IT)

The role of the Business Systems Analyst is to Analyze science, engineering, business, and other data processing problems to implement and improve computer systems. Analyze user requirements, procedures, and problems to automate or improve existing systems and review computer system capabilities, workflow, and scheduling limitations. May analyze or recommend commercially available software.

Position Responsibilities:

• Test programs or databases, correct errors and make necessary modifications.
• Modify existing databases & database management systems or direct programmers and analysts to make changes.
• Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
• Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
• Train users and answer questions.
• Specify users and user access levels for each segment of database.
• Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems such as the installation of new databases.
• Review project requests describing database user needs to estimate time and cost required to accomplish project.
• Develop standards and guidelines to guide the use & acquisition of software and protect vulnerable information.
• Conduct performance tuning for servers, databases, and SQL
• Provide recommendations for process improvements and technical solutions that can be integrated into existing environments.
• Perform login management, install/patch, troubleshoot connectivity issues, monitor performance and tune when necessary, backup and restore databases in a complex three-tier architecture (client web interface, application engine, database engine).
• Write and debug PowerShell, VB and/or PERL scripts to automate DBA processes such as monitoring/alarming on volume growth, performance bottlenecks, batch scheduling, and connectivity failures.
• Utilize Windows-based tools and knowledge of Windows internals to troubleshoot, diagnose, and resolve performance and connectivity issues with Oracle on Windows.
• Recommend SAN-based storage configuration, such as disk layout, to improve performance.
• Provide developer and end-user support for databases including maintaining existing SQL and PL/SQL code and troubleshooting database interoperability problems
• Perform routine database management from command line without the use of GUI Tools.
• Install and maintain appropriate database fail-over solutions.

• A degree in Information Technology, Technical Management, Information Management, Engineering, Business Systems, Computer Science or a directly related technical discipline is preferred.
  • 10 years of experience is required with an applicable Associate's degree.
  • 8 years of experience is required with an applicable Bachelor's degree.
  • 12 years of experience is required without a degree.
• Experience should include business systems analysis with a focus in Networking and Infrastructure projects. Expert level practitioner in business systems analysis and/or systems analysis with a focus in Software, Data Integration, Cyber Security, Networking and/or IT Infrastructure projects. (Project business system analysis experience required; do not include Service Desk or O&M experience).

• Advanced knowledge of Visio or other similar flowchart tools.
• Advanced proficiency in Excel, including pivot tables, charting, and reporting.
• Expert knowledge in supporting full lifecycle of projects through the IT Systems Development Lifecycle
• Expert knowledge in IT planning, functional and technical specifications, and system life-cycle (SLC) management.
• Experience Supporting Requirements Development including a) Conduct interviews and facilitate workshops to elicit business requirements b) Research, analyze, model and organize information for developing requirements c) Decompose high-level information and abstract up from low-level information to distinguish solution ideas from business needs d)Facilitate requirements validation sessions and present findings to BPA management and other stakeholders e) Collaborate to resolve requirements conflicts between stakeholders f) Research, document, and validate current and future state processes and designs (functional and technical) g) Help define best approaches, alternatives, and decision frameworks for alternative business solutions analyses

• Experience in organizational change management methods and tools.
• Experience with use of SharePoint.
• Experience delivering projects with Cyber Security and/or other compliance requirements.
• Experience with Agile and Waterfall methodologies.
• Advanced knowledge of Network Hardware and Software, Server Hardware, and Server Operating Systems.
• Advanced knowledge of a broad spectrum of technologies including applications, servers, storage, backup systems, networking, and security.
• Experience supporting large technical infrastructure projects.
• Expert communication and customer service skills, to move assigned project(s) forward in a large agency environment with many stakeholders.

Everest Consultants offers the following benefits for this position: medical, dental, & vision insurance, short-term disability, life and AD&D insurance, a 401(k) retirement plan, and a referral bonus program, paid sick/vacation/holidays, and a health and welfare fringe benefit.

Everest Consultants is an equal opportunity employer and does not discriminate on the basis of race, color, religion, sex, national origin, age, disability, or any other characteristic protected by applicable local, state, or federal civil rights laws. #IND