SSIS MS SQL Stored Procedures Triggers Data Import And Monitoring TroubleShooting S   Requirement id 100768 Job title DBA Job location in Chicago, IL Skills required SQL DBA, SSIS, SQL Development, MS SQL Stored Procedures Triggers Data I Open Date 02-Dec-2019 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description DBA: SQL DBA, SSIS, SQL Development, MS SQL Stored Procedures Triggers Data I Responsibilities DBA I (SQL, SSIS, Visual Studio) Comments for Suppliers: Urgent request 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 on capacity. The ability to work in an agile team environment is critical. Mandatory: • 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: • 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 Languages Must have English Native or bilingual proficiency   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 100768 while calling.   Other jobs in IL: Chicago (77), Deerfield (7), Des Plaines (2), Downers Grove (7), Downtown Chicago (5), DT Chicago (2), Elk Grove (3), Elk Grove Village (24), Elkgrove Village (1), Evanston (1), Lake Forest (1), Lincolnshire (4), Northbrook (3), Oak Brook (5), Oakbrook (1), Oakbrook Terrace (5), Round Lake (3), Schaumburg (4), South Barrington (1), Springfield (2), Vernon Hills (6), Warrenville (7),    SQL DBA job openings in other states Jobs List APIGEE Architect - J-11-479-983 Create date: 14-Apr-2020 This requirement is critical. Please share profiles on priority. This candidate must work on Vendors W2. APIGEE Architect - M/F, ODBA, SQL DBA, M/F DBA, App Support, Incident Management, etc Mandatory Skills: .... (This job is for - job Jobs in TX Dallas Architect - (in Dallas, TX)) SQL DBA - 3487 Create date: 18-Feb-2020 Note: * Please be advised responses are due no later than 3/1/20. Responsibilities Are you a tech & IT geek? We have a 24-month project with our client in New York, NY that requires a SQL DBA, Expert Guides consultants and their projects Day-to-Day Tasks include, but not limited to: .... (This job is for - job Jobs in NY NewYork Administrator - (in New York, NY)) SQL DBA - 59581 Create date: 17-Feb-2020 Job Description : It combines with parent company On Assignment to make it the 2nd largest IT staffing agency in the country. It has an opportunity for a SQL Server Database Administrator for a Major Healthcare Client in Basking Ridge, NJ. Here are the details: Position: Working on the ope.... (This job is for - Troubleshooting Jobs in MN EdenPrairie DBA - (in EDEN PRAIRIE, MN)) Database Administrator - 54951 Create date: 30-Oct-2019 Candidate must be our W2 Employee We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens Notes : NO Sub vending, Skype/WebEx Interview for non locals Description : The resource in this position will handle database administration for mission critical database servers with a .... (This job is for - MS SQL Server SSIS Jobs in AL Montgomery Administrator - (in MONTGOMERY, AL)) Senior Lead SQL DBA Create date: 27-Sep-2019 Description: I have an immediate need for a senior Lead SQL DBA for a long term contract here in Orange County, CA. The ideal candidate MUST have recent experience leading a SQL Server Database Upgrade / Migration to SQL 2016. Candidate must have excellent communication and analytical / troubleshooting skills. The candidate must also be.... (This job is for - job Jobs in CA OrangeCounty Consultant - (in Orange County, CA))     (DBA: SQL DBA, SSIS, SQL Development, MS SQL Stored Procedures Triggers Data I in Chicago, IL)

Featured Jobs DHCP LANWAN Analyst (Jobs in Atlanta, Georgia) JavaScript Communication Analyst (Jobs in Richmond, Virginia) Agile SCRUM Manager (Jobs in Madison, Wisconsin) Cisco LAN Manager (Jobs in Stafford, Virginia) Dataverse SQL Developer (Jobs in Raleigh, North Carolina) Data Developer (Jobs in Durham, North Carolina) SOAP JavaScript JSON SQL Administrator (Jobs in Salem, Oregon) MicrosoftOffice Consultant (Jobs in Golden, Colorado) GIT Automation Ansible Engineer (Jobs in Raleigh, North Carolina) SCRUM Azure Analyst (Jobs in Lansing, Michigan)