Principal Database Administrator jobs in Chicago, IL

What you will be doing

As a Database Administrator you will be responsible for deployment, migration, implementation, and administration of databases and support of all database environments and related applications on on-prem and Azure SQL Databases. Performs performance monitoring, security, troubleshooting, backups, error checks, and replication. Work directly with other teams to triage and troubleshoot on escalating issues.

Responsibilities:

• Install, configure, maintain and patch SQL Servers
• Manage SQL server databases, Azure SQL databases and Managed Instances
• Backup and restore on-prem and Azure SQL databases, Managed Instances
• Monitor SQL Agent jobs and respond to critical job notifications on failure
• Troubleshoot and resolves problems with production systems; escalates issues and facilitates resolution
• Automate common management tasks using PowerShell.
• Evaluates data access and security to ensure that electronic data resources are available to those who need access and protected
• Automates database Management tasks
• Creating documentation and maintenance plans, assigning monitoring threshold values
• Test backup/recovery, replication, failover, and disaster recovery
• Works collaboratively with the application support and development team including architects, developers to ensure project success
• Assists in project planning and management with clients and other staff members
• Deploy new database and code per change requests
• Provides troubleshooting and support including after-hours support
• Other duties as assigned

How will you succeed

• If you are a SQL DBA with relational database experience in addition to the points below:
• 6 years SQL DBA experience
• 1-2 years of Azure SQL experience
• Knowledge of Azure Data Lake/Data Factory
• Experience with backup strategies, replication, and DR solutions for SQL is a must
• Experience in monitoring and tuning MS SQL Server databases for optimum performance
• Knowledge of indexes, index management, statistics, performance tuning
• Familiarity with SQL Integration Services
• Knowledge of  Postgres and Oracle is plus
• Flexible and able to adapt to a rapidly changing environment and can manage projects of varying length
• Responsible, highly reliable, organized; able to work individually and collaboratively with peers
• Bachelor's Degree in Information Technology or equivalent experience
• Microsoft Azure Certification
• Basic PowerShell knowledge or any other scripting language is a huge plus.

Skills

• Microsoft Azure, Microsoft Azure Administration, Microsoft SQL Server, Relational Database Management System (RDBMS), SQL Databases

rkrebs@judge.com?subject=Database Administrator

About the Company:
Judge Group

Company Size:
10,000 employees or more

Industry:
Computer/IT Services

Founded:
1970

Website:
https://www.judge.com