University of Rochester Oracle Database Developer - 223582 in Rochester, New York
Oracle Database Developer
Laser Lab & COI
Full Time 40 hours Grade 054 LLE-Laboratory for Laser Energ
8 AM-5 PM
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
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
Candidate must be a US Citizen.
How To Apply
All applicants must apply online.
EOE Minorities/Females/Protected Veterans/Disabled