No H1B/OPT/CPT
Job Title:MS SQL Server Developer
Job Location:Torrance, CA
Duration: 6+ months
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 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
Wants
- 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)