MY SQL Database Administration
Published date: 2024/01/10
- Location: Noida, Uttarpradesh, India
Job Description
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
11) Writing Computation-Intensive Programs in T-MYSQL
12) Monitor MYSQL Performance and IO
13) Production support on issues
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
11) Writing Computation-Intensive Programs in T-MYSQL
12) Monitor MYSQL Performance and IO
13) Production support on issues
0 page views
Related listings
-
Lead Oracle Database AdministratorDatabase AdministratorRole : Lead ORACLE DBA Experience: 9 - 17 years Location: Permanently WFH or Noida Hybrid Client: A leading Fintech Co Skill Set: Oracle DBA, PostgreSQL DBA, Oracle RAC, Oracle ASM, Oracle Data Guard, Backup and Recovery, Scripting, Performance Tunin...2026/11/06
-
Back up Administrator (Commvault and Data Protector)Database AdministratorBackup with Commvault AND Data Protector • Should have Experience on Commvault AND Data Protector Should be able to do L2+ /L3 Level activities • Expertise in management, configuration, and administration of Commvault and Data protector backup is Man...2024/01/10
-
Database AdministratorDatabase AdministratorJob Title Database Administrator (Hybrid) Job Description For more than 80 years, Kaplan has been a trailblazer in education and professional advancement. We are a global company at the intersection of education and technology, focused on collaborati...2024/01/10