SQL DBA

     TASKS, DUTIES & RESPONSIBILITIES  

• Support Areas
  • Database Administrative support of SQL Server versions 2008 – 2016: Monitoring, maintenance and housekeeping of SQL Server and Databases, SQL Jobs, User Access management and regular client requests. Writing and tuning SQL codes and highly customized jobs.
  • Infrastructure support of SQL Server versions 2008 – 2014: server/instance installs (stand-alone and clustered), service-pack upgrades, hot fixes, client tool installs, readiness programs, new feature exploitation, research and development.
  • BI support of SSIS and SSRS: Deployment, Security, performance tuning, Creating and enforcing Standards & best practices, automate repetitive tasks, designing, troubleshoot and diagnose issues with SSIS, SSRS.
• Support of application and upgrade database (Database Migration/ upgrade) from existing SQL versions to latest SQL Server versions.
• Incident Management: Knowledge of Incident management process and participation in a rotational on-call schedule to support off hours production incidents
• Occasional participation in after-hours and weekend support of production implementations, infrastructure activities, and various disaster recovery exercises
• Maintaining up-to-date documentation and procedures for all supported applications and environments.
• Maintaining 99.99% availability for all production environments.
• Evaluation of functionality and features with newer versions of the SQL Server DBMS/ database related tools
• Pro-active and reactive performance analysis, monitoring, troubleshooting and resolution of issues.
• Monitoring and support of nightly production batch cycles (SQL Jobs and SSIS Packages).
• Regular review of database maintenance/ support tasks and performance improvement procedures
• Work Planning/Escalation: Organizing and monitoring personal workload and escalating to manager when issues arise
• Continuous Improvement: Sharing ideas for process improvement and innovative solutions to known problems

  KNOWLEDGE, SKILLS & ATTITUDES  

• Intermediate Knowledge
  •  SQL Server Concepts like SQL Architecture, Indexes, T-SQL skills & DMV. 
  •  Database Maintenance/ Support tasks and lower level monitoring using tools like profiler, DMV, Perfmon
  • SQL Server Replication, Backup/ Restore, maintenance plans and DR recovery strategies.
  • Troubleshooting & diagnose issues with both SSIS & SSRS (Deploy, design, Security, Tuning, Creating and enforcing Standards & best practices, automate)
  • Understanding of system tables, stored procedures, functions, triggers & SQL tuning
  • General troubleshooting like assisting clients with various issues related to connectivity, permissions, access, distributed queries issues, suggesting solutions, best practices etc.
  • SQL Server Security, adept in creating and maintain complex User and permission management environment using AD groups, DB roles, SQL ids and Proxy accounts.
    • Desirable to have
  • Knowledge of Performance Tuning by analyzing, optimizing and rewriting/re-designing SQL codes.
  • Knowledge of SQL Server database tuning using Profiler, Index Tuning Wizard, Dynamic Management Views and Functions (DMVs), and other third-party tools.
  • Hands-on experience with SQL Server installations and patching.
  • PowerShell scripting to automate DBA related tasks. Ability to understand existing automated tasks and tweak/troubleshoot them.
  • Some knowledge of data-mapping and logical and physical data modeling.
  • Knowledge of clustering, Always on / multi node clusters at the time of DR process.
  • Knowledge of AWS, Specifically, migration to AWS from in premise data center

CORE COMPETENCIES  

• Strong analytical abilities and willingness to handle medium to complex scenarios.
• Excellent communication skills (both verbal and written)
• Very high commitment levels and willing to work in any shift timings.
• Strong organizational skills with the ability to do multi-tasking
• Detailed oriented, focused approach on handling issues
• Taking accountability and ownership
• Sharing information and  best practices with team members
• Drive Knowledge management sessions in expertise skill with team

          MINIMUM QUALIFICATIONS & EXPERIENCE REQUIRED DEGREE/ DEPLOMA IN: BE/ B. Tech /MCA / M. Tech / in Computer Science or related technology. PRIOR EXPERIENCE: SQL Server database administration experience handling medium to large databases.

• In SQL Server 2008- 2016 running on the Win Server 2008, 2012 operating system

GOOD TO HAVE: Basic knowledge of SSAS, CMD Shell Scripting/ FTP shares, VB script and .net/C# would be preferred.
Experience on SQL backup tools like power designer, DB artisan, Redgate. CERTIFICATIONS: MCSE or MCSA certified in SQL Server2012 or 2014 desirable  
 
                                                              


Total Exp – 3.1 to 6 Years
 
Location - Gurgaon