Database Administrator II
PURPOSE OF POSITION:
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.
Translates logical data models into physical database designs.
Develops physical databases.
Assists in the establishment of database system flows.
Develops and maintains enterprise data documentation and metadata models.
Develops and provides database requirements to system administrators.
Codes, edits, installs and verifies stored procedures and functions for accessing, maintaining, and populating databases.
Recommends and implements database solutions to support data integrity efforts.
Participates in projects that require testing and produces metrics and samples for further analysis.
Monitors utilization for capacity planning.
Monitors database replication performance.
Troubleshoots and resolves applications (ex., SQL) performance issues.
Monitors, analyzes and calibrates DBMS parameters so that the database is tuned for optimal performance.
Maintains development, production, and multiple testing environments.
Performs upgrades of databases, adding new structures or elements.
Plans and manages the migration of databases.
Installs, configures and maintains the database management systems software.
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.
Implements database backup and recovery procedures.
Controls privileges and permissions to database users.
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 fixing problems, identifies and mitigates risks, and implements solutions.
Escalates/communicates issues when necessary.
Standard Policies and Procedures:
Supports enterprise standards.
Assists in establishing database methods and procedures.
Service Level Agreements:
Is aware of service level agreement levels.
Takes steps to meet or exceed requirements.
Research and Evaluation:
Evaluates future technologies.
Coaching and Mentoring:
May provide coaching to less experienced individuals.
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 3-5 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