Skip to content

Senior Database Administrator - Pipeline

Woodbridge, NJ 07095

Employment Type: Contract Expertise: Data and Business Analytics Job Number: 24106 Pay Range:

Job Description

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.


 
Apply Online

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

About Woodbridge, NJ

Ready to embark on a fulfilling career journey in Woodbridge, New Jersey? This vibrant area nestled in Middlesex County is brimming with job opportunities and endless possibilities for professional growth. From the picturesque landscapes of Merrill Park to the bustling atmosphere of Woodbridge Center Mall, there's something for everyone in this thriving community. Take a stroll through the artsy Downtown Woodbridge and catch a show at the historic State Theatre. Indulge in a delicious slice of Woodbridge's famous pizza or explore the diverse culinary scene that lines Main Street. Join our team and discover why Woodbridge is not just a place to work, but a place to thrive. Explore our job listings today and kickstart your career in this charming and bustling region!