Snap-on Business Solutions (Group); under RS&I Division; Snap-on Incorporated. is looking to solve problems related to the design, testing, implementation, maintenance, and control of logical and relational databases across multiple platforms.
Requirements
- 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
- 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.
- Proficient in scripting with Bash, Python, or Perl for automation of DBA tasks (e.g., maintenance scripts, monitoring).
Responsibilities
- 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.
- 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.
- Support design work for internal and commercial product developers to insure appropriate and efficient use of the specific infrastructure environment
Other
- Work: Facility Onsite -- Monday thru Friday - 8a-5p.
- Bachelor's degree in Computer Science or Computer Engineering or equivalent work experience.
- Excellent interpersonal and communications skills and ability to work with clients, technical staff, and vendors.
- Excellent problem solving and consultative skills.
- Must be a team player with a positive attitude, enthusiasm, initiative, sense of urgency, and be self-motivated.
