Lorven Technologies
Role: Sr. SQL Developer
Location: Edison, NJ or NYC, NY - Hybrid
Rate: C2C All inclusive
Experience : 10+ years
Job description:
Job Overview
We are seeking an experienced and detail-oriented SQL Developer to join our team. The SQL Developer will be responsible for designing, developing, and optimizing SQL databases, creating complex queries, and maintaining the overall data structure for applications. The ideal candidate will have strong technical expertise in SQL, database management, and data analysis, and will be skilled in working with large datasets to ensure smooth and efficient data operations.
Key Responsibilities Database Design & Development: Design and implement database solutions using SQL to support business applications and processes. SQL Query Development: Write, modify, and optimize complex SQL queries and stored procedures. Data Integration: Work with different data sources to integrate, migrate, and transform data. Performance Tuning: Identify performance bottlenecks and optimize SQL queries, indexes, and database structures to ensure optimal performance. Database Maintenance: Monitor and maintain database systems to ensure high availability, reliability, and security. Troubleshooting & Support: Provide troubleshooting and support for database-related issues, including error resolution and performance improvements. Data Analysis & Reporting: Analyze data and generate reports to assist stakeholders in decision-making processes. Documentation: Document database designs, changes, and processes to ensure smooth team collaboration and knowledge sharing. Collaboration: Work closely with developers, system architects, and business analysts to meet project goals and requirements. Quality Assurance: Test and validate database functionality and performance under different conditions. Data Security & Compliance: Ensure databases are secure and comply with relevant data protection regulations and standards. Required Skills and Qualifications
Technical Skills:
Strong proficiency in SQL (Structured Query Language) and experience with complex queries, joins, subqueries, and indexing. Expertise in relational database management systems (RDBMS) like Microsoft SQL Server, Oracle, MySQL, PostgreSQL, etc. Experience with stored procedures, triggers, and functions. Familiarity with ETL (Extract, Transform, Load) processes and data integration tools. Knowledge of database performance tuning techniques. Problem-Solving:
Strong analytical skills and the ability to troubleshoot database-related issues effectively. Tools and Technologies:
Familiarity with database management tools like SQL Server Management Studio (SSMS), Oracle SQL Developer, or similar. Basic knowledge of data warehousing concepts and technologies. Communication:
Ability to clearly explain complex technical concepts to non-technical stakeholders.
Location: Edison, NJ or NYC, NY - Hybrid
Rate: C2C All inclusive
Experience : 10+ years
Job description:
Job Overview
We are seeking an experienced and detail-oriented SQL Developer to join our team. The SQL Developer will be responsible for designing, developing, and optimizing SQL databases, creating complex queries, and maintaining the overall data structure for applications. The ideal candidate will have strong technical expertise in SQL, database management, and data analysis, and will be skilled in working with large datasets to ensure smooth and efficient data operations.
Key Responsibilities Database Design & Development: Design and implement database solutions using SQL to support business applications and processes. SQL Query Development: Write, modify, and optimize complex SQL queries and stored procedures. Data Integration: Work with different data sources to integrate, migrate, and transform data. Performance Tuning: Identify performance bottlenecks and optimize SQL queries, indexes, and database structures to ensure optimal performance. Database Maintenance: Monitor and maintain database systems to ensure high availability, reliability, and security. Troubleshooting & Support: Provide troubleshooting and support for database-related issues, including error resolution and performance improvements. Data Analysis & Reporting: Analyze data and generate reports to assist stakeholders in decision-making processes. Documentation: Document database designs, changes, and processes to ensure smooth team collaboration and knowledge sharing. Collaboration: Work closely with developers, system architects, and business analysts to meet project goals and requirements. Quality Assurance: Test and validate database functionality and performance under different conditions. Data Security & Compliance: Ensure databases are secure and comply with relevant data protection regulations and standards. Required Skills and Qualifications
Technical Skills:
Strong proficiency in SQL (Structured Query Language) and experience with complex queries, joins, subqueries, and indexing. Expertise in relational database management systems (RDBMS) like Microsoft SQL Server, Oracle, MySQL, PostgreSQL, etc. Experience with stored procedures, triggers, and functions. Familiarity with ETL (Extract, Transform, Load) processes and data integration tools. Knowledge of database performance tuning techniques. Problem-Solving:
Strong analytical skills and the ability to troubleshoot database-related issues effectively. Tools and Technologies:
Familiarity with database management tools like SQL Server Management Studio (SSMS), Oracle SQL Developer, or similar. Basic knowledge of data warehousing concepts and technologies. Communication:
Ability to clearly explain complex technical concepts to non-technical stakeholders.