Business Analyst with PL/SQL Development Experience (FULLTIME POSITION)

We are seeking a versatile Business Analyst with strong Oracle PL/SQL development skills to bridge the gap between business needs and technical solutions. The ideal candidate will be responsible for gathering requirements, analyzing data, and developing robust database solutions using Oracle PL/SQL to support our business operations and reporting needs.

Key Responsibilities:

• Requirements Gathering & Analysis: Collaborate with stakeholders and cross-functional teams to understand business processes, gather software requirements, and translate them into detailed technical specifications and data mapping documents.
• PL/SQL Development: Design, develop, test, and maintain efficient Oracle PL/SQL code, including stored procedures, functions, packages, triggers, and views.
• Data Analysis & Modeling: Perform extensive data analysis on source systems, create data models, and implement database structures to ensure data integrity and security.
• Performance Tuning: Optimize and troubleshoot existing SQL queries and PL/SQL code to improve database performance using techniques such as indexing, query tracing, and explain plans.
• Documentation & Testing: Prepare technical documentation, participate in code reviews, and support Quality Assurance (QA) activities to ensure developed solutions meet business requirements.
• Support & Collaboration: Provide support for database-related issues and collaborate with architects and other developers within an agile development lifecycle.

• Experience: Proven experience in a role requiring both business analysis and Oracle PL/SQL development.

• Technical Skills:
• Strong proficiency in SQL and advanced PL/SQL programming.
• Experience with database design concepts and data modeling tools (e.g., ERWIN, Toad).
• Familiarity with software development lifecycle (SDLC) methodologies (Agile or Waterfall).
• Knowledge of related technologies such as Unix/Shell scripting is a plus.