Redshift and Postgres Database administrator (DBA)

JSR Tech Consulting; Newark (NJ); Hybrid; USD 123,984 - 172,200; Part time

Job summary

A tech consulting firm is seeking a Redshift and Postgres Database Administrator to enhance database performance and manage AWS databases. This role requires 7+ years of RDBMS experience, hybrid work in Newark, NJ, and offers a pay rate of $90-$125/hr. Ideal candidates will have strong skills in database design and scripting along with a Bachelor's degree in a related field.

Qualifications

• 7+ years of experience in RDBMS database administration.
• 3+ years of hands-on experience with Redshift & Postgres on AWS.
• Strong knowledge of AWS security concepts.

Responsibilities

• Lead the configuration and implementation of Redshift & Aurora Postgres clusters.
• Design strategies to improve database performance.
• Develop scripting solutions to automate database tasks.

Skills

Database design

AWS Redshift

Postgres

Bash scripting

Agile methodologies

Communication skills

Education

Bachelor's degree in computer science or related field

Tools

GIT

Jira

Confluence

Job description

Redshift and Postgres Database administrator (DBA)

Join to apply for the Redshift and Postgres Database administrator (DBA) role at JSR Tech Consulting

Redshift and Postgres Database administrator (DBA)

Join to apply for the Redshift and Postgres Database administrator (DBA) role at JSR Tech Consulting

Database Administrator

Hybrid in Newark, NJ(Tues, Wed, Thurs)

payrate - 90 - 125 / hr

What You Will Do:
• Lead the configuration, design, and implementation of large-scale Redshift & Aurora Postgres database clusters on AWS
• Design indexing, query tuning and partitioning strategies to improve database performance and reduce SQL query response times
• Design and implement solutions to migrate data from large on-prem SQL databases to Redshift databases in AWS
• Develop scripting solutions to automate operational database tasks (DDL/DML deployment, security management and database maintenance)
• Implement proactive monitoring and maintenance solutions to improve reliability and scalability of Redshift & Aurora Postgres databases
• Partner with architecture and engineering teams in the design, development, and implementation of new AWS database applications
• Collaborate with engineering and support teams in defining, documenting, and evangelizing database best practices

What You Will Need:
• 7+ years of experience in the architecture, design, and administration of large-scale RDBMS database systems
• 3+ years of hands-on experience in the design, implementation, and management of multi-node Redshift & Aurora Postgres database clusters on AWS
• Strong experience in database schema design, use of sort keys and distribution keys in Redshift and indexing strategies in Aurora Postgres
• Strong knowledge of security related concepts in AWS databases (IAM roles, users, policies, temporary credentials, and security groups)
• Hands-on experience with bash scripting and source code management tools such as GIT
• Experience with Agile methodologies (Kanban/Scrum) including tools such as Jira and Confluence
• Excellent written and verbal communication skills
• Bachelor's degree in computer science or a related field.

What We Would Love to See:
• Experience with financial services datasets across investment, product and distribution functions.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at JSR Tech Consulting by 2x

Get notified about new Database Administrator jobs in Newark, NJ.

Database Administrator - Leading Hedge Fund - New York

New York, NY $130,000.00-$170,000.00 1 day ago

Certified IT Administrator (Database), III

New York City Metropolitan Area 1 week ago

New York, NY $89,301.33-$114,816.00 1 week ago

New York City Metropolitan Area 20 hours ago

New York, NY $77,000.00-$155,000.00 2 weeks ago

New York, NY $89,301.33-$121,194.66 2 weeks ago

New York, NY $114,816.00-$165,845.33 2 weeks ago

Iselin, NJ $77,000.00-$155,000.00 2 weeks ago

New York, NY $133,800.00-$161,200.00 3 months ago

New York, NY $77,000.00-$150,000.00 1 week ago

New York, NY $70,000.00-$130,000.00 9 months ago

Manhattan, NY $150,000.00-$170,000.00 2 months ago

Oracle Database Administrator - Contract to hire

Oracle Database Administrator (RAC/DataGuard) - to 165k

New York, NY $130,000.00-$165,000.00 1 day ago

Senior Discovery Database Administrator (DBA) (Top Secret Clearance Required)

New York, NY $182,700.00-$263,900.00 2 weeks ago

New York, NY $65,000.00-$70,000.00 1 month ago

Executive Director, SQL Infrastructure and Operations

New York, NY $150,000.00-$200,000.00 1 month ago

New York, NY $100,000.00-$120,000.00 2 weeks ago

New York City Metropolitan Area 1 week ago

Discovery Database Administrator (DBA) (Top Secret Clearance Required)

New York, NY $142,100.00-$192,850.00 2 weeks ago

DATABASE APPLICATION DEVELOPER/REPORT DESIGNER

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.