Apply on Employer Site

SiloSmashers, Inc. · 2 weeks ago

PostgreSQL Database Administrator - Senior

Washington, DC

Full-time

Onsite

Senior Level

SiloSmashers, Inc. is seeking a Senior PostgreSQL Database Administrator to design and implement database architectures that support business requirements. The role involves overseeing the installation, configuration, and maintenance of PostgreSQL databases while ensuring high performance, availability, and security.

ConsultingInformation Technology

Responsibilities

Design and implement database architectures that support business requirements and achieve high performance, availability, and security

Oversee the installation, configuration, and maintenance of PostgreSQL databases

Conduct performance tuning of database systems, including queries, stored procedures, and indexing strategies

Develop and implement database backup, recovery, and failover procedures

Assist in the design and development of data models and database solutions

Collaborate with development teams to optimize database code in application layers

Provide guidance on database best practices to IT staff and other stakeholders

Ensure database infrastructure is up-to-date with the latest technology trends and security patches

Develop and maintain documentation regarding database configurations, architectures, and procedures

Serve as the point of contact for database-related queries and technical support

Qualification

PostgreSQL administrationSQLPL/pgSQLLinux/UnixDatabase designHigh availabilityDisaster recoveryPostgreSQL certificationCloud servicesContainerization technologiesAnalytical skillsOther database systemsProblem-solving skillsCommunication skillsMentoring skills

Required

Bachelor's or Master's degree in Computer Science, Information Technology, or a related field

Strong expertise in PostgreSQL database administration, tuning, management, and security

Proficiency in SQL and experience with PL/pgSQL or similar procedural language

Familiarity with database design, documentation, and coding

Previous experience with Linux/Unix and scripting languages such as Bash, Python, or Perl

Knowledge of high availability and disaster recovery options for PostgreSQL

Good understanding of hardware performance, memory and I/O

Strong analytical and problem-solving skills

Excellent communication and mentoring skills

Preferred

PostgreSQL certification (e.g., PostgreSQL Certified Engineer)

Experience with cloud services (AWS, Azure, OCI) and containerization technologies (Docker, Kubernetes)

Familiarity with other database systems (e.g. Oracle and MSSQL)

Company

SiloSmashers, Inc.

SiloSmashers is an industry leading strategy, management, and technology consulting firm, with depth of knowledge and expertise, and a proven methodology that enables customers to break down organizational silos, and increase communications and collaboration, to achieve Peak Performance® and mission success.

Founded in 1992