Required Skills

Postgress SQL DBA

Work Authorization

  • US Citizen

  • Green Card

Preferred Employment

  • Corp-Corp

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 18th Mar 2023

JOB DETAIL

•    10 years of software development experience

Job Responsibilities
• Deep knowledge and experience designing and maintaining PostgreSQL infrastructure On-prem and in cloud 
• Experience building and maintaining complex, critical production database systems 
• Experience analyzing issues holistically, from the application tier through the database, down to the storage 
• Proven track record of automating tasks • Working knowledge of relational database internals (locking, consistency, serialization, recovery paths) 
• Systems engineering experience, including Linux performance, memory management, I/O tuning, configuration, security, networking, etc 
• Experience migrating database from on-prem to cloud and vice versa Responsibilities 
• As a member of the Data Infrastructure team, you will administer, scale, secure, and maintain our on-prem relational database systems 
• Work alongside our Infrastructure teams to plan, administer, maintain and secure our PostgreSQL infrastructure across our backend 
• Perform operational DBA duties: installation, database upgrades, patching, implement backup/recovery and monitoring procedures, capacity planning, and site failover/switchover 
• Ensure systems are running at the highest possible performance level by analyzing and tuning queries 
• Guide engineers on performance tuning and optimization, query optimization, index tuning, caching, buffer tuning, etc. 
• Review database changes requested by engineering teams for impacts to database designs, design standards, data conversions, naming standards, and documentation 
• Learn about the data and it’s use to make recommendations for improvements in how it is stored and processed 
• Develop procedures and scripts for data migration

Company Information