Skip to content
Senior Database Administrator – Postgresql
| Company | CoStar Group |
|---|
| Location | Irvine, CA, USA |
|---|
| Salary | $132200 – $183900 |
|---|
| Type | Full-Time |
|---|
| Degrees | Bachelor’s |
|---|
| Experience Level | Senior |
|---|
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.
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
Preferred Qualifications
- 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.
