Database Administrator III(no third party, only W2)
Job Description
Job Description:
\n
Pay Rate: $70/hour - $75/hour on W2
\n
Boston MA or NYC any of the location is fine.
\n
Must Have Skills / Requirements
\n
1) Experience with AWS data services: Redshift, RDS/Aurora PostgreSQL, S3, EC2, Athena, Glue, Lake Formation
\n
a. 3+ years
\n
2) Experience with Databricks: workspace administration, Unity Catalog, cluster management, Spark SQL, Delta Live Tables or similar
\n
a. 2+ years
\n
3) Experience with PostgreSQL or Aurora PostgreSQL: query tuning, replication concepts, pg_stat views, parameter groups
\n
a. 2+ years
\n
4) Experience with AWS =Security: IAM (Users, Groups, Roles, Policies, Instance Profiles), Redshift/RDS security, S3 bucket policies
\n
a. 2+ years
\n
Nice to Have Skills / Preferred Requirements
\n
1) PySpark for data pipeline development
\n
2) AWS Glue with Iceberg or Delta Lake integration
\n
3) Snowflake administration
\n
4) Terraform or AWS CDK for infrastructure as code
\n
5) DynamoDB experience
\n
6) Feature Store
\n
Soft Skills:
\n
1) Ability to read, understand, debug, and extend complex Python codebases; comfort navigating large repositories with multiple modules and abstractions
\n
2) Strong analytical and critical thinking skills
\n
3) Ability to lead projects, prioritize, and multitask
\n
4) Deadline and detail-oriented
\n
5) Part of on-call rotation
\n
Technology Requirements:
\n
1) Experience with Apache Iceberg on S3: partition management, compaction, snapshot management, schema evolution
\n
2) 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
\n
3) Experience automating database and platform operations using Python, Jenkins, Airflow, Datadog and Git