Oracle Developer with .Net, C#, VB, db optimization/normalization, and web based development experience
Location: Columbia, SC
Duration: 5 month's
Positions: 1
Description:
Reviews, analyzes, and modifies programming systems including encoding, testing, debugging and documenting programs. May require an associate's degree in a related area and 0-3 years of experience in the field or in a related area. Has knowledge of commonly-used concepts, practices, and procedures within a particular field. Relies on instructions and pre-established guidelines to perform the functions of the job. Works under immediate supervision. Primary job functions do not typically require exercising independent judgment. Typically reports to a project leader or manager.
RESPONSIBILITIES & DUTIES:
The S.C. Department of Natural Resources is seeking to acquire the temporary services of a database/applications programmer to provide web and data base application programming support to the SEAMAP program of the Marine Resources Division. This position will develop web-based data access and query functions for the SEAMAP marine fisheries program in Charleston, SC. The system will have an internal data management and analysis component for use by state and regional fisheries staff and a public component that will provide read-only access to summary fisheries data for the public. The system will be built around the Oracle 11g database running in a Linux RAC environment and using the Oracle Application Server web server software. The following specific duties and responsibilities have been identified for this position at the SC DNR.
1.Work with Oracle Database Administrator to maintain and enhance the project data schema that includes data collected by surveys and special studies of SEAMAP-South Atlantic states (North Carolina, South Carolina, Georgia and Florida). Data types to be covered include site-specific (spatial), environmental, species groups, individual life history, tagging, and other specimen data. The data will be accessible to other state fisheries staff via secure web and various components will be published to the web for public access. User roles and responsibilities will be managed through access permissions and control procedures to insure data security and integrity.
2.Develop web-based data input, editing and validation tools and procedures to manage SEAMAP fisheries data. Data will be submitted to the SEAMAP Data Manager for integration into the Oracle database in a variety of formats including text files, populated ACCESS database, and EXCEL files. Primary data entry and transfer will be handled on a yearly basis (as field collection season concludes, however, new and corrected data can be sent to the database manager at any time to be uploaded to the SEAMAP database. Procedures are required to tracks changes made to the database, and the ability to trace the data back to corresponding record in its original source. Also the system must provide the capability to export data to EXCEL, ACCESS, SAS or other industry-standard formats for integration with other scientific analysis software including geographic information systems (GIS).
3.Develop data query, access, analysis and reporting tools with the following requirements using web-based programs and technologies.
A.Three levels of access with appropriate rights based on roles and responsibilities.
1, Level 1: data administrator (full access for data content management)
2. Level 2: data contributors and SEAMAP partners (read-only access)
3. Level 3: external users (limited access, standard queries only)
B. Queries will provide the following selection criteria:
1. Project
2. Year/time
3. Season
4. State/stratum/grid/latitude and longitude
C. Queries will be created to reflect three levels of access:
1. Summarized data will be made available and will provide catch and effort data (with arithmetic and geometric ?weights?), species composition, and the default standard for a project cpue.
2. Detailed data output will provide three types of data for each project.
a. Event (Biomass, physical/hydrographic data)
b. Species abundance by event (with zero catches included)
c. Specimen data (by species and event), including individual measurements, age, tagging data, etc.
D. Ad hoc query tools to provide analysis and reporting capabilities to contributors from South Atlantic participant states.
E. Standardized reports and data summaries that include year-to-year abundance trends.
4.Develop web-based interfaces and programs to support the SEAMAP data access procedures for three levels of access as defined above. Access will be in the form of static data reports and summaries, programmed data queries, ad hoc data queries and extraction and download of data records for additional scientific analysis using GIS, statistical or other programs. Static reports for public access will be published to the SEAMAP web site.
5.Develop system administration tools that allows appropriate staff to manage the system including:
A. Create user login accounts and reset passwords
B. Input, edit, verify and manage SEAMAP data submitted by cooperating partners from SEAMAP-SA states.
C. Produce annual and other periodic reports regarding database utilization and status.
REQUIRED SKILLS :
1.Extensive knowledge of and experience with database and applications programming concepts and languages (including Microsoft .NET, C#, Visual BASIC, Javascript and other relevant object oriented programming and scripting tools).
2.Extensive knowledge of data base structures and schema design including the appropriate implementation of database security protocols.
3.Experience with developing web-based user interfaces to access and manage data and analysis and reporting tools.
4.Good oral and written communication skills.
PREFERRED SKILLS:
1.Extensive knowledge of enterprise information systems development involving the integration of tabular, statistical, electronic records management and web-based technologies.
2.Knowledge of and experience with DBMS optimization and normalization strategies; system integrity and monitoring/auditing activities.
3.Knowledge of Oracle relational database management systems
4.Knowledge and experiences with designing applications for fisheries and natural resources data is desired but not required.
Reference : Oracle Developer with .Net, C#, VB, db optimization/normalization, and web based development experience jobs
0 comments:
Post a Comment