Senior Database Administrator - Pipeline

Senior Database Administrator Key Responsibilities

Administered and optimized Snowflake environments, including schema creation, table setup, user management, warehouse scaling, performance tuning, backups, and monitoring disk/query performance.

Manage replication processes using tools like FiveTran or HVR, including creating locations and channels, monitoring agents, analyzing latency, and ensuring smooth replication flow.

Maintain and optimize traditional RDBMS platforms (Oracle, DB2, SQL Server), handling tasks such as user/schema setup, pipeline management, backups, reorgs, runstats, rebinds, and indexing strategies.

Write and troubleshoot complex SQL queries (T-SQL preferred) and develop Python scripts for automation, performance analysis, and workflow orchestration.

Manage Snowflake and related database environments within AWS, leveraging services like RDS, DMS, S3, Glue, DocumentDB, DynamoDB, and Redis.

Collaborate with data engineering, security, and application teams to ensure database reliability, security, and performance.

Document database configurations, processes, and troubleshooting steps comprehensively to support team knowledge sharing and compliance.

Participate in on-call rotations and off-hours deployments as needed. Required Skills and Qualifications Database Administration (50%)

Extensive experience in Snowflake administration, including end-to-end ownership of schema creation, table setup, user management, performance tuning, warehouse scaling, backups, and troubleshooting query/disk performance issues.

Strong hands-on experience with replication tools (FiveTran or HVR), including creating locations/channels, monitoring agents, and analyzing replication latency.

Proven expertise in at least one RDBMS platform:

Oracle: User/schema setup, pipeline management.

DB2 (On-Prem): Hands-on experience with AIX/DB2 utilities (backup, reorg, runstats, rebind).

SQL Server: Familiarity with general usage and indexing strategies. Technical and Cloud Skills (50%)

Strong SQL skills (T-SQL preferred) for writing and optimizing complex queries.

Proficiency in Python for automation, performance analysis, and workflow orchestration.

Experience with AWS services (RDS, DMS, S3, Glue, DocumentDB, DynamoDB, Redis) in managing Snowflake and other database environments.

Exposure to DevOps practices, including version control tools (e.g., Git) and working in SDLC/Agile environments. Additional Considerations

Experience with AWS DMS for database migrations is a plus.

Background in the Property & Casualty (P&C) insurance industry is advantageous.

Prior involvement in on-prem to cloud database migrations is highly valued.

Candidates must be local to Central New Jersey to facilitate collaboration and occasional on-site work. Why Join Us?

This role offers an opportunity to join a high-performing team of DBAs managing a hybrid database infrastructure that powers critical business operations. You ll work with modern cloud platforms like Snowflake and AWS, contribute to infrastructure modernization, and collaborate with a forward-thinking team dedicated to excellence in data management and innovation.

What is a Pipeline Job?

These roles represent future opportunities we've uncovered through our client discussions. We have stripped away the rigid Must Haves, Mandatories, and Required criteria to find the right fit for their needs. By applying for these future roles, we will complete our human-centered process to see if you are a fit while adding your profile to our database to be considered for additional openings. When you apply, rest assured a human will thoroughly review your resume and respond to you personally. We take pride in finding the right match for each job, valuing your unique talents and potential over just what's on your resume.