Job Description :

Role: SQL Developer

Location: Glen Allen, VA (onsite, hybrid model)

 

Requirements:  

  • Expertise in Database Architecture in an environment that handles large volume of data. 
  • Strong analytical and organizational skills. This job involves 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, stored procedures. Included following activities- 
    • Design and script database tables to store the application data  
    • Write queries used for front-end applications (websites, desktop applications, or cloud apps) and ensure that they perform at optimal speeds  
    • Perform functions – retrieve, add, edit, and delete database data  
    • Create stored procedures, views, and functions.  
    • Data modelling to visualize database structure  
    • Working 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 to change the functionality of those objects depending upon client requirements  
    • Hands on experience in Exception Handling and Troubleshooting  
    • Develop the tables, provide constraints, indexes, and grants, sequences, cursors, stored procedures and functions to implement in the product  
  • 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, procedure, and indexing strategies.  
  • Monitor and perform tuning on complex ETL jobs using meta-data/variables/parameters.  
  • Experience in SQL server agent Jobs and Linked servers’ usage  
  • Performance tuning experience using 3rd party tools

 

Responsibilities:  

  • Design, develop and optimize large, complex DB schemas, SQL scripts and objects to meet application functionality and performance requirements.  
  • Working cohesively with stakeholders including data, design, product, and executive teams and assisting them with data-related technical issues.  
  • Working closely with application developers and business teams at all levels to assist with data-related technical issues and help ensure the successful designing and delivering 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. 

 

,

 

Basanthi

US IT Recruiter
RITWIK Infotech, Inc.

Email:

38345 W. 10 Mile Rd, Suite 253|| Farmington|| MI 48335|| USA|

 

 **We strengthen Oracle EBS/Fusion Cloud, NetSuite Cloud and BI Partners & End Customers by accelerating career development.**

             

Similar Jobs you may be interested in ..