Principal SQL Database Administrator

Principal SQL Database Administrator

Job ID: 2013-18628
# of Positions: 1
Posted Date: 9/24/2013
Job Location: US-NY-New York
Position Type: Regular Full Time
Category: Information Technology

Overview

Pearson has one defining goal: to help people progress in their lives through learning. We champion innovation and we invest in models for education that deliver on our promise for effective, accessible, and personal learning from early literacy, college and career readiness to professional education, through data informed instruction and inventive applications for mobile and digital learning.

Pearson, the world's leading learning company, has global-reach and market leading businesses in education, business, and consumer publishing and is listed on the London and New York stock exchanges (UK: PSON; NYSE: PSO). For more information, visit www.pearson.com.

Schoolnet, Inc., a division of Pearson, is the leading provider of data-driven K12 education software that increases student achievement, teacher quality and operational efficiency. Our award-winning suite of data-driven education software is the only unified solution to align student assessment, curriculum and instruction; guide collaborative, data-informed discussion; and enable targeted instruction for every student. Our solutions are used successfully by many of the nation's largest school districts including Chicago Public Schools and the School District of Philadelphia. Schoolnet is recognized by Inc. Magazine's Top 500 List, Deloitte's Fast 50 as one of the fastest growing private companies, and is the recipient of several CODiE Awards.

Pearson is an Equal Opportunity Employer M/F/V/D, and a member of E-Verify.

We are seeking a SQL Server DBA role largely responsible for providing operational database services to the organization. Some of the primary responsibilities of this role would include owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs, reviewing service related reports (eg: database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs, responding to database related alerts and escalations and working with database engineering to come up with strategic solutions to recurring problems. Some 24x7 On-Call support as Database Subject Matter Expert is required.

Responsibilities

This MS SQL Server DBA role requires a service oriented mentality, high sense of ownership of the problems and requests assigned, focus on managing and resolving issues in alignment with the SLAs, establishing and maintaining communication with technology customers to keep them updated with status of their requests, initiating and performing changes on production systems and proactively escalating any issues that cannot be resolved withinthe established timeframes.

Qualifications
- Bachelor's Degree in Computer Science, MIS or equivalent work experience required
- Minimum 3 years SQL Server DBA experience required (5+ years preferred)
- Strong experience in managing and maintaining SQL Server 2008R2 database environments
- Strong understanding of backup and recovery plans, re-index operations, update statistics, and other system commands/objects such as DBCC and DMVs
- Strong experience in clustered SQL environments
- Experience building, maintaining and patching SQL Server stand-alone and clustered environments
- Experience setting up Disaster Recovery environments including log shipping and database mirroring technologies
- Experience with database migration between various environments (production, QA, staging)
- Experience in troubleshooting and resolving database issues such as connectivity, security, and other related system issues such as CPU, memory, I/O, disk space and other resource contention
- Experience in Performance Tuning, Query Optimization, Blocking and deadlocking analysis, as well as familiarity using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
- Solid experience automating operational tasks with Powershell
- Strong knowledge of SQL database development: tables, indexes, views, stored procedures, triggers, constraints, etc.
- Definition and Documentation of Standards/Processes
- Experience providing SQL Database Operational support to various teams (development, QA, etc.)
- Microsoft certifications a plus
- Experience with SQL Server BI components such as Analysis Services, Reporting Services, and Integration Services a plus
- Solid acquaintance with windows server, security, and storage components a plus

#LI-BF