RedShift Developer

Seneca Resources; Fairfax (VA); Remote; USD 68,880 - 75,768; Full time

Job summary

A leading IT services firm is seeking a Remote RedShift Developer responsible for managing database schemas and enhancing applications. Candidates should have over 10 years of IT experience, substantial knowledge of Amazon Redshift, and a Bachelor's degree in a relevant field. The role requires excellent communication skills and the ability to tackle complex technical challenges while working independently or as part of a team.

Qualifications

• 10+ years of experience in IT.
• 7-8 years of PL/SQL development experience.
• Strong attention to detail in high-pressure situations.

Responsibilities

• Create and maintain complex stored procedures/packages for Redshift.
• Perform code reviews and bug fixing.
• Conduct performance tuning of existing queries and packages.

Skills

Amazon Redshift experience

PL/SQL development

UNIX Shell scripting

AWS experience

Excellent written and oral communication

Education

Bachelor’s Degree in Business, Computer Science, Information Systems, or related field

Tools

SQL Developer

PuTTY

Microsoft Office

Job description

Overview

Job title: RedShift Developer

Location: (REMOTE) Chantilly VA 22033

Type: Contract

Rate: $50/hr on W2

Base pay range

$50.00/hr - $55.00/hr

Responsibilities

• Recent Amazon Redshift experience
• Create and maintain complex stored procedures/packages for Redshift
• Create and maintain database schemas for Redshift
• Create and maintain partitions in oracle to facilitate query performance and data maintenance
• Maintain the existing applications and enhance the system as per client requirements
• Modify existing procedures/packages to incorporate new functionalities
• UNIX Shell scripting
• Analyze system issues and devise and execute remediation plans
• Perform code reviews and bug fixing
• Conduct performance tuning of existing queries and packages
• Comply with all required standards and processes and devise approach to ensure compliance across the team
• Provide complete technical and maintenance support to the systems
• Run the assigned projects solo as well as working as a team
• Use of Redshift, PL/SQL, SQL Developer, PuTTY, Shell Scripting, UNIX, and Linux
• Interact directly with the customer on behalf of the team to resolve issues or identify new requirements to be addressed by the team

Qualifications

• Bachelor’s Degree in a Business, Computer Science, Information Systems, or related field
• 10 plus years of experience in IT
• Experience with Redshift database
• AWS Experience
• 7-8 years of PL/SQL development experience
• Excellent written and oral communication skills
• Understanding and knowledge of Software Development Life Cycle
• Maintains strong attention to detail in high-pressure situations
• Exhibit confidence and knowledge in solving problems
• Work well independently and within a team
• Proficient in Microsoft Office
• Ability to handle multiple tasks simultaneously
• Willingness to learn and acquire new knowledge
• Able to obtain a Public Trust Clearance and must have been within US for the last 5 years with no cumulative travel outside the US exceeding 6 months

Employment details

• Seniority level: Mid-Senior level
• Job function: Information Technology
• Industries: IT Services and IT Consulting

Referrals increase your chances of interviewing at Seneca Resources by 2x

Get notified about new Development Specialist jobs in Fairfax, VA.