Title Senior SQL Server Database Administrator Location Near to Los Angeles, CA Duration 6 Months Local Candidates are Highly Preferred, candidate must be willing to relocate to Los Angeles, CA area. Required skills and abilities Minimum 10 years of operational database administrator experience at an enterprise level, with multiple versions of Microsoft SQL Server, in a highly transactional OLTP OLAP environment, and preferably in a hosting andor corporate 24×7, highly available environment. In depth working knowledge of SQL CDC (Change Data Capture) Know it’s interaction with Tlog, TempDB, and Always On replication. Experience with installing and supporting a scaled-out Reporting Services environment (SSRS). Experience with developing and administrating data flow processes using SQL Server Integration Services (SSIS). Experience working with Windows server, including Active Directory, and proper disk configurations for database performance. Knowledge of managing and administrating MS Analysis Services and Tabular services. Solid understanding of best practices for SQL Server administration. Comprehensive knowledge of SQL Server engine internals, query execution plans, index management, and performance tuning. Familiarity in setting up actionable alerts to proactively manage systems with native Microsoft tools as well as third party applications, such as Idera. In-depth hands-on knowledge of Disaster Recovery, High Availability, Business Continuity strategies and architecture, such as Microsoft Windows Cluster, Always On, Backups, San replicationsnapshots. Self-motivated with the ability to be proactive, work well under tight deadlines, flexible hours, with limited direction. Team player with strong intercommunication skills and the ability to provide clear documentation of production processes as necessary. Ability to translate business requirements into technical solutions. Other skills MCDBA, MCITP-DBA, or MCSE certifications a plus. Practical knowledge of Tableau server and Tableau Cloud. Practical knowledge of DevOps concepts, strategies, and architecture. Understanding of relational database design and concepts. Expert skills in TSQL and PowerShell scripting.