Senior Sql Database Administrator

Hello Everyone,Role: SQL Server DBA with AllegroLocation: Irving TX Onsite (3 days onsite)Duration: 12+ MonthsTop things looking for:Experience 12 to 20 Years Skills (Must Have) – SQL Server DBA, Allegro, AWS Responsibilities:Database Design and DevelopmentDesign and develop scalable database schemas, tables, views, and stored procedures.Optimize database queries for performance and scalability.Implement best practices for database normalization and indexing.Application SupportCollaborate with application developers to design efficient database solutions for business applications.Provide database support during application development, testing, and deployment phases.Troubleshoot and resolve database-related application issues.Performance TuningMonitor and analyse database performance using tools like Extended Events or any Third-party tools.Optimize query performance, indexing strategies, and execution plans.Resolve deadlocks, blocking issues, and high CPU/memory utilization problems.Database AdministrationPerform backups, restores, and disaster recovery planning.Implement database security measures, including user roles, permissions, and encryption.Data IntegrationDesign and implement data import/export solutions using tools like SSIS, BCP, or BULK INSERT.Support ETL processes for data warehousing and reporting.Compliance and GovernanceEnsure databases comply with data governance policies and standards.Database Configuration and ManagementInstance Configuration:Knowledge on configure Amazon RDS or EC2-hosted SQL Server instances based on workload needs.Knowledge on choose appropriate instance types, storage classes (e.g., GP3, IO1), and scaling options.Parameter Groups: Knowledge on managing RDS and EC2 parameter groups to tune database engine settings.Multi-AZ Deployments: Knowledge on Leverage multi-AZ configurations for high availability and automatic failover.