Database Administrator

Hybrid

Chicago, IL

Associate Principal, Database Administration

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
• Other duties as assigned

Supervisory Responsibilities:

• None

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 as an associate DBA
• [Required] Proficient in Linux shell scripting
• [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

Technical Skills:

• [Preferred] 3+ years’ experience with Microsoft SQL Server OR DB2 LUW
• [Preferred] 1+ year Terraform, Ansible, Jenkins & CI/CD skills or enthusiastic to learn
• [Preferred] 1+ year PostgreSQL or enthusiastic to learn
• [Preferred] Exposure to additional databases such as SQL Server is a plus

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] Microsoft Certified: Database Administrator Associate OR
• [Preferred] IBM Certified Database Administrator - DB2 for Linux UNIX and Windows