UniVerse Database Administrator (On-site) - Snap-on Inc
Libertyville, IL 60048
About the Job
This position is on-site, Monday through Friday. Must be authorized to work in the United States.
Position Summary:
Hands-on administration and tuning of UniVerse and SQL Server databases. Develop, implement, and support applications that interface with core Credit CRM systems. Part of a team that is responsible for the transfer of all system files within Snap-on Credit, to/from corporate systems, external vendors, and partners. Responsible for cross-platform printing, file sharing, and security. Some light travel is possible
Responsibilities:PRIMARY DUTIES AND RESPONSIBILITIES:
- Provide monitoring, support, and productivity enhancements for in-house encrypted UniVerse Databases running on Linux platforms in multiple geographies
- Perform UniVerse database upgrades and conversions as required
- Manage database history files to facilitate application development testing
- Participate in system conversion activities with Veeam backup/restore and file transfer platforms
- Install, configure, and manage multiple instances of IBM MQ and GoAnywhere MFT across multiple geographies, utilizing SFTP, API calls, and other standard transfer protocols
- Manage and administer interface products on multiple OS platforms
- Assist in integrating and updating UniVerse systems in Development and Test environments
- Troubleshoot problems on systems of ownership, including business applications, hardware and software solutions
- Supplement UNIX Administrator with performance analysis, security, monitoring, and upgrades of Linux environments
- Assist in disaster recovery/business continuity design and testing with replicated production data
- Assist in servers and PURE storage provisioning and administration
SKILLS AND QUALIFICATIONS:
- Two years’ experience installing and supporting UniVerse Database Systems a plus.
- Five years' experience as SQL database administrator, including installation and configuration of SQL Server
- Four-year degree majoring in Engineering or Computer Science or 4+ years’ experience working as Database Administrator
- Broad system administration background, strong UNIX skills and familiarity with Windows, and Linux
- Strong TCP-IP, DNS, and networking skills are required in addition to knowledge of SSH certificates, GPG and PGP encryption, FIPS 140-2, AES, SFTP, SCP, FTPS, AS2, HTTPS, and RSYNC
- Proven project management skills: ability to handle multiple priorities in a fast-paced environment
- Excellent analytical and problem-solving skills
- Effective communication, excellent interpersonal and problem solving skills
- Experience with client/server technology, preferably with a PICK UniVerse/UniData environment
WORKING CONDITIONS
Required working hours are approximately 8 to 5 Monday - Friday. Some after hours (early morning / evenings and Saturdays) work may be required during the week and on weekends to accomplish work within critical deadlines. The environment will be intense and fast paced.