Senior Software Data Architect - Data Warehousing/SQL Server (11-17 Yrs) Bangalore (Systems/Product Software)

Responsibilities- - Determine database structural requirements by analysing the existing system, client operations, applications, business requirements and programming; reviewing objectives with solutions; - Defining database physical structure and functional capabilities, security, back-up, and recovery specifications and effectively articulate it to the various stake holders.
-Keep pace with the innovative technologies and consider possibilities of creating relevant solution offerings. Design POCs, discuss and coordinate with other architects in developmental direction choice; - Consult and supervise all team members, share knowledge. Mentor other Solution Architects in practical SA activities. Provide technical guidance and career-planning assistance; - Work closely with the stake holders to define and refine the infrastructural, architectural requirements for meeting various business requirements; - Reverse engineer highly-integrated, undocumented systems and uncommented code - This is a fast-paced, dynamic environment; ideal candidate loves a challenge and is ready to solve problems. Minimum Qualifications : - Should be hands-on in SQL, XML, Data Modelling, Database Design, Performance Tuning and preferably from Healthcare domain.
-Should have exposure to - AWS RDS, Dimensional modelling, Data warehousing and data engineering practices - Minimum of 5-8 years of experience in SQL Programming.
-A deep and thorough understanding of one of these Oracle/MySQL/MariaDB. and SQL database internals.
-Strong experience with performance tuning of SQL Server databases, SQL queries, procedures, functions, etc.
-Ability to trace SQL transactions through code.
-Write clean, clear, and efficient SQL stored procedures.
-Design tables, keys, indexes, views that effectively represent the data.
-Monitor, tune and troubleshoot database performance and data concurrency - Develop and maintain database and coding standards - Proficient in database concepts and design (tables, constraints, indexing, schemas, CLR) - Strong understanding of SQL Server security, performance monitoring and optimizing - Ability to plan, test and implement the safe modification of a production database environment during Software upgrade cycles - Ability to keep the lights on, handling routine support of existing features/functionalities and data integrity issues for applications - Experienced and comfortable working in a fast paced, ambiguous, and agile driven environment - Nice to have - Experience and understanding of NOSQL databases, Other RDBMS, Big Data Tools Preferred qualifications - Experience in a regulated industry will be preferred

Required Skills : English