Search Jobs

Search Site

Vaco Orange County

SQL DBA

Industry: IT

Location: Irvine, California

Date Posted: August 01, 2014

.Job Expectations:



  • Administration and management of SQL databases in development, QA and production environments

  • Superior troubleshooting skills with the ability to exude calmness and present effective solutions in high-pressure situations.?

  • Troubleshoot and handle all database related issues through to resolution

  • Proactive monitoring of databases both from a performance and capacity management perspective

  • Perform database maintenance activities such as backup/?recovery and rebuilding/?reorganizing indexes.?

  • Ensure that all database releases are properly assessed and measured from a functionality and performance perspective.?

  • Provide technical subject matter expertise on all database design and development projects
    SQL Development and performance tuning of database schema, stored procedures, etc.?

  • Hands on SQL programing skills with blended C# skills.?

  • Additional responsibilities will involve system monitoring, metric reporting, and diagnostics (all involve SQL and C# skills)




Knowledge Skill and Abilities:


Required:



  • Experience handling and managing databases in a real time production environment with sizes around 100+? GB

  • Experience with database technologies such as MS SQL Server (2005 onwards)

  • Experience troubleshooting and resolving database integrity issues, performance issues, blocking/?deadlocking issues, connectivity issues, data replication issues etc.?

  • Experience in performance tuning, query optimization using Performance Monitor, SQL Profiler and other related monitoring/?troubleshooting tools

  • Experience with database maintenance activities such as backup/?recovery & capacity monitoring/?management

  • Strong knowledge of how indexes work and management of index statistics & fragmentation

  • Will setup and manage fail-over clusters, developing and managing SSIS packages, database mirroring, and replications.?

  • Experience in managing and making software deployments/?changes in real time production environments

  • Experience collaborating with development teams on physical database design activities and performance tuning

  • Familiarity with C# and .?NET framework.?

  • Ability to concurrently handle multiple projects.?

  • Must have good problem-solving and communication skills

  • Experience with Microsoft Server 2008/?2012 Clustering & SQL Server High Availability Clustering/?Replication

  • A deep specialized domain knowledge and expertise in deployed systems (scalable distributed systems algorithms, storage allocation algorithms, and deep database skills.?


Preferred:



  • 6+? years of advanced T-SQL development and in-depth knowledge of SQL internals

  • 6+? years of experience developing and managing Microsoft SQL databases

  • NoSQL database experience highly advantageous

  • An MCSE or MCSM highly desired



Experience Requirements:


5-7 years of experience in Database Administration and support of enterprise level environments.?



Education Requirements:


Bachelor's Degree in Computer Science or related field required.? SQL Server 2012 Enterprise Experience and Microsoft Certified Database Administrator a plus.?


Email This Job to a Friend

 

Copyright © 2008 - 2014 Vaco :: All Rights Reserved :: Design & Development by centre{source}