University of Rochester Veterans Jobs

Job Information

University of Rochester Oracle Database Developer - 223582 in Rochester, New York

Oracle Database Developer

Job ID

223582

Location

Laser Lab & COI

Full/Part Time

Full-Time

Favorite Job

Regular/Temporary

Regular

Opening

Full Time 40 hours Grade 054 LLE-Laboratory for Laser Energ

Schedule

8 AM-5 PM

Responsibilities

ROLE AND RESPONSIBILITIES:

Model, develop, deploy, and maintain University of Rochester Laboratory for Laser Energetics (LLE) organization Oracle database software and data services for a highly diversified research facility. Provide database support for research operations, management, advance controls, archives and reporting. Day to day duties involve modeling of application subject areas, PL/SQL database development and working with research operators and scientific principle investigators to extract, transform and load (etl) data. Additional duties include supporting data and web services and some database administration, monitoring of the health, usage for performance and capacity planning.

PRIMARY JOB FUNCTION:

  • Relational Database modeling for new and existing application development. Including requirements gathering, storyboarding and documentation.

  • Development of database objects, PL/SQL procedures and packages for remote web and application interfaces.

  • Build robust data Extract, Transform and Load (ETL) applications to support the transformation of raw scientific data into accessible information.

  • Refactor existing database objects to support enhancements of system control, diagnostic and other research subject areas.

  • Investigate and support new technology initiatives to improve or enhance current database capabilities.

  • Work with key laboratory and scientific research stakeholders to ensure data connectivity, access control and reporting in research applications.

  • Provide secondary support for database configurations, maintenance, installations and upgrades.

QUALIFICATIONS AND EDUCATION REQUIREMENTS:

  • B. S. in Information Technology, Computer Science, Data Science or equivalent skills work experience

  • 5+ years of hands-on Oracle Relational modeling and database development experience

  • 3+ years working in Oracle Database DDL, DML and concepts (table, triggers, views, procedures, functions, packages, …), PL/SQL, SQL languages with SQLplus, SQLcli and/or SQLdeveloper, Modeling (SQLmodeler, ERWIN, TOAD), Data extraction, Oracle Datapump

  • Experience with database version control through GIT or equivalent

  • Demonstrated technical excellence working to support scientific user base to engage in problem solving and finding proactive solutions

  • Excellent analytical skills with the ability to support scientific work in MSAcess, Excel, MATLAB, PV-Wave, IDL, Python or other scientific language

PREFERRED SKILLS:

  • Proven track record of leading database transformation and development project through to successful implementation

  • Significant Oracle database test development and performance tuning experience

  • Experience on Red Hat Linux (RHEL+) and Oracle server performance and configurations

  • Experience with software project lifecycles and deployment strategies, including UML visualization, requirement gathering, use cases, and flow charting

  • Solid mathematical and scripting skills in sh and Python or other scripting language for data reporting, analysis and Extracting, Transforming and Loading (ETL) of data is highly desired

  • Basic programming experience in MATLAB, R, Python, PV-Wave, or other scientific languages is a plus

  • Proficiency in technical writing, documenting solutions, and communicating with clients and users

ADDITIONAL NOTES:

Candidate must be a US Citizen.

How To Apply

All applicants must apply online.

EOE Minorities/Females/Protected Veterans/Disabled

DirectEmployers