TorranceRecruiter Since 2001
the smart solution for Torrance jobs

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

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Torrance RSS job feeds