SQL Technology

<h2>Job Overview:</h2><ul><li><span style="font-family: calibri, sans-serif; font-size: 10pt;">Design and implement software artifacts as per Functional specifications using SQL</span></li><li><span style="font-family: calibri, sans-serif; font-size: 10pt;">Enhance and fix existing SQL scripts</span></li><li><span style="font-family: calibri, sans-serif; font-size: 10pt;">Help the team form queries required for data load and transformations based on the requirements of the configuration plan</span></li><li><span style="font-family: calibri, sans-serif; font-size: 10pt;">Understand the data model and triage issues with data load</span></li><li><span style="font-family: calibri, sans-serif; font-size: 10pt;">Implement Best coding and design practices</span></li><li><span style="font-family: calibri, sans-serif; font-size: 10pt;">Create Unit Test data as and when required</span></li><li><span style="font-family: calibri, sans-serif; font-size: 10pt;">Peer review of SQL artefacts code</span></li><li><span style="font-family: calibri, sans-serif; font-size: 10pt;">Follow all applicable departmental Standard Operating Procedures and Work Instructions.</span></li><li><span style="font-family: calibri, sans-serif; font-size: 10pt;">Complete required trainings according to required timelines.</span></li><li><span style="font-family: calibri, sans-serif; font-size: 10pt;">Complete day-to-day tasks ensuring quality and productivity.</span></li><li><span style="font-family: calibri, sans-serif; font-size: 10pt;">Manage project and technical documentation in an appropriate manner.</span></li><li><span style="font-family: calibri, sans-serif; font-size: 10pt;">Provide administrative and technical support to internal departments and teams as needed.</span></li><li><span style="font-family: calibri, sans-serif; font-size: 10pt;">Ensure timely escalation and issue resolution as needed.</span></li><li><span style="font-family: calibri, sans-serif; font-size: 10pt;">Track and report metrics as determined by management according to required timelines.</span></li><li><span style="font-family: calibri, sans-serif; font-size: 10pt;">Participate in process improvement opportunities and assist with the implementation of revised processes and procedures.</span></li></ul><h2>Education/Qualifications:</h2><p style="margin: 0px;"><span style="font-size: 10.0pt; font-family: 'Times New Roman',serif;"><span style="font-family: calibri, sans-serif;">Bachelors of Engg / Technology Degree from a Reputed University</span> </span></p><h2>Experience:</h2><ol style="margin-top: 0in;"><li style="margin-bottom: .0001pt;"><span style="font-size: 10pt; font-family: calibri, sans-serif;">Years of experience in the software industry in MS SQL Development job discipline: 5-6 Years</span></li><li style="margin-bottom: .0001pt;"><span style="font-size: 10pt; font-family: calibri, sans-serif;">Hands on experience in :</span></li></ol><ul><li style="margin: 0in 0in .0001pt 1.0in;"><span style="font-size: 10pt; font-family: calibri, sans-serif;">Working with Microsoft SQL Server</span></li><li style="margin: 0in 0in .0001pt 1.0in;"><span style="font-size: 10pt; font-family: calibri, sans-serif;">Designing database tables and structures</span></li><li style="margin: 0in 0in .0001pt 1.0in;"><span style="font-size: 10pt; font-family: calibri, sans-serif;">Creating views, functions and stored procedures</span></li><li style="margin: 0in 0in .0001pt 1.0in;"><span style="font-size: 10pt; font-family: calibri, sans-serif;">Writing optimized SQL queries for integration with other applications. </span></li><li style="margin: 0in 0in .0001pt 1.0in;"><span style="font-size: 10pt; font-family: calibri, sans-serif;">SQL performance tuning</span></li><li style="margin: 0in 0in .0001pt 1.0in;"><span style="font-size: 10pt; font-family: calibri, sans-serif;">Creating database triggers for use in automation</span></li><li style="margin: 0in 0in .0001pt 1.0in;"><span style="font-size: 10pt; font-family: calibri, sans-serif;">Maintaining data quality and overseeing database security</span></li><li style="margin: 0in 0in .0001pt 1.0in;"><span style="font-size: 10pt; font-family: calibri, sans-serif;">Experience with XSLT, Functional programming, NoSQL technologies</span></li></ul><ol style="margin-top: 0in;"><li style="margin-bottom: .0001pt;"><span style="font-size: 10pt; font-family: calibri, sans-serif;">Excellent Analytical skills to  quickly identify cause and effect relationships<br />proven design skills with solid understanding of designs that will be helpful while designing scalable applications</span></li><li style="margin-bottom: .0001pt;"><span style="font-size: 10pt; font-family: calibri, sans-serif;">Demonstrated ability for achieving process and delivery excellence</span></li><li style="margin-bottom: .0001pt;"><span style="font-size: 10pt; font-family: calibri, sans-serif;">Proven ability to peer review test cases, identify gaps in requirements and conducting UAT etc</span></li><li style="margin-bottom: .0001pt;"><span style="font-size: 10pt; font-family: calibri, sans-serif;">Deep Understanding of SDLC methodologies like SCRUM</span></li><li style="margin-bottom: .0001pt;"><span style="font-size: 10pt; font-family: calibri, sans-serif;">Other required work-related experiences:</span></li></ol><ul><li style="margin: 0in 0in .0001pt 1.0in;"><span style="font-size: 10pt; font-family: calibri, sans-serif;">Demonstrated ability to organize and communicate effectively.</span></li><li style="margin: 0in 0in .0001pt 1.0in;"><span style="font-size: 10pt; font-family: calibri, sans-serif;">Demonstrated ability to pay attention to detail.</span></li><li style="margin: 0in 0in .0001pt 1.0in;"><span style="font-size: 10pt; font-family: calibri, sans-serif;">Ability to work well with others.</span></li><li style="margin: 0in 0in .0001pt 1.0in;"><span style="font-size: 10pt; font-family: calibri, sans-serif;">Ability to deliver consistent high quality of work.</span></li><li style="margin: 0in 0in .0001pt 1.0in;"><span style="font-size: 10pt; font-family: calibri, sans-serif;">Ability to use computer and departmental tools.</span></li></ul>