SQL DBA

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

What you'll be doing:

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

Skills we're seeking:

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

Nice to haves:

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