Senior SQL DBA

Unclassified - Los Angeles, CA

Full-time - Senior

Los Angeles, CA

About the position

The Senior SQL Database Administrator (DBA) position involves managing and optimizing SQL Server databases to support high-traffic web applications. The role requires a critical thinker with extensive experience in SQL Server versions 2008R2, 2012, and 2014, and the ability to work in a 24/7 support environment.

Responsibilities

• Manage and optimize SQL Server databases for high-traffic web applications.
• Support enterprise-level database systems 24/7.
• Review database design and make recommendations for enhancements or improvements.
• Perform complex TSQL tuning to improve database performance.
• Manage SQL Clusters (active/passive, active/active).
• Utilize SSRS and SSIS for reporting and integration tasks.
• Design and manage VLDBs (Very Large Databases).
• Use PowerShell or VBscript for automation tasks.
• Create physical and logical models using Erwin or Visio.

Requirements

• Hands-on experience with SQL Server 2008R2, 2012, and 2014.
• Experience with SQL Clusters (active/passive, active/active).
• Proficiency in SSRS and SSIS.
• Experience in managing and designing VLDBs.
• Strong skills in complex TSQL tuning.
• Excellent written and verbal communication skills.
• Ability to support high traffic websites with over 60 million page views/month and 500K simultaneous users.
• Experience in architecting and tuning database servers for high traffic requirements.

Nice-to-haves

• Experience with MySQL and NoSQL databases.
• Familiarity with SAN technology and server technology.
• Knowledge of C# programming.