Database Administrator III(no third party, only W2)
CBTSNew York, United States
ContractOn-siteMid$145,600 - $145,600 / YearLimited info disclosed
42 views0 applications
Description
Job Description: Pay Rate: $70/hour - $75/hour on W2 Boston MA or NYC any of the location is fine. Must Have Skills / Requirements
- Experience with AWS data services: Redshift, RDS/Aurora PostgreSQL, S3, EC2, Athena, Glue, Lake Formation a. 3+ years
- Experience with Databricks: workspace administration, Unity Catalog, cluster management, Spark SQL, Delta Live Tables or similar a. 2+ years
- Experience with PostgreSQL or Aurora PostgreSQL: query tuning, replication concepts, pg_stat views, parameter groups a. 2+ years
- Experience with AWS =Security: IAM (Users, Groups, Roles, Policies, Instance Profiles), Redshift/RDS security, S3 bucket policies a. 2+ years Nice to Have Skills / Preferred Requirements
- PySpark for data pipeline development
- AWS Glue with Iceberg or Delta Lake integration
- Snowflake administration
- Terraform or AWS CDK for infrastructure as code
- DynamoDB experience
- Feature Store Soft Skills:
- Ability to read, understand, debug, and extend complex Python codebases; comfort navigating large repositories with multiple modules and abstractions
- Strong analytical and critical thinking skills
- Ability to lead projects, prioritize, and multitask
- Deadline and detail-oriented
- Part of on-call rotation Technology Requirements:
- Experience with Apache Iceberg on S3: partition management, compaction, snapshot management, schema evolution
- Proficiency in Python for automation and shared tooling: object-oriented design, writing maintainable and testable code, participating in code review, and contributing to a shared Git-based codebase
- Experience automating database and platform operations using Python, Jenkins, Airflow, Datadog and Git