*SQL Server DBA** – **In person interview** - **Direct Client* *Immediate Interview and Start ASAP!!!*
*Please send resume to **[email protected] <[email protected]>* *Job Title: SQL Server DBA* *Location: NYC* *Duration: 5 Months* *Client: DOITT* *In person interview* *SCOPE OF SERVICES * *At DHS, the Office of Information Technology (OIT,) is firmly committed to combating homelessness and hopelessness in New York City through IT transformation; as NYC DHS evolves its’ operational strategy to best serve today’s homelessness prevention and assistance needs and challenges, The agency seeks an experienced SQL Database Administrator to support critical DHS OIT Infrastructure, stabilize existing legacy databases maintained agency wide, and transform legacy applications in alignment with DHS OIT and IT policies/standards – citywide. As a member of DHS OIT, the SQL DBA will support the development, deployment and ongoing management of monitoring and evaluation databases across programs housed at and/or primarily supported by DHS. S/he will maintain databases and support end users. The selected candidate will perform the following duties under the direction of the CIO. * *The qualified candidate will serve as the agency’s lead SQL DBA, with responsibilities that include, but aren’t limited to:* *Develop, design, configure and document database architecture, including software, hardware and physical layout (processor configurations, SAN luns, data file layouts)* *Lead/manage/collaborate with software developers (in-house/intra-City/business partners,) collaborate with administrators in a 24x7 multiple-cluster production environment* *Standardize and perform best practice database troubleshooting* *Implement risk management practices to mitigate data corruption* *Perform backup and disaster recovery* *Monitor, tune, and develop per SQL DB perform daily DBA tasks during SDLC, including reviewing logs, establishing and responding to automated monitoring, and performance tuning* *Administer, configure and maintain various types of data replication in particular AlwaysOn* *Manage distributed databases, SSIS packages and SSRS* *Participate in functional, performance and security testing* *Assist developers and end users with implementation best practices * *Coordinate by/between intra-city stakeholders on special technology projects (cross-functional)* *Maintain/administer/tune program databases (built in Microsoft Access and SQL)* *Develop and conduct staff trainings on program databases and tracking tools * *Provide ongoing database technical support to DHS and OIT staff as needed * *Maintain quality control and data cross checks of databases * *Manage updates/enhancements to database as needed * *Test logical input, processing and output scenarios in the database design* *Add in sample data, test user functionality, build in reports and modify controls as required and/or necessary * *Design, create and update database user manuals for all program databases * *Consult as needed across all DHS on database development and management* *Analyze data using available statistical software to support, guide and evaluate DHS strategic planning and community-based efforts* *Prepare summary tables, figures, maps and draft reports to present findings for publication and presentation to the public and other public health professional* *Present and report public health data and research findings to community leaders, key stakeholders and residents* *Perform other tasks based on DHS needs, including literature reviews and policy scans* *Mandatory Skill/Expertise* *Develop, design, configure and document database architecture, including software, hardware and physical layout (processor configurations, SAN luns, data file layouts)* *Lead/manage/collaborate with software developers (in-house/intra-City/business partners,) collaborate with administrators in a 24x7 multiple-cluster production environment* *Administer, configure and maintain various types of data replication in particular AlwaysOn* *Manage distributed databases, SSIS packages and SSRS* *Present and report public health data and research findings to community leaders, key stakeholders and residents* *Desirable Skill/Expertise * *Experience building and working with data management systems - Microsoft Excel and Microsoft Access* *Experience using SAS and/or SPSS programming for data analysis* *Experience conducting trainings and presenting training materials using Microsoft PowerPoint* *Keen ability to prioritize and handle multiple assignments* *Ability to work closely with all levels of staff inside and outside the Agency* *Ability to work independently and exercise a high degree of initiative to accomplish tasks and solve problems* *Excellent oral and written communication skills.* *Excellent project management skills.* *Demonstrated success in managing and coordinating with staff across multiple projects, and successful leadership of cross-functional teams.* *Thorough knowledge of office management, systems development and database management, and will have design, problem solving, analytic and team building skills.* *Familiarity with New York City business processes and experience working with NYC agencies.* *Please send resume to [email protected] <[email protected]> * *Thanks, Sam CNC Consulting, Inc. 201-546-3096 [email protected] <[email protected]>* -- You received this message because you are subscribed to the Google Groups "Open Source J2EE frameworks" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/open-source-j2ee-frameworks. For more options, visit https://groups.google.com/d/optout.
