We are looking for a Senior SQL developer who will be responsible for maintaining the customer data and its redundancy ensuring their stability, reliability, and performance within the system.
. Should be strong in basic DB concepts, joins, aggregate functions and commands (DDL, DML, TCL & DCL) and help write and optimize in-application SQL statements. Should be proficient in advance SQL concepts like CTE, Recursive queries, Pivots, Self joins, Temporary functions, UDF, etc., Should be knowledgeable in Memory management for database systems or in-application. Should have a strong Troubleshooting and problem-solving skills. Should be able to develop/test the queries with respect to the performance and load distribution. He/she should be trained in Development, optimize, and tune the queries. Should be able to prepare documentation and specifications. Collaborate with other team members and stakeholders. Use database analytical tools to analyse performance and generate reports. Should know the database design and development best-practices. He/she should be staying up to date with all relevant data security procedures and complying with all applicable data protection. Should be capable of cross-validating the data between two sources through writing queries and datasets.