MySQL Database
Centilytics
0 - 3 Years
|
5 - 12 LPA
|
Noida
Centilytics, an Intelligent cloud management platform, serves as a governance, security & optimization tool to save unnecessary cloud spend with 360-degree visibility. It pinpoints loopholes in the cloud infrastructure to put the resources into optimum utilization and check the entire infrastructure for threats and malicious attacks.
- Visualize every dollar spent with cost visibility and analysis.
- Identify inefficiencies in your cloud that slows down your business.
- Efficient and optimum utilization of resources to reduce wastage.
- Ensure complete accuracy in your cost allocation.
- Over 500 health checks and recommendations.
Website: https://www.centilytics.com/
Job Description:
Roles Responsibilities:
1)Evaluate and analyze custom MYSQL server programs/T-SQLs for high performance issues.
2)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.
3)Hands on Advance MySQL server concepts (Performance Tuning, Larger subqueries, JOINS, PerfMon tooling)
4)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.
5)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.
6)Document improvement in the MYSQL level metrics CPU, I/O requests, throughput, Files and File-groups to a desirable level.
7)Report trace files comparison for the required parameters before and after the optimization for the improvement of statistics.
8)Analysis trace files, identify problem queries, I/O, Waits, Correlated sub queries and Parameters validation.
9)Tune the queries and use Materialized or temp tables if required, Re-write the logic for better performance if required.
10)Replace Correlated sub queries, reducing Loop Overhead for DML Statements and Queries.
Skill Set Required:
1-Performance Tuning, Larger subqueries, JOINS, PerfMon tooling, Triger.
2-Writing Computation-Intensive Programs in T-MYSQL.
3-Monitor MYSQL Performance and IO.
4-Production support on issue
Profile/Designation: MySQL Database
Gender: Any
Job Location: Noida 83
Desired experience: 0-3 years, MySQL server concepts (Performance Tuning, Larger subqueries, JOINS, PerfMon tooling)
Target batch Pass out: 2020-2023
Course specialization: B.tech(CS/IT), BSC, MSC, M.tech
Academic % Criteria 10th,12th, Graduation: 60%
Probation/Training Period: 90 days
Salary: 5LPA - 12LPA Including Retention
Tentative date of interview: Immediate
Tentative date of joining: Immediate/30days Negotiable
Interview Process: Virtual
Education:
B.Sc., B.Tech/B.E., M.Sc., M.Tech./M.E.
Work Experience:
0 - 3 Years
Salary
5 - 12 LPA
Industry
IT Infrastructure
