SQL Developer

Company: Emonics, LLC
Location: Torrance
Posted on: November 24, 2022

Job Description:

The selected candidate will perform the following duties:

• 
  
• Codes and performs unit and integration testing of software to ensure proper and efficient execution and adherence to business and technical requirements
  
• Codes, tests, and debugs new software or makes enhancements to existing software
  
• Writes programs according to specifications from higher level staff or business analysts
  
• Develops technical documentation
  
• Resolves in a timely manner problems that arise with existing production applications to ensure the efficient and proper functioning of application components
  
• Collaborates with technical staff to learn and understand software problems
  
• Generates a variety of complex and periodic reports and/or data through database management, data administration and data extraction techniques
  
• Provides general system users and management with system analysis and feedback
  
• Influences system design by identifying and recommending design and requirements needs for software enhancements
  
• Mentors and coaches less experienced staff
  
• Maximizes the efficiency of the various software systems by implementing, monitoring, testing and auditing new software programs
  
• Analyzes and resolves computer related problems by coordinating with in house personnel to diagnose and fix operational difficulty, as well as consulting, advising and training on specialized features and functions
  
• Follows established configuration/change control processes
  
• Create/Modify SQL Server code/packages including SSIS/Stored Procedures/Handle error conditions
  
• Database tables design based transactional and analytical requirements
  
• Create complex queries
  
• Design and develop an end to end ETL to load/store data
  
• Schedule processes and reports
  
• Trouble shoot production issues affecting database issues, performance issues, and answer/investigate data issues
  
• Work with DBA on reviewing design and attain DBA approval
  
• Attend various meetings with project team
  
• Create and execute SQL statements and perform complex data analysis
  
• Database development using T-SQL, creating/updating stored procedures/creating/updating SQL Functions & Triggers
  
• Experience working with SQL XML on SQL Server 2008 r2 or higher
  
• Experience working on Sql Server 2019
  
• Create/Maintain/Deploy SSIS packages
  
• Create/Update Database Design based on new requirements, document the database design, review with DBA team and obtains approval for the design
  
• Helps with production issues including identifying the problem/finding the appropriate solution to resolve the issue
  
• Documenting database designs
  
  
  Required Skills and Experience:
  
  
  • 
    
  • BA/BS in Information Technology, Computer Science, related field or equivalent work experience.
    
  • 5 plus years experience with major DBMS
    
  • 5 plus years experience with coding, testing and design
    
  • 5 plus years experience with software development methodologies
    
  • Advanced capability in software construction, testing, infrastructure, configuration and operating standards
    
  • Advanced corporate knowledge, and understands how a change would affect multiple applications
    
  • Advanced ability to make recommendations/decisions in application and program design, standards and program enhancements
    
  • Advanced ability to utilize system traces and debugging tools for problem/issue resolution
    
  • Advanced ability to analyze and model business functions, processes and information flow within or between systems
    
  • Advanced ability to provide guidance and mentoring on programming practices and techniques to individuals and cross functional teams
    
  • Advanced knowledge of software design, construction, programming trends, programming and scripting languages in multiple application and data management systems
    
  • Advanced ability to work with users at all levels to define system requirements, design and system topologies to meet operational needs and system performance objectives
    
    
    Mandatory Requirements/Time:
    
    
    • 
      
    • Must have experience working on SQL Server databases
      
    • Experience working on transactional database dealing with high number of transactions
      
    • Work closely with team members in requirements/design sessions to assure quality of end product
      
    • Work closely and take direction from Team leads
      
    • Experienced with Microsoft Office suite (including Visio and project)
      
      

Keywords: Emonics, LLC, Torrance , SQL Developer, IT / Software / Systems , Torrance, California