Database Warehouse Analyst jobs in Modesto, CA

• Build database structures based on detailed design and configure replication
• Maintain and test backup and recovery processes
• Enforce security measures to protect company data both internally and externally
• Provide support during system implementation and production
• Identify gaps in scripts and procedures
• Normalize data across all data sources
• Provide IT coverage for the office and assist staff with meetings when needed
• Research and document existing stored procedures and database structure
• Provide support for end users and help desk requests
• Define maintenance plans and maintain disaster recovery plan
• Work in conjunction with the Data Analyst to enable data accessibility
• Perform physical and logical database administration functions as required for Application Sustain Services
• Create shell scripts and SQL scripts for staff
• Work with end users and other third parties (Application, Architects, ITO personnel, tester etc.) to support DBA functions
• Review new Database Management System (DBMS) releases with end users to understand the business and technical impacts
• Set up and maintain test and production databases
• Propose database changes to ease monitoring and administrative effort
• Document and implement changes to databases via proper Change Management methodology
• Monitor and analyze database activity to proactively identify and prevent potential incidents and recommend performance improvements

Knowledge of:

• Microsoft SQL Server, Access Databases, and the 365 environment
• Cloud services such as Azure and AWS
• Microsoft Windows Active Directory
• Oracle Database Architecture
• Audio Visual systems
• Veeam Enterprise Backup
• Database services and management as well as the principles and practices of database analysis and evaluation

• Keen attention to detail and strong organizational skills
• The ability to prioritize tasks in a fast-paced environment
• Strong sense of urgency to provide timely service to staff
• Critical thinking, logical thought processes, and complex problem-solving
• Working in a team-oriented, highly collaborative environment
• Best practices in data visualization and business intelligence

• Participation in work-related upgrades and service restoration outside of normal working hours as needed
• Highly motivated to keep abreast of technology and industry best practices, pursue relevant certifications, etc.

• Bachelor’s degree in related field and 4 years of experience in database management preferred or equivalent combination of education and experience
• Certified in Microsoft SQL Server
• Power BI experience highly desired

• Ability to work for extended periods of time at a computer
• Vision sufficient to read handwritten and printed documents and computer screens
• Speech and hearing sufficient to communicate by phone and in person in English
• Manual dexterity sufficient to use a variety of office equipment and tools, computer keyboards, and to manipulate papers
• Lifting and transporting of moderately heavy objects, such as computers, servers and peripherals (10 lbs. - 50 lbs.) occasionally
• Occasional walking, stooping, climbing, kneeling to install, repair, and inspect equipment