SQL Developer

Remote Opportunity

US Citizenship Required

We are looking for a mid mid level SQL Developer to support a long term contract working with the VA. This is fully remote opportunity!

The SQL Developer conceives, designs, and tests logical structure to meet program requirements. Writes programs according to specifications provided. Builds, deploys and maintains programs, Web Site pages and applications. Develops and improves site navigation and applications. Responsible for the design, development, and configuration of software systems to meet market and/or client requirements. Updates, repairs, modifies, and expands existing computer programs. Writes, tests, and maintains computer programs. Develops code using Java, C#, HTML, Javascript, or other programming languages.

Job Responsibilities

* performing day to day querying and analysis using SQL queries and procedures, and script execution to enhance understanding of data within a consolidated data store.
* considering amorphous problem sets or functional requirements to determine path forward on creating the query to support end user business needs.
* migration of queries, including conversion of syntax, from Postgres DB to a Redshift data store.
* develop materialized views, stored procedures and scheduled queries
* analyze existing queries for performance improvement and optimize runtime against Redshift database.
* provide upskilling to team members and knowledge share usability and optimization techniques.
* Develops required specifications for simple to moderately complex programs or problems.
* Conducts systems tests, monitors test results, and takes appropriate corrective action for the non-routine issues.
* Creates coded unit tests and works with Testers/Information Assurance to address program and/or security findings.
* Prepares required documentation, including block diagrams, logic flow charts and software program documentation.

Minimum Qualifications

Bachelor's Degree in Computer Science, Information Systems or a related field or equivalent relevant experience.
2-5 years of experience with programming or web development activities.

Other Job Specific Skills

* SQL, PL/SQL, PL/pgSQL.
* PostgresSQL, Oracle.
* Liquibase.
* Performance tuning.
* Replication.
* User Maintenance.
* Ability to multi-task, work well under pressure, and work in a closed environment with others.
* Maintains current knowledge of relevant technology.
* Strong problem solving, logic, and analytic skills.
* Applies knowledge of technologies, applications, methodologies, processes and tools to support a client, project or entity.
* Familiar with and utilized best programming standards and practices in a professional capacity.