Database Administrator in Santa Barbara, CA

$80K - $100K(Ladders Estimates)

Ontraport   •  

Santa Barbara, CA 93101

Industry: Enterprise Technology

  •  

5 - 7 years

Posted 45 days ago

Overview


We're looking for a MySQL database administrator who can wrangle our many MySQL databases and our terabytes of data. You will oversee development and help with organization of our databases, as well as assessment and implementation of our exciting and rapidly growing new technologies and advancements. Our database administrators will work as part of a collaborative team to optimize and scale the data layer of the business.

Duties

Monitor and provide recommendations for optimizing and scaling our Db infrastructure

Design and document database architecture

Design Data Warehousing and Business Intelligenceplatform

Build database scheme, tables, procedures and permissions

Monitor User Level Security

Optimization and Design

Maintain Server Uptime

Proactively monitor the servers to ensure secure services with minimum downtime

Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management

Responsible for improvement and maintenance of the databases to include rollout and upgrades

Responsible for implementation and release ofdatabase changes according to agreed timescales and costs

Back-up & Recovery

Researching, testing, and implementing new technologies such as CouchDB, Cassandra, etc.

Designing and deploying our rapidly scaling serverinfrastructure

Researching and deploying worldwide DNS network to minimize dns latency

System Administrator:

Profiling

Coordination with Manage Hosting Solution

Scheduled Maintenance



Requirements

Five years experience working in LAMP environment

Experience Optimizing my.cnf

MySQL query profiling

Data Modeling

Writing Queries, stored procedures, triggers

Monitoring system load in relation to mysql

Binary Log / Mysql Replication

Load Balancing


Strong oral and written communication skills

Capacity Planning

Bonus

Mysql Cluster

Experience with Big Data


NoSQL or other Database Languages

Physical Demands


Must be able to remain in a stationary position for long periods of time. The person in this position needs to occasionally move about inside the office to access file cabinets, office machinery, etc. Constantly operates a computer and other office productivity machinery, such as a copy machine and computer printer.


Must have a high level of computer literacy. Role includes repetitive movement of hands and fingers for long periods of time – typing and/or writing.


Valid Through: 2019-10-31