Senior Database Administrator

CoStar Group
CA, Orange County
$114K-$192K a year
Full-time

Responsibilities

  • Administrate and integrate with Microsoft SQL Server so decent MSFT SQL DBA skill is required
  • Demonstrate extensive knowledge of all aspects AWS Database Engines (RDS, DynamoDB)
  • Include DB technology evaluation, guidance and consultation, design support, task automation and scripting, best practice and standards development, capacity planning, optimization and tuning, system upgrades and migrations, performance management, monitoring, security, backup and recovery, issue troubleshooting, and documentation.
  • Implement and Maintain Automated Processes using TSQL / PowerShell / Python / Terraform scripts.
  • Deploy, configure, monitor, and maintain databases in the production, development, and quality assurance environments.
  • Understand AWS-based architecture and, closely work with DevOps, SecOps, and Develop scripts to support continuous deployment process and maintain the environment via TFS / Terraform.
  • Work with the Operations & Development team planning server / server-less resource requirements to decide the proper size for specific application requirements and performance metrics.
  • Process database change requests, including the creation and modification of databases, tables, views, stored procedures, triggers, jobs, etc.

in accordance with change control policies.

  • Analyze problems, anticipate future problem areas, and implement solutions.
  • Work outside of normal business hours as required to complete projects, work on deployments, and resolve system outages.
  • Responsible for level 2 systems management and exercises project-level control over initiatives.
  • Recommend and implement solutions for performance monitoring and tuning.
  • Carries out assignments with minimal coaching and guidance from others.
  • Develops, enhances, and adheres to engineering and administration standards. Upholds and maintains strong documentation.
  • To be placed on on-call rotation for a week every three months and respond to system alerts

Basic Qualifications

  • Bachelor’s Degree required from an accredited, not for profit university or college (preferably in Computer Science or a related field)
  • A track record of commitment to prior employers
  • Minimum of 5 years + experience working as a Database Administrator
  • 1-3 years of supporting a large data platform and data pipelining.
  • 2-3 or more years of experience with NoSQL data platforms like Spark, Solr, MongoDB Atlas, DynamoDB.
  • 2-3 years’ experience with relevant scripting languages or programming frameworks desired (PowerShell, Python, NodeJS, JavaScript, bash)
  • Expertise in database administration for large Data warehouse / datamart implementations including configuration, implementation, data modeling, maintenance, redundancy / HA / DR, security, troubleshooting / performance tuning, upgrades, database, data and server migrations, SQL

Preferred Qualifications And Skills

  • Cloud migration experience
  • Experience with Data Warehouse technologies such as AWS Redshift, Snowflake, Databricks, Azure Data Warehouse, etc.
  • Strong experience with Linux Server platform
  • Experience solving data engineering problems using technologies such as Spark, Solr.
  • NoSQL database experience (MongoDB / Hadoop / Redis / DynamoDB / Elastic Search).
  • Strong Cloud Database management experience (Redshift / Snowflake) Data warehouse or Data analytics
  • Having knowledge of all aspects of Azure Database Engines (Managed Instances, Data Warehouse) including administration
  • Any other programming skills are valuable such as .Net.
  • AWS solution architect certification
  • Azure solutions architect associate certification
  • Experience with Databricks
  • Experience with DMS

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
  • 30+ days ago
Related jobs
Promoted
Lockheed Martin
Palmdale, California

Database Administrator Senior - Level 3. Database Administrator Senior - Level 3. Primary responsibility includes database management to include in-depth use and troubleshooting of relational databases. Working with field engineers, logistics / procurement personnel and subcontractors to ensure time...

Promoted
Booz Allen Hamilton
Seaside, California

Experience with database implementations, database language theory, database design, SQL, and database programming. Database Administrator, Senior. As a database administrator supporting a DOD client, you will create, modify, and maintain some of the largest datasets in the industry. At Booz Allen, ...

Promoted
VirtualVocations
El Cajon, California

A company is looking for a Senior Logical Database Administrator/Developer with extensive experience in database management. ...

Promoted
Promote Project
San Francisco, California

Work on a team of highly technical and talented database engineers responsible for maintaining the global database systems for Enterprise Engineering. The primary responsibilities for this role will be defining and executing our cloud database strategy. You will be responsible for developing databas...

DCS Corp
Ridgecrest, California

Perform database administration support to the F-18 Integrated Product Team (IPT) at NAWCWD China Lake. Provide advance support in an enterprise environment by installing, configuring, hardening, and maintaining SQL Server databases. Perform routine database maintenance tasks, including backups, res...

ICONMA
Remote, CA
Remote

The Senior Database Administrator will be a creative, analytical, and innovative individual who is passionate about database administration and solutions. Senior Professional Database Administrator. They will be working with other system administrators, developers, database administrators, quality a...

Public Storage
Glendale, California

The Senior Database Administrator engages directly with Information Technology and Business stakeholders to ensure the on-time and successful delivery of database services to the organization and development team as defined by the Information Technology Department’s Service Level Agreement. Provide ...

Lockheed Martin
San Ardo, California

Database Administrator Senior - Level 3. Database Administrator Senior - Level 3. Primary responsibility includes database management to include in-depth use and troubleshooting of relational databases. Working with field engineers, logistics / procurement personnel and subcontractors to ensure time...

CGI
Sacramento, California

We are seeking a Senior Oracle Database Administrator (AWS) to join our CGI team in Sacramento, CA! This is a client facing full-time career opportunity to work on a highly visible transformation (Infrastructure services) projects for one of our long-standing government clients!. Includes the develo...

Cedars-Sinai
Los Angeles, California
Remote

The Senior SQL Database Administrator (DBA) leads and works closely on the EIS DBA technology team in designing, installing, maintaining, fix and optimization of SQL Server database instances for departmental and enterprise-wide systems across physical and virtual servers for both on-premises and cl...