Senior Database Administrator — Baton Rouge, LA
Зарплата не указана
ОткликнутьсяBrief Description
About u4qj5r CWEpPPDpc
6AAmx3 is a Louisiana-headquartered personal auto insurance company with operations spanning eight states, 68 branch locations, and approximately 440 employees. Our mission is simple: to make auto insurance accessible and affordable for everyone.
As we continue to grow, we are investing in the technology, systems, and talent that support our operations and deliver reliable service to our customers. Data plays a critical role in every aspect of our business, from quotes and policy administration to claims processing. As a Database Administrator, you will play an essential role in maintaining the security, integrity, performance, and reliability of the data and systems our employees and customers depend on every day.
Position Summary
u4qj5r CWEpPPDpc is seeking an experienced Senior Database Administrator to own the availability, performance, security, and recoverability of the Microsoft SQL Server environments that run our policy administration, claims, premium finance, and reporting systems.
This is a hands-on senior role with broad ownership, spanning day-to-day administration, database security, performance, and the reporting data layer. The person in this role will set the standards for how database work is done here and will be the company's primary technical authority on the database environment.
As an auto insurance organization operating across eight states, our data supports underwriting and rating decisions, claim handling, regulatory filings, and financial reporting. Database integrity, availability, and security are business-critical, and this role is central to all three.
Key Responsibilities
Availability, Backup, and Recovery
• Own the backup strategy across production and non-production database instances, including full, differential, and transaction log backups aligned to recovery point and recovery time objectives
• Own scheduled restore testing and document that backups are recoverable
• Own high availability and disaster recovery for the database environment, selecting and maintaining the appropriate technologies
• Plan and lead failover exercises, and document results and follow-up items
• Participate in on-call response for database incidents; lead root cause analysis and post-incident documentation
Database Security and Access Administration
• Own database security administration, including logins, roles, permissions, and periodic least-privilege access reviews
• Implement and maintain encryption at rest and in transit, and evaluate data masking or tokenization where appropriate
• Configure and maintain database-level auditing sufficient to support internal control reviews and state Department of Insurance examinations
• Support the company's information security program as it applies to database systems, including controls for nonpublic personal information under the Gramm-Leach-Bliley Act safeguards requirements and the insurance data security laws of the states in which 6AAmx3 operates
• Define and enforce data retention and secure disposal practices for database systems, in coordination with Compliance and Legal
• Serve as the subject matter expert on database security in audits, examinations, and vendor security reviews
Performance, Capacity, and Platform Modernization
• Own database monitoring and alerting, including performance baselines for CPU, memory, I/O, blocking, deadlocks, and wait statistics
• Analyze and tune slow-running queries and stored procedures using execution plans, statistics, and query store
• Own index strategy, including design, maintenance, fragmentation management, and removal of unused or duplicate indexes
• Perform capacity planning for storage and compute growth, and communicate infrastructure needs ahead of constraints
• Lead database version upgrades and cloud or hybrid migrations as needed, including assessment, compatibility testing, cutover planning, and rollback strategy
Data, Reporting, and Integration
• Own the reporting and analytics data layer, including any data warehouse, data marts, and reporting databases
• Design, build, and maintain ETL and data integration processes using SSIS, Azure Data Factory, or equivalent
• Support Power BI and other reporting platforms as the owner of data sources, refresh schedules, and semantic model performance
• Partner with business analysts and business owners to ensure reporting data is accurate, timely, and reconcilable to source systems
• Support data extracts required for statistical reporting, state filings, carrier and reinsurer reporting, vendor integrations, and audit requests
• Own data quality and reconciliation controls
Standards, Documentation, and Technical Leadership
• Maintain the inventory of database instances, databases, and their business owners
• Own and enforce database standards covering naming conventions, change control, schema versioning, and promotion through development, test, and production environments
• Review and approve database changes proposed by application developers, including schema changes, stored procedures, and query patterns
• Maintain runbooks and operational documentation for critical database procedures
• Provide technical direction and mentorship to developers and analysts on database design, query efficiency, and safe data handling
• Advise leadership on database architecture, licensing, and infrastructure investment
Required Qualifications
• Seven or more years of hands-on database administration in a production environment, with deep Microsoft SQL Server experience
• Demonstrated ownership of backup and recovery, including documented experience performing real restores and recovering from failure
• Direct experience implementing and testing high availability and disaster recovery solutions
• Strong performance tuning skills: execution plan analysis, indexing strategy, wait statistics, and resolution of blocking and deadlocking
• Hands-on experience administering database security, permissions, encryption, and auditing
• Experience migrating or upgrading SQL Server across major versions, and experience with cloud or hybrid database platforms such as Azure SQL Database or Azure SQL Managed Instance
• Advanced T-SQL, including complex queries, stored procedures, and production troubleshooting
• Experience with ETL development and maintenance, such as SSIS or Azure Data Factory
• Experience supporting a business intelligence or reporting platform as a data source owner
• Proven ability to work in a regulated environment subject to audit or examination
• Strong written documentation skills; able to produce runbooks and procedures others can follow
• Ability to communicate database risk and status clearly to non-technical business leadership
Preferred Qualifications
• Experience administering PostgreSQL or MySQL in addition to Microsoft SQL Server
• Experience in insurance, particularly personal auto, or another regulated financial services environment
• Familiarity with policy administration, claims, billing, or premium finance systems
• Understanding of insurance data concepts such as policy lifecycle, claim reserves, premium transactions, and statistical reporting
• Experience supporting Department of Insurance examinations or similar regulatory reviews
• Familiarity with the NAIC Insurance Data Security Model Law or comparable state insurance data security requirements
• PowerShell scripting for database automation
• Microsoft certification in database administration, data engineering, or Azure
• Experience mentoring developers or leading a small technical team