Database Administrator II

Job description

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 (., 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 (., RHEL) for systems management and troubleshooting.

Experience/Knowledge a plus:

EnterpriseDB Oracle Database SQL Serverpgwatch2Pgpool and/or PgBounceroptimizing query performance Git for database code and configuration version controlAnsible for configuration managementBasic knowledge of GDPR, SOC2 Type II compliance standardsAWS

Snap-on is an equal opportunity employer and complies with all applicable federal, state, and local fair employment practices and laws.

Snap-on strictly prohibits and does not tolerate, discrimination against applicants, associates, or any other covered persons for any reason including race, ethnicity, religion, color, national origin, sex, age, physical or mental disability, veteran status, gender identity, sexual orientation or any other characteristic protected under applicable federal, state, or local law.

Required Skill Profession

Computer Occupations