Postgres Developer

Job Description:

• Postgres Developer
• Postgres Developer provides database code development and migration of code from Oracle to PostgreSQL.
• Postgres Architect provides guidance and technical support to application teams in optimizing the queries and fixing data related issues.
• Provides performance tuning best practices to enhance and maintain application SQL and PL/PGSQL performance.
• Applicants for employment in the US must have valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in the US by DXC.

About the Role:

• Expert Level SQL, PL/PGSQL, including stored procedures, functions, triggers, and views.
• Ability to efficiently write database code without compromising data quality, privacy or security.
• Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels
• Excellent verbal, written, and interpersonal communication skills
• Ability to evaluate alternative solutions and/or workarounds.
• Additional Skills: Oracle PL/SQL (as this is a migration project from Oracle to Postgres)
• Partners with PostgreSQL Administrators to optimize implementation of system design in order to optimize performance and effectiveness while realizing the optimum technical issues.
• Evaluates application database queries performance and optimize the code and database configuration as appropriate.
• Partners with PostgreSQL administrator for the implementation of secured PostgreSQL database platform in compliance with STIG.
• Provide technical leadership to other DBAs.
• Design process for database change management issues related to environment migration.
• Other duties as assigned.

Requirements:
Knowledge, Skills, Qualifications, Experience:

• 7 plus years of professional experience as a Postgres code development and migrations.
• In depth knowledge of the PostgreSQL architecture and application data lifecycle management.
• Experience in implementing Security Guidelines of Postgres STIG, testing, and other vulnerability remediation.
• Experience in working closely with the application teams to resolve any performance related issues.
• Measure database performance and troubleshoot complex database issues, I/O bottlenecks and SQL Tuning.
• Proven experience in working in a mission critical environment in a multi-terabyte database platform.
• Working knowledge of Database Security mechanism, data encryption, obfuscation, auditing using tools.
• Experience with automation using Python, Ansible, etc.
• In-depth knowledge of IT industry database technologies and processes and business applications integrated with database technologies.
• Ability to develop efficient data models.
• Ability to write optimized SQL queries and PL/PGSQL code.
• Experience in triggers and constraints.
• Strong experience in SQL and Database performance tuning.
• Experience in developing and managing table and index partitioning.
• Strong experience in writing complex JOINS and Sub Queries
• Extensive experience in using extensions and all available functions.
• Knowledge in Agile Scrum Framework.

Preferred:

• PostgreSQL Certification.
• Oracle to PostgreSQL Migration experience will be a great plus.
• Automobile industry related experience.

Key Words:

• Postgresql developer
• Oracle to Postgresql migration (Code migration)
• PG/PLSQL development