SQL DBA
About IPsoft
IPsoft automates IT and business processes for enterprises across a wide range of industries. Through our portfolio of world leading autonomic and cognitive solutions we provide services that deliver clear outcomes and allow our clients to secure competitive advantage. Headquartered in New York City, IPsoft has offices in 13 countries across the world and serves more than 500 of the world’s leading brands directly as well as more than half of the largest global IT services providers.
The MSSQL Database Administrator (DBA) is responsible for providing database technical support for ALL client databases in multi-environment (production to non-production).
As part of operations support, DBA is expected to work in 24x7 support model.
It is extremely important to understand and be aligned to the ITIL process while delivering the Operational support service to our client.
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 database engineering to come up with strategic solutions to recurring problems.
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 keepthem updated with status of their requests, initiating and performing changes on production systems and proactively escalating any issues that cannot be resolved within the established timeframes.
- BE or Master Degree in one of the following subject areas: Computer Science, Information Technology or related field preferred
- 4-7 years of MS SQLServer DBA experience in operational support environment
- Strong experience in Database Administration in SQL Server ( 2005 - 2008 )
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
- Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
- Ability to detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention.
- Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
- Expert experience in implementing operational automation.
- Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
- Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
- SQL Development - ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
- Solid acquaintance with windows server, security delegation, SPNs, storage components.
- Good understanding of the organizations goals and objectives
- Good interpersonal, written, and oral communication skills
- Good Technical documentation skill to produce the SOP - Standard Operating Procedure
- Self motivated and directed, with keen attention to detail
- Able to prioritize and execute tasks in a high-pressure environment
- Experience working in a team-oriented, collaborative environment
- Good communication skills to efficiently handle client interactions
- Competitive Base Salary
- Medical Insurance, Dental Insurance and Vision Care
- Life Insurance
- Short Term and Long Term Disability Insurance
- 401(k) Plan
- Flexible Spending Accounts: Health Care, Dependent Care, Transit
- Paid time off