Position: SQL Developer
Location: New York City, NY- only local (Hybrid)
Experience: 10+ Years
Work type: C2C
PETADATA is currently looking to hire for the position of 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: jhansib@petadata.co
After carefully reviewing your experience and skills one of our HR team members will contact you on the next steps.
Location: New York, NY
Posted: Aug. 20, 2024, 8:29 a.m.
Apply Now Company Website