Job Description
Job Description
Join our team in Los Angeles as a Database Administrator, specializing in SQL. We're looking for someone with a knack for managing diverse database environments like Azure SQL Database, PostgreSQL, MongoDB, and MS SQL Server. Your role will be pivotal in shaping, implementing, and maintaining our organization's database infrastructure to meet our operational needs effectively.
Key Responsibilities:
Oversee and administer databases across various platforms including Azure SQL Database, PostgreSQL, MongoDB, and MS SQL Server.
Conduct database installations, configurations, and upgrades adhering to best practices and security standards.
Monitor database performance, fine-tune queries, and troubleshoot performance bottlenecks for optimal scalability and efficiency.
Establish and enforce database security measures, encompassing user access controls, encryption, and auditing.
Design database schemas, tables, and indexes to ensure optimal performance and scalability.
Collaborate closely with developers to enhance database queries and bolster application performance.
Deploy database partitioning, sharding, and replication strategies to enhance data distribution and availability.
Implement high availability solutions like failover clustering, Always On Availability Groups, and database mirroring for critical databases.
Develop and maintain robust database backup and recovery strategies to uphold data integrity and minimize downtime during outages or disasters.
Manage databases in Azure Cloud environments, including Azure SQL Database, Azure Database for PostgreSQL, and Azure Cosmos DB.
Leverage Azure services for data storage and analytics, like Azure SQL Managed Instance, Azure Blob Storage, and Azure Data Lake.
Monitor Azure resources, analyze performance metrics, and optimize database configurations for cost-effectiveness.
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.
Fulfill any other duties as necessary and assigned.
Experience and Skills:
Bachelor's degree from an accredited university, preferably in Computer Science, Information Technology, or a related field.
At least 5 years of experience in database administration, showcasing 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 desirable.
Proficiency in SQL query optimization, database performance tuning, and troubleshooting.
Knowledge of database security, encryption, and compliance standards (e.g., GDPR, CCPA).
Familiarity with cloud computing platforms such as Azure Cloud and AWS.
Strong problem-solving abilities, attention to detail, and capacity to work autonomously or collaboratively.
Excellent communication and interpersonal skills, enabling effective interaction with diverse stakeholders.
Company Description We specialize in staffing exceptional IT Professionals to industry leading companies in the US and abroad. Through our dedicated and ethical approach, we represent the finest employers and professionals in the marketplace today. This position is with one of our clients.
Company Description
We specialize in staffing exceptional IT Professionals to industry leading companies in the US and abroad. Through our dedicated and ethical approach, we represent the finest employers and professionals in the marketplace today.
This position is with one of our clients.
#J-18808-Ljbffr
