EY Advanced Technical Specialist – SQL DBA_Sr Associate in Kerala, India

Title: Advanced Technical Specialist – SQL DBA_Sr Associate

Location: IN-Kerala-Kochi

Job Number: IND009HD

Advanced Technical Specialist

The MS SQL Specialist – Senior Associate is a position with a minimum of 5 years of MS SQL DBA experience.

The candidate is experienced in all aspects of database administration supporting production databases.

Candidate is accustomed to working and handling day to day operations of fast-paced complex distributed database environments supporting primarily OLTP databases

The candidate strives for very low defect/incident rate and meets all change requests within SLA. Candidate is willing to provide on-call support and may have to work in shifts, weekends.

This role will serve as first level of support for the enterprise MS SQL database environment. This includes all aspects of database management, including building and deploying MS SQL database systems, evaluating performance requirements, performing performance reports and forecasts.

Qualifications:

Experience/Skill requirements:

  • Demonstrable knowledge of Windows 2008/2012 server O/S

  • Demonstrable intermediate to advanced experience with MS SQL 2005/2008/2012

  • Demonstrable experience administering clustered, consolidated or shared clustered SQL servers

  • Strong skills in configuring and administering SQL Server Replication and DR solutions

  • Demonstrable intermediated to advanced knowledge in configuring and administering SSAS/SSRS/SSIS

  • Strong working knowledge of SQL best practices (e.g. schema management, index optimization, etc.)

  • Experience in support of business intelligence solutions/applications or experience in managing large data warehouse environments

  • Strong query, performance diagnosis (i.e. SQL Profiler), and database tuning skills

  • Understanding of n-Tier application environments in complex or enterprise level environments

  • PLSQL, SQL skills added benefits

  • Experience in managing SQL on VMs is a plus

  • Ability to manage multiple tasks with shifting priorities

  • Ability to build and maintain strong working relationships with other DBAs and application teams

  • Strong communication skills is must

  • Strong understanding of ITIL principles desirable

Additional knowledge and skills requirements:

  • Ability to develop and communicate technical concepts.

  • Strong knowledge of computers, network, and software roadmaps.

  • Demonstrated problem investigation and resolution skills.

  • Understanding of Project management concepts.

  • Experience with data warehousing and operational data stores.

Analytical/Decision making responsibilities:

  • Support key escalation and resolution point.

  • Selects appropriately from applicable standards, methods, tools and applications and use accordingly.

  • Ability to work well within a multi-disciplinary team structure, but also independently

  • Ability to work with 3rd party vendors (i.e. Microsoft) for escalation of issues

  • Ability to manage multiple tasks with shifting priorities

  • Ability to build and maintain strong working relationships with other DBAs and application teams

  • Demonstrates analytical and systematic approach to problem solving.

  • Communicates fluently orally and in writing and can present complex technical information to both technical and non-technical audiences.

  • Is able to plan, schedule and monitor work activities in order to meet time and quality targets.

  • Is able to absorb rapidly new technical information, business acumen, and apply it effectively.

  • Good appreciation of wider field of information systems, its use in relevant employment areas and how it relates to the business activities of the employer or client.

  • Support and to an extent be responsible for troubleshooting and complex analysis of metrics, data, and key performance indicators (KPI) for the purpose of making decisions around capacity and processes

Other Requirements:

  • Participate in a fixed shift pattern including Saturday & Sunday/on-call rotation/weekends

  • Shift 1 APAC : Thursday to Monday 6 AM till 3 PM IST

  • Shift 2 EMEIA: Thursday to Monday 2 PM till 11 PM IST

  • Flexibility in scheduling with a willingness to work extra non-standard hours on occasion

  • Ability to work well within a multi-disciplinary, multi-cultural team structure, but also independently

  • Strong interpersonal and verbal and written communication skills

  • Ability to meet agreed deadlines, with demonstrable productivity

Education/Suggested technical certification:

  • Bachelor’s Degree or equivalent work experience

  • 5-7 years of relevant work experience (Level 3 Support)

  • ITIL Foundation Certification in IT Service Management preferred

  • Microsoft Certified Database Administrator for 2008 or later