PURPOSE OF POSITION:
Senior Database Administrators design, install, maintain and upgrade the enterprise’s databases (development, testing, and production). They provide technical expertise in the use of database technology and are accountable for the overall performance of the enterprise’s database environment. Database Administrators work closely with business and system analysts and solution developers to define and resolve information flow and content issues—helping to transform business requirements into environment specific databases.
Works on multiple projects as a team member or sometimes as a technical lead.
Supports multiple databases of medium to high complexity (complexity defined by database size, technology used, and system feeds and interfaces) with multiple concurrent users, ensuring control, integrity and accessibility of the data.
Plans and organizes database activities regarding reliability, performance monitoring and tuning, security, backup and disaster recovery.
Works with analysts, to understand business needs.
Participates in long term planning for software and hardware upgrades of the database environments.
Participates and consults in cross-team and cross-project implementations.
Translates logical data models into physical database designs.
Develops physical databases.
Assists other teams in the design of highly available and redundant database systems.
Designs and implements data warehouse using SQL Server Analysis Service (SSAS).
Designs and implements reporting solution using SQL Server Reporting Service (SSRS).
Establishes information flows.
Develops and maintains enterprise data documentation and metadata models.
Develops and provides database requirements to system administrators.
Design, monitor and maintain data replication primary and secondary databases.
Develop, test, maintain, and exercise procedures for backup, restoration and disaster recovery for high availability, high volume mission critical databases.
Designs, codes, edits, installs and verifies stored procedures and functions for accessing, maintaining, and populating databases.
Recommends and implements db solutions to support data integrity efforts.
Participates in projects that require testing and produces metrics and samples for further analysis.
Ensures optimal database performance and availability.
Works with applications team on optimizing the use of databases.
Conducts application transaction volume and traffic analysis, and interprets the impact on database performance.
Troubleshoots and resolves applications (ex., SQL) performance issues.
Forecasts utilization patterns and recommends modifications or upgrades.
Proposes and implements enhancements to improve system performance and reliability.
Oversees the upgrades of databases, adding new structures or elements.
Provides, evaluates and develops data access tools and techniques.
Directs the scheduling of DBMS software installs.
Builds scripts automating the daily operations of database management.
Monitors transactions between application systems and the database for the purpose of identifying and improving inefficiencies.
Recommends and implements tools and solutions to improve efficiency and effectiveness in database administration and monitoring.
Maintains and monitors database security, integrity and access controls.
Controls privileges and permissions to database users.
Provides audit trails to detect potential security violations.
Makes recommendations to improve security.
Participates in security investigations as needed.
Assures that appropriate information security is applied in all tasks.
Provides production support / database access 24 hrs x 7 days a week (on a standby basis).
Conducts Level 2 and 3 support.
Troubleshoots databases accessibility, availability or operability problems.
Determines the appropriate course of actions for problems, identifies and mitigates risks, and implements solutions.
Escalates/ communicates issues when necessary.
Standard Policies and Procedures:
Establishes and supports enterprise standards.
Service Level Agreements (SLAs):
Monitors performance against service agreement levels.
Participates in the developing SLAs.
Ensures that operating level agreements are met with internal/external customers.
Research and Evaluation:
Evaluates future technologies and makes recommendations for software and hardware upgrades.
Coaching and Mentoring:
Provides technical leadership, work guidance and direction, and coaching to less experienced individuals.
May coordinate training of staff.
KNOWLEDGE, SKILLS & ABILITIES:
Bachelor’s degree or technical institute degree/certificate in Computer Science, Information Systems, or other related field. Or equivalent work experience.
MCSA: SQL Server.
Typically requires more than 7 years of relevant experience in diverse database technologies.
Willingness and ability to travel domestically and internationally, as necessary.
Fully competent skills in Database Administration such as:
SQL Optimization and troubleshooting
Redgate SQL Backup
Redgate SQL Monitor
Running SQL in the cloud