Job details

Database Administrator II

Get a free resume review

Overview

Snap-on Business Solutions (Group); under RS&I Division; Snap-on Incorporated.

Location: Richfield, OH

Work: Facility Onsite -- Monday thru Friday - 8a-5p.

Assists in the design, testing, implementation, maintenance and control of the provisioning of logical and relational databases across multiple platforms and computing environments including host based, distributed systems, and client/server. Implements established standards, performs capacity management and planning, assists with performance management, and performs implementation and reconfiguration. Makes recommendations on alternative approaches to support client requirements. Assists with security and integrity management techniques. Assists with the development and maintenance of data base support tools, tables, dictionaries, recovery and backup procedures. Assists internal and external clients regarding problems with and capabilities of various internally-used databases. Supports the activities related to database planning and development. Receives general supervision and is competent to work in most aspects of database management.

Responsibilities

Support design work for internal and commercial product developers to insure appropriate and efficient use of the specific infrastructure environment

*Monitor actual performance to insure adherence to standards.

*Assist efforts related to the identification and analysis of corporate-wide information flows, interfaces between business processes and the development of logical data base designs, detailed data models and relational data base designs.

*Assist with the establishment of policies and procedures pertaining to security, maintenance, and utilization.

*Install and upgrade the database and applications, or other databases systems as directed.

*Create primary database structures upon completion of an application design and modify database structures from information provided by application developers.

*Support backup and recovery of the database and application information. Conduct periodic restore tests.

*Support trouble reporting process with suppliers through established escalation paths to insure rapid response to problems.

*Insure adherence to established standards for software version management currency including end of life planning for supported technologies coincident with vendor/supplier plans; participate in the establishment of new standards.

*Support maintenance of the business systems through management of patches and the patch installation process. Insure that a patch log is maintained.

*Assist with capacity and performance management planning and development of change recommendations within the DBA group and across the Infrastructure Technology and commercial development organizations as required.

*Participate in periodic planning sessions with customer support, information services infrastructure, and other internal clients as required to guide direction within standards and provide thought leadership around the employment of new technologies to improve the efficiency and effectiveness of business operations.

*Support security practices as regards access, usage, and management of privileges to insure that the information assets of the business are protected at all times.

*Support other elements of the Infrastructure Technology organization in their performance of system administration efforts in areas such as backups, memory/CPU/architecture planning disc space planning, security management, , license management, and general infrastructure management.

*Maintain/enhance technical expertise and industry knowledge in database technologies and their uses.

Focus on the achievement of our mission in accordance with our Beliefs, Values and Vision; striving to embody the culture of respect, teamwork and integrity. Contributing to an environment where diversity is valued and there is equal opportunity for all.

Participates in Rapid Continuous Improvement to contribute to the delivery of safety, quality, delivery and cost saving objectives.

Perform other miscellaneous duties as assigned.

Qualifications

Bachelor's degree in Computer Science or Computer Engineering or equivalent work experience. Related work experience and industry recognized certifications will be considered.
Six to eight (6-8) years of extensive experience installing and supporting Postgres, Microsoft SQL/Server, open source database solutions, and related technologies.
Detailed knowledge of hardware and software issues on Linus/Unix and Microsoft servers, SQL/Server and Postgres databases.
Experience working with commercial developers, internal developers, and customers on the deployment and support of Postgres, Microsoft SQL/Server, open source database solutions, and current Oracle applications software
Excellent interpersonal and communications skills and ability to work with clients, technical staff, and vendors.
Excellent problem solving and consultative skills.
Excellent planning, project management and implementation skills.
Must be a team player with a positive attitude, enthusiasm, initiative, sense of urgency, and be self-motivated.
Ability to carry a mobile device, work overtime, and provide off-hours support as required.
Ability to work on a global presence as required.
Ability to travel to remote company locations or for other business related needs as required.
Ability to lift up to 60lbs./27Kg of equipment.

SKILL SETS REQUIRED:

- Proficient in installation, configuration, and maintenance of PostgreSQL databases.
- Proficient in setting up and managing streaming replication and/or logical replication, and failover mechanisms.
- Proficient in designing and implementing backup strategies using pg_dump, pg_basebackup and/or pgBackRest and point-in-time recovery.
- Knowledge of role-based access control.
- Experience in partitioning and managing large datasets.
- Experience with extensions.
- Proficient in scripting with Bash, Python, or Perl for automation of DBA tasks (e.g., maintenance scripts, monitoring).
- Proficient in analyzing PostgreSQL logs for error detection, slow queries, and deadlock resolution.
- Proficient in diagnosing and resolving issues like memory bottlenecks and disk I/O problems.
- Proficiency in Linux environments (e.g., RHEL) for systems management and troubleshooting.

Experience/Knowledge a plus:

- EnterpriseDB
- Oracle Database
- SQL Server
- pgwatch2
- Pgpool and/or PgBouncer
- optimizing query performance
- Git for database code and configuration version control
- Ansible for configuration management
- Basic knowledge of GDPR, SOC2 Type II compliance standards
- AWS

Average salary estimate

$80000 / YEARLY (est.)

min

max

$70000K

$90000K

If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.

What You Should Know About Database Administrator II, Snap-on

Join Snap-on Business Solutions as a Database Administrator II in Richfield, OH, where you will dive into the engaging world of database design, testing, and implementation! In this full-time role, you’ll be at the forefront of managing logical and relational databases across various platforms, showcasing your expertise in everything from Postgres to SQL Server. Your day-to-day will involve handling capacity management, performance oversight, and security protocols—all crucial elements for efficient database operation. Collaborate with internal and external clients to troubleshoot database issues, support data planning activities, and ensure adherence to best practices in database management. With a Monday to Friday schedule from 8 AM to 5 PM, you’ll enjoy a balanced workday while still contributing to major projects. Your recommendations on alternative approaches will help shape our data management strategies, ensuring client needs are consistently met. The ideal candidate will have 6-8 years of extensive experience in database support, a solid educational background in Computer Science, and a passion for continuous improvement. Join a team that values respect, teamwork, and integrity, and be part of a company that embraces diversity and equal opportunity for all. If you're ready to leverage your skills in a supportive environment and make a significant impact, we’d love to hear from you!

Frequently Asked Questions (FAQs) for Database Administrator II Role at Snap-on

What are the responsibilities of a Database Administrator II at Snap-on Business Solutions?

As a Database Administrator II at Snap-on Business Solutions, your primary responsibilities will include assisting in the design and maintenance of logical and relational databases, supporting internal and commercial product development, and ensuring adherence to database performance standards. You'll also handle important tasks such as capacity management, security management, and configuration of both PostgreSQL and SQL Server databases. Your role will be critical to maintaining the integrity and security of the data systems.