Database Administrator II
PURPOSE OF POSITION:
Database Administrators 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.
Database Administrators develop databases across multiple platforms. They support the transformation of business requirements into database solutions. Once a database is in place, they monitor and analyze performance metrics and then allocate database resources to achieve optimum database performance. Individuals implement and perform backup and recovery procedures for the enterprise’s databases and help develop the tools and techniques that allow customers to access data in a secure environment. Lastly, they support and help develop a common set of standards, the methods and procedures used for all database administration development work and recommend software and hardware upgrade paths. These professionals have a solid working knowledge of database administration methodologies and techniques, and a good understanding of logical and physical database design principles. They work well in a team environment and exhibit flexibility when addressing daily shifting work priorities
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.
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.
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.
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.
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.
Policies, Procedures and Standards:
Supports enterprise standards.
Assists in establishing database methods and procedures.
Servie Level Agreements (SLAs):
May assist in developing SLA’s.
Provides coaching and guidance to team members.
Evaluates future technologies and makes recommendations.
KNOWLEDGE, SKILLS & ABILITIES:
Bachelor’s degree or technical institute degree/certificate or equivalent work experience.
Typically requires 3-5 years of relevant database administration experience.
Willingness and ability to travel domestically and internationally, as necessary.
Relevant certification is required.
Effective in written and verbal communication in English.
The position requires ability and willingness to travel domestically and internationally up to 5% of the time.