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.