Postgresql Dba Pan India (preference Bangalore / Noida) (#girik952) Job in Girikon Inc

Roles & Responsibilities:

• 7+ years of experience in managing Postgres database. Some years of Postgres experience should be on the cloud version preferably AWS
• Expert in PostgreSQL Database internals.
• Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc.
• Should be able to implement effective and maintainable database coding practices that form an architectural foundation.
• Experience in Postgres SQL performance improvement, indexing/other approaches
• Good experience on partitioning database
• Experience with message queuing, full text indexing, and other high-performance data concepts.
• Ability to find issues with complex SQL queries to help application/ETL team members to fine tune SQL
• Experience in writing Postgres DB function
• Experience to upgrade Postgres database, Experience in database backup and restoration of the same.
• Experience in AWS environment management and knowledge of different tools for same.
• Experience in Postgres SQL migration approach, estimate it, technically manage it
• Aware of costing models in cloud environment & ways to control it
• Advanced understanding of Linux OS, use SSH to connect to remote systems with password & public/private keys
• Ability to efficiently write database code without compromising data quality, privacy or security.
• Knowledge of JSON and PostgreSQL support for JSON.
• Knowledge in Azure, Jira and GitHub.
• Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels
• Good troubleshooting skills, Ability to evaluate alternative solutions and/or workarounds
• Good Communication / Presentation Skills.

Competencies/Values:

• Ability of write python scripts
• Knowledge of Snowflake & Redshift databases

Competencies/Values:

• Ability to work in a startup-like culture and conform to shifting priorities, demands and timelines through analytical and problem-solving capabilities.
• Ability to complete projects successfully while maintaining sensitivity to political issues.
• Persuasive, encouraging, and motivating.
• Excellent negotiation and conflict resolution skills.
• Flexible during times of change.
• Ability to understand the different communication styles of team members and contractors who come from a broad spectrum of disciplines.
• Ability to elicit cooperation from a wide variety of sources, including upper management, clients, and other departments.