Database Administrator II
Database Administrator II
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Overview
Snapon Business Solutions (Group); under RS&I Division; Snapon Incorporated.
Location: Richfield OH
Work: Facility Onsite Monday thru Friday 8a5p.
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 internallyused 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 corporatewide 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
- Bachelors degree in Computer Science or Computer Engineering or equivalent work experience. Related work experience and industry recognized certifications will be considered.
- Six to eight 68 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 selfmotivated.
- Ability to carry a mobile device work overtime and provide offhours 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 pgdump pgbasebackup and/or pgBackRest and pointintime recovery.
- Knowledge of rolebased 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
Required Experience:
Unclear Seniority
Employment Type
Full-Time
