ABOUT THE COMPANY
Â
Acumen, LLC. is one of the nation's leading fiscal agents offering a portfolio of innovative financial management services backed by superior customer service. Our passion is to help people lead independent lives through exceptional participant-directed programs. Acumen is a great place to work. Our employees make a positive difference in our clients lives by what they do. Among many benefits to working here, we offer medical, dental and vision coverage, generous paid time off, and incentive bonuses to those who qualify.
Â
OVERVIEW AND ESSENTIAL JOB FUNCTIONS
The Senior Database Administrator serves as a subject matter expert and technical leader, overseeing the architecture, performance, security, and reliability of our data platform resources. As a senior member of the DCI Engineering team, this individual will spend their time managing the performance, reliability, and availability of production and non-production databases used across the DCI Software product line. The Senior Database Administrator will be the ultimate escalation point for complex data platform performance, availability, and security issues, and will play a key role in ensuring the scalability and sustainability of our data infrastructure.Â
Â
- Lead the design, implementation, and maintenance of data platform solutions, ensuring alignment with business requirements and industry best practices
- Serve as a technical guide to other SQL analysts and engineers, providing training, knowledge sharing, and technical guidance
- Develop and maintain comprehensive documentation of database architecture, configurations, and operational procedures
- Collaborate with cross-functional teams, including software development, application support, and infrastructure, to ensure seamless integration of database services
- Manage security of data platform resources, implementing security best practices and access controls to protect sensitive data
- Lead cost optimization efforts regarding data platform resources, identifying opportunities for efficiency improvements and cost reductions
- Participate in the evaluation and selection of new database technologies and tools, ensuring alignment with business needs and technical requirements
- Stay up-to-date with the latest database technologies and trends and proactively identify opportunities to leverage new features and capabilities
- Use Power BI and SSRS to create and maintain reports on data needed for customers and internal personnel.
- Assist SQL analysts and other report writers with training and guidance for data reports
- Drive automation initiatives to streamline database administration and data reporting tasks and improve operational efficiency
- Receive, assess, and categorize escalated issues using DCI's ticketing and issue management tools
- Perform regular regression analysis across all environments to identify poor-performing queries and identify potential issues before customer impact
- Perform pre-release performance review in both UAT, and production post-deployment
- Evaluate and monitor index utilization and strategy, implementing solutions on an as-needed basis
- Propose and lead cost reduction efforts in regard to data platform resources
- Identify and tune bottleneck queries (high IO, CPU, record count, run time, execution count)
- Proactively identify and address security vulnerabilities and scalability limitations within the data platform
- Perform database baselining, benchmarking, performance analysis, and tuning functions
- Assist in process development and enhancement in accordance with ITIL best practices
- Act as a technical escalation point for the software development and application support teams
- ALL Acumen employees will be vigilant to support the positive compliant cybersecurity company posture by familiarizing themselves with all policies, procedures, standards, and guidelines and act accordingly. In addition to the cybersecurity requirements of all positions at DCI, the Data Services team will support the secure design, development, security installation/configuration, and remediation of computer hardware, software, systems, networks, printers, scanners, and cloud properties. Additionally, these positions will support the proper conduct of incidents, responses, and investigations.
