Postgre SQL DBA

Postgre SQL DBA

Role Description - Summary:

As a part of a technical team, You will design, implement, administer, and maintain databases including monitoring, backup and recovery procedures, performance tuning and implementing database change management. This role requires familiarity with both PostgreSQL on Linux/Unix/Windows based environments. The role holder promotes teamwork between Development and Operations teams. The DBA ensures principals with data design, stewardship, and acts as a data guardian. Builds should be scripted as much as possible, and these scripts are managed in a source control system

Responsibilities/Tasks:

Design logical and physical databases, review database design to understand how changes to be made would affect physical database

Establish physical database parameters, codes database objects/queries and specifies database identifiers to DBMS or guide others in coding best practices

Participate in the management and operations of PostgreSQL deployments

Works in partnership with development resources to code, test, and implement database solution according to defined/org standards

Define, develop and implement best practices for DR and Backups

Defining and implement maintenance plan for the database systems

Work with case tracking tools

Specify user access level

Tests and corrects errors (i.e. queries, views, stored procedures/functions, triggers etc.), and refine changes to database configuration

Ensure that database systems are available, secure, and that production support procedures are well documented

Leverage scripting and automation technologies to improve speed of delivery

Other duties as required by the position

Experience/Exposure:

You must have at least 8+ years' of hands-on experience in similar role.

Solid understanding of database design principals

Hands-on expertise with performance tuning, high-availability (HA) and data warehousing

Experience with Data modeling tools

Experience with developing stored procedures/queries/triggers/views etc. using SQL scripting languages

Expertise with Windows/Linux Operating Systems and cloud hosting providers (Azure/AWS etc.)

Automation and configuration management tools

Backup and recovery , security and Monitoring applications

Knowledge of development process, tools and technologies

Problem-solving skills and ability to thrive in a fast-paced, deadline-sensitive environment

Relevant certifications would be an added advantage.