Analyze technical requirements and design new data models or update existing data models
Analyze technical requirements and recommend ETL strategies and provide visual representation of design
Code stored procedures of high complexity to meet product requirements
Conduct Index and Performance Analysis to provide optimal performance
Deliver work products that meets specifications, are free of defects, and have optimal performance
Define and keep up to date Database Architecture and Development best practices
Build design consensus amongst different teams working on software development projects
Understands complex database concepts as well as the implications of different database designs on performance, scalability and maintainability.
Demonstrates expert knowledge of database design
Demonstrates expert knowledge of performance tuning.
Skills and Experience
Demonstrated T-SQL proficiency, especially design considerations surrounding stored procedure development performance, indexing, parametrization, etc.
Experience in designing database for large and complex enterprise applications
Working knowledge of open DBs such as MySQL, PostgreSQL.
Experience with the following technologies a plus:
C#, Java, Python, Perl, etc.
Big Data, Hadoop, MongoDB.
Migration from legacy DBs
Minimum of 10 years in the ICT industry with at least 3 years into development of large scale applications
An Engineering degree (preferably Computer Science), Master in Computer Applications, Master in Science from a leading university in India or abroad