Job Description :
Position: Sr. SQL Server DBA
Location: Newport Beach, CA
Duration: 6 + months contract

Looking for a SQL Server expert, to work in a fast paced environment, providing both production & development support. This position will work closely with various development groups across the firm, and should demonstrate his/her ability as a technical expert on the team.

Job Summary

Provide production support, solutions and expertise for 100+ SQL Servers in multiple data centers, including development, test and production environments.
Ability to troubleshoot difficult production issues quickly.
SQL Server installations, configuration, upgrades and patching.
Tune complex SQL proactively & reactively as required. Be able to rewrite SQL queries where necessary.
Design, implement, and maintain capacity planning for database systems.
Database development including writing stored procedures, functions, triggers, indexes and jobs.
Perform Database Upgrades as required.
Help design, maintain, improve and implement monitoring tools.
Resolve complex database related issues and outages.
Handle your share of DBA tickets, user requests, routine support and maintenance.
Ability to work off hours / weekends as required.

Technical Knowledge:
10+ years’ experience as a Microsoft SQL Server DBA.
Experience in use of T-SQL for SQL Code and stored procedures are required.
Experience with clustering, Always On, SSRS, SSIS and disaster recovery exercises.
Experience with Backups, Restores, DBCC commands & SQL Profile.
Proven track record of physical optimization, query optimization and capacity planning.
Proven track record of SQL and database tuning on VLDBs.
Outstanding problem solving and analytical skills.

Preferred Additional Qualifications:
Experience with database replication technology, such as Sybase Rep Server & Oracle Golden Gate.
Experience with Sybase IQ, ASE, Oracle and/or MongoDB is a plus.