Associate Principal, Database Administration
Akkodis is seeking an Associate Principal, Database Administration for a Fulltime position with a client located in Chicago, IL Onsite 3 days per week).
Salary Range : $117,000 to $135,000 / Year(The salary may be negotiable based on experience, education, geographic location, and other factors)
Title : Associate Principal, Database Administration
Location : Chicago, IL Onsite 3 days per week)
Type : Fulltime
What You'll Do :
This role will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards.
Participate in and contribute to all phases of systems development projects. Monitor and tune database and database application performance.
Primary Duties and Responsibilities :
To perform this job successfully, an individual must be able to perform each primary duty satisfactorily.
- 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, modeling, 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
- Supports business studies, proposal teams and costing / feasibility studies
- Prepares system documentation
- Maintains metadata repositories
Qualifications :
The requirements listed are representative of the knowledge, skill, and / or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the primary functions.
- Required 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
- Required Well versed in all phases of Systems Analysis and Design
- Required Experienced in two or more programming languages and two or more scripting languages
- Required Practiced at Entity / Relationship or Object modeling and translation to physical database designs
- Required Proficient in DML, DDL, and database utilities for at least two DBMS technologies
- Required Proficient in all access methods of a DBMS as well as the underlying operating system access methods
- Required Knowledge of hardware and operating system capabilities within one environment
- Required Understanding of all software subsystems (DBMS, TP Managers, etc.) for one environment
- Required Accepts ownership in assignments, team, and company and takes initiative outside immediate area of responsibility
- Required Speed / Sense of Urgency Contributes additional effort when necessary to get the job done and to help others meet their objectives
- Required Seeks additional responsibility, shows initiative to learn every aspect of the job, and strives to become a mentor to others in area of expertise
- Required Communicates openly and effectively. Challenges established practices appropriately
- Required Ability to maintain composure under pressure and avoid defensive or irritated or reactions in challenging situations
Technical Skills :
- Required 7+ years’ experience with PostgreSQL
- Required 7+ years’ experience with DB2 LUW; preferably on Red Hat Linux
- Required Proficient with coding and review of SQL, stored procedures, and triggers
- Preferred 1+ year’ Terraform, Ansible, Jenkins & CI / CD skills
- Preferred 1+ years’ EDB Postgres & EDB Postgres Distributed experience
- Preferred Basic Java, Perl & Linux Shell script skills
- Preferred 1+ years’ experience with SQL Server
- Preferred 1+ years’ experience with DB2 in a z / OS environment
- Preferred 1+ years’ experience with MySQL / MariaDB
- Preferred Experience with BMC tools for DB2 (Change / Catalog Manager, Main View, Log Master)
- Preferred Basic JCL & REXX script skills
Education and / or Experience :
- Required bachelor’s degree (or equivalent) in Computer Science, Engineering, Mathematics, or Business
- Preferred Related financial industry experiences
Certificates or Licenses :
- Preferred PostgreSQL Professional Certification
- Preferred IBM Certified Database Administrator - DB2 for Linux UNIX and Windows
Benefits include but are not limited to :
- Medical / Dental / Vision
- 401K
- PTO / Paid Holidays
To read our Candidate Privacy Information Statement, which explains how we will use your information, please visit https : / / www.
akkodis.com / en / privacy-policy.
The Company will consider qualified applicants with arrest and conviction records