Employer: Yakima Chief Hops
Job Title: Database Administrator
Department: Information Technology
Reports to: Database Administration Manager
1.Proven experience building and deploying the SQL scripts in multiple environments.
2.Experienced in database design, optimization, and tuning.
3.Experience with database backup and recovery, including implementing disaster recovery standards.
4.Service oriented mentality, able to work within a team and independently.
5.Exposure to supporting a 24/7 data dependent global environment.
6.Sound written and verbal communication skills; must be able to communicate proficiently to a non-technical audience.
7.Adept at reading, writing, and interpreting technical documentation and procedure manuals.
8.3-5 years of experience within Database Administration using the following software applications/tools:
◾Microsoft SQL 2014/2016, Access 2014, MySQL
◾ASP.NET C#, Visual Studio, PHP would be a plus
◾Reporting tools such as Crystal Reports, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS);
◾Transact-SQL (T-SQL) stored procedures, functions, triggers, and database optimization
◾Experience with other programming languages a plus
◾Experience with and/or willing to learn the ETL process
◾Knowledge of Microsoft Dynamics suite, CRM/BI
◾Understanding of SOAP, REST, JSON, and 3rd party APIs
◾Experience in Windows and Linux environments
Bachelor's degree from a four-year college or university and 3-5 years of varying environmental experiences centered around database support, design, and development.
Responsible for providing technical support for the enterprise database environment including overseeing the development, organization and integration of databases, the assessment and implementation of new technologies, supplying a strategic long-term perspective on the relationship of database technology to business opportunities, participating in numerous application development projects with medium to high complexity, performing capacity planning, researching, evaluating and recommending new tools and techniques to keep the business supplied with the right data to make informed decisions
1.Promote data standards, system procedures, security policies, and database best practices.
2.Take ownership of database-related ad hoc requests, incidents, alerts, escalations, research and respond to resolve in a timely manner.
3.Collaborate with user groups, development teams, and ops team to plan and communicate database upgrades/ patches and releases.
4.Support the deployment of enterprise applications from the database side, Business Intelligence (BI), including the installation of software and the design, build and maintenance of multiple supporting environments (development, test, and production).
5.Responsible for the design, development and administration of transactional and analytical data constructs/structures.
6.Able to edit/create ETL packages to support data warehouse needs
7.Responsible for database performance tuning, monitoring, software installs and upgrades, scripting, and physical and logical database design.
8.Design, develop, and test backup and recovery procedures along with supporting disaster recovery solutions.
9.Perform security and access control on all databases and provide audit reports as required.
10.Track and manage database problems with appropriate vendor support channels.
11.Remain vigilant in the pursuit and presentation of process improvement and enhanced efficiency.
12.Ensure that federal, state and local safety and environmental regulations are observed.
13.Must have a complete understanding of company’s policies, SOPs, QPs, EPs, HACCP and cGMP to ensure quality, safety and sustainability.
14.Follow all SOPs pertaining to the respective business process.
15.Perform all other duties as assigned by Manager and/or designee.
Location: Yakima, WA
Application Method: Online
Base Pay: DOQ