Serve as a SQL developer implementing, optimizing complex stored procedures
Write fast and performant database queries using various SQL tools
Contribute and lead troubleshooting problematic or slow SQL code
Will be responsible for creating Tables, Stored Procedure, Views, Indexes, Cursors, Triggers, User profiles, User defined functions, Relational database models & data integrity in observing business rules
Candidate will need understand data conditioning and preparation of test data for testing of various scenarios
Candidate should have knowledge and understanding on Normalization & RDBMS
Candidate will participate in extracting, transforming and loading (ETL) data from variouse formats (flat files, excel files, csv files, Json documents, etc.) using one or more ETL Tools (SSIS/Talend/Python)
Required Qualifications:
BS/MS degree in Computer Science, Engineering or a related subject, or equivalent experience
5+ years relational DB Experience, including TSQL, complex queries, stored procedures, Index creation, and performance tuning
Proficiency in executing multi-step data management and analysis tasks including creating data dictionaries and specification documents from research protocols
Solid database skills with One or more DB technologies (SQL Server, Postgres, MongoDB, Casandra, Graph DB etc.)