Senior Sql Database Administrator

Title: Sr SQL DBALocation: Chicago, IL (hybrid)Pay Rate: $125,000 - $135,000Duration: PermanentInterview Process: 3 RoundsThis is production support + consistence "business as usual" work, but main focus is to analyze the performance issues via the code and give developers feedbackYou need to build this index to improve your queryExplain why he is recommending that-Automation and IDS, PowerShell-Azure SQL - day to day support and migration-Azure Managed Instance-Design tables-Proactive monitoring of ticketsAs 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.Compensation:$125,000 to $135,000 per year annual salary. Exact compensation may vary based on several factors, including skills, experience, and education.Benefit packages for this role may include healthcare insurance offerings and paid leave as provided by applicable law.