Image Loading

Senior Database Engineer / Administrator/Postgres DBA

Job Description

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.

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.

 

Skills

  • Project Design
  • Database Administration
  • Devops
  • CI/CD
  • Power Bi
  • Automation

Education

  • Master's Degree
  • Bachelor's Degree

Job Information

Job Posted Date

Aug 13, 2024

Experience

5-10 Years

Compensation (Annual in Lacs)

₹ Market Standard

Work Type

Permanent

Type Of Work

8 hour shift

Category

Information Technology

Copyright © 2022 All Rights Reserved. Saas Talent