JOSHNA NAIR

Project : Microsoft Azure SQL

• Provided expert support to Microsoft customers, troubleshooting complex Azure SQL Database queries and performance issues to ensure optimal operation.
• Assisted clients in diagnosing and resolving database-related problems, including query optimization, indexing, and schema design.
• Conducted root cause analysis for database performance issues, utilizing Azure Monitor, SQL Database Query Performance Insight, and other diagnostic tools.
• Guided customers in best practices for database configuration, security, and scalability to enhance system performance and reliability.
• Developed and delivered tailored solutions and recommendations to address customer-specific requirements and challenges.
• Collaborated with internal teams to escalate and resolve intricate technical issues, ensuring prompt and effective resolution.
• Created and maintained detailed documentation and knowledge base articles to facilitate self-service troubleshooting and support for common issues.
• Participated in regular review meetings with clients to discuss progress, provide updates, and strategize on continuous improvement for their Azure SQL Database environment
• Implemented and managed Snowflake schemas within SQL environments, optimizing data organization and retrieval for enhanced performance and scalability.
• Integrated Snowflake with Azure SQL Database solutions, ensuring seamless data flow and effective utilization of both platforms for comprehensive analytics.

• Develop and optimize complex SQL queries for various applications, ensuring efficiency and accuracy in data retrieval and manipulation
• Collaborate with software developers, data analysts, and stakeholders to understand application requirements and optimize database queries accordingly
• Perform query tuning and optimization to improve database performance, identifying and resolving bottlenecks and inefficiencies
• Proficient in leveraging Azure cloud services for diverse applications and workloads
• Extensive experience in monitoring, analyzing, and optimizing Azure service logs for performance enhancement and issue resolution
• In-depth understanding of Load Balancer functionality and its role in ensuring high availability and scalability of applications
• Proficiency in utilizing Kibana as a powerful data visualization and analysis tool
• Create and maintain documentation for SQL queries, database schemas, and data dictionaries for reference and future improvements.
• Designed and implemented data transformation workflows using DBT ensuring accurate and efficient data processing and analysis
• Created comprehensive documentation for DBT models transformation , Spark transformation and data processing providing timely resolutions as well

• Documented all concerns and incidents and reported them to a senior supervisor
• Conducted internal audit and submitted report on production team with volume inflow and outflow
• Processed insurance for nationwide client with the information provided and generated claim numbers
• Kept a regular check on team production and updated the team with relevant information from time to time
• Monitored process performance metrics, analyzed trends, and implemented necessary improvements to achieve operational excellence
• Mentored and guided team members, providing support, training, and feedback to enhance their performance and skill development
• Conducted quality checks and audits to maintain accuracy, consistency, and reliability in the execution of processes
• Implemented corrective actions to address any deviations and prevent recurrence of errors.

• Worked productively with Product Team to understand requirements and business specification around creations of PLIs and handling restricted data sites
• Worked on assigned ticket of SAP and Sales org
• Handled the process of Restricted data sites
• Collaborated with cross-functional teams, including system administrators, developers, and security personnel, to resolve escalated issues and implement solutions aligned with RDS guidelines
• Oversaw the handling, prioritization, and resolution of SAP and Salesforce tickets within the RDS team, ensuring timely responses and effective solutions while maintaining data security standards.

• Handled the athletics session of decathlon and provided the financial and sales report on a daily basis and weekly report
• Engaged with customers to understand their sports needs, offering expert advice on products and services, ensuring a personalized and enjoyable shopping experience
• Upheld safety standards, ensuring that sports equipment and facilities are safe for customer use, and compliance with company policies and procedures.