We use cookies to improve your experience on our site. To find out more, read our privacy policy.

DE Jobs

Search from over 2 Million Available Jobs, No Extra Steps, No Extra Forms, Just DirectEmployers

Home View All Jobs (2,300,752)

Job Information

Rutgers The State University SQL Programmer in New Brunswick, New Jersey

Position Details

Position Information

Recruitment/Posting Title SQL Programmer
Posting Number 24TM0167
Department Institute for Families
Overview
The School of Social Work's mission is to develop and disseminate knowledge through social work research, education, and training that promotes social and economic justice and strengthens individual, family, and community well-being in this diverse and increasingly global environment of New Jersey and beyond.
Posting Summary
Rutgers, The State University of New Jersey is seeking a SQL Programmer for the The Institute for Families (IFF) at the Rutgers University School of Social Work.Among the key duties of the position are the following:
  • Performs SQL Server programming and SQL Server Database Administration, with a focus on providing Microsoft SQL Server and MySQL support for a public website that aggregates data into longitudinal reports with user-defined views, and provides data files for users to download.
  • Collaborates with IT professionals at the Rutgers University School of Social Work to ensure a smooth data preparation process across Oracle, SQL Server, and MySQL platforms.
  • Writes new code and optimizes current code.
  • Creates stored procedures with parameters, transactions and exception handling.
  • Creates tables, views and functions.
  • Writes queries with multiple joins.
  • Handles data imports, exports, and file management with SSIS.
  • Searches metadata to find relevant columns and tables required for new reports.
  • Implements version control policies for code management and technical documentation.
  • Implements and documents policies for scheduled database backups and conducts periodic database recovery tests.
  • Works proactively with system administrators on management of disk space and performance.
Position Status Part Time
Hours Per Week 4-20
Daily Work Shift Day
Work Arrangement
FLSA Nonexempt
Position Salary $65.00-$70.00/Hour
Payroll Designation PeopleSoft
Terms of Appointment Temporary Staff Appointment - Hourly
Qualifications

Minimum Education and Experience
  • Bachelor's degree in a related field, or an equivalent combination of education and/or experience.
  • Ten (10) years of relevant professional experience in SQL Server database development and administration, excellent communication, and Windows computer literacy.
Certifications/Licenses
Preferred Qualifications
  • SSIS Packages - SQL Server Integration Services.
  • PHP.
  • Javascript.
  • Drupal.
  • Visio.
  • Geocoding knowledge: SQL Server Geography data type handling; ARCGIS Pro Geocoding tool.
  • Microsoft Visual Studio Professional.
  • Microsoft Visual Studio Code.
  • Experience with macros and VBA a plus.
Required Knowledge, Skills, and Abilities
  • Able to derive technical solution from non-technical business requirements.
  • Able to work at times with limited supervision.
  • Experience documenting mappings between user-defined terms and database columns.
  • Excellent communication skills in order to provide daily status updates, identify problematic results, identify and address exception cases that are likely to arise, and confirm understanding of requirements.
Equipment Utilized
  • Intermediate/Advanced Excel (including pivot tables, lookups, custom sorting and database connections.
  • MS Outlook.
  • MS Teams.
Physical Demands and Work Environment
Special Conditions
Posting Details

Posting Open Date 05/02/2024
Posting Close Date 05/30/2024
Open Until Filled No
Special Instructions to Applicants
Regional Campus Rutgers University-New Brunswick
Home Location Campus Rutgers University - New Brunswick
City New Brunswick
State NJ
Location Details
Pre-employment Screenings

All offers of employment are contingent upon successful completion of all pre-employment screenings.
Immunization Requirements

Under Policy 100.3.1 , if employment will commence during Flu Season, Rutgers University may require certain prospective employees to provide proof that they are vaccinated against Seasonal Influenza for the current Flu Season, unless the University has granted the individual a medical or religious exemption. Additional infection control and safety policies may apply. Prospective employees should speak with their hiring manager to determine which policies apply to the role or position for which they are applying. Failure to provide proof of vaccination for any required vaccines or obtain a medical or religious exemption from the University will result in rescission of a candidate's offer of employment or disciplinary action up to and including termination.

Affirmative Action/Equal Employment Opportunity Statement

It is university policy to provide equal employment opportunity to all its employees and applicants for employment regardless of their race, creed, color, national origin, age, ancestry, nationality, marital or domestic partnership or civil union status, sex, p regnancy, gender identity or expression, disability status, liability for military service, protected veteran status, affectional or sexual orientation, atypical cellular or blood trait, genetic information (including the refusal to submit to genetic testing), or any other category protected by law. As an institution, we value diversity of background and opinion, and prohibit discrimination or harassment on the basis of any legally protected class in the areas of hiring, recruitment, promotion, transfer, demotion, training, compensation, pay, fringe benefits, layoff, termination or any other terms and conditions of employment. For additional information please see the Non-Discrimination Statement at the following web address:

It is university policy to provide equal employment opportunity to all its employees and applicants for employment regardless of their race, creed, color, national origin, age, ancestry, nationality, marital or domestic partnership or civil union status, sex, p regnancy, gender identity or expression, disability status, liability for military service, protected veteran status, affectional or sexual orientation, atypical cellular or blood trait, genetic information (including the refusal to submit to genetic testing), or any other category protected by law. As an institution, we value diversity of background and opinion, and prohibit discrimination or harassment on the basis of any legally protected class in the areas of hiring, recruitment, promotion, transfer, demotion, training, compensation, pay, fringe benefits, layoff, termination or any other terms and conditions of employment. For additional information please see the Non-Discrimination Statement at the following web address: http://uhr.rutgers.edu/non-discrimination-statement

DirectEmployers