Petadata - New York, NY

posted about 2 months ago

Full-time - Mid Level
New York, NY

About the position

The SQL Developer position at PETADATA involves working closely with application developers and business analysts to design and implement efficient database structures. The role requires the creation and maintenance of both logical and physical data models, ensuring that data is normalized to minimize redundancy and enhance query performance. The SQL Developer will be responsible for writing and optimizing complex SQL queries for data retrieval, transformation, and reporting, as well as ensuring efficient data manipulation operations, including inserts, updates, and deletes. In addition to query optimization, the SQL Developer will implement stored procedures, triggers, and user-defined functions, and design and create various database objects such as tables, indexes, and views based on specific business requirements. The role also involves defining constraints, relationships, and data integrity rules, optimizing schema design for scalability and performance, and managing SQL Server instances, including installation, configuration, and upgrades. Monitoring database performance is a critical aspect of this position, as the SQL Developer will need to identify bottlenecks and optimize query execution plans. Security management, including access controls and user permissions, is also part of the responsibilities, along with performing regular backups and ensuring that data recovery procedures are effectively in place.

Responsibilities

  • Collaborate with application developers and business analysts to design and implement efficient database structures.
  • Create and maintain logical and physical data models.
  • Normalize data to minimize redundancy and improve query performance.
  • Write and optimize complex SQL queries for data retrieval, transformation, and reporting.
  • Ensure efficient data manipulation operations (inserts, updates, deletes).
  • Implement stored procedures, triggers, and user-defined functions.
  • Design and create database objects (tables, indexes, views, etc.) based on business requirements.
  • Define constraints, relationships, and data integrity rules.
  • Optimize schema design for scalability and performance.
  • Install, configure, and upgrade SQL Server instances.
  • Monitor database performance, identify bottlenecks, and optimize query execution plans.
  • Manage security, access controls, and user permissions.
  • Perform regular backups and ensure data recovery procedures are in place.

Requirements

  • 9+ years of experience as an SQL Server DBA or similar role.
  • Proficiency in data modeling tools (e.g., ERwin, ER/Studio, or similar).
  • Strong understanding of DML (SELECT, INSERT, UPDATE, DELETE) and DDL (CREATE, ALTER, DROP) statements.
  • Experience with SQL Server Management Studio (SSMS) and T-SQL.
  • Familiarity with performance monitoring tools and query optimization techniques.
  • Certifications such as MCSA: SQL Server or MCSE: Data Management and Analytics are a plus.
  • Excellent written and verbal communication skills, presentation, and problem-solving skills.

Nice-to-haves

  • Certifications such as MCSA: SQL Server or MCSE: Data Management and Analytics are a plus.

Benefits

  • Professional work environment with opportunities for growth in the Information Technology field.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service