SQL Database Engineer

Job Description:

Good at managing and operating Microsoft SQL Server database instances; optimizing

configuration settings performing database backups & restores developing and running optimization tasks composing automation scripts for repetitive tasks etc.

Experienced with the most recent releases of SQL Server including the related products of Integration Services Reporting Services and Analysis Services. You have excellent communication skills work well in a team and provide outstanding customer service.

Able to work independently with minimal supervision

Individually execute and deliver on daytoday activities

Perform research of viable technical and/or nontechnical solutions

Share knowledge with the Team

Leverage internal networks in role and viewed by stakeholders as skilled specialist.

Supporting a combination of project and operational activities in conjunction with our Managed Service Provider for Database operations.

Focus on assisting the team in the management of our ServiceNow ticket queue.

Goal is to maintain reasonable ticket SLAs while meeting the Teams project commitments.

Qualifications we seek in you!

Bachelors degree in computer or information sciences or similar field preferred

You bring to us experience in managing SQL Server databases TSQL programming knowledge of third form normalization design principals and indexing best practices. Experience in Oracle and/or other DBMSs to help support RtB

Preferred qualifications:

Solid MS SQL Server DBA experience (SQL

Strong Database Design skills

Expertise in SQL Statement Tuning

Experience with native transactional Data Replication

Experience in configuring AlwaysOn Availability Groups (incl. Windows Clustering)

Experience with deploying and managing Cloud Database Services (AWS/Azure preferred) like AWS DynamoDB AWS RDS Azure SQL Azure Cosmos DB

Experience with Cloud automation deployment (e.g. Terraform for SQL RDS)

Good understanding of networking concepts in cloud (VPCs Subnets Security Groups etc)

Strong TSQL Programming capabilities

PowerShell and/ or Python scripting capabilities

Familiarity with Oracle Database technology (versions 11g 12c 18c and 19c) a plus

Familiarity with Datadog as a monitoring and analytics tool

Familiarity with MySQL and PostgreSQL a plus

Maintain database security

Maintain Server and DB Auditing

Excellent troubleshooting and problemsolving abilities

Primary Skills:Solid MS SQL Server DBA experience (SQL Strong Database Design skills Expertise in SQL Statement Tuning

Secondary Skills:Deploying and managing Cloud Database Services (AWS/Azure preferred) like AWS DynamoDB AWS RDS Azure SQL Azure Cosmos DB.Cloud automation deployment (e.g. Terraform for SQL RDS) PowerShell and/ or Python scripting capabilities