US Citizen
Green Card
Corp-Corp
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 18th Mar 2023
• 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