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 NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
