JobWatch

1+ months

Sr. Database Administrator

WIRB-Copernicus Group (WCG)
Hamilton, NJ 08609

General Information

Location: Hamilton, NJ

Organization: WIRB-Copernicus Group Inc

Job Type: Full Time - Regular

Description and Requirements

We are looking to hire a Sr. Database Administrator to join our team.  In this role, you will be responsible for building and supporting SQL Server database management systems across the company while recommending and implementing standard concepts, practices, and procedures for our application systems. In addition to possessing the requisite technical skills, the preferred candidate will have a track record of demonstrating initiative, teamwork and a can-do attitude. Within the scope of this position, contributes to the companys overall mission to protect the rights and welfare of human subjects involved in clinical research.


Educational 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:

7+ consecutive years of experience in the SQL Server DBA role

  • Expert hands-on experience with Microsoft SQL Server 2005 through 2017

  • Knowledge of Azure SQL, Streaming Analytics, or other Azure data services preferred

  • SQL Server enterprise level experience with 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

  • 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

  • Centralized DB instance management

  • Oracle and Open Source database technologies a plus 

Experience in the following concepts:

  • PowerShell administration automation of SQL Server

  • Azure or other cloud database offerings

  • Experience supporting ITSM regarding change, incident, and request policies and procedures

  • Excellent communication, documentation, and organizational skills

  • Self-starter and proactive 

Essential Duties / Responsibilities: 

  • Install and maintain the DBMS server operating systems as well as all supporting software.

  • Recommend short- and long-term strategic plans to make certain database infrastructure meets existing and future requirements. Ideally covering Microsoft SQL, Oracle, and Open Source technologies.

  • Propose backup and recovery processes and procedures as well as Disaster Recovery designs and solutions for databases as required.

  • Define and propose policies, procedures, and associated maintenance plans for DBMS resource administration and appropriate use.

  • Maintain DBMS accounts, groups, permissions, etc. as necessary.

  • Follow database best practices and solutions support existing database systems and support development efforts.

  • Manage and tune SQL Server DBMS across technologies and environments.

  • Troubleshoot database-related issues as necessary.

  • Recommend tools and practices to enhance performance and insights.

  • Create documentation to supplement organization's knowledge, increase consistency, and facilitate ongoing management.

  • Tune database code, reporting, store procedures, and relevant scripts prior to implementation.

  • Educate other DBAs and developers on database best practices on all aspects of database management.

  • Planning maintenance activities and implementing during defined windows.

  • Develop on call rotation and off hours support as needed to support business needs.

Categories

Posted: 2020-08-18 Expires: 2020-10-22

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Sr. Database Administrator

WIRB-Copernicus Group (WCG)
Hamilton, NJ 08609

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast