PostgreSQL Developer

Compunnel Inc.; Columbus (OH); On-site; USD 80,000 - 100,000; Full time

Job summary

A technology consulting firm is seeking a PostgreSQL Developer responsible for designing, developing, and maintaining database applications. Key responsibilities include database design, SQL optimization, data modeling, and collaborating with software developers. Experience in FinTech or Banking is preferred. The position offers a contract role in Columbus, OH with a salary range of $80,000.00-$100,000.00.

Qualifications

• Mid-Senior level experience in PostgreSQL database administration and development.
• Knowledge of FinTech/Banking domain is a plus.
• Strong analytical and troubleshooting skills.

Responsibilities

• Design and implement PostgreSQL database schemas and procedures.
• Optimize SQL queries and maintain high performance.
• Monitor database performance and implement tuning strategies.
• Develop data migration and ETL processes.
• Collaborate with stakeholders to integrate database solutions.

Skills

PostgreSQL

SQL optimization

Data modeling

ETL processes

Database security

Job description

Direct message the job poster from Compunnel Inc.

PostgreSQL Developer is responsible for the design, development, and maintenance of applications and systems that utilize the PostgreSQL database. This role involves a blend of database administration and software development skills.

Key Responsibilities:

Database Design and Development:

Designing and implementing PostgreSQL database schemas, tables, views, stored procedures, functions, and other database objects to support application requirements.

SQL Development and Optimization:

Writing, optimizing, and maintaining complex SQL queries, scripts and code for data manipulation, retrieval, and reporting, ensuring high performance and efficiency.

Data Modeling and Management:

Creating and managing logical and physical data models, ensuring data integrity, consistency, and security through appropriate constraints, triggers and validation rules.

Performance Tuning:

Monitoring database performance, identifying bottlenecks, and implementing tuning strategies such as index optimization, query rewriting, and database configuration adjustments.

Data migration and ETL:

Developing and executing scripts and processes for data migration, transformation, and loading (ETL) between different systems or database versions.

Collaboration and Integration:

Working closely with software developers, data analysts, and other stakeholders to integrate database solutions with applications and ensure seamless data flow.

Troubleshooting and Support:

Diagnosing and resolving database-related issues, providing technical support, and ensuring the stability and availability of the PostgreSQL environment.

Candidates from Tier 1 background along with Recent FinTech/Banking domain experience will be highly preferred

Documentation:

Creating and maintaining comprehensive documentation for database schemas, queries, processes, and configurations.

Security and Backup:

Implementing and maintaining database security measures, access controls, and backup and recovery procedures to protect sensitive data.

Staying current:

Keeping abreast of the latest PostgreSQL features, tools, and industry best practices.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Accounting/Auditing

• Industries

  IT Services and IT Consulting and Investment Banking

Referrals increase your chances of interviewing at Compunnel Inc. by 2x

Get notified about new Database Developer jobs in Columbus, OH.

Dublin, OH $80,000.00-$100,000.00 1 day ago

SQL Server Database Administrator - Hybrid, OH

Columbus, OH $109,900.00-$183,100.00 2 months ago

Senior Oracle Database Administrator - Hybrid, OH

Specialist, Technology Engineer - SQL DBA

Columbus, OH $109,900.00-$183,100.00 3 weeks ago

Data Analyst II - IT Research and Innovation

Data Science - College Intern - (20068617)

Infrastructure Engineer III - Cloud Database Engineer with AWS

Remote Data Contributor (No experience needed)

Columbus, Ohio Metropolitan Area 15 hours ago

Columbus, OH $82,000.00-$197,000.00 15 hours ago

Groveport, OH $70,000.00-$115,000.00 3 days ago

Westerville, OH $70,000.00-$115,000.00 6 days ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.