Job Title: Data Engineer / Database Administrator

Company Name: Pivotly

Job Url: https://www.simplyhired.com/job/Rtq8CQ-s000q5mJtDeB_SB0GNu2CaYTEu-unXI22iXW95QKmIzaibA

Job Description: Data Engineer / Database Administrator (PostgreSQL / Snowflake)
Pivotly
Remote

Job Details
Full-time
Qualifications
Data storage
Data Integration (Data management)
Cloud data warehouses
Automation
Technical documentation
Database backup and recovery
Data structures
IT system monitoring
High availability architecture
NoSQL
Mid-level
Scalable systems
Database security management
Snowflake
Bash
SQL
AWS
Docker
Scalability
JSON
Technical troubleshooting support
RDS database
BigQuery
Python
PowerShell
High availability
System performance monitoring
IT disaster recovery planning
Full Job Description
Overview
We are seeking a skilled Data Engineer / Database Administrator with strong experience in PostgreSQL / Snowflake. The ideal candidate will have hands-on expertise in Dynamic DDL and DML, managing complex database operations, and working with JSON data structures in PostgreSQL. This role involves ensuring database performance, reliability, and scalability while supporting development and data-driven initiatives across the organization.

Responsibilities

Design, implement, and manage PostgreSQL and Snowflake databases.
Develop and optimize Dynamic DDL and DML scripts for flexible schema and data operations.
Work extensively with JSON data in PostgreSQL (storage, indexing, querying, transformation).
Ensure data integrity, security, and high availability across environments.
Monitor, troubleshoot, and optimize database performance (queries, indexes, execution plans).
Collaborate with developers and analysts to support ETL processes, data pipelines, and reporting needs.
Maintain backup, recovery, and disaster recovery strategies.
Document processes, configurations, and database standards.
Requirements

Proven experience with PostgreSQL and Snowflake administration and development.
Strong knowledge of Dynamic DDL and DML scripting.
Hands-on experience working with JSON data structures in PostgreSQL.
Solid understanding of SQL query optimization and performance tuning.
Experience in database security, roles, and permissions management.
Familiarity with ETL processes, data pipelines, and integration with applications.
Strong troubleshooting and problem-solving skills.
Nice to Have

Experience with cloud-hosted databases (AWS RDS, Snowflake, GCP BigQuery).
Knowledge of NoSQL or hybrid databases.
Familiarity with containerization and orchestration tools (Docker, Kubernetes).
Exposure to automation scripts for database operations (Python, Bash, PowerShell).
Job Type: Full-time

Work Location: Remote