Senior Database Engineer / Administrator/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.
Manage secure access to DB inclusive of DBA.
Data sharing/Partitioning, Purging and Archiving solutions in the Azure PostgreSQL ecosystem.
Azure CLI and/or PowerShell.
Writing PostgresSQL, including stored procedures, functions, views, and triggers.
Able to port across versions.
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.
Work with Development and QA team, guide developers on following best coding practices to write optimal & efficient code.
Guide on analyzing and fine tuning queries to be optimal and efficient.
Perform regular maintenance and archival activities complementing Azure managed databases
Essure availability/ recovery with minimal downtime.
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.