Employer Active
Job Alert
You will be updated with latest job alerts via emailJob Alert
You will be updated with latest job alerts via emailPostgre 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.
Full Time