Job #: 1992
Title: SQL Developer – Brooklyn, NY
Develop SQL database infrastructure, routines, SSIS packages, and processes throughout product lifecycle environments, on development and testing to mission-critical production systems. Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
ESSENTIAL JOB FUNCTIONS
Design and maintain SQL databases, including test interface.
Develop and integrate SSIS packages for daily processes.
Develop and implement ingestion and export routines for FTP.
Troubleshoots job task / agent failures as they occur, including after hours and/weekends.
Configure SQL monitoring utilities to minimize false alarms.
Identifies and resolves database problems.
Reviews systems and databases to optimize available space and operational efficiency.
Sets up the disaster recover plan for the system, and arranges period tests of the plan.
Ensures integrity of data on a daily basis, resolving and reporting problems as they arise.
Participates in multidisciplinary task forces, committees and projects.
Works with computer operations and programmers to define policies and procedures for new releases, upgrades, storage and download recovery.
Define and execute archival and purge functions.
Coordinates database enhancements, program fixes, and system maintenance including testing, for database related implementations.
Other Job Duties
Provides guidance and direction to database users and project team members.
Establishes database security procedures.
Maintains records/documentation of programs as needed.
Required: 2 years of college or technical training.
Preferred: 4 year college degree.
Required: 4 years of database development experience.
Preferred: 6 years of development experience, including developing and deploying SSIS packages.
Expert in Database Programming for Microsoft SQL Server,.
Expert in SQL Server Architecture and building, installation, upgrade and configuration of MS SQL Server
Expert in Planning and implementing the Database design and Data Modeling
Expert in Planning and implementing SQL Server Security and Replication of Databases
Strong knowledge and working experience with SQL Server clustering, log shipping mirroring or other technologies.
Tuning T-SQL queries to improve performance.
Effectively utilize troubleshooting hardware and/or tools.