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
Click
here to apply!
|