Provide insight into the changing database storage and utilization requirements for the company and offer suggestions for solutions.
Analyze database implementation methods to make sure they are in line with company policies and any external regulations that may apply.
Create data monitoring models for each product and work with our marketing team to create models ahead of new releases.
Develop database design and architecture documentation for the management and executive teams.
Help maintain the integrity and security of the company database.
Bachelor’s Degree in Computer Engineering or related field required (Master’s degree preferred)
5+ years’ experience in a data analysis or management role
Object oriented languages
Experience with Informix, MongoDB
SQL Development Experience – Ability to design, write, tune, and troubleshoot SQL solutions (Stored procedures, functions, tables, views, triggers, indexes, constraints, synonyms, linked servers, templates/snippets, SSIS packages, SSRS reports, etc.)
Strong knowledge and experience in archival backup and restore/recovery methods –Snapshots, Full, Differential, Log, File Groups, Partitioning, System, etc.
Strong knowledge and experience in implementing/supporting High Availability/Disaster Recovery models (Clustering, Log Shipping, Replication, Mirroring and Availability Groups, etc.)
Oracle is a plus
Ability to monitor, detect, and troubleshoot SQL Server related resource contention issues including CPU and memory utilization, I/O and disk space utilization, deadlocks, tempDB utilization, etc.
Good analysis skill
Strong communication skills proven through past experience
Attention to detail; accuracy is a must