Previous Job
Previous
SQL Application DBA/Pomona, CA 6mth+ Contract (NTTJP00006159)
Ref No.: 18-01147
Location: Pomona, California
Position Type:Contract
 Client is in need of an SQL application DBA to troubleshoot and make minor enhancements. 

Position's General Duties and Tasks 
• Develop and support the SQL Server database architecture by creating tables, indexes, views, indexed views, functions, triggers, stored procedures, and tuning complex queries 

• Responsible for SQL Server Software installation and upgrades. Develop and implement Backup and Recovery Strategies. 

• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. 
• Support High Availability Solutions like Always On, DB Mirroring, Log shipping, Clustering etc. 
• Create and support data load processes via SSIS and database refreshes 
• Participate in documenting all ETL processes and flows 

EXPERIENCE 
• Bachelor's degree in Computer Science or Information Science or related field with a minimum of 3 years of experience 
• 2 to 3 years MS SQL Server Administration experience required (2008 R2, 2012, 2014, 2016) 
• Microsoft SQL DBA certification preferred 
• Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools 
• Experience with backups, restores and recovery models 
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server 
• Experience with SQL Server Integration Services (SSIS) and ETL tools/operations 
• Experience with SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) 
• Experience working with Windows Server, including Active Directory 
• Strong organization skills to manage multiple timelines and complete projects quickly within the constraints of timelines and budgets 
• Strong interpersonal, collaborative and creative problem-solving skills