Position Details
Position Information
| Recruitment/Posting Title |
SQL Programmer |
| Posting Number |
25TM0054 |
| Department |
Institute for Families |
| Overview |
The School of Social Work 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.
The Institute for Families (
IFF) at the Rutgers University School of Social Work exists to advance the professional practices and knowledge base of individuals and organizations dedicated to improving the lives of children and families. As the largest Center within the School, the organization leads a portfolio of $16M in programming and evaluation that increases the capacity of child welfare and human service systems, largely through training, technical assistance, applied research and evaluation services. The team at
IFF represents a multi-disciplinary community of professionals committed to innovative, evidence-based and culturally responsive programming, equitable and inclusive practices, accountability and continuous quality improvement, and transparent, responsive engagement with our stakeholders. The work of
IFF is supported by a staff of 80+ full-time and part-time employees, and more than 100 consulting subject matter experts. |
| Posting Summary |
Rutgers, The State University of New Jersey is seeking a
SQL Programmer for the Institute for Families at the School of Social Work.
Among the key duties of the position are the following:
- 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 conduct periodic database recovery tests.
- Works proactively with system administrators on management of disk space and performance.
- Collaborates with IT professionals to ensure a smooth data preparation process across Oracle, SQL Server, and MySQL platforms.
|
| 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 |
| Benefits |
Rutgers offers a comprehensive benefit program to eligible employees. For details, please go to
http://uhr.rutgers.edu/benefits/benefits-overview. |
| 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.
- Eight (8) years of relevant professional experience as a database administrator/programmer, including use of SQL or other database management systems, familiarity with programming languages commonly used for database interaction and application development.
|
| Certifications/Licenses |
|
| Preferred Qualifications |
- Experience with 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.
|
| Required Knowledge, Skills, and Abilities |
- Ability to derive technical solutions from non-technical business requirements.
- Experience documenting mappings between user-defined terms and database columns.
- Ability to work at times with limited supervision.
- 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 for email.
- MS Teams for chat.
|
| Physical Demands and Work Environment |
|
| Special Conditions |
|
Posting Details
| Posting Open Date |
02/07/2025 |
| Posting Close Date |
02/17/2025 |
| 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 Immunization Policy for Covered Individuals, 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, pregnancy, 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 |
Rutgers University
Feb 07, 2025