SQL Server DBA

  •  

Chicago, IL

Industry: Information Services

  •  

Less than 5 years

Posted 370 days ago

  by    Gina Gomulka

This job is no longer available.

The ideal SQL Server DBA will be a highly motivated individual that can work efficiently with a technical team in a highly demanding environment. Duties may include owning, tracking and resolving database related incidents and requests, implementing maintenance procedures and overseeing standard service reports (e.g:  database backups, maintenance, patching, monitoring) on a daily basis to ensure service related issues are identified and resolved, responding to database related alerts and escalations, creating and implementing enterprise wide project plans aligned to company strategic goals. The candidate must have outstanding communication and prioritization skills and be able to effectively take direction from management.

 

Job Functions:

 

-Provide 24/7support for firm critical databases.

-Performing troubleshooting, resolution and root cause analysis for database and application specific incidents.

-Perform schema design, capacity planning and change control management tasks.

-Executing database base-lining, bench-marking, performance analysis and tuning.

-Maintaining and enhancing database maintenance routines.

-Working with company technical leads and development teams to create and execute project plans in line with customer expectations and company strategic goals.

-Executing database backup and recovery operations, database patching and upgrades and implementation of databasesecurity policies.

-Integrating SQL systems with third-party tools and environments.

-Documenting policies, processes and procedures.

-Cross-training members of the organization on how to use databases effectively and efficiently.

-Supportother key initiatives as the business dictates.

 

Required Skills:

 

-Excellent written and verbal communication skills.

-Excellent analytical and troubleshooting skills.

-Excellent time management skills; able to multi-task among projects.

-Solid Project management skills; able to take a project from inception to completion.

 

RequiredExperience:

 

-3-7years of experience in database administrator.

-Strong RDBMS concepts and experience in creating, maintaining and optimizing Tables, Views, Stored Procedures, User Defined Functions using SQL Server, T-SQL.

-Knowledge of databasesecurity methods and procedures.

-Understanding of ETL best practices across the enterprise.

-Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profile, Extended Events and other related monitoring and troubleshooting tools.

-Knowledge of High Availability and Disaster Recovery options for MSSQL.

-Experience in implementing operational automation utilizing a scriptinglanguage such as python.

-Knowledge of indexes, index management and statistics.

-Experience with database backup, restore and recovery models.

-Bachelor’s degree in Computer Science or related subject.

-Strong GPA (3.0 or higher).

 

Extensive Experience:

 

-Experience with SQL 2014/2016 a plus.

-Understanding of Windows Server (2012/R2) configuration and management, specifically as it relates to MS SQL Server installations.

-Experience with Linux in conjunction with PostgreSQL and MySQL a plus.

-Experienceworking with both ISCSI and FC SAN environments, specifically with aspects relating to MS SQL Server.

-Source code management systems such as GIT.

-QA manual and database testing with SDLC and STLC.

-Experience with virtualization software such as VmWare vSphere.

 

Keywords: Chicago IL Jobs, SQL Server DBA, Database Administrator, SQL Server, T-SQL, RDBMS, Tables, Views, Stored Procedures, ETL, Trading, Chicago Recruiters, Information Technology Jobs, IT Jobs, Chicago Recruiting

 

Company Will Relocate Candidates!

 

No Corp-To-Corp Or Third Party Recruiters; W-2 Direct Hire Only.

$80K - $130K