Roles and Responsibilities
Evaluate and analyze custom PostgreSQL server programs/T-SQLs for high performance issues
Create PostgreSQL objects like Tables, Views, Indexes, Stored Procedures, Triggers, Rules, Defaults and user defined functions and Extensive Knowledge of advance query concepts that includes Dynamic PostfreSQL scripting, Recursive CTE and Partitioning management
Hands on Advance PostgreSQL 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 PostgreSQL server for improved performance
Proficient in tuning queries using PostgreSQL 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 PostgreSQL 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
Monitor PostgreSQL Performance and IO
Production support on issues
Skillsets:
3 plus years of experience as PostgreSQL server DBA
Knowledge on AWS or Azure is a plus
Knowledge on MOngoDB is a plus
Working in 24/7 critical environment
AWS or Azure PostgreSQL Development knowledge
Excellent written and verbal communication skills.
Experience in database backup & restore activities.