CoStar Group
Senior Database Administrator (PostgreSQL)
CoStar Group, California, Missouri, United States, 65018
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. Experience with other RDBMS such as MySQL and MS SQL. Whats In It For You
When you join CoStar Group, youll 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 Groups 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.
#J-18808-Ljbffr
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. Experience with other RDBMS such as MySQL and MS SQL. Whats In It For You
When you join CoStar Group, youll 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 Groups 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.
#J-18808-Ljbffr