SQL Database Administrator in Pomona, CA at GDH

Date Posted: 8/10/2018

Job Snapshot

Job Description

Description:

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