Oracle PL/SQL Application Developer II

Company: Expert Technical Solutions
Location: Smyrna
Posted on: May 11, 2022

Job Description:

Oracle PL/SQL Application Developer II Expert Technical Solutions is seeking a SQL Application Developer II for one of our premier, industry leading clients in Atlanta, GA. This person will be a pivotal member of the team that builds and integrates interactive, enterprise level applications. In this role, you will be responsible for hands on database development, optimization and testing, design and implementation of reporting solutions. The ideal candidate will manage data analysis, transformation, and extraction using company standards and industry standard tools. You will work with application architects, DBAs, business analysts, and management to build and implement applications from the requirements stage, through design, development and production deployment and support. This team is responsible for the development and support of financial and other business reporting. This is a Permanent opportunity offering strong pay, excellent benefits, and unlimited growth potentia l. Primary Duties And Responsibilities Plan, design, develop, test, implement, analyze & maintain database models and content Develop and support complex SQL queries used for reporting, data interfaces, and integrated application programming Troubleshoot and tune complex database query performance issues Work with Development team and DBAs in the design and modeling of relational databases Design, manage, and document logical and physical data models and data dictionaries Work with the Development team in developing queries, functions , triggers, procedures and materialized views Implement policy and standards relating to the design, creation, supportability of SQL queries Develop estimates, execute plans & report to management on progress Communicate with management staff on a timely & re gular basis Work with business analysts and technical staff to develop and finalize requirements and deliver technological solutions Consult with users to clarify business requirements and program objectives. Write documentation to describe query development, logic, coding, and corrections. Participate in the testing process through test script development, unit and system test execution, test review and analysis. Test application components to assess whether the solution meets the reliability, performance, capacity, scalability and technical requirements Required Experience 5 years--- experience with large scale relational database s such as Oracle or SQL Server 5 years --- experience writing complex queries for reporting and data extraction Strong data base design experience required 3 years --- experience developing logical and physical models of multiple application databases and staging areas in design tool like E R/WIN 4 years --- experience troubleshooting and tuning database performance, queries, and stored procedures Demonstrated Linux troubleshooting and support experience Well versed in data modeling and OLAP technology Advanced knowledge of Oracle analyt ic functions Expertise in tuning SQL statements using various tools Understanding of database architecture, statement parsing, query optimizer, etc. Knowledge of the role and development of materialized views Experience with tools such as DbVisualizer, TOAD, SQLLoader, Oracle Sqldeveloper, etc Familiarity with using version control systems.

Keywords: Expert Technical Solutions, Smyrna , Oracle PL/SQL Application Developer II, IT / Software / Systems , Smyrna, Georgia