Basic qualifications: BTech degree or equivalent preferably in Computer Science Have a strong sense of ownership, urgency and drive Be a good mentor and loves working on technical challenges Has 8+ years of experience in software development and at least 5+ years as a PostgresSQL developer for a large / high volume project. Work effectively across functional teams and can effectively estimate the effort involved on tasks assigned to him Is inherently curious, spends time learning new technologies, trying and likes to build / experiment. Conduct code review and ensure that coding standards are being followed by the team members. Preferred qualifications: Technical Can breakdown the business requirements into an underlying scalable/secure application design. Believes in the POC (proof of Concept) model and likes to quickly build POCs and evaluate the pros and cons. Ability to identify possible bottlenecks when system scales and builds/designs accordingly. Ability to roll up sleeves and be able to troubleshoot issues Strong database fundamentals and has experience dealing with database performance tuning, bottlenecks, and database ER modeling, databases (PostgreSQL) Expert in PostgreSQL Database internals. Database Performance Tuning. Experienced with PostgreSQL & PostgreSQL Architecture Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc. Create SQL to PostgreSQL migration approach, estimate it, technically manage it
We should be able to implement effective and maintainable database coding practices that form an architectural foundation. Installation & Configuration. Schema handling. Database user roles and Security related permission. User creation, object Backup & Restore. Creating and Managing PostgreSQL Databases PostgreSQL Index Management PostgreSQL Partitioning and System Catalogs Backup, Recovery and PITR Monitoring disk usage Transferring Data, moving Trans