Design, implement, and maintain database systems: model schemas, write optimized SQL, build stored procedures, tune performance, manage ETL/data migrations to cloud warehouses, enforce data security, and troubleshoot database issues.
A Database Developer (or SQL Developer) is responsible for the design, implementation, and maintenance of the systems that store and manage a company's most valuable asset: its data. They ensure that information is structured logically, retrieved quickly, and stored securely.
Core Roles & Responsibilities
- Database Design & Modeling: Creating high-level architectural blueprints using Entity-Relationship (ER) Diagrams to define how data tables link together.
- Coding & Programming: Writing complex, optimized queries using SQL (Structured Query Language) to manipulate and retrieve data.
- Stored Procedures & Triggers: Developing automated server-side logic to handle repetitive tasks and maintain data integrity without manual intervention.
- Performance Tuning: Monitoring query execution times and "indexing" tables to ensure applications remain fast even as the database grows to millions of rows.
- ETL Management (Extract, Transform, Load): Building pipelines to move data from various sources into a centralized Data Warehouse for analysis.
- Data Security & Access: Implementing user permissions and encryption protocols to protect sensitive data and comply with regulations like GDPR or SOC2.
- Troubleshooting & Bug Fixing: Identifying and resolving issues like "deadlocks," data corruption, or connection failures within the database environment.
- Data Migration: Overseeing the safe transfer of data from legacy systems to modern cloud environments like Snowflake or Google BigQuery.
Essential Technical Stack
- Relational Databases (RDBMS): Mastery of MySQL, PostgreSQL, Microsoft SQL Server, or Oracle.
- NoSQL Databases: Familiarity with non-tabular systems like MongoDB or Cassandra for big data applications.
- Cloud Infrastructure: Experience managing managed databases on AWS RDS or Azure SQL.
Top Skills
Sql,Mysql,Postgresql,Microsoft Sql Server,Oracle,Mongodb,Cassandra,Snowflake,Google Bigquery,Aws Rds,Azure Sql,Etl
Similar Jobs
3D Printing • AdTech • Aerospace
Design, implement, and maintain database schemas, stored procedures, and queries. Optimize performance, ensure data integrity and security, implement backup/recovery, collaborate with developers, monitor and troubleshoot databases, document systems, and keep up with database technologies and best practices.
Top Skills:
MySQLOraclePl/SqlSQLSQL ServerT-Sql
Information Technology • Consulting
The Database Developer will work on AWS database development, collaborate with teams, and integrate solutions into existing systems.
Top Skills:
Api GatewayAWSDynamoDBGitGraphQLOraclePostgresPythonRdsSQLTypescript
Cloud • Security • Software • Cybersecurity • Automation
As a Backend Engineer in the Database Excellence group, you will enhance frameworks and tooling to ensure data scalability, health, and performance. Key responsibilities include developing backend features, collaborating with cross-functional teams, improving database operations, and documenting best practices.
Top Skills:
PostgresRubyRuby On Rails
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
