Experience
Salary
Location
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.
Postgres SQL
IT-ITeS
IT Services
Full Time
Bachelor Degree
Work From Office
10 Minutes
Mahi Hr Solution Pvt Ltd
Join the Mahi Hr Solution Pvt Ltd team as a Full Time Executive Assistant on Erekrut, specializing in Executiv...
3-6 Lakhs
1-3 Years
Uttar Prad..
Personal Ass...
Ambica
Join the Ambica team as a Full Time Accountant (Female) on Erekrut, specializing in Accountant (Female) in the...
0-3 Lakhs
1-3 Years
Gujarat-Ah..
Accounting
Santa Eventz & Exhibitions Private Limited
Join the Santa Eventz & Exhibitions Private Limited team as a Full Time Customer Support on Erekrut, specializ...
0-3 Lakhs
1-3 Years
Uttar Prad..
Customer Sup...
Mahi Hr Solution Pvt Ltd
Join the team as a Full Time PG Manager on Erekrut, specializing in P G Manager in the Hostel and PG industry...
0-3 Lakhs
0-1 Years
Uttar Prad..
Administrati...
Avsar Ventures
Join the Avsar Ventures team as a Full Time Customer Support on Erekrut, specializing in Customer Support in t...
3-6 Lakhs
1-3 Years
Uttar Prad..
Customer Sup...
K Drama
Join the team as a Full Time Data entry Executive on Erekrut, specializing in Data entry Executive in the Ban...
3-6 Lakhs
1-3 Years
Uttar Prad..
Accounting
Nation Wide Consultancy
Join the Nation Wide Consultancy team as a Full Time Team Manager on Erekrut, specializing in Team Manager in ...
6-10 Lakhs
4-6 Years
Delhi-Nort..
Banking
Nation Wide Consultancy
Join the Nation Wide Consultancy team as a Full Time Virtual Relationship Manager on Erekrut, specializing in ...
3-6 Lakhs
1-3 Years
Delhi-Nort..
Customer Sup...