1872 Consulting
Senior SQL Server DBA - Chicago
What's your preference?
Job Description
- Req#: 21-00074
- Monitor and maintain database security
- Migrate databases between servers and various platforms
- Review database object and create and maintain change controls
- Analyze and resolve SQL Server faults
- Investigate and resolve reported application issues, escalating issues as necessary to the application owners
- Design, develop and implement internal data feeds, data reporting extracts and ETL processes between disparate systems
- Document data flows, application specifications from a DB perspective and system procedures
- Monitor relational databases to optimize performance, resource use, backup/recovery, and physical implementation
- Implement and maintain data distribution and disaster recovery solutions, such as mirroring, replication, and log shipping
- Implement, create reports and provide general support for SQL Server Reporting services
- Support highly-available and disaster recovery (HA/DR) database technologies (such as SQL Clustering and SQL Server Availability Groups across multiple data centers)
- Provide 24x7 on-call support on a rotating basis
- Flexible to work off-hours, as required
- 5+ years of experience with SQL Database administration
- Stored Procedure Code Development and Standardization
- Data Integration and Migration (SSIS)
- Management Studio
- Database Auditing and Controls
- Performance management and tuning, including understanding of SQL execution plans.
- Experience installing and working with SQL 2012, SQL 2014, SQL 2016 and SQL 2019
- Experience working with and creating reports in SSRS
- Experience with physical and VMWare SQL configuration from an infrastructure perspective
- Experience working with vendors for 3rd party products and integrations
- Ability to translate Logical Data Models into physical structures
- Experience working with SentryOne SQL Sentry, RedGate Compliance Manager, IDERA tools, ServiceNow.
Senior SQL Server DBA
Chicago, IL (remote to start, eventually back in the office in the loop 3-4 days/week)
Summary
The SQL Server DBA will be a part of the team responsible for the operational support of project initiatives surrounding the SQL Server Database environments. This position will play an integral role in the maintenance, support and enhancements of business critical applications.
What you'll be doingAbout the company
1872 Consulting is a Chicago-based IT Recruitment, Staff Augmentation and IT Consulting firm. 1872 focuses on emerging technology such as Data Science, Blockchain and Cloud Native Infrastructure.
Notice
Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at accessibility@talentify.io or 407-000-0000.
Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.
An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report. NYC applicants may request an alternative process or accommodation at aedt@talentify.io or 407-000-0000.