- System design
- Database design
Lead Postgres Developer helps the project team in establishing AWS Aurora Cloud and On-premise EDB environments configuration, optimization, capacity planning, database code migration from Oracle to Aurora or EDB PostgreSQL database. 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.
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.
Converting Oracle SQL and PLSQL code to PostgreSQL SQL, PL/PGSQL.
Migrating Oracle schema and data to EDB or AWS Aurora PostgreSQL.
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.
Evaluate 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.
The design process for database change management issues related to environmental migration.
Other duties as assigned.
Requirements:Knowledge, Skills, Qualifications, Experience:
10+ years of professional experience with 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 mechanisms, 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.
Oracle to PostgreSQL Migration experience will be a great plus.
Automobile industry-related experience.
If you are an applicant from the United States, Guam, or Puerto Rico
DXC Technology is an Equal Opportunity/Affirmative Action employer . All qualified candidates will receive consideration for employment without regard to disability, protected veteran status, race, color, religious creed, national origin, citizenship, marital status, sex, sexual orientation/gender identity, age or genetic information. DXC's commitment to diversity and inclusive selection practices includes ensuring qualified long-term unemployed job seekers receive equal consideration for employment. View postings below.
We participate in E-Verify. In addition to the posters already identified, DXC provides access to prospective employees for the Federal Minimum Wage Poster, Federal Polygraph Protection Act Poster as well as any state or locality specific applicant posters . To access the postings in the link below, select your state to view all applicable federal, state and locality postings. Postings are available in English, and in Spanish, where required. View postings below.
If you are an individual with a disability, a disabled veteran, or a wounded warrior and you are unable or limited in your ability to access or use this site as a result of your disability, you may request a reasonable accommodation by contacting us via email .
Please note: DXC will respond only to requests for accommodations due to a disability.