Senior Project Manager iPipeline, Inc.
Senior SQL Database Administrator
This position is based in Exton or Philadelphia, Pennsylvania.
This is a MS 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 (e.g: 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 rest of Database team to come up with strategic solutions to recurring problems.
This role requires a high level of service orientation and a high sense of ownership of the problems and requests assigned. Other responsibilities include managing and resolving issues in alignment with the SLAs, establishing and maintaining communication with other internal technology groups to keep them updated with status of their requests, initiating and performing changes on production/test systems and proactively escalating any issues that cannot be resolved within the established timeframes.
The position will require off-hours on-call support.
A minimum of 3 years of experience as Database Administration for MSSQL Server.
Working knowledge of SQL 2008 R2 and SQL 2012.
Experience in troubleshooting and resolving database problems.
Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
Experience with backups, restores and recovery models.
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
Experience in implementing operational automation using scripts.
Knowledge of indexes, index management, and statistics.
Experience working with Windows server, including Active Directory and proper disk configurations.
Good communication and documentation skills.
Ability to improve/troubleshoot TSQL code.
Strong SSRS and Report Writing skills.
ADDITIONAL DESIRED SKILLS:
Experience with PowerShell
Visual Studio/Team Foundation Server
Working knowledge of 3rd party tools such as Idera/RedGate.
Familiarity with Enterprise versions of SQL server and the added functionality that comes with it.
Implementing AlwaysON DR solution
Any experience with MongoDB/MySQL/DB2 would be a plus.
||Exton, PA |