at Insight Global in Chicago, Illinois, United States
Job Description
Job Description
You will be responsible for setting up database environments, 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
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
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com .
To learn more about how we collect, keep, and process your private information, please review Insight Global’s Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .
Skills and Requirements
- 8+ years of relevant experience in SQL Database management
- 2+ years’ experience working with major cloud vendors, Azure preferred.
- Experience with backup strategies, replication (SQL native, Azure 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.
Knowledge of Azure Data Lake/Data Factory/SQL Integration Services. Knowledge of Postgres and Oracle is plus.
Microsoft Azure Certification.
Basic PowerShell knowledge or any other scripting language is a huge plus. null
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.