SQL DBA

1872 Consulting

Chicago, IL, United States

Full-time

We are sorry. The job offer you are looking for is no longer available.

SQL DB

Chicago, IL (loop) 2 days onsite, 3 days work from home

What you'll be doing

Optimize stored procedures, functions and ad-hoc SQL
Design, develop and implement internal data feeds, data reporting extracts and ETL processes between disparate systems
Implement, create reports and provide general support for SQL Server Reporting services
Monitor relational databases to optimize performance, resource use, backup / recovery, and physical implementation
Review database objects and create and maintain change controls
Monitor and maintain database security
Migrate databases between servers and various platforms
Analyze and resolve SQL Server faults
Document data flows, application specifications from a DB perspective and system procedures
Implement and maintain data distribution and disaster recovery solutions, such as mirroring, replication, and log shipping
Support highly-available and disaster recovery (HA / DR) database technologies (such as SQL Clustering and SQL Server Availability Groups across multiple data centers)
Investigate and resolve reported application issues, escalating issues as necessary to the application owners
Provide 24x7 on-call support on a rotating basis
Flexible to work off-hours, as required

Skills we're seeking

5+ years of experience as a SQL DBA
Strong SQL Server experience
Experience in the following DBA areas (all not required, more the better) :
Performance management and tuning, including identifying solutions that optimize SQL execution plans
Triggers
Stored Procedure Code Development and Standardization
Data Integration and Migration
Management Studio
SQL XML
Database Auditing and Controls

Nice to haves

Experience with Azure SQL
Experience with physical and VMWare SQL configuration from an infrastructure perspective
Experience with Ability to translate Logical Data Models into physical structures

6 days ago

Related jobs

Promoted

Sql Dba

Diverse Lynx

Chicago, Illinois

Experienced and knowledge of high availability SQL Server solutions with SQL Server Always on Availability groups, Failover Clustering, Replication, Log shipping, and Database Mirroring. IT experience on Database Administration and development with MS SQL Server technology. Experience in System Anal...

SQL Server DBA/developer

Gables Search Group

Chicago, Illinois

Extensive TSQL experience, including query optimization, using SQL Server Management Studio. MS SQL Server Database Administrator, Backups, Restores, and experience with High Availability Failover clusters, SQL server/job monitoring. DBA is ideal!Great Downtown Chicago location and train accessible....

Senior SQL Server DBA, Trading or Financial Experience Required – Work From Home

Next Step Systems – Recruiters for Information Technology Jobs Top IT Recruiting Firm

Chicago, Illinois

Remote

Keywords: Chicago IL Jobs, Senior SQL Server DBA, Senior Database Administrator, DBA, MS SQL, Performance Tuning, Query Optimization, Performance Monitor, SQL Profile, Scripting, Linux, PostgreSQL, MySQL, C#,. Senior SQL Server DBA, Trading or Financial Experience Required – Work From Home. Senior S...

SQL Server DBA/developer

Pam & Company, Inc.

Chicago, Illinois

Ms Sql Dba

Danta Technologies

Chicago, Illinois

Monitor and troubleshoot SQL jobs using available tools such as SQL Profiler, Quest Spotlight, review logs and triage issues. Maintain and exhibit knowledge of AWS RDS, Azure SQL and NOSQL database. Design and develop complex SQL queries and appropriate database code such as stored procedures, trigg...

SQL Server DBA/developer

The Boland Group

Chicago, Illinois

SQL DBA - hybrid in OKC

Addison Group

Chicago, Illinois

We are working with a client that is looking to add a SQL DBA to their team. They need a DBA talented in SQL Server on the administration and maintenance side, keeping all servers running and troubleshooting as business units call in and ask why queries are running slow. Skills needed: SQL coding, w...

Promoted

Data Quality SQL Developer - HYBRID or REMOTE

NTT DATA, Inc.

Chicago, Illinois

Remote

We are currently seeking a Data Quality SQL Developer - HYBRID or REMOTE to join our team in Chicago, Illinois (US-IL), United States (US). ...

Promoted

SQL Developer- Financial Aid Systems

Adtalem Global Education Inc

Chicago, Illinois

The SQL Developer is responsible for building, maintaining, and enhancing our business systems to drive efficiency and compliance. SQL Developer or Analyst(or equivalent). Identifies and performs annual and ad hoc system modifications using oracle SQL and Unix batch scripting. Technical skills in wr...

Promoted

Database Administrator, Oracle and SQL

Argonaut Management Services, Inc

Chicago, Illinois

Will also collaborate closely with our DBA who supports SQL, MySQL, No SQL databases. We have an exciting opening for a Database Administrator focused on Oracle for our office in Chicago, IL. Writes complex SQL and PL/SQL functions, procedures, packages, and triggers. Conducts system tuning, perform...