The Job Auction Country


Share On

Sr Sql server DBA 
(Job)

adzuna-us  |  United States  |  

Ref:
ADZUNA-US-DN2KE
Direct:
Employer:
Location:
United StatesRembrandt, CA, 92602
Category:
Information Technology/Computing
Work Type:
Permanent
Work Time:
Full Time
Tags:
job,united-states,adzuna

Description 

What you ll do Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems and assist in capacity planning.

Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.

Assist developers with development of complex SQL query tuning and schema refinement.

Maintain data integrity and security (manage roles and permissions of database users).

Provide 24x7 support for production systems and perform scheduled maintenance and support release deployment activities after hours.

Use tools like SQL Profiler for database tuning.

Generate traces, execution plans, identify performance issues, deadlockscontention and resolve them.

Create and manage constraints and indexes.

Learn relevant business processes and understand the data flow, criticality and dependencies.

Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

We re looking for someone who has BA or MS in computer science or equivalent education and experience.

10-15 years experience administering Microsoft SQL server databases Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies and Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server Experience with backups, restores and recovery models