Senior Database Administrator

Job Title:

Location:

Employment Type:

Experience:

About NationsBenefits:

platform modernization

Database Administrator (Azure SQL)

Key Responsibilities:

Performance Optimization:

• Monitor and analyze database performance, identifying and resolving bottlenecks.
• Optimize SQL queries and stored procedures to enhance application performance.
• Ensure indexes are well-defined and maintained.
• Evaluate performance across releases to ensure consistency.

Query Tuning:

• Conduct performance assessments and optimize query execution plans.
• Utilize tools like Azure SQL Database Query Performance Insights and Query Store to track and improve query performance.

Schema Management:

• Design and maintain database schemas for optimal data integrity and normalization.
• Work with Development & Change Management teams to implement schema changes with minimal downtime.

Backup & Recovery:

• Develop and manage backup and recovery plans to ensure data availability.
• Regularly test backup and recovery procedures to validate effectiveness.

Security & Compliance:

• Implement and enforce database security policies, including user access controls and auditing.
• Ensure compliance with industry standards for data protection and security.
• Enable role-based access control (RBAC) at the column level for geo-sensitive data.

Collaboration & Support:

• Work closely with development teams to provide database design input and support application development.
• Troubleshoot and resolve database-related production issues.
• Assess and guide the migration of business logic from stored procedures to middletier services.
• Educate development teams on efficient database access using LINQ and C#.

Documentation & Reporting:

• Maintain detailed documentation of database configurations, procedures, and performance metrics.
• Generate reports on database performance and optimization efforts for stakeholders.

Requirements:

• Educational Background:

  Bachelors degree in

  computer science, Information Technology, or a related field

  .

• Experience:

  At least

  5+ years of experience as a Database Administrator, specializing in Azure SQL Database

  . With overall,

  10+

  of IT experience.

Technical Skills:

• Strong expertise in performance tuning, query optimization, and schema management.
• Hands-on experience with Azure Monitor, Azure SQL Analytics, and Azure Data Studio.
• Familiarity with C# and LINQ for database interactions.
• Understanding of database security best practices and compliance requirements.

Soft Skills:

• Problem-solving

  and troubleshooting abilities.
• Strong

  communication skills

  for cross-team collaboration.

Why Join Us

• Lead a pioneering FinTech initiative with cutting-edge technologies and scalable architecture.
• Career growth opportunities in a fast-growing, innovative-driven environment. o Impact the financial ecosystem by building secure, high-performance applications.
• Contribute to cutting-edge products that enhance member engagement in healthcare.