Work Location: 100% ONSITE
Summary:
This position is part of a highly collaborative, driven team that enjoys researching and implementing new systems and technologies to foster an increase of business value. This position is a key member in planning of overall data strategy. Supporting operations are a primary focus, looking at database performance and optimization. The increase in business value will be mainly project driven, which includes implementing database systems that support new technologies, migration efforts due to infrastructure upgrades, and working with data analysts to expose data to enable them to develop reports with the focus on deriving additional business value.
Responsibilities:
- Maintain several SQL Server database clusters used for core business operations.
- Troubleshoot production database issues.
- Monitor and analyze SQL performance in order to improve database performance using SQL Spotlight or other tools.
- Assist in the review, design, and implementation of the database environment.
- Automate routine tasks.
- Perform security functions, such as compliance related reporting on database activity.
- Assist the Planning and Analysis team with gathering the proper data for business reporting.
- Assist with automation processes and aid in performance analysis and optimization of reporting.
- After hours and weekend on-call availability for production issues.
- Create, maintain, and organize technical documentation for all property information systems.
- Investigate business solutions, technologies, and opportunities that can benefit the organization and/or their area of responsibility.
Requirements:
- Bachelor’s Degree in Computer Science, Computer Information Systems or equivalent experience.
- Solid experience (8+ years) administering SQL server databases.
- Experience with SQL Server and SSRS.
- Strong knowledge with failover clustering, replication, and other high availability technologies.
- Knowledge of data warehouse space, custom ETL design and implementation.
- 2 years’ experience in managing projects effectively, and utilizing resources appropriately to ensure a timely, quality product.
- Ability to work well in a highly team driven environment.
