Database Specialist - MS SQL

₹3L–₹6L a yearFull–time
JD for Database Specialist (MS SQL)  Techno managerial skills, Project management, Technical Database and associated technology knowledge, Vendor and Stakeholder Mgmt. Excellent communication skills.  Overall 2-4 years of hands-on experience in MSSQL.  Hands on experience in installation and configuration of MSSQL RDBMS and NoSQL environment  Hands-on experience in configuring & maintaining AAG, Failover Cluster Instance, Log-shipping etc.  Hands-on experience in troubleshooting complex database performance, availability and fine-tuning issues of large databases.  Hands on experience in building information framework, data pipeline, business intelligence, data analytics, ETL strategy.  Should be able to design solutions for workloads on virtual & physical server to meet business continuity & DR plans and RTO/RPO targets.  Performs all DBA tasks to support 24x7 production environments including Index rebuild & update statistics  Should be able to deploy new jobs, SSIS packages, write/configure customized alerts  Ensure high levels of DB performance, availability, sustainability, security and compliance  Ensures all security requirements are met, supports audit and compliance activities  Drives incident response, root cause analysis, and advanced performance troubleshooting to proactively resolve database problems and isolate issues.  Works closely with internal and external stakeholders for new projects, service improvements and troubleshooting  Should be expert in developing scripts and using automation technologies to reduce incidents and service requests  Hands on experience in managing Infrastructure using automation  Cloud Migration of Databases as per Cloud Strategy  Manage Service Levels for key customers and Patch Management for Databases and replication technologies.  DB upgrades for Ensuring Performing Systems. Lead Performance Initiatives.  Capacity Planning for the heterogeneous databases and replication technology  Manage Incident change, configuration and Problem Management within SLA with Customers and obtaining all RCA's & RCCA's in defined timelines. Vendor Management  Ensuring Backups properly taken and checking the validity of the backups through periodic restoration.  Ensure reliable disaster recovery plan for databases to meet business RPO and RTO  Ensure software license compliance for databases  Ensure successful internal and external audits for DB domain  Ensure security and compliance for Databases  Project management under new initiatives.  Innovation and Cost saving initiatives for databases. Internal Operations  Easily recognizes areas for internal improvement and develops plans for implementation.  Lends expertise to internal teams and task forces.  Reviews the status reports of team members across projects and addresses issues as appropriate.  Complies with and enforces standard company policies and procedures. ORGANIZATIONAL RESPONSIBILITIES  Innovator Development  Participates in all programs relating to performance evaluations and career development planning.  Reviews evaluations within practice for consistency.  Mentors managers through formal channels.  Assesses training needs and selects training tools for team members.  Manages the development of project teams by ensuring that project tasks are in line with each Innovator's career i