SQL DBA

• Monitor database health using native tools and third-party monitoring software to identify and resolve performance bottlenecks.
• Optimize SQL queries, stored procedures, views, and indexes to ensure maximum system throughput and efficiency.
• Manage server resources by configuring CPU, memory, and disk I/O parameters for optimal database performance.
• SQL Database Security & Compliance
• Manage user access by implementing strict role-based access control (RBAC) and managing server permissions.
• Audit database systems regularly to ensure compliance with corporate security policies and data privacy regulations.
• Apply security patches, service packs, and cumulative updates to mitigate vulnerabilities.
• SQL High Availability & Disaster Recovery:
• Maintain backup strategies including full, differential, and transaction log backups, ensuring regular recovery testing.
• Configure high availability solutions using SQL Server AlwaysOn Availability Groups, Failover Cluster Instances (FCI), or database mirroring.
• Develop DR plans to guarantee business continuity and minimize Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO).
• SQL Operations & Maintenance
• Automate routine tasks such as database maintenance plans, index rebuilds, and statistics updates using SQL Server Agent jobs or PowerShell.
• Support deployment pipelines by reviewing, testing, and executing database schema changes and migrations
• Provide on-call support for critical production database incidents and troubleshooting.
• Open to learning SolarWinds

• 7-10 years of experience

PRISM is devoted to modernization and innovation across technology, security, and IT enterprise solutions. We are recognized for meeting performance requirements and exceeding customer expectations since 1994. Our culture is founded on relationships, opportunity, and success. Offering comprehensive benefit plans including medical, dental, vision, and 401K along with our people - first approach sustains our reputation as a premier employer.