Looking for SQL Server Application DBA

Company: DATAECONOMY
Location: Chicago, Illinois, United States
Type: Full-time
Posted: 29.NOV.2019

Summary

Job Title: SQL Server Application DBA Location: Chicago, IL Duration: 6+ Months Job Description: This is a SQL Server Application DBA ro...

Description

Job Title: SQL Server Application DBA

Location: Chicago, IL

Duration: 6+ Months

Job Description:

This is a SQL Server Application DBA role responsible for providing database services and development services to the organization. Some of the primary responsibilities of this role include developing database solutions, ensuring that new database code meets team standards for readability, reliability, and performance. Experience designing indexes for applications, choosing when to add or remove indexes is required.
Experience writing stored procedures, functions, views, triggers, and T-SQL. Ability to write batch scripts, SSIS packages and ETL jobs is required. The application DBA will need to come up with strategic solutions to database related application issues and managing database projects using tools such as Visual Studio.
The Application DBA role requires a service oriented mentality, high sense of ownership of the problems and requests assigned. The ability to work on multiple application development projects serving in a hands capacity. The ability to work in an agile team environment is critical.
Position Requirements:
We are looking for a person who:
Has 5+ years of experience in database development and support in MS SQL Server environments.
SQL Development ability to write and troubleshoot complex SQL code
Experience writing SSIS packages.
Experience designing stored procedures, functions, tables, views, triggers, indexes, constraints
Strong knowledge of normalization, primary and foreign key constraints
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues etc.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
Knowledge of SQL Server tools ( Profiler, SSIS, SSMS, PerfMon, DMVs)
Experience working with JSON and XML
Documentation skills for processes and procedures (creating KBs, whitepapers, topology diagrams)

Preferred candidates would also meet the following criteria:

Experience working with Visual Studio Database Projects desired
Experience working in a Windows Azure Environment
Knowledge of both Azure SQL Database as well as IAAS SQL Servers are desired
Experience working in a development scrum team desired.
Knowledge of Powershell Scripting
Documentation skills for processes and procedures
Experience working with sensitive data such as PHI, HIPPA or PCI
Experience understanding the healthcare/HL7 data

Company Overview for DataEconomy:
"DATA ENGINEERS ARE THE NEW DOCTORS, DATAECONOMY IS BORN TO BUILD THE SCALE, JOIN THE FUTURE"
We are a rapidly growing team of passionate DataCrats who have been living and breathing Data & Analytics in our work endeavors serving fortune 500 companies for the last 2+ decades. Our Genesis stems from the fact that there is so much untapped potential regarding Technology, people and bringing in machine and humans together. We are industry experts who have been providing thought leadership for the Fortune 100 companies to define their Data & Analytics strategies, how they can use the ecosystem approach, leverage multitude of technologies to solve real-world problems. As our Name DATAECONOMY sounds, we are here to commoditize the Niche & create scale in the areas of Data & Analytics, AI, Blockchain and Cloud. We are specialized in creating IP in the cutting edge technologies such as AI, machine learning, Block Chain, etc., and applying that IP to help mid to large sized organizations to monetize the data.

Please reach out to Suman Gurram at / Mail ur cv at
- provided by Dice

 
Apply Now

Share

Free eBook

Flash-bkgn
Loader2 Processing ...