Match score not available

IT-Lead Software Engineer (Azure PostgresSQL)

Remote:

Full Remote

Contract:

Full time

Work from:

United States

Resource Informatics Group, Inc SME https://www.rigusinc.com/

51 - 200 Employees

See more Resource Informatics Group, Inc offers

Job description

100% Remote – Confidential customer in the Healthcare space
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.