SQL DBA-Remote

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 Seniority Level Mid‑Senior level Employment Type Full‑time Job Function Information Technology Industries: Software Development #J-18808-Ljbffr Apply tot his job