Find Jobs
Find Jobs Near You – Available Work in Your Location
Skip to job details
TT
Trigyn Technologies, Inc.
Oracle PL/SQL Developer
Job Description
Trigyn's direct government client has an immediate need for an Oracle PL/SQL Developer in Menands, NY.
Description:
? Develop, test and execute Oracle SQL queries against the schema of production database upon request, for program validation and data analysis ? Develop and maintain a library of SQL queries that can be executed on a recurring basis with different parameters, for similar requests ? Assist program staff in understanding data structures within the NYWIC modules, for developing new report requirements ? Assist program staff in developing new ad-hoc queries within the Datamart OBIEE system, using defined user guidelines and additional guidance from the Datamart team as needed ? Work with Datamart team members, program staff, and the application vendor as needed to develop a knowledgebase of system data mappings between the application and the Datamart, for program assistance ? Participate in review and/or documentation of regression test scripts for user acceptance testing ? Provide general support for user acceptance testing efforts ? Work closely with ITS and Program managers to ensure adherence to standard policies and procedures.Mandatory Qualification:
? Is involved with all facets of the software development process, including the research, design, programming, testing and implementation of computer software. ? Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field. ? 84 months of experience creating SQL queries and stored procedures using Oracle PL/SQL ? 84 months of experience meeting with business staff to elicit business requirements ? 84 months of experience working with business staff or end users to analyze or troubleshoot Oracle reports ? months of experience creating software documentation including functional specifications and technical specifications ? 48 months of experience analyzing, optimizing Oracle SQL queries and improving database performance ? 48 months of experience preparing or facilitating the creation of testing scenarios and test scripts ? 36 months of experience creating user documentation such as user guides or training presentations ? 36 months of experience using OBIEE (Oracle Business Intelligence Enterprise Edition), including end user experience ? Bachelor?s Degree in an Information Technology related field, from an accredited institution. For Immediate Response call , or send your resume toTRIGYN TECHNOLOGIES, INC.
is anEQUAL OPPORTUNITY
EMPLOYER and has been in business for 35 years. TRIGYN is anISO 9001
2015, ISO 27001:2013 (ISMS),ISO 20000:2018 and CMMI Level 5 certified company.Career Insights for SQL Developer
See where this job fits in the broader career landscape. Knowing your career path helps you see what's possible from here.
Scorecard
Based on New York data
Review key factors to help you decide if this role fits your goals. How is this calculated?
What they do
A SQL Developer develops, test and maintains database structures and processes. Specializes in the structured query language (SQL) processes and structures. Provides support for software, product and client needs addressed through the database systems.
$107,806 / year median in New York
-15% projected decline