PostGresSQL Senior Developer

TEKsystems
$55.00 - $62.00 / hr
life insurance, sick time, 401(k), retirement plan
United States, New Jersey, Princeton
Jan 29, 2025
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.