25 Oct
Postgres Developer
Vacancy expired!
Job Description
Position: 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.
- 6+ 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.
- PostgreSQL Certification.
- Oracle to PostgreSQL Migration experience will be a great plus.
- Automobile industry related experience.
Vacancy expired!