Senior Database Administrator (PostgreSQL)

  • Orange County, CA
  • Posted 1 day ago | Updated 3 hours ago

Overview

On Site
USD 132,200.00 - 183,900.00 per year
Full Time

Skills

PB
Servers
Data Centers
Management
Database Administration
Replication
Streaming
Backup
Concurrent Computing
Terraform
Microsoft TFS
Microsoft Visual Studio
DevOps
Kibana
Version Control
Change Management
Data Architecture
Disaster Recovery
High Availability
Collaboration
Microsoft Operating Systems
Microsoft Windows Server
SQL Azure
Performance Tuning
Amazon RDS
Remote Desktop Services
Amazon EC2
NoSQL
Redis
Elasticsearch
Data Warehouse
Snow Flake Schema
Databricks
Scripting
Python
Bash
Windows PowerShell
Recovery
Linux
Communication
Documentation
Work Ethic
RDBMS
SQL
PostgreSQL
Clustering
Failover
Continuous Integration
Continuous Delivery
Cloud Computing
Migration
DMS
Amazon Web Services
Database
MySQL
Microsoft SQL Server
Amazon DynamoDB
Microsoft Exchange
Health Care
Legal
Insurance
Training
Audiovisual
AV
Testing

Job Details

Senior Database Administrator (PostgreSQL)

Job Description

CoStar Group serves up over 1.8PB of data from more than 800 SQL Servers that span four On-Premise data centers, two continents, and six different time zones and we are expanding to AWS Cloud solution rapidly and start to support Aurora MySQL, PostgreSQL (Aurora and RDS), DynamoDB, Databricks, and other DB engines on the cloud. Our highly motivated, extremely talented DBA group is looking for an exceptionally bright Senior Database Administrator both On-prem and AWS Cloud that will help the company continue to grow. If you are passionate about automating and programming to support databases, this is your job!. Our goal is to provide an exceptional experience for our customers through continued development, refinement, and improvement of our industry-leading applications.

We are seeking a Senior PostgreSQL Database Engineer with deep experience managing enterprise-scale relational systems, particularly PostgreSQL, and a strong background in Microsoft SQL Server. This role is ideal for an engineer ready to expand their expertise in cloud-native technologies while maintaining and evolving a large-scale PostgreSQL platform.

CoStar Group is the leading data provider of Multi Family and Commercial Real Estate data in an industry valued at over 15 trillion dollars. If you are seeking a challenge that pushes your limits, have a strong desire to delight your customers, want to work with the latest technologies and are looking for responsibilities beyond that a typical DBA, come to work for us today.

This position will have a work schedule of 4 days onsite, with 1 remote day located in Irvine, CA.

Duties and Responsibilities:
  • Design, deploy, monitor, and maintain PostgreSQL databases in AWS
  • Administer PostgreSQL replication (logical and streaming), backup/recovery, performance tuning, upgrades, partitioning, and index strategies.
  • Support high-traffic applications with large data volumes, optimizing PostgreSQL for concurrency, throughput, and durability.
  • Leverage Python and PowerShell for automation, scripting, and operational tooling. Experience with Terraform, CloudFormation, and TFS/Visual Studio Database Projects is a strong plus.
  • Collaborate with DevOps and engineering teams to build and support scalable, resilient infrastructure using infrastructure as code (IaC) and CI/CD pipelines.
  • Use monitoring tools like CloudWatch, Kibana, DataDog, or pg_stat_statements to identify and resolve performance and availability issues.
  • Apply enterprise practices including version control for database artifacts, structured change management, and documentation.
  • Support AWS database platforms such as DynamoDB, Aurora MySQL, Aurora PostgreSQL, MS SQL and contribute to cloud data architecture strategies.
  • Ensure effective disaster recovery (DR) and high availability (HA) strategies are in place
  • Work across both Linux and Windows Server environments, ensuring compatibility AND stability for all data workloads
  • To be placed on on-call rotation for a week every 3 months and respond to system alerts


Requirements:
  • 3-5+ years of hands-on experience iwth PostgreSQL in large scale production environments
  • Experience with cloud-native PostgreSQL (e.g., AWS RDS, Aurora, Azure Database for PostgreSQL
  • Strong understanding of PostgreSQL internals, query planning, indexing strategies, partitioning, sharding, and performance optimization.
  • Proficiency with cloud platforms, especially AWS (Aurora PostgreSQL, RDS, EC2)
  • Experience with database migrations, cloud-native data services, and automation frameworks.
  • Familiarity with NoSQL systems such as DynamoDB, Redis, or Elasticsearch.
  • Experience with data warehousing platforms like Snowflake, Databricks or similar is desirable
  • Strong scripting skills in Python, Bash, or PowerShell.
  • Expertise with pg_dump/pg_restore.
  • Experience working with Linux-based environments.
  • Excellent communication and documentation skills.
  • Excellent work ethic and willingness to put in significant extra time as needed
  • Experience with other RDBMS such as MySQL and MS SQL.
  • Bachelor's degree required. Relevant equal work experience may be considered in lieu of a degree.


Nice to have:
  • Experience with PostgreSQL clustering and failover
  • Experience with CI/CD and Infrastructure-as-Code practices
  • Familiarity with cloud migration tools like AWS DMS.
  • AWS Certified Solutions Architect or AWS Database Specialty certification is a strong plus.
  • Exposure to additional databases such as MySQL, MS SQL Server, or DynamoDB is a bonus.


What's In It For You:

When you join CoStar Group, you'll experience a collaborative and innovative culture working alongside the best and brightest to empower our people and customers to succeed.

We offer you generous compensation and performance-based incentives. CoStar Group also invests in your professional and academic growth with internal training, tuition reimbursement, and an inter-office exchange program.

Our benefits package includes (but is not limited to):
  • Comprehensive healthcare coverage: Medical / Vision / Dental / Prescription Drug
  • Life, legal, and supplementary insurance
  • Virtual and in person mental health counseling services for individuals and family
  • Commuter and parking benefits
  • 401(K) retirement plan with matching contributions
  • Employee stock purchase plan
  • Paid time off
  • Tuition reimbursement
  • On-site fitness center and/or reimbursed fitness center membership costs (location dependent), with yoga studio, Pelotons, personal training, group exercise classes
  • Access to CoStar Group's Diversity, Equity, & Inclusion Employee Resource Groups
  • Complimentary gourmet coffee, tea, hot chocolate, fresh fruit, and other healthy snacks


This position offers a base salary range of $132,200-183,900, based on relevant skills and experience and includes a generous benefits plan.

We welcome all qualified candidates who are currently eligible to work full-time in the United States to apply. However, please note that CoStar Group is not able to provide visa sponsorship for this position.

CoStar Group is an Equal Employment Opportunity Employer; we maintain a drug-free workplace and perform pre-employment substance abuse testing

#LI-AV1

CoStar Group is an Equal Employment Opportunity Employer; we maintain a drug-free workplace and perform pre-employment substance abuse testing
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.