Jobs /

Database Administrator


Apply Now

Job Details

Location: Chicago, Cook County, Illinois, USA Posted: Sep 03, 2020

Job Description

  • Work alongside business functions to create novel solutions and support new business projects
  • Assist with researching new database technologies and implement them to increase productivity and efficiency of database dependent applications.
  • Manage and support production, QA, and Dev databases running on SQL Server, SSAS Cubes, and other NoSQL databases.
  • Develop DBA administration scripts using T-SQL, stored procedure, SSIS packages, and Power Shell scripts
  • Assist with the development and automation of reports for business analysis and compliance purposes.
  • Assist with the development of ad-hoc SQL, stored procedures/views, and tune them to improve performance.
  • Troubleshoot database related issues and provide solutions to increase database system reliability and availability.
  • Manage and maintain database Schemas using database modeling tools and deploy schema changes to Dev, QA, and Prod environments following the change control process.
  • Manage database security and maintain data safety and integrity.
  • Ensure all database servers are backed up that meets RPO and RTO
  • Implement and maintain database/data archiving and retention process
  • Document database environment and administration process
  • 5+ years of experience supporting MS SQL server or other OLTP database as a DBA
  • 5+ years of experience developing T-SQL or other procedural languages
  • 3+ years of experience working with database monitoring tools (SQL Profiler, Quest, RedGate, Idera, Foglight, PDBA, etc.)
  • 3+ years of experience working with at least two scripting language: PowerShell, Python, Shell, Perl
  • Must have administration experience with SQL Server SSAS, SSRS, and SSIS
  • Must be able to work in Linux environment and know basic Linux commands and be able to use a Linux editor
  • Knowledge of and experience with OLAP and NoSQL databases is a plus
  • Must be able to work in a team environment
  • Must have solid communication and interpersonal skills
  • Understanding of Execution Services business and Options specific product knowledge is a plus
  • Self-starter and ability to work with minimal supervision
  • Willingness to learn new skills and take on new challenges
  • BS degree in Computer Science, Mathematics, or related Computer Engineering or Science curriculum

About Citadel

Citadel is a financial services company offering a comprehensive range of wealth management services to individuals.

View Website

Get More Interviews for This and Many Other Jobs

Huntr helps you instantly craft tailored resumes and cover letters, fill out application forms with a single click, effortlessly keep your job hunt organized, and much more.

Sign Up for Free