Jobs via Dice
PostgreSQL Developer @ Columbus, OH (Local Candidates only)
Jobs via Dice, Columbus, Ohio, United States, 43224
PostgreSQL Developer (Local Candidates only)
Location: Columbus, OH (Onsite Job).
Duration: 12 Months. Rate: DOE.
Job Description: This role involves a blend of database administration and software development skills.
Key Responsibilities
Designing and implementing PostgreSQL database schemas, tables, views, stored procedures, functions, and other database objects to support application requirements.
Writing, optimizing, and maintaining complex SQL queries, scripts and code for data manipulation, retrieval, and reporting.
Creating and managing logical and physical data models, ensuring data integrity, consistency, and security through appropriate constraints, triggers and validation rules.
Monitoring database performance, identifying bottlenecks, and implementing tuning strategies such as index optimization, query rewriting, and database configuration adjustments.
Developing and executing scripts and processes for data migration, transformation, and loading (ETL) between different systems or database versions.
Working closely with software developers, data analysts, and other stakeholders to integrate database solutions with applications and ensure seamless data flow.
Diagnosing and resolving database-related issues, providing technical support, and ensuring the stability and availability of the PostgreSQL environment.
Creating and maintaining comprehensive documentation for database schemas, queries, processes, and configurations.
Implementing and maintaining database security measures, access controls, and backup and recovery procedures to protect sensitive data.
Keeping abreast of the latest PostgreSQL features, tools, and industry best practices.
Qualifications Required experience with PostgreSQL database administration and development, SQL performance tuning, data modeling, and ETL processes.
Details
Seniority level: Entry level
Employment type: Full-time
Job function: Engineering and Information Technology
Industry: Software Development
Location: Columbus, OH (Onsite)
#J-18808-Ljbffr
Duration: 12 Months. Rate: DOE.
Job Description: This role involves a blend of database administration and software development skills.
Key Responsibilities
Designing and implementing PostgreSQL database schemas, tables, views, stored procedures, functions, and other database objects to support application requirements.
Writing, optimizing, and maintaining complex SQL queries, scripts and code for data manipulation, retrieval, and reporting.
Creating and managing logical and physical data models, ensuring data integrity, consistency, and security through appropriate constraints, triggers and validation rules.
Monitoring database performance, identifying bottlenecks, and implementing tuning strategies such as index optimization, query rewriting, and database configuration adjustments.
Developing and executing scripts and processes for data migration, transformation, and loading (ETL) between different systems or database versions.
Working closely with software developers, data analysts, and other stakeholders to integrate database solutions with applications and ensure seamless data flow.
Diagnosing and resolving database-related issues, providing technical support, and ensuring the stability and availability of the PostgreSQL environment.
Creating and maintaining comprehensive documentation for database schemas, queries, processes, and configurations.
Implementing and maintaining database security measures, access controls, and backup and recovery procedures to protect sensitive data.
Keeping abreast of the latest PostgreSQL features, tools, and industry best practices.
Qualifications Required experience with PostgreSQL database administration and development, SQL performance tuning, data modeling, and ETL processes.
Details
Seniority level: Entry level
Employment type: Full-time
Job function: Engineering and Information Technology
Industry: Software Development
Location: Columbus, OH (Onsite)
#J-18808-Ljbffr