Postgres DBA

Postgres DBA We are seeking qualified Database Engineer / Administrator is responsible for independently analyzing database performance characteristics and collaboratively changing the database design to improve performance and resource utilization. Duties and responsibilities: Administers, manages, and monitors all systems, including databases, in development, test, stage and production environments. Design and implementation of Azure Postgres databases, high-availability solutions, replication, encryption, and disaster recovery solutions. Data Partitioning, Purging and Archiving solutions in the Azure PostgreSQL ecosystem. Azure CLI and/or PowerShell. Writing PostgresSQL, including stored procedures, functions, views, and triggers. Query analysis and troubleshooting Leadership responsibilities: Provide technical leadership through example, develop innovation, strategies, processes, and best practices. Monitor database performance, implement changes, and apply new patches and versions when required. Manage PostgreSQL databases through multiple product lifecycle environments, from development to mission-critical production systems. Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations. Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end. Perform scheduled maintenance and support release deployment activities after hours. Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members. Own and manage uptime and performance SLAs. Ability to work well with team globally specifically in India. Work with Development and QA team, guide developers on following best coding practices to write optimal & efficient code. Experience: 5+ years in database tuning and project support, database server upgrades and migrations, writing and troubleshooting database stored procedures. In-depth knowledge of security best practices including database encryption, column level encryption, SSL/TLS connection encryption, and service specific account permissions. Experience with Azure databases specifically Azure Postgres. Good understanding of DevOps and the role of database administration teams in DevOps. Experience performing database deployments (CI/CD) Advanced knowledge of performance tuning and administration, query analysis, performance monitoring and tuning, and maintenance routines. Experience with data warehouse and reporting technologies (specifically Power Bi) a plus. Background in automating processes Experience with creating and maintaining database infrastructure. Experience interacting with customers on an as needed basis. Education: Minimum of an undergraduate degree in Business, Engineering, or other related field; or a combination of commensurate experience and education. My3Tech Inc