Please answer the following questions in order to process your application.
I certify that I am a U.S. citizen, permanent resident, or a foreign national with authorization to work in the United States. *
File Attachments:
(2MB file maximum. doc, docx, pdf, rtf or txt files only)
* denotes required field
Additional Information:
Availability/Notice
Salary Expectation USD
Approximately how far are you willing to travel to work (in miles) ?
Key Privacy Information
When you apply for a job, JobShark will collect the information you provide in the application and disclose it to the advertiser of the job.
If the advertiser wishes to contact you they have agreed to use your information following data protection law.
JobShark will keep a copy of the application for 90 days.
More information about our Privacy Policy.
Job Details
Associate Principal, Database Administrator (Full Time)
Location: Chicago, Illinois Country: United States of America Rate: $140-150K + Bonus
*Hybrid, 3 days onsite, 2 days remote*
*We are unable to sponsor as this is a permanent Full time role*
A prestigious company is looking for an Associate Principal, Database Administrator. This DBA will focus on production support, performance back up, and DBMS. This company needs someone with 7+ years of working with DB2 LUW on Red Hat and PostgreSQL. This DBA is also expected to have heavy experience coding, reviewing SQL, and some experience with other Scripting languages such as basic Java, linux Shell, Pearl, etc.
Responsibilities:
- Assists with the design, implementation, and maintaining databases
- Manage database performance and disk usage
- Provides support in database access methods
- Provides consultation support in database analysis, modelling, coding, and production problem resolution.
- Develops maintenance, backup and recovery procedures and documentation
- Participates in Disaster Recovery drills
- Provides Primary On-Call Support for production problems
- Understands and supports corporate data standards
- Recommends and assists with new DBMS and operational standards.
- Participates in testing and in evaluations of new software and software release upgrades
- Maintains metadata repositories
Qualifications:
- Bachelor's degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business
- 3+ years' experience developing and maintaining complex applications that make extensive use of a supported database technology or 3+ years' experience as an associate DBA
- Experienced in two or more programming languages and two or more Scripting languages
- Practiced at Entity/Relationship or Object modelling and translation to physical database designs
- Proficient in DML, DDL, and database utilities for at least two DBMS technologies
- Proficient in all access methods of a DBMS as well as the underlying operating system access methods
- Understanding of all software subsystems (DBMS, TP Managers, etc.) for one environment
Technical Skills:
- 7+ years' experience with PostgreSQL
- 7+ years' experience with DB2 LUW; preferably on Red Hat Linux
- Proficient with coding and review of SQL, stored procedures, and triggers
- 1+ year' Terraform, Ansible, Jenkins & CI/CD skills
- 1+ years' EDB Postgres & EDB Postgres Distributed experience
- Basic Java, Perl & Linux Shell script skills
- 1+ years' experience with SQL Server
- 1+ years' experience with DB2 in a z/OS environment
- 1+ years' experience with MySQL/MariaDB
- Experience with BMC tools for DB2 (Change/Catalog Manager, MainView, Log Master)
Posted Date: 28 May 2024
Reference: JSASSOCIATE PRINCIPAL, DBA
Employment Agency: Request Technology
Contact: Dillon Grooss