Sr. SQL Server DBA

  • JLA,
  • Princeton, NJ
  • 1 day ago
SQL Server, Database Administrator
Contract W2, Contract Independent, Contract Corp-To-Corp, 6 Months
Depends on Experience
Work from home not available Travel not required

Job Description

The SQL Server Database Administrator implements, supports and maintains SQL Server database software, and ensures its performance, availability, and security across a large enterprise. He/she provides input to architecture and data center teams on infrastructure design standards for SQL server and reviews architecture and project deliverables to ensure that proposed solutions meet or exceed established standards. He/she provides outstanding customer service to both internal and external customers in a very large 24x7 highly available environment. The DBA is responsible for providing input to and guiding other SQL resources in regard to SQL standards and best practices

Role Specific

  • Install and patch SQL Server software for standalone and clustered configurations.
  • Configure SQL Server installations to meet defined best practices.
  • Monitor and remediate issues with SQL Server maintenance jobs to include backups, DBCC and reindexing.
  • Perform SQL Server database migrations for hardware refreshes and SQL upgrades.
  • Manage SQL Clusters with primary focus on SQL 2012 and 2014 running on Windows 2012.
  • Troubleshoot database and instance performance problems.
  • Troubleshoot issues with SQL Server high availability solutions to include Windows Failover Clusters and SQL Server AlwaysOn.
  • Review and provide feedback on scheduled SQL Server database changes.
  • Implement and maintain database security according to Deloitte security provisions.
  • Proactively monitor database systems to ensure minimum downtime.
  • Participate in database tuning to include add/drop/change indexes based on vendor and developer input.
  • Review SQL Server instances for compliance with documented best practices.
  • Provide excellent customer service for incident and service request tickets.
  • Work with the team to ensure that the associated hardware resources allocated to the databases are adequate and to ensure high availability and optimum performance.
  • React and resolve all database related warning and alarms from database monitoring system.
  • Provide database backup and recovery operation according to given strategy.
  • Review and analyze critical (security) patch information sent by Microsoft.
  • Manage database storage and capacity planning for internal objects and database files.
  • Escalate and manage problems to resolution through Microsoft Support, SQL Development Team and/or third parties as appropriate.
  • Provide 24x7 on call support as scheduled.

Knowledge Sharing / Documentation

  • Document SQL standards and team processes/procedures as needed

Required Education, Qualifications, and Experience Settings :

Technical Skills

  • 5+ years of experience in general database administration in a large MS SQL Server environment
  • General knowledge of infrastructure technologies and how they relate to SQL performance (storage model/design, Windows OS, Hyper-V, clustering, etc.)
  • Experience in SQL database engine infrastructure and support, version 2012 and higher
  • Operational support knowledge of SQL Server on Windows 2012 failover clusters
  • Ability to write and troubleshoot SQL Server automation scripts (backups, indexing, migrations, etc.)
  • Ability to troubleshoot and resolve database performance issues, blocking and deadlocking issues, connectivity issues, security issues etc.
  • Ability to detect and troubleshoot SQL Server related CPU, Memory, I/O, disk space and other resource contention
  • Expert knowledge of SQL installation, configuration and patching on standalone server, Windows failover cluster and SQL AlwaysOn cluster.
  • Expert knowledge of backups, restores, recovery models and backup strategy design and implementation.
  • Expert knowledge of SQL Server best practices as defined by Microsoft and generally accepted in the DBA community
  • Documentation skills for processes and procedures (creating KBs, work instructions, standards definitions, etc.)
  • Knowledge of 3rd party monitoring tools and applications (Idera, SCOM)
  • Knowledge in a scripting language like PowerShell, VBScript, WSH
  • Some level of understanding of AD and AD security principles

Other Attributes

  • Attention to detail
  • Strong customer focus
  • High level of awareness of the importance of Information Security and the associated policies, processes and activities undertaken within DTS. Awareness of Privacy principles and Safe Harbor provisions.

Understands technology and technical concepts; Produces written materials with a consistent approach and tone; Communicates effectively with stakeholders and project team members regarding technical concepts.

Preferred Education, Qualifications, and Experience Settings :

  • DBA Certification in SQL Server 2012 or above - preferred

Posted By

Jayson Amoroso

Contact
Dice Id : 90796024
Position Id : 6243951
Originally Posted : 2 months ago
Have a Job? Post it

Similar Positions

DBA - Database Administrator
  • NewWay Recruiting
  • Princeton, NJ
SQL Server DBA SQL Server 2016
  • Perennial Resources International
  • Holmdel, NJ
Junior SQL DBA
  • The Judge Group, Inc.
  • Philadelphia, PA
SQL DBA
  • Kforce Technology Staffing
  • Morrisville, PA
Global Database Technology Lead
  • Johnson & Johnson
  • Raritan, NJ
My SQL DBA/ Python Engineer
  • NetSource, Inc.
  • Edison, NJ
Sr.SQL Server DBA
  • Chenoa Information Services
  • Holmdel, NJ
IBM DB2 LUW / UDB DBA
  • Chenoa Information Services
  • Holmdel, NJ
IDMS DBA
  • DISYS - Digital Intelligence Systems, LLC
  • Princeton, NJ
Database Administrator
  • Matlen Silver
  • Pennington, NJ
Oracle DBA with Argus
  • Yochana IT Solutions
  • Rahway, NJ
IBM DB2 LUW/UDB DBA
  • Software Guidance & Assistance
  • Holmdel, NJ
IBM DB2 / UDB DBA
  • Alpha Technologies Inc
  • Holmdel, NJ