Job Description :
SQL Developer
Location : Manhattan, NY
Interview : Phone and F2F
Duration : 6+ Months
Visa : USC or GC or GC EAD
JOB DESCRIPTION :
Planning/Design
Work with the data management team to review current and create new front-end interfaces and functionality;
Develop and design new functionality for the REPS database application to meet program and administrative needs;
Assess current processes and develop technology solutions to create efficiencies, maximize data integrity and minimize manual data entry;
Design, develop and unit test new features, enhancements and interfaces for Oracle APEX web application.
Management
Maintain applications, including bug fixes, performance enhancements and runtime production support;
Serve as the project lead on all tasks related to the database application and implementation of technology tools, provide guidance and feedback on the design and execution of new features;
Work closely with REPS staff to support all stages of data collection, cleaning, coding, and file conversion into formats that are useful for program management, evaluation, and research;
Maintain selected data sources and implement regular updates to ensure data quality;
Assist with coordination and troubleshooting of database and software systems.
Documentation
Create and maintain Standard Operating Procedures (SOPs) to ensure accuracy, consistency, and relevancy of all information stored across the REPS databases;
Work with staff to create the end user documentation and training materials to be used throughout the life of the database.
Other tasks
Provide technical and operational assistance to users, troubleshoot and resolve application and database related problems;
Work with IT to solve technical problems;
Perform other duties as assigned.
Qualifications
Required:
Bachelor’s degree in Computer Science or related field required;
Minimum 4 years of experience in data management with a strong background in relational database design along with knowledge of SQL Databases (Microsoft Access, Oracle database, Microsoft SQL Server);
Strong understanding of relational data structures, theories, principles, and practices;
Must have a strong background working with Oracle, SQL, and PL/SQL;
Able to prioritize a heavy workload with minimum supervision;
Strong project management and documentation skills.
Preferred:
A solid understanding of Full Stack Development;
Knowledge of data warehouse best practices, dimensional design/modeling and ETL architectures;
The ability to write complex SQL queries, stored procedures, triggers and views and program in PL-SQL,VB/VBA;
Experience with HTML, JavaScript, AJAX, JQuery, CSS, JSON, Java, APEX, MS Access and Oracle Database;
Understanding of web architecture.