Senior Database Administrator

Founded in 1936, Roseburg Forest Products is a privately owned company and one of North America's leading producers of particleboard, medium density fiberboard and thermally fused laminates. Roseburg also manufactures softwood and hardwood plywood, lumber, LVL and I-joists. The company owns and sustainably manages more than 600,000 acres of timberland in Oregon, North Carolina and Virginia, as well as an export wood chip terminal facility in Coos Bay, Ore. Roseburg products are shipped throughout North America and the Pacific Rim. To learn more about the company please visit www.Roseburg.com.

Purpose

The Senior Database Administrator (Sr. DBA) will join a data operations team. Under the general supervision of the Data Architect Manager, this position will perform daily and weekly tasks needed to administer SQL databases and SQL database servers. The ideal candidate should be able to work independently with minimal supervision, and be able to build strong relationships with team members and users. Strong verbal and written communication skills is a must, especially across differing SQL knowledge levels. In addition, the ideal candidate should have a service oriented mentality, and a willingness to take ownership of problems and assigned tasks. This position should be willing to suggest improvements to processes and procedures, to learn new skills, and improve proficiency with existing skills.

Key Responsibilities

• Provide an on-going assessment of database performance and the identification of problem areas, using various tools, queries, DMV's, etc., to provide the highest reliability and performance possible.

• Monitor scheduled jobs;

• Monitor SQL database size and growth;

• Monitor SQL instance space\cpu\memory usage;

• Maintain documentation about the company's database environment;

• Ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO);

• Test backups to ensure we can meet the business' Recovery Time Objectives (RTO);

• Restore production backups to test environments, ensuring proper security levels are maintained for data and for user access.

• Perform capacity planning for servers, to include disk space, CPU, memory, user counts, database distribution across the server farm

• When performance issues arise, determine the most effective way to increase performance including hardware configuration changes, SQL configuration changes, or index/query changes

• Work with system engineers, data analysts, application developers and business analysts to help achieve a stable environment that meets current and future business objectives

• Install and configure new SQL Servers, including SSIS and SSRS as needed

• Troubleshoot SQL Server service outages as they occur, recommend and implement solutions as needed

• Deploy and execute database change scripts (DDL) and data change scripts (DML) as provided by developers and analysts

• Provide SQL query help to developers and analysts

• Set up cybersecurity measures, where indicated by the cyber security team

• Ensure hardware and software is kept up to date

• Ethically handle private data, including financial and/or PII

• Manage user accounts and permissions

• Assist in disaster recovery planning, testing and implementation if necessary

• Develop and deploy SSIS packages as needed for data movement

• Support SSRS administrators, maintain shared data sources for reporting

• Model Company core values

• All other duties as assigned

Required Qualifications

• Bachelors Degree in Computer Science, Business Administration, Information Technology or related field

• Minimum of 5 years in IT operations with strong understanding of database structures, theories, principles, and practices; or an equivalent amount of training, education, and experience

• Minimum 5 years of Microsoft SQL Server experience

• Proficiency with SQL configuration and administration, performance tuning

• Experience writing Powershell scripts for monitoring, management, and automation

• Ability to handle multiple projects and able to work in teams or individually

• Occasional after hours support and weekend work required

• Experience installing, configuring, administering and trouble-shooting Integration Services (SSIS) and Reporting Services (SSRS)

Preferred Qualifications

• ITIL/Agile dev-ops background

• Experience with cloud technologies

• Usage of the following technologies: ServiceNow, SQL Sentry, Qlik Replication

AN EQUAL OPPORTUNITY EMPLOYER INCLUDING DISABILITY AND VETERANS