2 Query Analysis Jobs

Job Summary: Synechron is seeking a knowledgeable and experienced AppDynamics SME to lead application performance monitoring initiatives across multiple projects. The role involves providing technical expertise, optimizing application performance, and ensuring compliance with industry standards. The SME will collaborate with development, operations, and testing teams to implement best practices, troubleshoot issues, and drive continuous improvement, ultimately contributing to reliable, high-performing software solutions aligned with organizational goals. Software Requirements: Required: In-depth experience with AppDynamics monitoring, configuration, and troubleshooting, preferably with the latest versions Familiarity with project management tools such as JIRA, Trello, or Asana Working knowledge of database technologies including MySQL, MongoDB, and Oracle Preferred: Experience with other APM tools (New Relic, Dynatrace, etc.) Knowledge of cloud platforms (AWS, Azure, GCP) and containerization (Docker, Kubernetes) Overall Responsibilities: Serve as the technical expert on AppDynamics tools, providing guidance on configuration, deployment, and troubleshooting. Develop and implement strategies for application performance monitoring, ensuring optimal operation of critical applications. Collaborate with cross-functional teams—including development, operations, and QA—to integrate AppDynamics effectively within the software lifecycle. Conduct research on emerging technologies and APM best practices, recommending enhancements to monitor and improve application health. Lead incident analysis, root cause investigations, and resolution efforts for performance issues. Ensure all monitoring solutions adhere to industry standards and best practices for security and compliance. Technical Skills (By Category): Monitoring & Performance Tools: Essential: Deep expertise in AppDynamics installation, configuration, and management Preferred: Experience with other APM solutions like New Relic or Dynatrace Databases/Data Management: Proficiency with MySQL, MongoDB, Oracle; underlying database monitoring and query analysis Cloud Technologies: Experience with cloud platforms supporting enterprise applications (AWS, Azure, GCP) Development Frameworks & Libraries: Knowledge of application architectures and integration methods involving various technologies Development Tools and Methodologies: Familiarity with Agile, DevOps, and CI/CD pipelines for monitoring deployment and automation Security Protocols: Understanding of data security, application security, and compliance standards related to monitoring tools (preferred) Experience Requirements: Minimum of 12+ years in software development, application performance management, or related consulting roles. Proven track record of implementing and managing AppDynamics solutions in complex enterprise environments. Experience working with cross-functional teams on large-scale projects, handling incident management, and performance tuning. Familiarity with cloud deployment models and containerization is highly desirable. Day-to-Day Activities: Conduct daily monitoring and analysis of application performance metrics via AppDynamics dashboards. Collaborate during planning sessions to define monitoring requirements based on project needs. Lead performance tuning, troubleshooting, and incident response activities. Coordinate with development and operations teams to optimize application architecture and deployment strategies. Document configuration settings, best practices, and incident resolutions for ongoing reference and training. Stay informed about new trends and features in application performance monitoring, recommending practical integrations. Provide technical guidance and mentorship to team members on AppDynamics best practices. Qualifications: Bachelor’s degree in Computer Science, Information Technology, or a related field; Master’s degree is a plus. Certifications in Application Performance Monitoring or related technologies (e.g., AppDynamics Certified Associate/Professional) preferred. Ongoing learning through technical training, webinars, or relevant industry courses. Professional Competencies: Strong analytical and problem-solving skills with a focus on performance optimization. Excellent communication and interpersonal skills to engage with technical and non-technical stakeholders. Leadership abilities to motivate and guide teams on complex technical topics. Adaptability to changing technology landscapes and evolving project requirements. Critical thinking and decision-making capabilities grounded in data analysis and troubleshooting.

Roles and Responsibilities Design, develop, test, deploy, and maintain complex SQL queries to meet business requirements. Optimize database performance by analyzing query execution plans using tools like Query Analyzer and SQL Profiler. Create stored procedures, views, triggers, CTEs, tables, indexes, normalized databases for efficient data storage. Collaborate with cross-functional teams to identify areas of improvement in existing systems. Desired Candidate Profile 1-2 years of experience in Microsoft SQL development with expertise in T-SQL programming language. Strong understanding of DDL/DML commands for creating/modifying database structures. Proficiency in writing complex queries including joins, aggregations, subqueries etc. . Experience with SSIS (SQL Server Integration Services) for extracting/transforming/loading data between different systems.