Job Description:
Overview
A Senior Redshift Developer is needed to support client contract requirements. This is a full-time, fully remote position based in the Washington, D.C. area.
Responsibilities
-
Design, develop, and maintain complex Redshift stored procedures, packages, and schemas.
-
Create and manage partitions to improve query performance and data maintenance.
-
Maintain and enhance existing applications to meet client requirements.
-
Modify existing procedures/packages to add new functionality.
-
Perform performance tuning for queries and packages.
-
Develop and maintain UNIX shell scripts.
-
Analyze system issues, implement remediation plans, and provide long-term solutions.
-
Conduct code reviews, debugging, and bug fixing.
-
Ensure compliance with required standards, processes, and best practices.
-
Provide complete technical and maintenance support for systems.
-
Manage assigned projects independently and collaboratively within a team.
-
Utilize Redshift, PL/SQL, SQL Developer, PuTTY, Shell Scripting, UNIX, and Linux.
-
Communicate directly with customers to resolve issues and gather new requirements.
Required Qualifications
-
Bachelors degree in Computer Science, Information Systems, Business, or related field with 12+ years of IT experience (or equivalent).
-
Extensive, recent Amazon Redshift database experience.
-
78 years of PL/SQL development experience.
-
AWS experience.
-
Strong understanding of the Software Development Life Cycle (SDLC).
-
Excellent written and verbal communication skills.
-
Strong problem-solving skills and attention to detail in high-pressure environments.
-
Proficiency with Microsoft Office Suite.
-
Ability to manage multiple tasks and projects simultaneously.
-
Self-motivated, adaptable, and eager to learn new technologies.
Clearance
-
Must be able to obtain a Public Trust clearance.
-
Must have resided in the U.S. for the last 5 years with no cumulative travel outside the U.S. exceeding 6 months.