Database Administrator - Judge Group
Chicago, IL
About the Job
Location: Chicago, IL
Salary: $100,000.00 USD Annually - $120,000.00 USD Annually
Description:
Contact: rkrebs@judge.com
Salary: $100,000.00 USD Annually - $120,000.00 USD Annually
Description:
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
Contact: rkrebs@judge.com
This job and many more are available through The Judge Group. Find us on the web at www.judge.com
Source : Judge Group