SQL Database Administrator (DBA)
The SQL Database Administrator manages all of the SQL Server transactional databases and will be responsible for making sure the SQL systems are functioning optimally and that users are able to upload, retrieve and analyze the data as it flows across the various platforms within the institution. Responsibilities include all functions associated with the design, implementation and maintenance of SQL Server databases including security, back-up, logging, reporting and recovery procedures. Manage all technical aspects of the databases and processes. Transform data via standardization, cleaning, data repair, matching, and de-duping. Manage data from multiple sources including internal, external, and 3rd party data. Assist in maintaining and improving database operational efficiency. Perform daily, weekly, and monthly data maintenance tasks. Assist in developing feeds to Data Warehouse and Marts. Ensure data can be provided to support OLAP reports and various reporting requirements. Assist in client support and setup configurations. Maintain technical support via phone and email. Configuration of devices, test various internal applications and commercial apps; backup procedures; assist in data management processes; performs other duties as assigned.
Required: Bachelor's degree in Information Technology, Computer Science or a related field. Experience with MS SQL Server 2000/2005/2008 and 2008 R2, including use of Query Analyzer, stored procedures, DTS, Jobs and Profiler. Experience creating and maintaining an extraction, transformation, and loading process from source systems or files into a data warehouse. Ability to extract data from a data warehouse and package according to user needs. Familiarity with managing data in Microsoft Access and Excel. Understanding of XML helpful. Ability to plan, organize and work on multiple tasks simultaneously. Strong communication skills required. A desire to exceed project, client and co-worker expectations; experience with SQL database administration activities including; installation, configuration, monitoring, space management, database backup and recovery. Strong understanding of Microsoft Cluster technology, prior experience in supporting SQL cluster environment. Must have the ability to read, analyze and interpret general business periodicals, professional journals, technical procedures and governmental regulations. Excellent interpersonal, oral and written communication and customer service skills required as well as the ability to work with a diverse population. Must have the ability to multitask as well as be team oriented. Periodic on-call availability and flexible work hours required. Must be able to lift and transport moderately heavy objects.
To ensure full consideration, all requested application materials must be received by February 13, 2012. All interested candidates should send a letter of intent (include the job code P-SQL), curriculum vitae, copies of transcripts, salary requirements, and three professional letters of reference with current contact information. Send materials by e-mail with the appropriate job code in the subject line to employment@bergen.edu, or by fax to (201) 251-4987, or by mail to:
Bergen Community College
Department of Human Resources
400 Paramus Road, Room A316
Paramus, New Jersey 07652
EOE/NJ First Act Employer
Smoke-Free and Drug-Free Workplace