Location: Chicago, IL
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?subject=Database Administrator
This job and many more are available through The Judge Group. Find us on the web at www.judge.com
About the Company:
Judge Group
The Judge Group, celebrating its 50th anniversary, is a leading professional services firm specializing in talent, technology, and learning solutions. We consult, staff, train, and solve. Through our work we make people and organizations better. Our services are successfully delivered through a network of more than 30 offices in the United States, Canada, and India. The Judge Group serves more than 50 of the Fortune 100 and is responsible for over 9,000 professionals on assignment annually across a wide range of industries. If you would like to learn more about The Judge Group visit www.judge.com or call toll free (800) 360-4474.
Company Size:
10,000 employees or more
Industry:
Computer/IT Services
Founded:
1970
Website:
https://www.judge.com