LOGIN
No products in the cart.

Postgres SQL

Centilytics

Classified Job

Experience

1-3 Years

Salary

10-15 Lakhs

Location

Uttar Pradesh- Noida

Posted - 749 days ago

Applications - 28

Vacancies- 1

Continue With Google

Top Hiring Companies

Join the team as a Full Time Postgres SQL on Erekrut, specializing in Postgres SQL in the IT-ITeS industry. We are seeking talented individuals with a passion for IT Services and educational qualifications ranging from 1-3 Years. Apply now on Erekrut to take the next step in your career with a leading global company.

Job Description

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.

Designation

Postgres SQL

Key Skills

Analytical SkillsPostgreSQLProject ManagementSQLTime managementTroubleshooting Skills

Industry

IT-ITeS

Functional Area

IT Services

Employment Type

Full Time

Education

Bachelor Degree

Job Type

AnalyticalPostgreSQLProject

Apply Now

Postgres SQL

Top Hiring Companies

Job Description

Designation

Key Skills

Industry

Functional Area

Employment Type

Education

Job Type

Assessment Details

SQL Developer Quiz

Related Jobs

Executive Assistant

Sales Engineer (B2B)

Inside Sales Executive

Sales Force (Education –...

GCP Architect

Designer- UI/UX & Graphic

Sales & Campaign Speciali...

AI Video Editor / AI Filmmaker

Top Hiring Companies

Top Locations

Top Skills

Top Sectors