Database Administrator

ABOUT THE ROLE

Information technology staff enable Cavco employees to leverage data and systems to perform their roles, improve efficiency of the organization, reduce costs, and extend sales and marketing opportunities.

The Database Administrator is responsible for database planning, configuration, monitoring, optimization, and issue resolution. This role works independently on complex efforts, executing process steps, conducting analysis, problem solving, and delivering recommendations. Mastery of skills and knowledge of specialized work.

ESSENTIAL DUTIES & RESPONSIBILITIES

• Administers Cavco's databases, using various database management system tools to organize and store data.
• Ascertains user requirements, creates procedures, functions, and code and tests and coordinates changes with IT staff.
• Interacts with development and end-user personnel to determine application data access requirements, transaction rates, volume analysis, and other pertinent data required to develop and maintain integrated databases.
• Ensures performance of database at optimum level.
• Coordinates changes to databases; codes, tests, and implements physical database, applying knowledge of database management system.
• Designs logical and physical databases or reviews description of changes to database design to understand how changes to be made affect physical database; i.e., how data is stored in terms of physical characteristics, such as location, amount of space, and access method.
• Creates database dictionaries or helps others create data dictionaries for publishing to other technical staff.
• Continuously monitors vital database parameters, such as amount of computer memory, disk space and CPU utilization, index performance.
• Specifies user access level for each segment of one or more data items, such as insert, replace, retrieve, or delete data.
• Specifies which users can access databases and what data can be accessed by user.
• Tests and corrects errors and refines changes to production database.
• Monitors staging and development databases to raise potential issues with programmers early in the development process.
• Confers with co-workers to determine impact of database changes on other systems and staff cost for making changes to database.
• Refactors and optimizes database programming logic to improve execution efficiency and overall system performance.
• Trains new database team staff in best practices and company standards for database development and management.

MINIMUM QUALIFICATIONS

• Bachelors in Computer Science, Information Technology or related discipline
• Masters in related field preferred
• 5 - 8 years’ experience managing production databases in a large complex multi-tiered environment
• Expert level of understanding with SQL Server and Oracle administration and troubleshooting.
• Experience in supporting databases for critical systems with high uptime requirements.
• Expertise with SQL Profiler (or alternate performance monitoring / troubleshooting tools)
• Proficient with T-SQL.
• Detailed knowledge of High Availability implementations (e.g. Windows Failover Cluster, “Always On” availability groups).
• Experience with SQL Server Reporting Services (SSRS) configuration and administration.
• Experience with SQL Server Integration Services (SSIS) configuration and administration.
• Familiarity with OLTP database design, theory and best practices.
• Familiarity with automation techniques (Maintenance Plans, Powershell, etc.)
• Familiarity with a source code repository to check-in and check-out code as needed for deployment to production database environments.
• Excellent written and verbal communication skills