PL/SQL Developer/Data Analyst
[Annapolis, MD] | 2023-08-30 15:08:23
Apply Now
Share Job
Job Code : 2023-MY3TECH0995
PL/SQL Developer/Data Analyst
Annapolis, MD (Hybrid)
2-3 years Contract
Qualifications:
- Active Oracle PL/SQL certification,
- Twelve (12) or more years of SQL programming experience, and
- Twelve (12) or more years of PL/SQL programming experience.
Scope of Work:
- Analyzing, testing, debugging and repairing existing PL/SQL based applications.
- Analyzing new business rules and interfaces in order to design and implement new Oracle objects.
- Preparing and maintaining documentation on new and existing data models.
- Preparing and maintaining documentation for new and existing programming objects.
- Packaging and configuring Oracle object components for deployment across Development, Test and Production Database Environments.
- Working with Architects and Oracle DBA staff to establish standards for developing and deploying Oracle objects.
- Assisting Business Intelligence staff with reporting requirements and solutions.
- Collaborating with stakeholders across different business units to align data initiatives with business strategies.
- Evaluating and enhancing SQL performance.
- Preparing regular and ad hoc reports, including:
- Weekly project report of progress and status,
- Weekly time report, and
- Additional reports as requested.
Skills Experience & Capability:
- The ability to:
- Break down complex programming concepts into organized and concise units.
- Work in an agile, self-motivated environment with multiple, concurrent priorities.
- An understanding of relational data concepts and the ability to apply these concepts to concrete solutions.
- Development skills with Oracle PL/SQL (Packages, Functions, Procedures, triggers), Materialized Views, DBLinks, and Oracle Jobs.
- Strong analytical skills for evaluating, documenting, and enhancing existing and new data models.
- Experience with:
- Reverse Engineering and Refactoring PL/SQL code,
- Extraction, Transform and Load programming,
- Data Warehouse/ Data Mart design,
- Asynchronous event-driven applications.
- Knowledge of the following:
- BI Publisher,
- Java syntax,
- SQL Server Reporting Services (SSRS),
- XML syntax and parsing,
- Domain knowledge of court related concepts and business activities.