Database Administrator

MedAvante   •  

Hamilton Township, NJ

5 - 7 years

Posted 237 days ago

This job is no longer available.

Our Database Administrator is responsible for designing, building and supporting SQL Server database management systems across the company through familiarity with standard concepts, practices, and procedures. In addition to possessing the requisite technical skills, the preferred candidate will have a track record of demonstrating initiative, team work and a ‘can-do’ attitude.  Within the scope of this position, contributes to the company’s overall mission to protect the rights and welfare of human subjects involved in clinical research. 
 
 ESSENTIAL DUTIES/RESPONSIBILITIES: 

  • Install and maintain the DBMS server operating systems as well as all supporting software
  • Implement short- and long-term strategic plans to make certain infrastructure capacity meets existing and future requirements
  • Implement and maintain policies, procedures, and associated plans for DBMS resource administration and appropriate use
  • Conduct research and make recommendations on DBMS products, services, protocols, and standards in support of network procurement and development efforts
  • Design, implement, manage, and tune SQL Server DBMS
  • Create documentation to supplement organization's knowledge, increase consistency, and facilitate ongoing management
  • Act as gatekeeper to ensure that promoted code changes do not compromise data integrity or degrade performance
  • Educate developers on database coding best practices and team members on all aspects of database management

 
 
EDUCATION REQUIREMENTS:

  • Bachelor's degree or equivalent from four-year college in computer science or related field or 5 years of equivalent industry experience

 
CERTIFICATIONS:

  • MCSA in SQL Server Administration preferred

 
QUALIFICATIONS/EXPERIENCE:

  • 5+ years of experience in the SQL Server DBA role
  • Hands-on experience with Microsoft SQL Server 2005 through 2016,
  • SQL Server enterprise levelexperiencewith the following features:
    • SSIS, SSAS, and SSRS administration
    • Failover Clustering (Always On: FCI & AG) design and configuration
    • Data replication solutions (i.e. Log Shipping and SQL Replication) configuration
    • Applying data compression on tables and indexes
    • Troubleshooting performance with SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor
  • Expert knowledge of the following concepts:
    • T-SQL administrative scripting
    • Analyzing Dynamic Management Views for monitoring database health
    • Creating SQL Server maintenance plans and/or custom maintenance scripts
    • Database stored procedure, trigger, and index creation and tuning
  • Microsoft Active Directory authentication and authorization
  • Windows Server 2003-2016 operation
  • Preferredexperiencein the following concepts:
    • PowerShell administration automation of SQL Server
    • Azure or other cloud database offerings
  • Experience in ITSM regarding change, incident, and request policies and procedures