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
ā¢ 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.
Apply tot his job
Apply To this Job
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
ā¢ 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.
Apply tot his job
Apply To this Job