What are the responsibilities and job description for the PostgreSQL DBA (Only W2) position at CBTS?
Role: PostgreSQL DBA
Location: Boston, MA or NYC - Onsite, Hybrid
Pay Rate: $70-78/hour on W2, client will not consider C2C
Job Responsibilities / Typical Day in the Role
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
Must Have Skills / Requirements
1) Experience with AWS data services: Redshift, RDS/Aurora PostgreSQL, S3, EC2, Athena, Glue, Lake Formation
a. 3 years
2) Experience with Databricks: workspace administration, Unity Catalog, cluster management, Spark SQL, Delta Live Tables or similar
a. 2 years
3) Experience with PostgreSQL or Aurora PostgreSQL: query tuning, replication concepts, pg_stat views, parameter groups
a. 2 years
4) Experience with AWS Security: IAM (Users, Groups, Roles, Policies, Instance Profiles), Redshift/RDS security, S3 bucket policies
a. 2 years
Salary : $75 - $78