Job Details

ID #45459553
State Colorado
City Denver
Job type Permanent
Salary USD $DOE DOE
Source TekShapers
Showed 2022-09-05
Date 2022-09-05
Deadline 2022-11-04
Category Et cetera
Create resume

Postgre SQL DBA

Colorado, Denver, 80265 Denver USA

Vacancy expired!

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.

Vacancy expired!

Subscribe Report job