Senior Sql Database Administrator Job at Insight Global, Chicago, IL

SHgxQjVSUWM1bXFGMGo4KzhKaDRkZlhEQ1E9PQ==
  • Insight Global
  • Chicago, IL

Job Description

Job Title: Sr SQL DBA/Programmer

Location: Chicago, IL ( Hybrid )

Pay Rate: $130,000 - $135,000

Start Date: ASAP

As a Database Administrator /Programmer you will be responsible for application support, analyzing the performance issues and code, deployment, migration, implementation, and administration of databases and support of all database environments and related applications on on-prem and Azure SQL Databases. You will do performance monitoring, security, troubleshooting, backups, error checks, and replication and works directly with developers to solution, triage and troubleshoot on escalating issues. You will make installs, configure, maintain and patch SQL Servers, test backup/recovery, replication, failover, and disaster recovery, deploy new database and code per change requests and provides troubleshooting and support including after-hours support.

• 8+ years of experience in SQL database administration and development/programming. • Experience with Azure SQL and knowledge of Azure Data Lake, Databricks, Data Factory is desired. • Strong experience with backup strategies, replication, and DR solutions for SQL, monitoring and tuning MS SQL Server databases for optimum performance and a deep knowledge of indexes, index management, statistics, performance tuning. • Strong PowerShell scripting and automation skills • Some Python knowledge and familiarity with SQL Integration Services, Postgres and Oracle. • Ability to analyze database code and issues to create solutions for developers.

This is production support + consistence BAU work, but main focus is to analyze the performance issues via the code and give developers feedback.

  • You need to build this index to improve your query
  • Explain why he is recommending that

Compensation:

$130,000 to $135,000 per year annual salary.

Benefit packages for this role may include healthcare insurance offerings and paid leave as provided by applicable law.

Job Tags

Immediate start,

Similar Jobs

BedMart Mattress Superstores

Furniture and Design Consultant Job at BedMart Mattress Superstores

 ...2021, we joined forces with The Mind's Eye Interiors to bring elevated home design to your community. This position focuses on furniture sales, so previous furniture or design experience is preferred. We invite you to join the Mind's Eye Interiors and BedMart Family... 

Cipriani

Help Desk Technician Job at Cipriani

 ...POSITION PURPOSE The Help Desk Technician I serves as the first and primary point of contact for all IT support requests across the...  ...commitment to delivering a high-quality, customer-focused support experience. ESSENTIAL FUNCTIONS AND DUTIES Serve as the... 

Colorado Watersports

Summer Camp Counselor Job at Colorado Watersports

 ...interested in recreation, outdoor adventure, and child care. Camp Counselors will be working with our week and day camps groups teaching...  ..., water sports experience preferred. Why work here Our summer camp counselors are out on the water teaching kids watersports...