Personify Health · 3 days ago
Senior Database Administrator (MSSQL)
United States
Full-time
Remote
Senior Level
$103K/yr - $130K/yr
5+ years exp
Maximize your interview chancesConsultingElectronic Health Record (EHR)
Insider Connection @Personify Health
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
Manage and maintain data management systems to encompass design, installation, deployment, replication, backup, restoration, optimization, security, and data exchange. Systems include ETL, transactional data stores, data warehouse, and reporting.
Maximize database performance by tuning file structures and managing indexes.
Advise and guide software architects and engineers on data access methods and decisions on optimal data structures.
Safeguard data integrity and maintain security controls in all existing databases and data exchange technology through process, training, quality control, and monitoring.
Write simple to complex SQL queries, troubleshoot queries, and tune queries for best performance.
Design and implement processes to automate transactional information functions to optimize operational efficiency throughout the organization.
Manage data operations for data at rest, data exchange, batch processing, and data reporting.
Support development and production activities.
Generate and maintain documentation of data store systems, architectures, configurations, operations, and maintenance.
Provide guidance and coaching to junior and mid-level engineers.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
5 years’ experience administering, maintaining, and optimizing Microsoft SQL Server at scale
3-5 years of experience running large MSSQL data stores in AWS on EC2 and RDS/Aurora
Expert knowledge (2-3 years of experience) of performance and availability monitoring, backup/restore, performance tuning, query optimization
Thorough understanding of relational database technology and concepts, SQL scripting, database normalization best practices
Configuration of database servers for high availability and operation of HA environments via Always On availability groups
Advanced expertise in SQL, stored procedures, data batch processing, and data as a service
Practical experience in managing internal and external database security
Excellent communication and documentation skills
Ability to triage issues, react well to changes in priority, work with teams, and self-manage time and effort across multiple projects
Preferred
Microsoft SQL Server certification is preferred.
Previous experience in healthcare or other highly regulated industries preferred.
Benefits
10% target bonus/variable compensation
Health, dental, vision, mental health and other benefits
Company
Personify Health
Personify Health is a software that provides health plan administration, comprehensive health navigation, and holistic well-being solutions.
1,001-5,000 employees
Funding
Current Stage
Late StageRecent News
GlobeNewswire News Room
2024-11-19
2024-11-15
2024-11-01
Company data provided by crunchbase
