PostgreSQL DBA (Only W2)

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