Head (Manager/Sr. Manager/Director Level)

Job Description

Head (Manager/Sr. Manager/Director Level) of SQL Server DB ( DB Architecture & Administration ) Brief about this role: This is a leadership role, critical and integral part of Technology team. Role requires extensively hands on and technologically expert individual. Role is responsible for overall architecture, integrity, performance, stability, optimization, accessibility (through queries,) and security of all Databases / Data Tables in the Technology platform of Easypolicy. Role will extensively interact (daily basis) with Product & Solution Architect various Back-end engineers, Engineering Managers, Product Managers, BI and Data Analytics teams.Requirements Minimum 10-15 years of total experience in medium to large scale (More than 1 Million transactions in a month & tens of millions of DB records) technology driven product companies either B2C or B2B Minimum 8 years of continuous strong production support experience in Development, Design and Maintenance of relational databases using SQL Server 2008/2008R2/2012/2016 in OLTP/OLAP/BI environment Data Base architecture design database warehousing and Database Modeling Knowledge of SQL Server tools (DTA, SSMS, SAC, SSCM, Perf Mon). Database installation, Database maintenance, Upgradation, Migration, Server/database Tuning, Backup & Recovery operations Hands on Experience in Tuning T-SQL queries to improve performance, Index tuning, Windows Performance Monitor Knowledge on High Availability (HA), DB mirroring, log shipping Knowledge on ETL (SSIS, SSRS AND SSAS (MDX Query)) No-SQL Database, Mango DB, Cassandra, Radis Database, Hadoop Experience for installing, configuring, patching and maintaining SQL Server software on Windows environment for Standalone and High Availability clusters Knowledge of 3rd party DBA tools and applications (Apex Tools, Red Gate etc.) Experience of managing a team size of minimum 3 Senior-level SQL Develoeprs and DB Administrators Key Responsibilities Ownership of the database, maintaining at different stages i.e. Live, UAT, QA, Dev Setting up reporting system and fundamental building block for analytics team DB Development and documentation (Tables, SPs, DB changes) Ensuring DB team and Dev team following the best practices Responsible for revamping the database Highly Secure DB architecture, capable of handling various kind of malicious attacks Database maintenance and Management Ownership of the database, maintaining at different stages i.e. Live, UAT, QA, a. Maintaining high availability of various environment including Live (and failover), reporting, Dev, QA Routine maintenance of the databases Installation, configuration, patching and maintenance SQL Server software on Windows environment for Standalone and High Availability clusters Identifying database problems in live environment, quick and long term solution Ensuring the delivery of resolution to live environment in shortest time Lead the team of 3-5 people Responsible to maintain a cordial working relationship and conducive culture within the team As per the HR processes, appraise team members with timely feedback and guidance d. Complete knowledge and awareness about the abilities, skill level, quality and concerns of each team member. Do proper growth planning for each team member. Establish and drive software processes within database team. Contribute at company level to establish best practices to improve quality of overall development and processes Maintain highly positive attitude and conducive working relationship with peers Always keep himself/herself updated about technology advancements, new trends. Share the knowledge with team members and peers regularly. What s in it for you ,

Keyskills :
sqlserver logshipping hrprocesses dataanalytics highavailability commercialmodels databasemodeling recoveryoperations routinemaintenance architecturaldesign roductionsupp perf mancemonitdatabas