DBA (Database Administrator)
Build.com - Chico, CA

This job posting is no longer available on Build.com. Find similar jobs: Database Administrator jobs - Build.com jobs

Job Responsibilities:
Troubleshoot data and query errors as reported by team members

Ability to develop database schema's and write clean SQL queries and code under tight deadlines

Query optimization and index tuning

Design and document database architecture

Evaluate and recommend new database technologies

Implement and maintain solutions to monitor database systems

Supporting high availability database (24/7/365 operation)

Self-organized with good time management, and ability to multitask

Setup and maintain working DR locations, with near real-time data synchronization

Strong understanding of HA environments including advanced techniques such as sharding, partitioning, and master/slave setups

Assist with Master Data Management solution

Required Skills and Experience:
5+ years experience with MSSQL, (MySQL and/or Postgres experience a plus)

Experience with system administration and architecture

Knowledge of database design standards

Experience in Windows and Linux operating systems preferred

5+yrs experience stored procedure programming

Strong troubleshooting skills

Detail Oriented

Proficient Communication

Ability to work independently and in a team environment

Problem solving/troubleshooting

Good organization

Proficient in both written and conversational English

Ability to work in a dynamic fast paced environment with multiple priorities and projects

Must work well with others. Collaboration and professional communication is key

Requires initiative to work when necessary to meet deadlines or when working on high-priority projects

Knowledge of SQL Server tooLog Outls ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)

Strong knowledge of indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.

Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.

Ability to detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention issues.

Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, clustering, database mirroring, replication.

About this company
8 reviews