• Administer and maintain PostgreSQL databases in cloud environments (Azure preferred). • Track database health, performance, and capacity using cloud-native and third-party monitoring tools. • Own backup strategy, integrity checks, retention policies, and disaster recovery planning. • Configure and maintain replication, failover, and high-availability setups across environments. • Build and maintain automation for provisioning, migrations, monitoring, and maintenance using IaC and scripting tools. • Improve performance through partnering with development teams on query tuning, indexing, schema design, normalization, and indexing strategies. • Implement security best practices for RBAC, encryption, auditing and patching. • Troubleshoot and resolve database-related incidents in collaboration with DevOps and engineering. • Develop root cause analysis findings and implement preventative actions.

• Fully remote position requiring expertise in database architecture and related technologies • Collaborate with teams to deliver quality solutions • Ensure compliance with IRS security standards • Engage in performance and capacity management tasks

• Analyze, maintain, and optimize PostgreSQL database environment to ensure 99.9% availability and data integrity. • Analyze, maintain, and optimize Microsoft SQL database environment to ensure 99.9% availability and data integrity. • Identify and resolve bottlenecks, optimize SQL queries, and enhance data retrieval efficiency for PostgreSQL and Microsoft SQL. • Update database architecture, build schemas, tables, stored procedures, and manage permissions. • Manage, improve, and work with Legacy databases and Platform as a Service databases. • Provide recommendations on policies, procedures, and emerging technologies. • Monitor systems for availability, oversee database mirroring, replication, and failover. • Support advanced PostgreSQL features like JSON, full-text search, and PostGIS for geospatial queries. • Generate queries and reports using PostgreSQL tools like pgAdmin, psql, and third-party tools such as DataGrip. • Create, populate, and maintain PostgreSQL databases, materialized views, and indexes for analysis and reporting. • Restore PostgreSQL databases from backups and support disaster recovery activities using WAL archiving and point-in-time recovery. • Collaborate with developers, analysts, and IT teams to design, implement, and troubleshoot PostgreSQL database issues. • Assess future storage and performance needs, and create and maintain comprehensive PostgreSQL documentation. • Work with Platform as a Service pre-built database to optimize and manage as needed for growing solutions. • Communicate effectively with customers, stakeholders, and technical specialists.