*Responsibilities: * • Design and maintain large clinical 2-3 TB SQL Server Databases • Tune complex SQL Server queries • Design and code a large number of SQL Queries and stored procedures • Monitor and performance tuning on complex ETL jobs • Implement processes and procedures for the development and release of products/projects that facilitate high quality and rapid deployment • Provide solutions to promote data integrity in enterprise systems. • Participate in code reviews to validate the effectiveness and quality of code. • Publish documentation and collaborative information using internal tools. • Mentor team members in best practices and review other ETL designs and implementations.
*Requirements: * • Expertise in Database Architecture in an environment that handles a large volume of data, an excess of 500 million every day • Demonstrate expertise in performance tuning including both query and server optimization. • Strong knowledge and experience in data modeling, database design, optimization for performance, SQL, stored procedures • Expertise in understanding complex business needs, analyzing, designing and developing solutions • Experience in SQL Server Integration Services 2012/2014/2016. • Hands-on development experience in SQL Server 2012/2014/2016 using SSIS and SSRS • Experience in troubleshooting and resolving data issues • Experience in agile development is preferred • Eager to learn clinical data and systems • Excellent oral and written communication skills *Experience:* • 8 years + relational database and SQL experience • Solid experience (4 years +) in coding complex SQL queries and stored procedures • Strong understanding of database development methodologies (Agile and Scrum) • Experience with Continuous Integration Tools (Jenkins, TeamCity, Bamboo) and Test Driven Development (TDD) a big plus • Health care domain knowledge a big plus • Experience with Red Gate Tools a plus (SQL Source Control, SQL Compare, SQL Data Compare, DLM) Thanks... Uday Varanganti Recruiting Specialist [email protected] O: (785)380 8559 Ext:109 -- You received this message because you are subscribed to "rtc-linux". Membership options at http://groups.google.com/group/rtc-linux . Please read http://groups.google.com/group/rtc-linux/web/checklist before submitting a driver. --- You received this message because you are subscribed to the Google Groups "rtc-linux" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
