What are the responsibilities and job description for the SQL Developer(Hybrid) position at ChaTeck,Inc?
SQL Developer
Location:Morristown, New Jersey, 07960
Duration:Long term
Key Responsibilities
• Design, write, and optimize complex SQL queries, stored procedures, functions, triggers, and views across large-scale relational databases
• Develop and maintain ETL/ELT pipelines that extract, transform, and load data from disparate source systems into target environments
• Analyze and tune underperforming queries and database objects, leveraging execution plans, indexing strategies, and partitioning techniques
• Collaborate with data architects and modelers to implement physical database schemas that align with logical and conceptual designs
• Build and maintain database objects in support of reporting, dashboards, and analytical workloads
• Participate in data quality initiatives by developing validation logic, reconciliation scripts, and exception reporting
• Document database designs, data flows, and technical specifications to support knowledge transfer and long-term maintainability
• Conduct peer code reviews and uphold SQL development standards and best practices across the team
• Engage in Agile sprints, contribute to technical planning sessions, and deliver iteratively against project milestones
Required Qualifications
• 7 years of hands-on SQL development experience in enterprise environments
• Expert-level proficiency in one or more relational database platforms: SQL Server (T-SQL), Oracle (PL/SQL), PostgreSQL, or MySQL
• Strong experience developing and optimizing ETL/ELT processes using tools such as SSIS, Informatica, dbt, or Azure Data Factory
• Deep understanding of query optimization techniques including indexing, query plan analysis, partitioning, and statistics management
• Solid experience with data warehousing concepts and working within star/snowflake schemas and dimensional models
• Demonstrated ability to work independently, manage deliverables without heavy oversight, and communicate proactively with stakeholders
• Familiarity with Python or other scripting languages for data automation and pipeline orchestration
• Strong written and verbal communication skills with the ability to explain technical concepts clearly to non-technical audiences
Regards
Kevin
ChaTeck Inc.
972-597-5008 (D)
kevin@chateck.com
www.chateck.com
People .Consulting .Technology .Outsourcing