• SQL Server Database Administrator

    Posted Date 3 weeks ago(11/28/2018 4:39 PM)
    Location
    US-NY-New York
    Category
    Information Technology
    Experience Level
    Staff
    Shift (Days/Times)
    M-F 9am-6pm
  • Overview

    Join our team as an SQL-Server Database Administrator, and provide high-level knowledge, planning and implementation.

     

    We fully utilize our on-prem SQL Server technologies and we are now pushing out with the Azure part of our infrastructure. We are looking for a DBA with the right kind of enterprising mindset, a passion for infrastructure, learning and automation: a problem solver who enjoys a challenge. Who is detail oriented, great at maintaining system documentation, and make smart recommendations for database design.

     

    Bring your familiarity with the latest SQL Server features, storage solutions, client server and n-tier systems, and Windows Server administration and Windows Active Directory. Channel your stellar communication skills with both technical and non-technical audiences and thrive in a team-driven culture.

    Responsibilities

    • Check and triage database maintenance job failures (ie. backup, DBCC), develop and deploy standard maintenance jobs for all databases, and actively monitor database health and performance. You’ll perform tuning, backups, application testing and diagnostics.
    • Write and maintain SQL queries, administer SQL Reporting Services, run diagnostics and build new SQL clusters for optimal throughput.
    • Support database servers and terabytes of mission-critical data.
    • Assume responsibility for enterprise class systems support, with a key focus on day-to-day operations of SQL Servers (on-prem and in a cloud).
    • Support uptime of our servers: troubleshoot issues that may arise e.g. excessive CPU usage, mirroring latency, unexpected log growth. Experience in troubleshooting availability groups is very valuable. Some of this may require responding out of hours.
    • Maintenance: We will always be dealing with patching, space issues, query issues etc. We try to automate away as much as we can with PowerShell and tooling.

    Qualifications

    • At Least 5 Years of experience and knowledge of:
      • Databases and Infrastructure
      • Relational Schemas
      • Automation; PowerShell is a plus
      • ETL, SSIS and SSRS
      • T-SQL, Stored Procedures
      • MCITP or MCSE Certification is a huge plus

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed