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.
- 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