ESSENTIAL DUTIES AND RESPONSIBILITIES:|
Design and document database architecture. Data Modeling
Design Data Warehousing
Build database schemes, tables, procedures and permissions
Develop database utilities and automated reporting
Analyze and sustain capacity and performance requirements
Analyze and tune database for optimal efficiency
Monitor systems and platforms for availability
Oversee backup, clustering, mirroring, replication and failover
Restore and recover corrupted databases
Install and test upgrades and patches
Implement security and encryption
Provide 24/7 support for critical situations
Evaluate and recommend new database technologies
Work closely with the Development and IT team
SKILLS AND QUALIFICATIONS:
Strong experience in database development and support in MS SQL Server environments
Strong experience in troubleshooting and resolving database problems.
Experience in performance tuning and optimization using native monitoring and troubleshooting tools.
Experience with backups, restores and recovery models.
Knowledge of High Availability and Disaster Recovery options for MSSQL Server.
Experience in implementing operational automation.
Knowledge of indexes, index management and statistics.
Experience working with Windows server, including Active Directory and proper disk configurations
Ability to model data from user requirements.
Good communication and documentation skills
Experience in an Agile fast paced environment
Experience in a startup or small team environment
Experience with MYSQL
This job description in no way states or implies that these are the only duties to be performed by this employee. He or she will be required to follow any other instructions and to perform any other duties requested by his or her supervisor.