Senior Database Administrator

Maintaining efficiency and economy in operations management requires flexibility in job assignments. While each employee shall have a primary responsibility for the job in which that employee has been hired or later promoted to, each employee may be expected to perform other jobs from time to time.

SUMMARY:
Under the direction of the Information Technology Operations Manager, the Senior Database Administrator (DBA) is responsible for the administration and maintenance of the MS SQL server database infrastructure and dependent systems. The Senior DBA acts as the primary technical resource for database integrity, backup and restoration, and performance monitoring. 

EXAMPLES OF DUTIES:
Essential Functions

• Administers, monitors, maintains, upgrades and troubleshoots existing database infrastructure across development, testing, and production database environments.
• Designs, implements, and improves new database infrastructure components, applications, interfaces, replications, SSIS packages, stored procedures, etc.
• Develops, documents, and maintains enterprise best practices standards and procedures for database creation, upgrades, patches, backups, restoration, replication, index maintenance, tuning, monitoring, alerting, and security.
• Performs and monitors regular data imports from disparate internal and external systems, ranging from fully automated to manual processes, in order to meet the MTS operational reporting requirements.
• Performs required server and software patches in conjunction with Datacenter Operations schedules and System Administrators (may require after-hours support).
• Establishes and maintains security and access controls for MTS database systems, applications, data, indexes, database services, replication packages, and processes in conjunction with Datacenter Operations and System Administrators.
• Creates and maintains documentation for databases, database infrastructure and database processes and procedures. 

Duties May Include, But Are Not Limited To, The Following:

• Evaluates emerging database technologies and recommends adoption strategies to improve scalability and performance.
• Architects and manages high-availability and disaster recovery solutions using SQL Server Always On and cloud-native tools.
• Leads strategic planning and implementation of database technologies across on-premises and cloud environments.

• Maintains business critical replication infrastructure, including legacy systems.
• Designs and executes database queries and data analysis in response to requests from MTS departments. 

• Creates and maintains documentation for databases, database infrastructure and database processes and procedures.

• Collaborates with IT staff, MTS departments, and SAP support personnel in the design, development, tuning and troubleshooting of database infrastructure, services, servers and applications.
• Contributes to the IT Disaster Recovery Plan through yearly review and update.
• Performs other duties as assigned.

QUALIFICATIONS:
Knowledge, Skills, and Abilities
Knowledge of or ability to learn MTS policies and regulations; ability to read, understand and apply MTS policies, regulations and union labor contracts; ability to write letters, memoranda and reports using clear, concise and grammatically correct English; ability to speak clearly, distinctly and effectively in person-to-person or small group situations using tact and diplomacy; ability to coordinate and initiate actions necessary to implement decisions and delegate responsibilities to appropriate personnel; ability to establish and maintain priorities in order to complete assignments by deadlines without detailed instructions; skill in verifying the accuracy and completeness of forms and reports; knowledge of Microsoft Office Suite and the ability to learn and use other software that MTS might have or acquire; exceptional verbal and written communication skills; ability to clearly communicate complex technical concepts to individuals or groups with varying technical understanding; exceptional organizational, prioritization and multi-tasking skills; exceptional interpersonal skills and understanding of customer relationship management; exceptional collaborative and team-cent