• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 21st Dec 2020

Position : MS SQL Server Developer Consultant

Location : Torrance, CA (Remote Until COVID 19)              

Duration : 12+ months contract hire

Mandatory Skills Required:

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 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                                                                                 

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 Sever 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)                                                 

Unique Skill Set                                               

MS SQL Server Developer                             

Please fill below submission details and send with visa and DL card photo ASAP

Ajay Singh
 
IDC Technologies, Inc
Milpitas, CA , USA, 95035
Work - 408-684-0444
Mailto:- ajay.s@idctechnologies.com
Direct ||YIM- ajay.acetek49|| GTALK- ajaysingh.singh684|| Skype- ajay.singh1580 ||
 
ISO 9001-2008 Certified