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.

1. Support design work for internal and commercial product developers to insure appropriate and efficient use of the specific infrastructure environment
2. *Monitor actual performance to insure adherence to standards.
3. *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.
4. *Assist with the establishment of policies and procedures pertaining to security, maintenance, and utilization.
5. *Install and upgrade the database and applications, or other databases systems as directed.
6. *Create primary database structures upon completion of an application design and modify database structures from information provided by application developers.
7. *Support backup and recovery of the database and application information. Conduct periodic restore tests.
8. *Support trouble reporting process with suppliers through established escalation paths to insure rapid response to problems.
9. *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.
10. *Support maintenance of the business systems through management of patches and the patch installation process. Insure that a patch log is maintained.
11. *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.
12. *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.
13. *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.
14. *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.
15. *Maintain/enhance technical expertise and industry knowledge in database technologies and their uses.
16. 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.
17. Participates in Rapid Continuous Improvement to contribute to the delivery of safety, quality, delivery and cost saving objectives.

Perform other miscellaneous duties as assigned.

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