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

Irving, TX, US • Posted 10 hours ago • Updated 9 hours ago
Contract Independent
Contract Corp To Corp
Contract W2
12 Months
No Travel Required
On-site
Depends on Experience
Fitment

Dice Job Match Score™

🛠️ Calibrating flux capacitors...

Job Details

Skills

  • SQL Server DBA
  • Allegro
  • AWS

Summary

Role:  SQL Server DBA with Allegro
Location:  Irving TX Onsite  (3 days onsite)
Duration: 12+ Months
Experience 12 to 20 Years 
 
Skills (Must Have) – SQL Server DBA, Allegro, AWS 
 
Responsibilities:
  1. 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.
  2. 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.
  3. 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.
  4. Database Administration
    • Perform backups, restores, and disaster recovery planning.
    • Implement database security measures, including user roles, permissions, and encryption.
  5. 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.
  6. Compliance and Governance
    • Ensure databases comply with data governance policies and standards.
  7. 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.
 
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10120177
  • Position Id: 8973760
  • Posted 10 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Irving, Texas

Today

Easy Apply

Contract

$55 - $65

Irving, Texas

Today

Easy Apply

Contract

Depends on Experience

Irving, Texas

Today

Easy Apply

Contract

$50 - $79

Dallas, Texas

3d ago

Easy Apply

Contract

Depends on Experience

Search all similar jobs