Logo
JSR Tech Consulting

Redshift and Postgres Database administrator (DBA)

JSR Tech Consulting, Newark, New Jersey, us, 07175

Save Job

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

Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr