Oracle Business Systems Analyst

Delan Associates, Inc; Baltimore (MD); On-site; USD 90,000 - 120,000; Full time

Job summary

Delan Associates, Inc. is seeking a Mid-level Business Systems Analyst to analyze and design information systems to meet organizational needs.

Responsibilities include gathering requirements, documenting processes, and leading project workstreams with stakeholders. The role requires strong analytical, problem-solving, and communication skills, plus experience with Oracle databases, GoldenGate, UNIX environments, and SQL.

Qualifications

• Experience with Oracle databases and GoldenGate for enterprise solutions.
• Strong SQL query writing, performance analysis, and tuning skills.
• Comfort with Unix environments, shell scripting, and capacity planning.

Responsibilities

• Gather and document requirements for new or enhanced systems.
• Analyze business processes and propose improvements.
• Design system specs, data models, and prototypes.
• Lead stakeholder meetings and provide progress updates.
• Develop and execute test plans for system quality.
• Troubleshoot and support system issues.

Skills

Oracle database

GoldenGate

SQL queries

Unix

Shell scripting

Analytical skills

Communication

Tools

Oracle GoldenGate

Unix

Job description

Job Description:

A Mid-level Business Systems Analyst typically plays a key role in analyzing and designing information systems to meet the needs of an organization.

• Gathering and documenting business requirements for new systems or system enhancements.
• Analyzing existing business processes and systems to identify areas for improvement.
• Designing and developing system specifications, prototypes, and data models.
• Leading meetings with stakeholders to gather requirements and provide updates on project progress.
• Developing and executing test plans to ensure system quality and functionality.
• Providing support and troubleshooting assistance for system issues.
• Developing user documentation and training materials.
• Collaborating with developers and other team members to implement solutions.
• Leading small to medium-sized projects or workstreams within larger projects.
• Staying current with industry trends and developments in business systems analysis.

A Mid-level Business Systems Analyst should have strong analytical, problem-solving, and communication skills. They should be able to work effectively with stakeholders at all levels of the organization.

Requirements:

Provide technical Oracle database and GoldenGate expertise and support for maintaining performance and reliability of enterprise database solutions. Undertake database projects requiring specialized technical knowledge. Makes well-thought-out decisions on moderately complex or ambiguous database issues and effectively develops, presents and implements . Collaborate efficiently and proactively within team and with other teams to improve reliability, optimize costs, enforce standards and compliance, and support requests from customers. Participate in on-call rotation, effectively troubleshoot issues to prevent and resolve incidents. Must have enterprise experience supporting, building, documenting, monitoring and maintaining Oracle databases and GoldenGate, performance analysis and capacity planning. Will need experience working with Unix type operating systems, shell scripting and of course be strong with writing, troubleshooting and optimizing SQL queries.