Centilytics is hiring for Software Engineer

The job you are looking for is no longer available..
Company Name
Centilytics
Company Website
https://www.centilytics.com/
Job Role
Software Engineer
Job Type
  • Fresher
  • Experienced
Job Location
  • Noida
Education
  • BE/BTech
Branch
  • IT
  • CS
Job will expire on
24 Jan 2024

Eligibility Criteria

  • Report trace files comparison for the required parameters before and after the optimization for the improvement of statistics
  • Analysis trace files, Identify problem queries, I/O, Waits, Correlated sub queries and Parameters validation
  • Tune the queries and use Materialized or temp tables if required, Re-write the logic for better performance if required
  • Replace Correlated sub queries, reducing Loop Overhead for DML Statements and Queries
  • Writing Computation-Intensive Programs in T-MYSQLMonitor
  • MYSQL Performance and IO
  • Production support on issues

Job Description

  • Evaluate and analyze custom MYSQL server programs/T-SQLs for high performance issues
  • Create MySQL objects like Tables, Views, Indexes, Stored Procedures, Triggers, Rules, Defaults and user defined functions and Extensive Knowledge of advance query concepts that includes Dynamic MYSQL scripting, Recursive CTE and Partitioning management
  • Hands on Advance MySQL server concepts (Performance Tuning, Larger subqueries, JOINS, PerfMon tooling)
  • Analyze, tune & test identified top 30 programs, integrations and reports based on current CPU, I/O & throughput utilization and implement best practices recommended by MYSQL server for improved performance
  • Proficient in tuning T-MYSQL queries using MYSQL server profiler, Execution Plan, Performance Monitor, DBCC Commands, Database Tuning Advisor, Index Fragmentation techniques to improve the database performance and ensure high availability

Job Seeker Advisory & Application Guidelines

Before You Apply

Review the required educational stream, minimum cutoff percentage, eligible graduating batch, and job location carefully. Update your resume with relevant project highlights matching the job role before submitting your application.

100% Free & Anti-Fraud Notice

JobInvent and legitimate hiring employers never charge fees for job applications, interview scheduling, coding assessments, or offer letters. Never pay money to anyone promising guaranteed job placements. Report suspicious activity to admin@jobinvent.com.

Interview Preparation Tip: Need help with HR or technical rounds for this role? Check our free Interview Questions & Answers and real Interview Experiences from candidates across top MNCs.