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 Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
