Functional Skills

• Installing, Configuring and Managing MySQL/Percona Server (5.5, 5.6,5.7) and MariaDB (10.3,) on Linux Redhat/Centos 6,7 platforms.

• Performing tests and evaluations regularly to ensure data security, privacy and integrity.

• Upgrading various version MySQL including 5.1, 5.5, 5.6 and 5.7.

• Configuring MySQL replication for high availability. Setup and configure MySQL master-slave, master-master replication

• 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

• Document improvement in the MYSQL level metrics CPU, I/O requests, throughput, Files and File-groups to a desirable level

• 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-MYSQL

• Installing, Configuring and Managing PostgreSQL (9.5, 9.6,10.4) on Linux Redhat/Centos 6,7 platforms.

• Performing backup and recovery of PostgreSQL databases with pg dump, pg restore, pg dumpall, File system level Backup, restore an offline backup, Continuous Archiving, Base backup using pg basebackup tool and Point-in-time recovery.

• Setup Streaming and logical Replication in PostgreSQL databases.

• Performing PostgreSQL Privileges & User Management: Creating Users, granting privileges, creating views, sequences, schema management and updating statistics of a databases.

• Analyzing Database logs for errors and performing routine table and index maintenance tasks. Resolving table and index level database corruption.

• Performing Database maintenance task, Data Defragmentation and Routine Vacuuming, Vacuum, Vacuum Full, Vacuumdb Utility, Preventing Transaction ID Wraparound Failures, Autovacuuming, Routine Reindexing.

• Performance tuning of PostgreSQL Server.

• Monitor MYSQL Performance and IO.

• Production support on issues.
 

Must have skills:

· Proven experience in Database MY SQL relevant position

· Well-versed in technical/engineering

· Excellent verbal and written communication skills

· Excellent organizational and leadership skills.

· Good analytical/critical thinking.

· Procurement and negotiation skills.

· Good to have skills:

· Interpersonal, relationship-building

· The ability to multitask and prioritize your workload.

· Decision making

· Time management skills

· Project management skills

· The ability to draw information from various sources, including people.

· Clear and concise writing skills and the ability to handle long and complex documents.

· Teamwork skills and the ability to lead and motivate others.

· Hands on experience on cloud based PAAS databases.