Our Los Angeles office is seeking a SQL Database Administrator with expertise in managing diverse database environments, including Azure SQL Database, PostgreSQL, MongoDB, and MS SQL Server. The ideal candidate will have a deep understanding of database architecture, performance tuning, and disaster recovery strategies across multiple platforms. The Senior SQL DBA will play a critical role in designing, implementing, and maintaining our organization's database infrastructure to support our business needs efficiently.
Responsibilities Include, But Are Not Limited To:
- Manage and administer databases across multiple platforms, including Azure SQL Database, PostgreSQL, MongoDB, and MS SQL Server
- Perform database installation, configuration, and upgrades following best practices and security standards
- Monitor database performance, optimize queries, and troubleshoot performance issues to ensure optimal performance and scalability
- Implement and maintain database security measures, including user access controls, encryption, and auditing
- Design database schemas, tables, and indexes for optimal performance and scalability
- Work closely with developers to optimize database queries and improve application performance
- Implement database partitioning, sharding, and replication strategies to distribute data and improve availability
- Implement high availability solutions such as failover clustering, Always On Availability Groups, and database mirroring for mission-critical databases
- Develop and maintain database backup and recovery strategies to ensure data integrity and minimize downtime in the event of failures or disasters
- Perform regular database backups, test restore procedures, and implement disaster recovery drills
- Manage databases in Azure Cloud environments, including Azure SQL Database, Azure Database for PostgreSQL, and Azure Cosmos DB
- Implement Azure services for data storage and analytics, such as Azure SQL Managed Instance, Azure Blob Storage, and Azure Data Lake
- Monitor Azure resources, analyze performance metrics, and optimize database configurations for cost-efficiency
- Document database configurations, procedures, and troubleshooting guides for reference and training purposes
- Maintain up-to-date documentation of database inventory, configurations, and change management processes
- Perform other duties as required and assigned
Experience And Skills:
- Bachelor's degree from accredited university required, preferably in Computer Science, Information Technology, or a related field
- Minimum of 5 years of experience in database administration, with expertise in Azure SQL Database, PostgreSQL, MongoDB, and MS SQL Server
- Relevant certifications such as Microsoft Certified: Azure Database Administrator Associate, PostgreSQL Certified Professional, MongoDB Certified DBA, or Microsoft Certified: Azure Solutions Architect Expert are highly preferred
- Strong proficiency in SQL query optimization, database performance tuning, and troubleshooting
- Experience with database security, encryption, and compliance standards (e.g., GDPR, CCPA)
- Familiarity with cloud computing platforms such as Azure Cloud and AWS
- Excellent problem-solving skills, attention to detail, and ability to work independently or as part of a team
- Strong communication and interpersonal skills, with the ability to effectively interact with diverse stakeholders
