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 experience6+ years of experience with PowerShell , Azure DevOps , and Scrum methodologiesStrong expertise in T-SQL and PL / SQL with performance tuningHands-on with SSMS , SQL Server Agent , and monitoring tools (SolarWinds, Redgate, Idera)Solid understanding of backup / recovery models , HA configurations , and database securityBachelor's degree in Computer Science, Information Systems, or a related fieldDesired Skills :
Combined experience as DBA, Architect, and DeveloperFamiliarity with ETL processes , Azure SQL , and PowerShell scripting