SQL Server DBA with Allegro - (Need locals to TX) - Need 12 to 20 Years Exp

Role:

SQL Server DBA with

Allegro Location:

Irving TX Onsite (3 days onsite)

Duration:

12+ Months Experience 12 to 20 Years Skills (Must Have) -

S QL Server DBA, Allegro, AWS Responsibilities:

Database Design and Development Design 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 Support Collaborate 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 Tuning Monitor 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 Administration Perform backups, restores, and disaster recovery planning. Implement database security measures, including user roles, permissions, and encryption. Data Integration Design and implement data import/export solutions using tools like SSIS, BCP, or

BULK INSERT.

Support ETL processes for data warehousing and reporting. Compliance and Governance Ensure databases comply with data governance policies and standards.

Database Configuration and Management Instance 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.