Vacancy expired!
- Microsoft Azure Certification.
- 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 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.
- 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.