Senior Sql Database Administrator
Insight Global, Chicago, IL, United States
Job Overview
This is production support + consistency business as usual work, but main focus is to analyze the performance issues via the code and give developers feedback.
Key Responsibilities
You need to build this index to improve your query.
Explain why he is recommending that.
Automation and IDS, PowerShell.
Azure SQL - day to day support and migration.
Python good to know.
Proactive monitoring of tickets.
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 work directly with developers to resolve and triage 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 provide troubleshooting and support including after‑hours support.
Qualifications
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 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.
Compensation Compensation:
$125,000 to $135,000 per year annual salary.
Exact compensation may vary based on several factors, including skills, experience, and education.
Benefits Benefit packages for this role may include healthcare insurance offerings and paid leave as provided by applicable law.
#J-18808-Ljbffr
Key Responsibilities
You need to build this index to improve your query.
Explain why he is recommending that.
Automation and IDS, PowerShell.
Azure SQL - day to day support and migration.
Python good to know.
Proactive monitoring of tickets.
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 work directly with developers to resolve and triage 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 provide troubleshooting and support including after‑hours support.
Qualifications
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 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.
Compensation Compensation:
$125,000 to $135,000 per year annual salary.
Exact compensation may vary based on several factors, including skills, experience, and education.
Benefits Benefit packages for this role may include healthcare insurance offerings and paid leave as provided by applicable law.
#J-18808-Ljbffr