JOBSEARCHER

SQL Database Administrator

Role: SQL DBA
Location: Los Angeles, CA/Brea, CA (onsite)
Job Summary: As an SQL database engineer, you will be responsible for managing and maintaining SQL Server databases, with a focus on SQL clustering, Always On, replication, and SSIS package development; troubleshooting; performance tuning; and supporting database-related projects. This role involves responding to escalated issues from L1/L2 engineers, optimizing database systems, and ensuring operational stability. You will collaborate closely with developers, system administrators, and other IT staff to resolve database issues and improve overall database efficiency.
Key Responsibilities: 1. Database Administration:
  • Administer, maintain, and monitor SQL Server databases.
  • Perform database installations, upgrades, and patching.
  • Monitor and optimize the performance of the database system by analyzing performance metrics and logs.
  • Ensure database availability, scalability, and security through backup strategies and recovery processes.2. Troubleshooting:
  • Act as an escalation point for L1 and L2 database issues, providing advanced troubleshooting and resolving complex database incidents.
  • Investigate and resolve performance bottlenecks, deadlocks, and locking issues.
  • Collaborate with developers to optimize query performance and enhance database operations.3. Performance Tuning:
  • Analyze and optimize slow queries, indexes, and database configurations.
  • Perform query optimization and index tuning to improve database performance.
  • Use performance monitoring tools (SQL Profiler, Performance Monitor, etc.) to track and resolve performance issues.4. Backup & Recovery:
  • Manage automated backup and recovery processes.
  • Ensure the reliability of backup and recovery operations through regular testing.
  • Implement disaster recovery strategies to minimize downtime in the event of a system failure.5. Security & Compliance:
  • Implement and enforce database security measures, including access control and encryption.
  • Monitor user roles and permissions to ensure proper data access.
  • Ensure compliance with industry standards and internal security policies.6. Collaboration & Support:
  • Collaborate with developers and application teams to support database design and query optimization.
  • Work with L1/L2 support teams to resolve escalated issues.
  • Communicate with stakeholders to provide status updates on database health, incidents, and performance improvements.7. Documentation:
  • Maintain detailed documentation of database configurations, processes, and troubleshooting steps.
  • Create and update knowledge base articles to assist L1 and L2 teams.
Key Skills and Qualifications
Education: Bachelor’s degree in computer science, information technology, or a related field (or equivalent experience).
Experience: 10+ years in SQL database administration, with at least 1-2 years in an L3 support or senior role.
Certifications: (preferred):Microsoft Certified: Azure Database Administrator Associate Microsoft Certified Solutions Associate (MCSA) in SQL Server
Technical Skills:
  • Strong experience with Microsoft SQL Server (2012, 2016, 2019, or newer).Proficient in T-SQL, query optimization, and performance tuning.
  • Experience with database clustering, replication, and AlwaysOn availability groups.
  • Hands-on experience with database backup, recovery, and disaster recovery processes.
  • Knowledge of SQL Server tools (SSMS, SQL Profiler, Performance Monitor).Familiarity with cloud-based databases (Azure SQL, AWS RDS) is an advantage.
  • Experience with scripting languages (e.g., PowerShell) for automation.
  • Soft Skills:
  • Strong problem-solving and analytical skills.
  • Excellent communication skills to interact with both technical and non-technical stakeholders.
  • Ability to work under pressure and manage multiple priorities.
  • Team player with a proactive attitude.
Preferred Qualifications: Experience working in enterprise environments. Familiarity with NoSQL databases is a plus. Knowledge of data warehousing and ETL processes.