Accord Technologies Inc.
SQL Developer
Accord Technologies Inc., Trenton, New Jersey, United States,
SQL DeveloperLocation:
Glen Allen, VADuration:
6 monthsPosition type:
RemoteVisa:
Any visa independentBelow is JD for SQL DeveloperRequirementsExpertise in Database Architecture in an environment that handles large volume of data.Strong analytical and organizational skills, involving analyzing existing databases and the client's needs to develop effective data-driven solutions.Demonstrate expertise in performance tuning, including both query and server optimization utilizing SQL tools and/or 3rd party solutions.Strong knowledge and experience in data modeling, database design, optimization for performance, and stored procedures.Design and script database tables to store the application data.Write queries for front-end applications (websites, desktop applications, or cloud apps) and ensure optimal performance.Perform functions to retrieve, add, edit, and delete database data.Create stored procedures, views, and functions.Data modeling to visualize database structure.Work with application developers to create optimized queries.Create table indexes to improve database performance.Review query performance and optimize code.Modify existing views, procedures, functions, and code based on client requirements.Hands-on experience in Exception Handling and Troubleshooting.Develop tables, provide constraints, indexes, grants, sequences, cursors, stored procedures, and functions for implementation.Expertise in understanding complex business needs, analyzing, designing, and developing solutions.Hands-on development experience in SQL Server 2016 and above using SSIS and SSRS.Experience in troubleshooting and resolving data-related issues.Expertise in performance tuning, especially tuning complex queries, procedures, and indexing strategies.Monitor and perform tuning on complex ETL jobs using metadata/variables/parameters.Experience in SQL Server Agent Jobs and Linked Servers usage.Performance tuning experience using 3rd party tools.ResponsibilitiesDesign, develop, and optimize large, complex DB schemas, SQL scripts, and objects to meet application functionality and performance requirements.Work cohesively with stakeholders including data, design, product, and executive teams, assisting them with data-related technical issues.Collaborate closely with application developers and business teams at all levels to assist with data-related technical issues and ensure successful delivery of data-driven solutions.Implement processes and procedures for the development and release of products/projects that facilitate high quality and rapid deployment.Provide solutions to promote data integrity in enterprise systems.Participate in code reviews to validate effectiveness and quality of code.Liaise with developers to improve applications and establish best practices.Publish documentation and collaborative information using internal tools.
#J-18808-Ljbffr
Glen Allen, VADuration:
6 monthsPosition type:
RemoteVisa:
Any visa independentBelow is JD for SQL DeveloperRequirementsExpertise in Database Architecture in an environment that handles large volume of data.Strong analytical and organizational skills, involving analyzing existing databases and the client's needs to develop effective data-driven solutions.Demonstrate expertise in performance tuning, including both query and server optimization utilizing SQL tools and/or 3rd party solutions.Strong knowledge and experience in data modeling, database design, optimization for performance, and stored procedures.Design and script database tables to store the application data.Write queries for front-end applications (websites, desktop applications, or cloud apps) and ensure optimal performance.Perform functions to retrieve, add, edit, and delete database data.Create stored procedures, views, and functions.Data modeling to visualize database structure.Work with application developers to create optimized queries.Create table indexes to improve database performance.Review query performance and optimize code.Modify existing views, procedures, functions, and code based on client requirements.Hands-on experience in Exception Handling and Troubleshooting.Develop tables, provide constraints, indexes, grants, sequences, cursors, stored procedures, and functions for implementation.Expertise in understanding complex business needs, analyzing, designing, and developing solutions.Hands-on development experience in SQL Server 2016 and above using SSIS and SSRS.Experience in troubleshooting and resolving data-related issues.Expertise in performance tuning, especially tuning complex queries, procedures, and indexing strategies.Monitor and perform tuning on complex ETL jobs using metadata/variables/parameters.Experience in SQL Server Agent Jobs and Linked Servers usage.Performance tuning experience using 3rd party tools.ResponsibilitiesDesign, develop, and optimize large, complex DB schemas, SQL scripts, and objects to meet application functionality and performance requirements.Work cohesively with stakeholders including data, design, product, and executive teams, assisting them with data-related technical issues.Collaborate closely with application developers and business teams at all levels to assist with data-related technical issues and ensure successful delivery of data-driven solutions.Implement processes and procedures for the development and release of products/projects that facilitate high quality and rapid deployment.Provide solutions to promote data integrity in enterprise systems.Participate in code reviews to validate effectiveness and quality of code.Liaise with developers to improve applications and establish best practices.Publish documentation and collaborative information using internal tools.
#J-18808-Ljbffr