SQL DBA

Compensation

: $83,870.00 - $126,970.00 /year *

Employment Type

: Full-Time

Industry

: Information Technology



Loading some great jobs for you...





Position DBA Consultant Work location Overland Park, KS. Duration 6+ Months Summary Support database servers and data processing products across the enterprise. The Data Services team provides support for departmental reporting, enterprise reporting, software development, and data warehouse initiatives. DutiesResponsibilities Install, Configuring, Patching and Upgrading SQL Server Database Servers Performance Tuning and Query Optimization using native SQL Server tools Monitor and support High Availability Database server including Availability Groups and Replication. Ability to troubleshoot performance issues impacting production databases. Work as part of a project team to coordinate database development and determine project scope and limitations Work with Database Synchronizations and HUB - MEMBER Topologies Troubleshoot automated backups and metric management Select correct tier for Azure SQL Databases and Azure SQL Data warehouses. Manage Performance Metrics and Plan Management Create functions and stored procedures to provide custom functionality as per the requirements. Ad-hoc query generation using T-SQL Develop reports using SQL Server Reporting Services. Deploy, Maintain and troubleshoot applications on Microsoft Cloud infrastructure Azure. Design and built cloud service models including Infrastructure-as-a-Service, Platform-as-a-Service, and Software-as-a-Service. Other duties may be assigned QualificationsSkills Strong Azure SQL experience Strong SQL coding skills (SQL ServerT-SQL), including stored procedures. Experience with SSIS. Experience with data modeling including normalization, logical and physical designs. Performance Tuning, Query Optimization, Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools. Experience working with Database Synchronizations and HUB - MEMBER Topologies Experience troubleshooting automated backups and metric management Ability to select correct tier for Azure SQL Databases and Azure SQL Date warehouses. Experience working with Performance Metrics and Plan Management Strong knowledge of backups, restores, recovery models, DBCC commands, Database mirroring, Replication. Knowledge of indexes, index management, integrity checks, configuration, patching, statistics, etc. Knowledge of SQL Server tools (Profiler, SSMS, DMVs, and system stored procedures Database Security Technical documentation skills Experience with PowerBI a plus Experience with KingswaySoft SSIS Integration Toolkit is a plus Data Warehouse experience a plus
Associated topics: data administrator, data analyst, data analytic, data engineer, data integrity, data management, data scientist, erp, mongo database, sql * The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

Launch your career - Create your profile now!

Create your Profile

Loading some great jobs for you...