Oracle PL/SQL Developer

Oracle PL/SQL Developer

ISQL developer must develop high-quality database solutions to implement and optimize with stored procedures and functions using Oracle PL/SQL. They will review and interpret ongoing business and functional requirements and research the required data structures. They must build appropriate and effective reporting deliverables with existing SQL and analyze existing SQL queries for performance improvements. They will investigate exceptions concerning asset movements.

• Create and manage data flow and data models for various systems.

• Provide troubleshooting and support for database instances in dedicated and multi-node clustered SQL Server environments.

• Participate in identifying stored procedure enhancements for database performance, reliability, and stability.

• Respond to client requests for data by mining a data warehouse.

• Develop requirements from data requests and develop necessary SQL queries to produce output.

• Act as a liaison between the development team leadership, coding teams, and support teams.

• Provide guidance to software engineers, architects and additional team members.

• Perform QA tests to ensure data integrity and quality.

• Review workflow charts developed by business analysts and programmers.

• Design and document database architecture using logical and physical data modeling tools and utilities.

• Run routine and ad-hoc queries as requested by the client.

• Conduct data exploration of new tables and schema in a data warehouse environment.

• Participate in technical design and requirements gather meetings with stakeholders.

• Assist with mapping activities to assist with data normalization activities.

• Demonstrate ability to analyze resource bottlenecks and provide suggestions to team, management, and internal customers on how to alleviate pressure and plan for capacity.

Qualifications

• Experience with Oracle PL/SQL, SQL Server software and systems.

• High level of proficiency with PL/SQL exception handling.

• Experience with TOAD and TOAD Data Modeler

• Experience with on-premise Microsoft Azure DevOps.

• Experience with C# coding language

• Fluency in scripting, debugging and relational databases.

• Comfortable running analysis services

• Preferred certified Oracle PL/SQL Developer Certified Associate

• Preferred Bachelor's Degree in computer science, engineering, information systems or information technology or equivalent experience.

• Preferred COMPTIA Security+ Certification

• Preferred experience with DoDAF documentation

● Position is on Customer Site
● US Citizenship Required

GDIT IS YOUR PLACE:
● 401K with company match
● Comprehensive health and wellness packages
● Internal mobility team dedicated to helping you own your career
● Professional growth opportunities including paid education and certifications
● Cutting-edge technology you can learn from
● Rest and recharge with paid vacation and holidays