Sr. Database Administrator

POSITION SUMMARY
ASCD is looking for a Database Administrator to overseeing the implementation, configuration, availability, resiliency, protection, automation, administration and monitoring of SQL DB environments across the enterprise. The incumbent ensures the accuracy and integrity of the organization's data.

ESSENTIAL FUNCTION AND RESPONSIBILITIES

• Database administration for Personify member database and NAV financial system platform

• Collaborate with hosting providers to ensure performance and systems integrity

• Custom reporting across multiple data systems

• Ensure performance, security, and availability of databases

• Preform common database procedures such as upgrade, backup, recovery, migration, etc.

• Develop stored procedures and triggers in support of application development

• Lead development and improvement procedures for automated monitoring and proactive intervention, reducing downtime need.

• Participate in application development projects and be responsible for the database architecture and design.

• Responsible for developer SQL code review where applicable to ensure queries are optimized and tuned to perform efficiently.

• Optimize database performance for Personify and the Financial System (NAV) database objects such as jobs, SSIS packages, queries, procedures, functions, triggers, indexes etc.

• Ensure software updates and SQL Server patches are applied according to department requirements and any issues are communicated in a timely fashion.

QUALIFICATIONS
Knowledge

• Bachelor of Science degree, in Information Systems, Computer Science, or Software Engineering preferred

Skills and Abilities

• Ability to research and troubleshoot technical problems

• Strong understanding of how data relationships align with and impact business requirements

• Ability to apply multiple software updates to SQL Servers which include multiple availability groups over multiple servers 

• Ability to perform configuration, performance, maintenance, and management duties with limited tools

• Ability to document departmental standards and procedures

• Excellent oral and written communication skills 

• Ability to work as part of a team

Experience

• 7-10 years IT experience

• 5 years experience with Personify Software

• Experience with Crystal Reports Software

• Experience with Power BI Data Analytics

This position description summarizes the main duties of the job. It neither prescribes nor restricts the exact tasks that may be assigned to carry out these duties. This document should not be construed in any way to represent a contract of employment. Management reserves the right to review and revise this document at any time.

Key Position Designation: Certain positions are essential to providing immediate and continuing support for operations or support functions during an emergency or building closure. Employees who hold these positions may be required to work (at their worksite or remotely) when other employees are not required above. Please refer to the General Information section above to determine whether this position is considered a key position.