SQL SERVER DEV DBA

T-SQL / SSIS / OLTP
Full Time, Contract W2, no end date
market
Work from home not available Travel not required

Job Description

 

KEY  POINTS:  

No report generating or Data Warehousing background needed.

Want experience with online transactions. 

XML not needed but highly desirable. 

Write complex  SQL Server stored procedures

SSIS package experience.

Trouble-shooting problems and taking corrective action.

Some C# knowledge is nice.

 

 

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 /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)* Schduel 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

Posted By

El Segundo, CA, 90245

Dice Id : sharpdec
Position Id : SQLDBA
Have a Job? Post it

Similar Positions

SQL Server Database Developer
  • Calance
  • Torrance, CA
Healthcare SQL Server SSIS/SSRS Developer - ***HOT***
  • Irvine Technology Corporation (ITC)
  • Huntington Beach, CA
Database Developer (SQL)
  • CyberCoders
  • Santa Ana, CA
Database Developer
  • Corus360
  • Cerritos, CA
SSRS Report Developer
  • OneAPPS
  • Los Angeles, CA
Senior Database Developer
  • Eleven Recruiting
  • Los Angeles, CA
SQL Programmer Analyst
  • The Judge Group, Inc.
  • Los Angeles, CA
SQL DBA
  • TechLink Resources
  • Los Angeles, CA
SQL Developer | Epic Clarity
  • Onpoint Search Consultants
  • Los Angeles, CA
SQL Developer 2
  • Delta Computer Consulting Inc
  • Torrance, CA
SQL Developer
  • Apetan Consulting
  • Anaheim, CA
Data Warehouse Developer
  • CGS
  • Newport Beach, CA
1. Jr.-Mid SQL Developer
  • Robert Half Technology
  • Santa Monica, CA