Rise Services-posted 3 months ago
Full-time • Senior
Mesa, AZ
1,001-5,000 employees
Nursing and Residential Care Facilities

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
  • Support the positive compliant cybersecurity company posture by familiarizing themselves with all policies, procedures, standards, and guidelines and act accordingly
  • 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
  • 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
  • Medical coverage
  • Dental coverage
  • Vision coverage
  • Generous paid time off
  • Incentive bonuses to those who qualify
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service