Senior Database Administrator

Description

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.
  
  

Qualifications

MINIMUM QUALIFICATIONS

• 7+ years of experience with MS-SQL or similar SQL database writing T-SQL and stored procedures and database schema design
• 5+ years developing or administering large-scale, highly reliable and highly available Internet facing application databases using Microsoft SQL Server, or Azure SQL
• 5+ years of experience in performance monitoring and tuning of SQL based workloads
• 3+ years of experience working with Azure
• 1+ year of experience with Power BI and SSRS for data reports
• Demonstrated ability to coordinate cross-functional work teams toward task completion
• Advanced written and verbal communication skills
• Strong mathematical, problem solving and analytical skills
  
  

Preferred Qualifications

• Experience with non-AzureSQL Azure data platform resources such as Storage accounts, CosmosDB, Azure Data Factory.
• Related certifications such as MCSA: SQL 2016 Database Administration, Azure Database Administrator Associate, Azure Data Fundamentals, or related certifications.
• Experience in developing technical documentation
• Experience using JIRA, Git (BitBucket), Lucid Chart, C#
• Experience with data warehousing and business intelligence concepts
• Experience with scripting languages such as PowerShell or Python for automation of database tasks
  
  

Acumen is an Equal Employment Opportunity (EEO) employer. We embrace diversity in all its form. We provide equal employment opportunities to all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran or disabled status, or genetic information.

If you require reasonable accommodation for any part of the application process or hiring process, please submit your request through one of the following methods listed below:

• Dedicated fax 866-268-8885
• Dedicated email
• US mail -
• Dedicated phone 1-866-242-2714 Option 1 (Employment Opportunities) DISABILITY ACCOMMODATION REQUESTS ONLY