The Database Administrator working with the Senior Database Administrator will be responsible for the installation, implementation, configuration, maintenance, security, integrity and performance of critical Microsoft SQL Server systems, to ensure the availability and consistent performance of our applications. This is a "hands-on" position requiring solid technical skills, as well as excellent interpersonal and communication skills.
Duties and Responsibilities
Responsibilities include, but are not limited to the following:
- Ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO)
- Test backups to ensure meeting the business' Recovery Time Objectives (RTO)
- Troubleshoot SQL Server issues as they occur, including after-hours and weekends. Regularly maintain and troubleshoot databases, work effectively with other team members to identify and address problems
- Configure SQL Server monitoring utilities to minimize false alarms
- Install and configure new SQL Servers
- Deploy database change scripts from developers or provided by third party vendors
- When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes or index/query changes
- Document the company's server and database environment and write detailed design or process specifications documents
- On-call troubleshooting experience with production SQL Server
- Use third party tools or scripts to solve system or performance issues
- Monitor databases, manage backups and recovery, and performance tuning for all databases
- Extracts, transforms and loads data from disparate data sets to ensure the effective and efficient storage, retrieval, customization and archiving of data
- Develop database schema, stored procedures, functions and scripts
- Perform data analysis and data design to support business and performance requirements
- Assist with the establishment and enforcement of database and data integration standards and guidelines in order to ensure data integrity
- Engineer best practices and processes to ensure the best possible solution and delivery timelines
- Other duties as assigned
- Corporate Compliance Responsibility - As an essential function, responsible for complying with Neighborhood's Corporate Compliance Program, Standards of Business Conduct, applicable contracts, laws, rules and regulations, policies and procedures as it applies to individual job duties, the department, and the Company. This position must exercise due diligence to prevent, detect and report unlawful and/or unethical conduct by fellow co-workers, professional affiliates and/or agents