Previous Job
Previous
Software Dev. - Level III - SQL BI, MySQL
Ref No.: 18-00641
Location: Torrance, California
Position Type:Contract
Title: Software Developer - Level III
Location: Torrance, CA

Job Description:
  • 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 problem 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

Academic/Experience/Competency:
  • BA/BS in Information Technology, Computer Science, related field or equivalent work experience.
  • 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

Business 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

Daily Tasks Performed:
  • Create/Modify SQL Server/MySQL 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 and reporting solutions to load/store data and provide analytics for business users (for analytics purposes we are looking to design tables, populate data, and create queries when needed)
  • 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
  • Responsible for documenting technical flows, context diagrams, sequence diagrams, and design

Wants:
  • Must have experience working on SQL Server and MySQL databases
  • Experience working on transactional database dealing with high number of transactions
  • Experience working on analytics databases and creating SQL queries for analytical purposes
  • 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)