What are the responsibilities and job description for the PostGresSQL Senior Developer position at TEKsystems c/o Allegis Group?
Job Details
Description
SQL/PostGresSQL/PL/SQL Developer
Job Description:
We are looking for a seasoned PL/pgSQL Developer with extensive experience in PostgreSQL to join our team and take a leading role in the design, development, and optimization of our database systems. The ideal candidate will have extensive experience with relational databases, strong skills in writing complex queries, and a proven track record in database schema design and performance tuning.
Key Responsibilities:
Design and develop robust PL/pgSQL, procedures, functions, and triggers to meet business requirements.
Design and optimize PostgreSQL databases to ensure high performance and scalability.
Collaborate with application developers to integrate databases with backend systems.
Perform data analysis and generate complex queries to meet business needs.
Implement and maintain data integrity, security, and performance optimization.
Troubleshoot database issues and ensure minimal downtime.
Create and maintain database documentation, including ER diagrams and schema designs.
Stay updated with PostgreSQL advancements and suggest improvements to the database ecosystem.
Required Experience:
3 years of experience working with PostgreSQL and PL/pgSQL development or similar RDBMS products
Strong understanding of relational database design and normalization.
Proficiency in writing complex SQL queries, CTEs, and advanced indexing strategies.
Experience in performance tuning, including optimization of complex queries and database servers.
Knowledge of data backup, recovery, security, integrity, and SQL.
Familiarity with AWS technologies and their application in database solutions is highly desirable.
Experience in Liquibase or flyway is a plus
Additional Skills:
Experience with Agile development methodologies.
Experience in continuous integration processes for database code.
Excellent analytical, problem-solving, and organizational skills.
Ability to handle multiple tasks in a fast-paced environment.
Strong communication skills and the ability to work effectively in a team.
Three-day in-office hybrid work schedule at ETS, Princeton
Skills
sql, pl/sql, postgresql, database optimization, Devops, Amazon Web Services, Linux, Jenkins, security, Nodejs, Javascript, Server side, Ecmascript, Angular7
Additional Skills & Qualifications
NAEP Overview:
NAEP stands for National Assessment of Educational Progress. The National Assessment of Educational Progress (NAEP) is the largest national assessment provider for American students. NAEP academic assessments are the "Nation's Report Card" and are leveraged by local, state and federal agencies to measure and act upon a clear picture of student academic progress year over year.
ETS (Educational Testing Service) has developed applications, services, interactive 'item' (test question) development and reporting on behalf of the NCES since 1983 and is looking to upgrade the current NAEP website, NAEP Data Explorers and reporting to provide improved features, as well as, a tablet optimized user experience.
Pay and Benefits
The pay range for this position is $55.00 - $62.00/hr.
Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:
Medical, dental & vision
Critical Illness, Accident, and Hospital
401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available
Life Insurance (Voluntary Life & AD&D for the employee and dependents)
Short and long-term disability
Health Spending Account (HSA)
Transportation benefits
Employee Assistance Program
Time Off/Leave (PTO, Vacation or Sick Leave)
Workplace Type
This is a hybrid position in Princeton,NJ.
Application Deadline
This position is anticipated to close on Feb 3, 2025.
About TEKsystems:
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
SQL/PostGresSQL/PL/SQL Developer
Job Description:
We are looking for a seasoned PL/pgSQL Developer with extensive experience in PostgreSQL to join our team and take a leading role in the design, development, and optimization of our database systems. The ideal candidate will have extensive experience with relational databases, strong skills in writing complex queries, and a proven track record in database schema design and performance tuning.
Key Responsibilities:
Design and develop robust PL/pgSQL, procedures, functions, and triggers to meet business requirements.
Design and optimize PostgreSQL databases to ensure high performance and scalability.
Collaborate with application developers to integrate databases with backend systems.
Perform data analysis and generate complex queries to meet business needs.
Implement and maintain data integrity, security, and performance optimization.
Troubleshoot database issues and ensure minimal downtime.
Create and maintain database documentation, including ER diagrams and schema designs.
Stay updated with PostgreSQL advancements and suggest improvements to the database ecosystem.
Required Experience:
3 years of experience working with PostgreSQL and PL/pgSQL development or similar RDBMS products
Strong understanding of relational database design and normalization.
Proficiency in writing complex SQL queries, CTEs, and advanced indexing strategies.
Experience in performance tuning, including optimization of complex queries and database servers.
Knowledge of data backup, recovery, security, integrity, and SQL.
Familiarity with AWS technologies and their application in database solutions is highly desirable.
Experience in Liquibase or flyway is a plus
Additional Skills:
Experience with Agile development methodologies.
Experience in continuous integration processes for database code.
Excellent analytical, problem-solving, and organizational skills.
Ability to handle multiple tasks in a fast-paced environment.
Strong communication skills and the ability to work effectively in a team.
Three-day in-office hybrid work schedule at ETS, Princeton
Skills
sql, pl/sql, postgresql, database optimization, Devops, Amazon Web Services, Linux, Jenkins, security, Nodejs, Javascript, Server side, Ecmascript, Angular7
Additional Skills & Qualifications
NAEP Overview:
NAEP stands for National Assessment of Educational Progress. The National Assessment of Educational Progress (NAEP) is the largest national assessment provider for American students. NAEP academic assessments are the "Nation's Report Card" and are leveraged by local, state and federal agencies to measure and act upon a clear picture of student academic progress year over year.
ETS (Educational Testing Service) has developed applications, services, interactive 'item' (test question) development and reporting on behalf of the NCES since 1983 and is looking to upgrade the current NAEP website, NAEP Data Explorers and reporting to provide improved features, as well as, a tablet optimized user experience.
Pay and Benefits
The pay range for this position is $55.00 - $62.00/hr.
Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:
Medical, dental & vision
Critical Illness, Accident, and Hospital
401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available
Life Insurance (Voluntary Life & AD&D for the employee and dependents)
Short and long-term disability
Health Spending Account (HSA)
Transportation benefits
Employee Assistance Program
Time Off/Leave (PTO, Vacation or Sick Leave)
Workplace Type
This is a hybrid position in Princeton,NJ.
Application Deadline
This position is anticipated to close on Feb 3, 2025.
About TEKsystems:
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Salary : $55 - $62
