Back to Search

Sr. SQL Developer

Date Posted: 12/6/2019

Apply Now

Job Description

Interested in working for a company where you are challenged to think outside of the box, work with motivated colleagues and have opportunity for growth? We are looking for a Senior SQL Developer to start immediately with a rapidly growing and well-established Energy in North Orange County. Highly desired work culture and competitive compensation package!

This person will join a team that supports many critical business systems, including SQL Server, SQL Integration Services, SQL Reporting Services, BizTalk, and ERP platforms. This position will regularly interface with business analysts and customers to gather requirements, provide estimates, execute work, perform quality testing and provide application support.

Please note: 

  • 60% of the role will be responsible for SSIS work, with some ETL aspect 
  • 30% Involves TSQL, Queries, and reporting 
  • 10% other types of reporting and miscellaneous needs like app support or assistance on other projects 
ESSENTIAL DUTIES & RESPONSIBILITIES:

Participate in all phases of development of database and system projects from definition and design through implementation, debugging, testing and deployment. Support and maintain existing systems, applications, jobs and processes.

Development/Design
  • Develop stored procedures and views in SQL Server to support new business requirements.
  • Develop SSIS packages to support business requirements and data access/manipulation.
  • Develop new reports from multiple data sources using SSRS.
  • Participate in peer code reviews and QA testing
  • Maintain data integrity when manipulating data files for the purpose of analysis. Validate data thoroughly by using multiple data sources or criteria when necessary to ensure accuracy of results
  • Create mock-ups of planned development work and get buy-in from appropriate SMEs or product owners prior to execution.
  • Follow best practices and established standards when developing new applications, processes, etc.
  • Act as a subject matter expert as it pertains to our business-critical systems.
  • Recommend improvements to existing software programs as necessary

Application and Data Support
  • Act as Tier 2 and 3 application support for our systems; this requires active monitoring, maintenance and support of business-critical systems.
  • Manage, monitor and validate regular data downloads from the company's and partners business systems.
  • Ensure that all jobs are running successfully and take appropriate actions when issues are found.
  • Independently identify and solve data problems, informing all parties concerned.
  • Troubleshoot SSIS package failures and fix as necessary
  • Work with 3rd party vendors and engineers as necessary

Administration
  • Evaluate and automate database and reporting systems regularly to improve and maintain efficiency and reliability.
  • Identify user needs to create and administer databases; ensure that the database operates efficiently and without error. Make and test modifications to the database structure when needed.
  • Backup and restore data to prevent data loss, merge old databases into new ones.
  • Actively monitor database systems and troubleshoot errors.

Misc
  • Document all essential duties and processes in a manual format for training purposes.
  • Clearly and regularly communicate with management and technical support colleagues.
  • Flexible and willing to accept change in priorities as necessary.
  • Strong attention to detail

QUALIFICATIONS:
  • 5+ years SQL Server 2012/2017 administration experience.
  • 5+ years T-SQL development experience, with good working knowledge of best

Apply Now Send to a Friend

Job Snapshot

  • Employee Type:Full-Time
  • Location:Orange, CA
  • Job Type:I.T.
  • Experience:Not Specified
  • Education:Not Specified
  • Date Posted:12/6/2019
  • Contact: Blair West (714) 940-5420
  • Pay Range: $85,000.00 - $105,000.00 Annually
Get Job Alertsby Email
  • Receive alerts with new job opportunities that match your interests
  • Receive relevant communications and updates from our organization

Sign Up Now


Job Reference: JO-1909-69178