PostgreSQL DBA (Only W2)

CBTS Technology Solutions LLC
Chelsea, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 162K

Job location

Chelsea, United States of America

Tech stack

Amazon Web Services (AWS)
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Apache HTTP Server
Unit Testing
Data as a Services
Digital Assets
Hive
Identity and Access Management
PostgreSQL
Performance Tuning
Query Optimization
SQL Databases
S3 Bucket
Data Lake
Git Flow
Databricks

Job description

  • Operate Redshift clusters, Databricks workspaces, RDS/Aurora PostgreSQL instances, and supporting AWS infrastructure
  • Perform user/security tasks across platforms: Redshift user/group management, Databricks Unity Catalog access controls, IAM Roles/Policies, RDS parameter and access management
  • Design and maintain open table format data lakes using Apache Iceberg on S3, including compaction, snapshot management, partition strategies, and schema evolution
  • Profile production workloads and develop strategies to run optimized clusters and workspaces with scale and efficiency
  • Provide architecture guidance and support to technical leads; help develop code and SQL for data assets, identify performance tuning opportunities, and work with developers to improve production systems
  • Contribute to and maintain automation scripts and internal tooling with production-quality code standards (unit tests, peer review, documentation, Git-based workflows)
  • Develop monitoring and recovery automation to identify and resolve issues to meet our high SLA
  • Research new technologies and develop proofs of concept; propose technical improvements and new capabilities

Requirements

  1. Experience with AWS data services: Redshift, RDS/Aurora PostgreSQL, S3, EC2, Athena, Glue, Lake Formation

a. 3+ years

  1. Experience with Databricks: workspace administration, Unity Catalog, cluster management, Spark SQL, Delta Live Tables or similar

a. 2+ years

  1. Experience with PostgreSQL or Aurora PostgreSQL: query tuning, replication concepts, pg_stat views, parameter groups

a. 2+ years

  1. Experience with AWS Security: IAM (Users, Groups, Roles, Policies, Instance Profiles), Redshift/RDS security, S3 bucket policies

a. 2+ years

Apply for this position