Senior Database Administrator

SUMMARY: The Senior Database Administrator (DBA) serves as the senior information technology specialist, providing leadership to technology specialists throughout the company to facilitate database and application design and implementation. The Senior DBA leads all aspects of the company’s information modeling, design, implementation, maintenance, security and data quality.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• Manage the support, operation, and performance of the company’s SQL database environment.
• Define and document all aspects of the database environment, including logical and physical data models, metadata, business rules, and logic to ensure consistency across all databases.
• Provide recommendations for data utility, management tools, and emerging technologies.
• Analyze application requirements and develop logical database table designs.
• Design and enforce referential integrity to align with business rules.
• Ensure data security, availability, and quality in alignment with corporate database security policies and compliance standards.
• Partner with network and systems administration staff to define database infrastructure requirements, including sizing, logging, backup, and disaster recovery strategies.
• Translate logical designs into optimized physical implementations.
• Utilize advanced techniques such as data profiling and reverse engineering of database objects to accelerate development.
• Develop, implement, and validate backup and recovery procedures, including high availability and disaster recovery solutions (e.g., clustering, mirroring, replication, Always On Availability Groups).
• Monitor database performance and optimize queries, indexes, and configurations to ensure efficient operation.
• Design and develop ETL (Extract, Transform, Load) and data transformation processes to support imports, exports, and integrations.
• Partner with infrastructure teams to upgrade, patch, and maintain database servers (on-premises and/or cloud environments such as Azure SQL, AWS RDS).
• Automate administrative tasks using scripting languages (e.g., PowerShell, Python, T-SQL).
• Ensure adherence to data governance, compliance, and regulatory requirements (e.g., HIPAA, SOX, GDPR, as applicable).
• Mentor developers and analysts in effective use of SQL, database design principles, and troubleshooting.
• Collaborate with application teams and stakeholders to design systems that meet both technical and business requirements.
• Administer FTP servers and related network data services.
• Participate in change management and deployment processes, including CI/CD and version control for database assets.
• Author and maintain system documentation, procedures, and user-facing reports.
• All other tasks as assigned.

EDUCATION and/or EXPERIENCE

• Bachelor’s degree in Computer Science, Information Technology, or related field plus 10 years related experience or equivalent combination of education and experience.
• 5+ years of hands-on SQL Server database administration experience.
• Strong background in database design, optimization, and performance tuning.
• Proven experience with high availability and disaster recovery solutions.
• Familiarity with cloud database platforms (Azure SQL, AWS RDS, or equivalent).
• Proficiency in automation and scripting (PowerShell, Python, or equivalent).
• Expertise in Microsoft Office suite and database modeling tools (Microsoft Word, Excel, Access, Visual Basic, Visio, Erwin, or equivalent).

PREFERRED EXPERIENCE

• Familiarity with Crop-Hail and/or Multiple Peril crop insurance.
• Relevant certifications (Microsoft, AWS, Oracle) .
• Familiarity with Automate and/or Mfiles.
• Familiarity with FTP Server Software.
• Experience with ETL tools (e.g., SSIS, Informatica, Talend) and BI/reporting tools (e.g., Power BI, Tableau, SSRS) preferred.

OTHER SKILLS and ABILITIES:

• Expertise in database/system design tools and methodologies.
• Ability to prioritize tasks, manage time effectively, and perform with minimal supervision.
• Strong leadership and mentoring skills for guiding technical teams.
• Knowledge of client-server architectures, Windows Server environments, and Microsoft SQL Server ecosystem (IIS, Exchange, etc.).
• Familiarity with DevOps practices, CI/CD pipelines, and version control systems (Git).
• Commitment to continuous learning and staying current with industry trends.

#toponehire