Senior Data and Applications Administrator - Town of Brookline

The Town of Brookline Information Technology Department is seeking a hands-on Senior Data and Applications Administrator to design, develop, implement, integrate and administer the Town of Brookline’s databases and applications. This position performs a key role in all areas of database management, maintenance, monitoring and support across all IT applications.

The Senior Data and Applications Administrator provides leadership in all areas of database management, database integration, maintenance, monitoring and support across all IT applications including ERP systems for both Town and Schools and serves as the chief data officer who oversees data security, privacy and transparency. All other related work as required.

Qualifications: We are seeking a flexible, qualified Senior Data and Applications Administrator with a BA/BS in computer science, management information systems, engineering, GIS or related fields. Candidates should have 5 years or more of experience in designing, implementing, securing, and supporting production SQL server databases; or equivalent combination of education and experience. Experience with most recent SQL server is preferable. Experience in database administration, systems administration or software development environment. Database security experience essential.

Please review the complete job description below for essential functions and qualifications.

Salary and Application Info:

Starting salary $101,323.91 annually, plus generous benefits and excellent working conditions. Please Apply with Resume and Cover Letter. Open until filled.

Senior Data and Applications Administrator Job Description

Position Purpose
Performs senior professional and technical work to design, develop, implement, integrate and administer the Town of Brookline’s databases and applications. This position performs a key role in all areas of database management, maintenance, monitoring and support across all IT applications. All other related work as required.

Supervision
Supervision Scope: Performs technical duties requiring a high level of initiative, creativity and independent judgment in planning for the development, management, and support of the Town’s production databases, data warehouses, and database security.

Supervision Received: Works under the general supervision of the Digital Services Manager. Once priorities are set, works with considerable latitude for independent judgment and action.

Supervision Given: None.

Job Environment
Work may be performed under a variety of conditions and locations which may include time sensitive objectives and stressful situations. Essential functions are regularly performed without exposure to adverse environmental conditions. Regularly attends meetings at various locations within the Town. Occasionally attends technical conferences.

May be required to work after normal business hours or contacted at home at any time to respond to important situations and emergencies. Position may require pager or cell phone connectivity to be provided by the Town.

Operates computers, printers, scanners, and other peripherals, telephone, and other standard office equipment.

Has regular contact with various Town/School Departments, the general public, computer hardware and software vendors, and software technical support personnel. Interdepartmental contacts involve gathering information regarding their computing needs, answering questions, solving problems, and providing training and support.

Has access to confidential information, which requires the application of appropriate judgment, discretion and professional office protocols.

Errors could result in substantial confusion and delay, loss or mismanagement of information, loss of time to correct errors, possible financial loss to the town, and may have legal repercussions.

Essential Functions
(The essential functions or duties listed below are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar, related, or a logical assignment to the position.)

• Provides leadership in all areas of database management, database integration, maintenance, monitoring and support across all IT applications including ERP systems.
• Serves as the chief data officer who oversees data security, privacy and transparency.
• Develops, maintains and implements policies and procedures for database management, data privacy, compliance, and security
• Develops and implements security standard. Supports, maintains and audits database security. Works with network and systems administrators to ensure the security of the town’s databases and systems. A leader in the IT department’s cyber security team.
• Responsible for planning, recommending and implementing changes to SQL Server architecture environments and applications.
• Responsible for the development and maintenance of SSIS packages and various (SSRS/Crystal/Power BI) reports.
• Responsible for data extracts and integration between multiple systems. Participates in development and support projects to design, implement, modify and optimize databases and related software.
• Recommends and oversees database enhancements.
• Analyzes and resolves database and application issues affecting SQL Server environments and performance
• Plans, implements, tests and documents database backup and recovery procedures.
• Tests and implements new releases and patches of SQL Server and other related software.
• Works with application specialists/vendors regarding optimal use of SQL Server and related Technologies.
• Performs database monitoring and reporting tasks including reviewing daily loading logs, ensuring data integrity, monitoring system event and error logs, monitoring disk drive space available to databases and transaction logs, and helping control and monitor user access and activity levels.
• Performance tuning, analyzes indexes and system metrics and assist in developing performance reviews and tuning recommendations for applications.
• Writes stored procedures, SQL views, triggers and scripts.
• Sets up database replications.
• Works with application specialist and/or vendors to develop and maintain data warehouses.
• Performs database application support to end users or some system administration tasks when needed.
• Working with colleagues, provide support to critical application systems such as the financial system.
• Develops, and maintains reports using SSRS, crystal and other tools.
• Updates job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
• Makes mission critical decisions and takes appropriate action in the absence of the Digital Services manager.
• Assists in the evaluation and recommendation of new technologies.
• Protects organization's value by keeping information confidential.
• Accomplishes organization goals by accepting ownership for accomplishing new and different requests; exploring opportunities to add value to job accomplishments.
• Perform other duties and responsibilities as required or situation dictates

Recommended Minimum Qualifications

Education and Experience
BA/BS in computer science, management information systems, engineering, GIS or related fields. Candidates should have 5 years or more of experience in designing, implementing, securing, and supporting production SQL server databases; or equivalent combination of education and experience. Experience with most recent SQL server is preferable. Experience in database administration, systems administration or software development environment. Database security experience essential.

Additional Requirements
A valid driver’s license.

Knowledge, Ability and Skill
Knowledge: Thorough knowledge of relational database programs. SQL knowledge required. Working knowledge of Microsoft network technology, including Active Directory structure and security concepts. Thorough knowledge of Windows server operating systems. Expert knowledge of MS SQL Server all current versions. Expert knowledge of database security standards. Knowledge of ERP systems a plus.

Ability: Demonstrated ability to maintain database security. Ability to give clear instructions and to communicate effectively, orally and in writing. Ability to maintain SQL server databases. Ability to troubleshoot issues at the database and operating system levels. Ability to develop software programs. Ability to install and troubleshoot all database programs and integration between systems. Ability to work collaboratively and effectively with various departments; Ability to develop schedules and long-range/short range plans to achieve stated goals. Ability to work as part of a team.

Skill: Excellent communication and analytical skills. Strong customer service and technical skills. Demonstrated skill in managing multiple tasks and projects with attention to detail and accuracy. Skill in all of the above listed technology, tools and equipment.

Physical Requirements
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Tasks may involve extended periods of time at a keyboard or workstation and on the telephone. Vision and hearing at, or correctable to normal ranges is necessary. Must be able to communicate verbally. Requires the ability to operate, maneuver and/or control the actions of equipment, machinery, tools, and/or materials used in performing essential functions. Ability to manipulate light to medium weights of 10 – 15 pounds. Requires good hand-eye coordination, arm, hand and finger dexterity, and visual acuity to read technical information. Regularly required to drive to multiple locations throughout the Town to perform work.

(This job description does not constitute an employment agreement between the employer and employee and is subject to change by the employer as the needs of the employer and requirements of the job change.)