The Database Administrator maintains the structure of B&H's databases on both development and production levels. S/he will implement and monitor the disaster recovery and backup systems. They would be responsible for regular maintenance, upgrades and patches ensuring efficient data storage and flow.
•Ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO)
•Test backups to ensure we can meet the business' Recovery Time Objectives (RTO)
•Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
•Configure SQL Server monitoring utilities to minimize false alarms
•Analyze and decide on technologies to use and methods to implement when new systems are bought in.
•Install and configure new SQL Servers
•Deploy database change scripts provided by third party vendors
•Determine the best approach on server configuration changes, index/query changes, hardware purchases etc in case of any performance issues
• Document the company's database environment
•As assigned by Director
Specific Knowledge, Skills and Abilities:
•Understands database structure and environmental relationships
•Knowledge of SQL coding language including PLSQL and T-SQL
•Excellent written and oral communication skills
•Ability to work independently, as well as a collaborative partner on a team.
•Able to maintain knowledge of current technologies and techniques
Preferred Education, Experience and Licenses:
•5+ years MS SQL Server Administration experience required.
•Successful track record in the hands-on support, monitoring, architecture, deploying, security, monitoring, performance and troubleshooting of MySQL Server instances.
•Demonstrated knowledge of database maintenance, recovery, and failover handling
•Experience setting up automated deploys. We are an Equal Opportunity Employer. All persons shall have the opportunity to be considered for employment without regard to their race, color, religion, national origin, ancestry, alienage or citizenship status, age, disability or handicap, sex or gender, marital status, veteran status, sexual orientation, arrest record, or any other characteristic protected by applicable federal, state or local laws.