OverviewA 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.ResponsibilitiesDesign, 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 QualificationsBachelors 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.ClearanceMust 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.