Senior Redshift Developer

GovCIO; Salem (OR); Remote; USD 140,000 - 160,000; Full time

Job summary

A government IT services company is seeking a Senior Redshift Developer to support client needs. This remote position involves creating and maintaining complex stored procedures, database schemas, and ensuring compliance with standards. The ideal candidate has extensive Amazon Redshift and PL/SQL experience, along with strong communication skills. Join us in making a positive impact in government IT.

Benefits

Employee Assistance Program (EAP)

Corporate Discounts

Learning & Development platform

Training and Certification Assistance

Referral Bonus Program

Internal Mobility Program

Pet Insurance

Flexible Work Environment

Qualifications

• 12+ years of experience in IT.
• Extensive and recent Amazon Redshift database experience.
• 7-8 years of PL/SQL development experience.

Responsibilities

• Create and maintain complex stored procedures for Redshift.
• Analyze system issues and devise remediation plans.
• Conduct performance tuning of existing queries.

Skills

Amazon Redshift

PL/SQL

AWS

Excellent communication skills

Detail-oriented

Problem-solving

Team collaboration

Microsoft Office

Time management

Ability to multitask

Education

Bachelor’s Degree in a related field

Tools

SQL Developer

PuTTY

Shell Scripting

UNIX

Linux

Job description

Overview

GovCIO is currently hiring for a Senior Redshift Developer to support our client’s contract needs. This position is located in the Washington DC area and will be a full remote position.

Responsibilities

• 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 resolves 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 with 12+ years (or commensurate experience) in IT

Required Skills and Experience

• Extensive and recent Amazon Redshift database experience
• 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
• Excellent time management skills
• Ability to handle multiple tasks simultaneously
• Willingness to learn and acquire new knowledge

Clearance Required: 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.

Company Overview

GovCIO is a team of transformers--people who are passionate about transforming government IT. Every day, we make a positive impact by delivering innovative IT services and solutions that improve how government agencies operate and serve our citizens.

But we can't do it alone. We need great people to help us do great things - for our customers, our culture, and our ability to attract other great people. We are changing the face of government IT and building a workforce that fuels this mission. Are you ready to be a transformer?

What You Can Expect

Interview & Hiring Process

If you are selected to move forward through the process, here’s what you can expect:

• During the Interview Process
• Virtual video interview conducted via video with the hiring manager and/or team
• Camera must be on
• A valid photo ID must be presented during each interview
• During the Hiring Process
• Enhanced Biometrics ID verification screening
• Background check, to include:
• Criminal history (past 7 years)
• Verification of your highest level of education
• Verification of your employment history (past 7 years), based on information provided in your application

Employee Perks

At GovCIO, we consistently hear that meaningful work and a collaborative team environment are two of the top reasons our employees enjoy working here. In addition, our employees have access to a range of perks and benefits to support their personal and professional well-being, beyond the standard company offered health benefits, including:

• Employee Assistance Program (EAP)
• Corporate Discounts
• Learning & Development platform, to include certification preparation content
• Training, Education and Certification Assistance*
• Referral Bonus Program
• Internal Mobility Program
• Pet Insurance
• Flexible Work Environment

*Available to full-time employees

Our employees’ unique talents and contributions are the driving force behind our success in supporting our customers, which ultimately fuels the success of our company. Join us and be a part of a culture that invests in its people and prioritizes continuous enhancement of the employee experience.

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, disability, or status as a protected veteran. EOE, including disability/vets.

Posted Pay Range

The posted pay range, if referenced, reflects the range expected for this position at the commencement of employment, however, base pay offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, education, experience, and internal equity. The total compensation package for this position may also include other compensation elements, to be discussed during the hiring process. If hired, employee will be in an “at-will position” and the GovCIO reserves the right to modify base salary (as well as any other discretionary payment or compensation program) at any time, including for reasons related to individual performance, GovCIO or individual department/team performance, and market factors.

Posted Salary Range

USD 140,000.00 - USD 160,000.00 /Yr.

Location: US-Remote

ID: 2025-6555

Category: Data Services

Position Type: Full-Time