Job Title: SQLServer Database Administrator SR. C2H

Job Title: SQL Server Database Administrator SR. C2H Location of role: Chicago, IL 60654 Shuttle from both Metra stations - Easy location - Remote for now till further notice. With Covid - All remote for now! Contract to hire usually within 3 months or possible Direct Hire. Hourly / Salary range: Contract to hire hourly range $60/hr to $80/HR depending w2 or c2c and upon conversion $120,000 - $150,000 plus 10% bonus - Depending on experience DOE Key Points of the role: Master's Degree in Computer Science or equivalent years of experience Required - Solid lead / mentor hands-on SQL DBA working with a commercial-grade SQL Server Database systems leveraging the following: Need ideally 9 yrs plus Sr. DBA hands-on, able to manage people and help them manage their workloads and Drive to end results? Microsoft SQL Server 2008, 2012 and 2014 (2016 a plus) Strong T-SQL skills MS SQL Server Integration Services (SSIS) Adept at Transactional Replication, including setup, troubleshooting and creating replication scripts Expert performance troubleshooting skills Strong understanding of Clustering , Always-On, Partitioning, SAN technologies Able to implement Disaster Recovery methods Technical design including high-level conceptual diagrams, data flow diagrams, component diagrams. Protect production (RDBMS, NoSQL, Cloud RDBMS) systems Identifies and correct performance bottlenecks related to SQL code. Preferred cloud skills: AWS, Redshift, S3, Lambda, Kinesis Streaming. 3rd Party monitoring tools, including Idera SQLDM, Solar Winds Ignite, SCOM, and others 24/7 Support Essential Position Functions Accountability | Technical Planning Accountable for Leading and completing projects from beginning to the end with help from fellow Technical Data Architects Contribute to design and development of extensible/sustainable/quality database solutions based on an understanding of business and customer requirements and needs Contributes to technical design including high-level conceptual diagrams, data flow diagrams, component diagrams. Continuous strive to protect production (RDBMS, NoSQL, Cloud RDBMS) systems Commands a broad awareness of related projects Principal Accountability | Database Administration Proactively involved in Technical Leadership team Proactively monitors database trends and acts to improve database systems and processes Identifies and owns database related risks and raises/resolves issues effectively Provides recommendations for and analysis and evaluation of systems improvements, optimization, development and/or maintenance efforts including, but not limited to capacity planning Develops ad-hoc scripts, including clean-up scripts when needed Identifies and correct performance bottlenecks related to Database Operations. Supports and is accountable for timely production releases and adherence to release activities Contributes to development Disaster Recovery plans and data retention strategy Proven track record (7 to 10 years) working in fast-paced, time-sensitive project that requires: Clear and timely communication of key information deemed critical to project success Managing design risk Balancing priorities Principal Accountability | Database Operations Provides recommendations for and analysis and evaluation of systems improvements, optimization, development and/or maintenance efforts including, but not limited to capacity planning Identifies and correct performance bottlenecks related to SQL code. Contributes to selection and design of tools required for management of the database and transaction processing environments Going above and beyond the requirement of the role Articulating technical information to a non-technical audience Understanding of Scrum/Agile methodologies is preferred Leading without authority What we offer: Competitive compensation package Medical, Dental, Vision, Disability, Life Insurance, and 401K Advancement Potential Fun and energetic work environment Volunteer opportunities Company relocation - At this time, client will NOT relocate for this role Company sponsorship - At this time, client will NOT sponsor for this role Travel: This role may require 0% travel Duration of role: Contract to hire or possible Direct hire Role - currently, they are all remote If applying for this role - Please take each key point and provide number of years experience and what you would rate yourself, 1 thru 10 (10 being expert) for each key point. Send your resume and notes on the role to expediate our recruiting services.