SQL DBA-Remote

Overview

Remote
$DOE
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12+

Skills

SQL DBA

Job Details

Job Title: SQL DBA
Remote
Duration: 1 year
Interview Method: Website

Position Overview:

The SQL DBA will be responsible for database analysis, development, and administration - including data modeling, performance tuning, and maintenance. The role requires hands-on expertise in SQL/PL-SQL development, database architecture, and production environment support.

Key Responsibilities:

SQL & PL/SQL Development

  • Write, optimize, and maintain complex SQL and PL/SQL procedures, functions, and packages.
  • Review and optimize code for performance and scalability.
  • Support application developers with SQL design and best practices.

Database Architecture & Design

  • Collaborate with IT Architects to design enterprise-grade database solutions.
  • Define and enforce database policies, standards, and naming conventions.
  • Develop and maintain logical/physical database models.
  • Provide leadership on database design for scalability and performance.

Administration & Maintenance

  • Install, configure, and manage SQL Server environments (Dev/Test/Prod).
  • Perform backups, restores, and recovery tests to ensure data integrity.
  • Monitor performance using SSMS, SQL Server Agent, and tools like SolarWinds, Redgate, or Idera.
  • Apply patches, upgrades, and manage indexes, partitions, and statistics.

Monitoring, Troubleshooting & Support

  • Proactively monitor system alerts and resolve performance bottlenecks.
  • Analyze logs, trace data, and performance metrics.
  • Collaborate with DevOps and IT for uptime and reliability.

Data Integrity, Security & Governance

  • Implement and manage roles, permissions, and access controls.
  • Ensure compliance with data security and governance policies.
  • Participate in disaster recovery and high-availability planning.
  • Document database models and access standards.

Required Skills & Experience:

  • 10+ years of SQL development and administration experience
  • 6+ years of experience with PowerShell, Azure DevOps, and Scrum methodologies
  • Strong expertise in T-SQL and PL/SQL with performance tuning
  • Hands-on with SSMS, SQL Server Agent, and monitoring tools (SolarWinds, Redgate, Idera)
  • Solid understanding of backup/recovery models, HA configurations, and database security
  • Bachelor's degree in Computer Science, Information Systems, or a related field

Desired Skills:

  • Combined experience as DBA, Architect, and Developer
  • Familiarity with ETL processes, Azure SQL, and PowerShell scripting
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.