PlanoRecruiter Since 2001
the smart solution for Plano jobs

Lead PostgreSQL Developer

Company: DXC Technology
Location: Plano
Posted on: November 22, 2021

Job Description:

**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 optimiztoyation, 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.+ 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:**+ 12+ 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:**+ Postgres Certification.+ Oracle to PostgreSQL Migration experience will be a great plus.+ Automobile industry related experience.DXC Technology is an Equal Opportunity/Affirmative Action employer. All qualified candidates will receive consideration for employment without regard to disability (physical or mental), protected veteran status or military service of affiliation, race, ethnicity, color, religion, national origin, citizenship, marital status, sex (including pregnancy, childbirth, and related medical conditions), sexual orientation, gender identity and expression, age, protected genetic information, or political affiliation. DXC's commitment to diversity and inclusive selection practices includes ensuring qualified long-term unemployed job seekers receive equal consideration for employment. EEO is the Law Poster (https://www.dol.gov/agencies/ofccp/posters) .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 (csser@dxc.com?subject=Reasonable%20Accommodation%20Request%20-%20External%20Career%20Site) . Please note: DXC will respond only to requests for accommodations due to a disability.

Keywords: DXC Technology, Plano , Lead PostgreSQL Developer, IT / Software / Systems , Plano, Texas

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest Texas jobs by following @recnetTX on Twitter!

Plano RSS job feeds