Description

Summary: 1) Designing databases and ensuring their stability, reliability, and performance. 2) Analyse existing MySQL queries/ procedures for performance optimization and troubleshooting issues. Responsibilities: 1) Designing databases and ensuring their stability, reliability, and performance 2) Write complex queries and scripts with advance MySQL queries. 3) Develop, Implement and optimize Stored Procedures, Functions, Triggers, Views, Joins, database objects. 4) Review and interpret ongoing business report requirements. 5) Prepare documentations and specifications. 6) Research required data / logic from the system and convent it into MySQL queriers. 7) Analyse existing MySQL queries/ procedures for performance optimization and troubleshooting issues 8) Prepare and provided the script using advanced query based on deliverables 9) BI Technologies - (SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)), Microsoft SQL Server, T-SQL, Dynamic SQL, Experience in Analytical Platform System (APS) PDW, Microsoft Team Foundation Server (TFS). 10) Alteryx, BIML using MIST, Power shell scripts, Windows.Net C Sharp, Azure Data factory, Power BI and PowerPivot. Exposure to RDBMS and Data warehousing design. 11) Demonstrate the ability to model and translate business requirements to a database architecture and design along with strong development skills. 12) Involvement in development/enhancement projects along with awareness of complete SDLC. 13) Operate in a fast paced Agile Development environment. 14) Will work closely with other developers, QA engineers, and product management to collaborate in the delivery of on time, high value, quality software solutions. 15) Must have the ability to quickly learn and implement new technologies and methodologies. 16) Provide support for existing integrations as needed and resolve deep rooted issues within the system 17) Adhere to the software change management and change control Education: B.E/ B.Tech/M.Tech/MCA(Computer/IT) Experience: 1) Candidate should have strong 8 years of experience. 2) Hands on Experience in developing, implementing and optimizing Stored Procedures, Functions, Triggers, Views, Joins, database objects 3) Excellent skills in MS SQL programming, debugging, and developing stored procedures Certifications: Oracle/Post gres Sql/ MS Sql Certified Professional Knowledge: 1) Hands on Experience in developing, implementing and optimizing Stored Procedures, Functions, Triggers, Views, Joins, database objects 2) Excellent skills in MS SQL programming, debugging, and developing stored procedures 3) Knowledge of best practices when dealing with relational databases. 4) Capable of troubleshooting common database issues. 5) Critical thinker and problem-solving skills 6) Good time-management skills and a team player 7) Great interpersonal and communication skills Technical Skills: SQL Server 2019, Microsoft SQL Server 2019, SQL Coding, data analytics

Role and Responsibilities

• Summary: 1) Designing databases and ensuring their stability, reliability, and performance. 2) Analyse existing MySQL queries/ procedures for performance optimization and troubleshooting issues. Responsibilities: 1) Designing databases and ensuring their stability, reliability, and performance 2) Write complex queries and scripts with advance MySQL queries. 3) Develop, Implement and optimize Stored Procedures, Functions, Triggers, Views, Joins, database objects. 4) Review and interpret ongoing business report requirements. 5) Prepare documentations and specifications. 6) Research required data / logic from the system and convent it into MySQL queriers. 7) Analyse existing MySQL queries/ procedures for performance optimization and troubleshooting issues 8) Prepare and provided the script using advanced query based on deliverables 9) BI Technologies - (SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)), Microsoft SQL Server, T-SQL, Dynamic SQL, Experience in Analytical Platform System (APS) PDW, Microsoft Team Foundation Server (TFS). 10) Alteryx, BIML using MIST, Power shell scripts, Windows.Net C Sharp, Azure Data factory, Power BI and PowerPivot. Exposure to RDBMS and Data warehousing design. 11) Demonstrate the ability to model and translate business requirements to a database architecture and design along with strong development skills. 12) Involvement in development/enhancement projects along with awareness of complete SDLC. 13) Operate in a fast paced Agile Development environment. 14) Will work closely with other developers, QA engineers, and product management to collaborate in the delivery of on time, high value, quality software solutions. 15) Must have the ability to quickly learn and implement new technologies and methodologies. 16) Provide support for existing integrations as needed and resolve deep rooted issues within the system 17) Adhere to the software change management and change control Education: B.E/ B.Tech/M.Tech/MCA(Computer/IT) Experience: 1) Candidate should have strong 8 years of experience. 2) Hands on Experience in developing, implementing and optimizing Stored Procedures, Functions, Triggers, Views, Joins, database objects 3) Excellent skills in MS SQL programming, debugging, and developing stored procedures Certifications: Oracle/Post gres Sql/ MS Sql Certified Professional Knowledge: 1) Hands on Experience in developing, implementing and optimizing Stored Procedures, Functions, Triggers, Views, Joins, database objects 2) Excellent skills in MS SQL programming, debugging, and developing stored procedures 3) Knowledge of best practices when dealing with relational databases. 4) Capable of troubleshooting common database issues. 5) Critical thinker and problem-solving skills 6) Good time-management skills and a team player 7) Great interpersonal and communication skills Technical Skills: SQL Server 2019, Microsoft SQL Server 2019, SQL Coding, data analytics