Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

SQL DBA Il-Fulltime Role

Expired Job

Humanoko Inc. Chicago , IL 60604

Posted 3 months ago

Title: SQL DBAs
Location: Chicago, IL
Duration: full time role
Interview : 2 phone interviews, 1 onsite interview
Salary: /annum + 10% bonus + benefits
SUMMARY
The SQL DBA is responsible for the deployment, administration, and maintenance of all databases hosted on the Microsoft SQL Server platform. This person will work as a member of the company wide database administration team which provides advanced Level 3 support for the SQL Server environment. They will investigate operational or systematic problems, provide resolution using advanced analytical skills and tools as necessary as well as be responsible for analyzing database performance issues, recommending tuning changes to improve performance. They will assist various project team(s) in completing project(s) with an advanced level of complexity.
RESPONSIBILITIES
Support, administer, and maintain development, test, and production environments.
Work with project teams comprised of project managers, developers, application vendors, application engineers, and application users to provide DBA support for database deployments and upgrades.
Create and maintain SQL Server Integration Services (SSIS) packages.
Review, deploy, and administer security for SQL Server Reporting Services (SSRS) reports.
Troubleshoot server and database performance problems and identify solutions to resolve the problems.
Administer SQL Server security and protect sensitive data.
Adhere to the Companys IT Service Delivery standards and Change Control processes.
Adhere to the Companys Security and Governance requirements across all administered applications.
Develop and maintain troubleshooting, configuration, and integration documentation for administered systems.
Function as a primary or backup DBA for assigned applications. Have a working knowledge of all database applications.
Work with server engineers, storage engineers, and network engineers to resolve issues and prevent downtime.
Provide 24x7 operational support. On-call support responsibilities are rotated among the members of the DBA team.

REQUIREMENTS

The SQL DBA must have a BA/BS in computer science, related field, or equivalent experience with 5+ years' experience of Microsoft SQL Server Administration.
The ideal candidate must have good judgment, problem-solving, oral, written and interpersonal communication skills, as well as the ability to work in a fast-paced environment and build positive working relationships. In addition, candidates must be self-motivated, organized, and able to multi-task and effectively prioritize competing demands.
Database administration experience with SQL Server 2008 R2, 2012, 2014 and 2016.
Proficiency with Transact-SQL including the ability to write, debug, and maintain scripts, stored procedures, functions, and views.
Experience configuring and maintaining replication, log shipping, and database mirroring.
Experience installing and configuring SQL Server on virtual machines and stand-alone servers.
Experience developing SSIS packages.
Experience optimizing and administering SSRS reports.
A solid understanding of normalized database design and modeling.
Nice to Haves
A working knowledge of Idera, RedGate, and SentryOne database tools.
Proficiency with PowerShell scripting.
Experience with SSRS report development.
Experience with setup and administration of Always On availability groups.
Experience installing and configuring SQL Server on fail-over clusters.
Core Technologies:
Microsoft SQL Server (Enterprise, Standard, & Express editions)
Database Engine, Integration Services, Reporting Services
Replication, Log Shipping, & Database Mirroring
Transact-SQL
Microsoft Windows Server (Enterprise & Standard editions)
Microsoft Fail-over Clustering
SAN Storage
Third-party SQL Server Tools & Utilities
Microsoft Office (including Visio)
Structured Programming or Scripting (e.g. PowerShell, VBScript)
Visual Source Safe
FTP & sFTP
Tech stack:
SQL Server 2008 R2, 2012, 2014, & 2016
SQL Server Integration Services 2008 R2 & 2016
SQL Server Reporting Services (SSRS) 2012
Transactional & Merge Replication
Synchronous & Asynchronous Database Mirroring
Transact-SQL scripts, stored procedures, functions, & views
Windows Server 2012 R2 & 2016
Server Virtualization Solutions such as Hyper-V & VMWare
Idera Diagnostic Manager & Admin Toolset
RedGate SQL Monitor, SQL Compare, & SQL Data Compare
SentryOne SQL Sentry
CozyRoc SSIS+
Microsoft Office 2016
Microsoft Outlook 2016
PowerShell 4.0
Thanks,
Anil saini
Direct No.:
Landline No.: Extn. 106
Email ID:
Web Address:

Skills:
SQL Adminstration,SQL Server Integration Services (SSIS) packages,SQL Server Reporting Services (SSRS) reports.
Permanent
fulltime role


See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
SQL Server DBA

Xperton

Posted 6 days ago

VIEW JOBS 12/6/2018 12:00:00 AM 2019-03-06T00:00 <p>Xperton LLC is in search of a hands-on SQL Server DBA Consultant for 6+ month project in Downtown Chicago.</p> <p><br></p><p><strong>Requirements</strong></p><ul><li>5+ Experience of administering and supporting SQL Server databases including:<ul> <li>Database backup and recovery;</li> <li>Database mirroring and Log Shipping;</li> <li>Database Replication;</li> <li>Database AG Availability Groups;</li> <li>Allocating database and box resources;</li> <li>Proactive monitoring and support;</li> <li>Query and Systems Performance tuning;</li> <li>SQL Server migration\upgrade</li> <li>Data center migration.</li> </ul> </li></ul><p><strong>Skills and Knowledge:</strong></p><ul> <li>Strong hands-on Microsoft SQL Server 2008 - 2016 skills.</li> <li>Experience with Microsoft SSIS, SSRS and SSAS.</li> <li>Strong verbal and written communication skills.</li> </ul><p><strong>Education:</strong></p><ul><li>Bachelor’s degree or equivalent experience.</li></ul><p><br></p><p><strong>Benefits</strong></p><p>Hourly Market Rate</p> Xperton Chicago IL

SQL DBA Il-Fulltime Role

Expired Job

Humanoko Inc.