Senior SQL Server (DBA) Database Administrator in Chicago, IL at Signature Consultants

Date Posted: 3/26/2020

Job Snapshot

Job Description

Senior SQL Server (DBA) Database Administrator Summary:

Signature Consultants is seeking a Senior SQL Server (DBA) Database Administrator for an opportunity with a client in Chicago, IL. We are looking for a Senior DBA to contribute to our database operations and engineering. The successful candidate will be working very closely with our business team, providing real-time database and data support. This position will be responsible for database administration, database troubleshooting and performance tuning, archiving data per compliance regulations, and providing data analysis, developing and implementing BI solutions for reporting and decision-making, and providing daily support.

Responsiblities:

  • 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 and support production, QA, and Dev databases running on SQL Server, SSAS Cubes and other NoSQL databases.
  • Assist with the development and automation of reports for business analysis and compliance purposes.
  • Manage database security and maintain data safety and integrity.
  • Ensure all database servers are backed up that meets RPO and RTO
  • Assist with researching new database technologies and implement them to increase productivity and efficiency of database dependent applications.
  • Assist with the development of ad-hoc SQL, stored procedures/views, and tune them to improve performance.
  • Implement and maintain database/data archiving and retention process
  • Develop DBA administration scripts using T-SQL, stored procedure, SSIS packages, and Power Shell scripts
  • Document database environment and administration process

Qualifications:

  • 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

Education: BS degree in Computer Science, Mathematics, or related Computer Engineering or Science curriculum.

About Signature Consultants, LLC

Headquartered in Fort Lauderdale, Florida, Signature Consultants was established in 1997 with a singular focus: to provide clients and consultants with superior staffing solutions. For the ninth consecutive year, Signature was voted as one of the "Best Staffing Firms to Work For" and is now the 14th largest IT staffing firm in the United States (source: Staffing Industry Analysts). With 28 locations throughout North America, Signature annually deploys thousands of consultants to support, run, and manage their clients' technology needs. Signature offers IT staffing, consulting, managed solutions, and direct placement services. For more information on the company, please visit www.sigconsult.com. Signature Consultants is the parent company to Hunter Hollis and Madison Gunn.