Company:
1872 Consulting
Location: Chicago
Closing Date: 26/10/2024
Salary: £100 - £125 Per Annum
Hours: Full Time
Type: Permanent
Job Requirements / Description
SQL DBA
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
Share this job
1872 Consulting
Useful Links