Senior SQL DBA with Azure

Chicago, IL

WHAT YOU’LL NEED:

Technical Requirements and Certifications »Microsoft Azure Certification.

Education and Experience »

SQL skills with relational database experience.

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.

Bachelor's Degree in Information Technology or equivalent experience.

Basic PowerShell knowledge is a must.

Knowledge, Skills and Abilities »

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.

WHAT YOU’LL DO:

Job 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.

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.

Troubleshoot and resolves problems with production systems; escalates issues and facilitates resolution.

Automate common management tasks using PowerShell.

Automates database Management tasks.

Deploy new database and code per change requests.

Evaluates data access and security to ensure that electronic data resources are available to those who need access and protected.

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.

Provides troubleshooting and support including after-hours support.

Other duties as assigned.

Please send/Email resumes:

lgironda@vsoftconsulting.com