Johnson Brothers is a national family-owned wine, spirits and beer distributor. Johnson Brothers has been providing, exceptional service to our customers since 1953, representing the world's most famous brands in the beverage industry.
The SQL Server DBA will be responsible for the implementation, configuration, maintenance, and performance of critical Microsoft SQL Server RDBMS systems, to ensure the availability and consistent performance of our applications. This is a “hands-on” position on our Infrastructure Team requiring solid technical skills, troubleshooting abilities as well as demonstrated communication and documentation experience.
The successful candidate will be responsible for multiple applications both commercially and internally developed ensuring their operational readiness (security, health and performance), executing data loads, and ability to troubleshoot complex issues with them . Our applications support the enterprise in product ordering, warehouse management, reporting systems, and Business Intelligence. Must be capable of working independently and collaboratively with Infrastructure and Development teams.
Job Description:
Job Duties:
Manage SQL Server databases through multiple product life cycle environments, from development to production systems
Monitors and tests database backup procedures and security procedures
Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
Calculates optimum levels for database parameters such as amount of computer memory and CPU cycles to be used by database
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end, and assisting with root-cause analysis
Refine and automate regular processes, track issues, and document data architecture and change control
Assist developers with complex query tuning and schema refinement.
Provide on-call support for critical production systems.
Perform scheduled maintenance and support release deployment activities after hours.
Skills and Qualifications:
5+ years MS SQL Server Administration experience required
Experience with Performance Tuning and Optimization (PTO), using Solarwinds DPA or similar native tools
Experience with backups, restores and recovery models Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
Experience working with Windows server systems, including Active Directory
Excellent written and verbal communication Flexible, team player, “get-it-done” personality
Ability to organize and plan work independently
Ability to multi-task and context-switch effectively between different activities and teams
MCTS, MCITP, and/or MVP certifications a plus Previous experience with other relational databases such as MySQL, IBM DB2, Oracle a plus
The expected pay range for this role is $77,316- $123,000. Pay is based on several factors including, but not limited to, labor markets, education, experience, certifications, etc. Johnson Brothers offers eligible team members and their dependents comprehensive health benefits and programs, which include medical, dental, vision, life insurance, health savings and flexible spending accounts. Other benefits for eligible team members include 401(k) with an employer match, short term disability coverage, company-paid long term disability insurance, generous paid time off (PTO) plans and paid parental leave.
Equal Opportunity Employer
Johnson Brothers is committed to providing equal employment opportunity and equal treatment in employment without regard to race, ethnicity, color, religion, gender/gender identity or expression, sexual orientation, age, national origin or ancestry, physical or mental disability, military status or any other basis in protected by applicable federal, state and local law. Johnson Brothers makes employment decisions based solely on the basis of qualifications for the job.
Worker Sub-Type:
Regular
Time Type:
Full time
Data & Analytics (1)