Sr. SQL Database Administrator

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