Senior Sql Database Administrator

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.