Position: Application SQL Developer
Location: New York City, NY- only local(Hybrid)
Experience: 10+ Years
Work type: C2C/W2
PETADATA is currently looking to hire for the position of Application SQL Developer for one of their clients.
Roles & Responsibilities:
- Must 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.
Required Skills:
- Required 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.
Educational Qualification:
Bachelor's/ Master’s degree in Computer Science, Engineering, or a related field.
We offer a professional work environment and are given every opportunity to grow in the Information technology world.
Note:
Candidates are required to attend Phone/Video Call / In-person interviews and after Selection of candidate (He/She) should go through all background checks on Education and Experience.
Please email your resume to: anandinik@petadata.co
After carefully reviewing your experience and skills one of our HR team members will contact you on the next steps.