This Job Vacancy has Expired!

Senior SQL DBA

Request Technology - Craig Johnson

Posted on Oct 19, 2022 by Request Technology - Craig Johnson

Chicago, IL 60601
IT
Immediate Start
Annual Salary
Full-Time

*We are unable to sponsor for this permanent Full time role*

*Position is bonus eligible*

Prestigious Global Firm is currently seeking a Senior SQL Database Administrator. Candidate 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 firm wide database administration team which provides advanced Level 3 support for the SQL Server environment.

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 and/or Talend jobs.
  • 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 Firm's IT Service Delivery standards and Change Control processes.
  • Adhere to the Firm's 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.

Qualifications:

  • The Senior Database Administrator I 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 2014, 2016, 2017, and 2019.
  • Proficiency with Transact-SQL including the ability to write, debug, and maintain scripts, stored procedures, functions, and views.
  • Experience configuring and maintaining AlwaysOn Availability Groups, 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 modelling.

Preferred Skills:

  • Working knowledge of SolarWinds, RedGate, and Idera database tools.
  • Proficiency with PowerShell Scripting.
  • Experience with SSRS report development.
  • Experience with PostgreSQL
  • Experience with Talend Data Fabric

Technologies:

  • Microsoft SQL Server (Enterprise, Standard, & Express editions)
  • Database Engine, Integration Services, Reporting Services
  • AlwaysOn Availability Groups, Replication, Log Shipping, & Database Mirroring
  • Transact-SQL
  • Microsoft Windows Server (Enterprise & Standard editions)
  • SAN Storage
  • Third-party SQL Server Tools & Utilities
  • Microsoft Office (including Visio)
  • Structured Programming or Scripting (eg PowerShell)
  • Team Foundation Studio
  • FTP & sFTP
  • Talend Data Fabric
  • SQL Server 2014, 2016, 2017 & 2019
  • SQL Server Integration Services 2016 & 2017
  • SQL Server Reporting Services (SSRS) 2019
  • SQL Server AlwaysOn 2014, 2016, 2017 & 2019
  • Transactional & Merge Replication
  • Synchronous & Asynchronous Database Mirroring
  • Transact-SQL scripts, stored procedures, functions, & views
  • Windows Server 2016 & 2019
  • Server Virtualization Solutions such as Hyper-V & VMWare
  • SolarWinds SQL Sentry
  • Idera Admin Toolset
  • RedGate SQL Monitor, SQL Compare, & SQL Data Compare
  • CozyRoc SSIS+
  • Microsoft Office 365
  • PowerShell

Reference: 1765363332

Set up alerts to get notified of new vacancies.

Similar Jobs

Senior SQL DBA

Chicago, IL

Annual Salary