What are the responsibilities and job description for the Senior Sql Database Administrator position at Indotronix Avani Group?
Job Title : SQL DBA
Location : San Diego, CA 92121
Position Type : Contract, Temp to Perm possibility
Duration : 12 Months
Indotronix Job Code : CFNJP00050267
Full Job Description :
Architect and design scalable, secure, and high-performance database solutions for current and future business needs.
Design and implement cloud data models that optimize scalability, performance, and flexibility.
Lead efforts to modernize and future proof database to align with enterprise cloud goals.
Work on configuring and updating SQL database environments with CI / CD pipeline.
Configure and manage Azure SQL services including elastic jobs for management across multiple databases.
Optimize and refactor SQL resources, implement best practices for performance maintainability and reliability.
Design and implement database security strategies.
Research, evaluate and implement new features and technologies to drive innovation.
Work closely with other teams to align database solutions with overall system architecture.
Work in a scrum-based agile development process that plans, and builds features targeted to a release.
Experience :
Bachelor’s degree in computer science, engineering, or a relevant field.
8 years of experience as SQL server DBA with expertise in database architecture, optimization etc.
3 years of experience with Azure SQL, Azure AD and cloud database administration.
Strong experience with PowerShell, T-SQL scripts and IaC tools / scripts.
Experience automating database setup and deployments using DACPAC, BACPAC, scripting tools etc.
Strong experience in query tuning, indexing strategies and database performance optimization.
Proficiency in failover, geo-replication and disaster recovery strategies
Proficiency in azure sql database, elastic jobs , elastic pools, managed identity etc.
Troubleshoot database issues, deployment failures etc.
Deep Understanding of Azure AD integration, RBAC etc.
Knowledge of event driven architecture and integration
Agile software development processes - Scrum or Kanban
Working in a regulated environment or medical SW is a big plus.
Must be a self-starter and independent managing workload with little day-to-day instruction keep up to date with the latest industry trends experience with demonstrated understanding of DevOps and Release Management processes, artifacts, and tools.
Supported and debugged sophisticated and multi-platform development environments
