Logo
SPECTRAFORCE

Database Administrator

SPECTRAFORCE, Newark, New Jersey, us, 07175

Save Job

Get AI-powered advice on this job and more exclusive features. This range is provided by SPECTRAFORCE. Your actual pay will be based on your skills and experience talk with your recruiter to learn more. Base pay range

$90.00/hr - $100.00/hr Direct message the job poster from SPECTRAFORCE Senior Recruiter at SPECTRAFORCE Technologies

Job Title: Database Administrator Location: Newark, NJ (Hybrid - Tues, Wed, Thurs) Duration: 6 Months Who We Look For: In PGIM Fixed Income, our technology group is a dynamic, fast-paced environment, with exciting changes under way. We are looking for a senior DBA to align with technology leaders in administering cloud databases across Fixed Income. Our ideal candidate will have proven experience in designing, configuring, and managing large scale Redshift & Aurora Postgres databases on AWS. 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 Bachelors 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

Information Services Referrals increase your chances of interviewing at SPECTRAFORCE by 2x Sign in to set job alerts for Database Administrator roles.

Database Administration, Emerging Talent Intern

Woodbridge, NJ $85,000.00-$130,000.00 10 hours ago Edison, NJ $89,586.00-$255,944.00 1 month ago New York, NY $64,000.00-$120,000.00 1 week ago Bedminster, NJ $97,692.00-$143,000.00 1 month ago New York, NY $70,000.00-$130,000.00 8 months ago Manhattan, NY $150,000.00-$170,000.00 1 month ago Ridgefield Park, NJ $35.00-$40.00 1 week ago Oracle Database Administrator (RAC/DataGuard) - to 165k

New York, NY $130,000.00-$165,000.00 21 hours ago Jersey City, NJ $100,000.00-$125,000.00 1 week ago New York, NY $65,000.00-$70,000.00 2 weeks ago Executive Director, SQL Infrastructure and Operations

New York, NY $150,000.00-$200,000.00 3 weeks ago Database Administration, Emerging Talent Intern

New York, NY $100,000.00-$120,000.00 2 weeks ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr