BurbankRecruiter Since 2001
the smart solution for Burbank jobs

Senior SQL Developer

Company: Outlook Amusements
Location: Burbank
Posted on: January 16, 2020

Job Description:

Outlook Amusements, Inc. is not your average company in a 'ho-hum' industry. We are a family of brands focused on developing technology and building connections that enable peace of mind. Our Mission is to be a positive force in people's lives, and we live it every day. For the past 20 years, we have connected top-ranked, premier, personal advisors with people world-wide looking to gain self-awareness and a clear life-path direction. This role is based out of headquarters in Burbank, CA. Senior SQL Developer is responsible for development, maintenance, and deployment of applications and database schema changes, identify data needs and potential issues, and perform basic Database Administration monitoring and troubleshooting. Duties Include:

  • Develop complex reports using SSRS MS Reporting Service
  • Maintain day to day activities and operations of SQL Server database
  • Identify and resolve potential issues to ensure successful completion of business critical processes to maintain proper uptime
  • Work with the development team to identify business critical data needs
  • Handles data modelling with the design of new databases to meet application requirements; support design and implementation of ETL processes between disparate systems; and continually maintain and support mission critical SQL Server applications
  • Create documentation on the design, development, implementation, daily loads and process flow of the database design
  • Design and develop Relational & Dimensional models
  • Perform MS SQL Server Installation, Configuration, Upgradation, Performance Tuning and Query Optimization
  • Manage SQL Server database tools (SQL Server Management Studio, SQL Profiler, SQL Server Business Intelligence Development Studio, SQL Server Data Tools, Client & Server Network Utilities, bcp.exe and third party tools red-gate)
  • Perform MS SQL Server database design & create, maintain multiple instances/ databases, Tables, Clustered & Non-Clustered Indexes, Stored Procedures, Functions, Cursors, Views & Triggers
  • Performance tune stored procedures by removing unnecessary cursors & using temporary tables, table variables wherever necessary
  • Customize stored procedures for complex reports containing multiple joins
  • Use Triggers to implement business logic & audit changes in the database
  • Perform consistency checks, maintain indexes and statistics & performance tune Database Application
  • Use SQL profiler to generate traces to identify long running queries causing database lockdown
  • Develop SQL Server Integration Services (SSIS) packages for extracting and loading the data into appropriate tables in SQL Server database & to import data to Text/Excel files
  • Develop custom SQL scripts for Data Import/Export
  • Create Jobs, Alerts, SQL Mail Agent & schedule SSIS package. Setup efficient monitoring of SQL server jobs to ensure failures are reported immediately
  • Perform database back-up/recovery; perform fault analysis and resolution; monitor and manage database backups, logs and maintenance
  • Design backup plans using native SQL Server backup & write customized scripts
  • Manage database technologies involving high availability groups, clustering, mirroring and replication
  • Create users role groups & grant privileges to Users and Groups and maintain security
  • Responsible for alldata migration including package issues 24. Assist in testing and implementation of the SQL scripts/SSIS Packages
  • Resolve SQL Server issues in development, QA and production environments 26. Create & maintain versions of database objects using Team Foundation Server (TFS)
  • Perform code review and participate in change control procedures
  • Fix bugs logged in JIRA Service Desk and coordinate/assist QA team in quality assurance testing
  • Provide 24x7 on-call production support to SQL Server databases
  • Handles troubleshooting, monitoring, optimizing & tuning of SQL Server environments across entire systems daily
  • Provide Knowledge Transfer to the end users
  • Develop logical and physical data models using Erwin to capture current state /future state data elements and data flows
  • Environment MS SQL Server 2012, Visual Studio 2015, windows Server 2008 Position Requirements: Bachelor's degree (or foreign equivalent) in a Science or Engineering field, plus 5 years of post-degree experience in SQL development and/or SQL Server administration. Experience, which may be gained concurrently, must include:
    • 5 years' experience with T-SQL (SQL 2012 and up) developing stored procedures, triggers, views, functions
    • 3 years' experience with MS SSRS and MS SSIS
    • 5 years' experience with SQL Server Data Tools
    • 5 years' experience in database stored procedure development and maintenance
    • 5 years' experience isolating and resolving typical problems with the SQL Server application and the databases (Loss or lack of connectivity, inability to leverage services provided by database, SQL Server specific errors, timeouts and severe loss of performance)
    • 5 years' experience using 2005 BI Studio for SSRS and SSIS
    • Requires participation in 24X7 on -call support rotation for SQL Server databases *PosPosition is eligible for employee referral program. To apply, please refer to Job Code 29455-012. What you get: Outlook Amusements has a dynamic, close-knit culture of teamwork and innovation. We know that your success is our success and you make a difference! You'll be part of a team that is serious about business, focused on our customers, and knows how to have fun too! Because we care about the whole you, we offer GROW, our Total Well-Being program, designed to offer convenient opportunities for your personal growth and development. Our comprehensive employee benefits package has been carefully designed to meet your health, financial and retirement wellbeing objectives, including medical, dental, vision, a 401k with a company match, additional add-on insurance plans, paid time off, and additional amenities based on the office you work out of. Outlook Amusements Inc. is an Equal Opportunity Employer. It does not discriminate on the basis of race, color, religion, sex, national origin, age, disability, sexual orientation, or any other characteristic protected by applicable state or federal civil rights laws.

Keywords: Outlook Amusements, Burbank , Senior SQL Developer, IT / Software / Systems , Burbank, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Other IT / Software / Systems Jobs

Software Test Engineer
Description: Raytheon Pasadena is seeking an experienced, highly motivated Software Test Engineer to support an exciting project for our JPL x2F NASA customer. The selected candidate will perform all levels of testing (more...)
Company: Raytheon
Location: San Gabriel
Posted on: 01/29/2020

Flight Software Test Developer
Description: Raytheon Pasadena is looking for a software developer to be a member of a Flight Software Internal Test FIT team that performs testing against software requirement, integration, verification and validation (more...)
Company: Raytheon
Location: Northridge
Posted on: 01/29/2020

Software Engineer II
Description: Job responsibilities will entail collaborating with team members, product owners and customers to develop applications to service the needs of movie studios, independent film distributors, production (more...)
Company: City National Bank
Location: North Hills
Posted on: 01/29/2020

Programmer Analyst III
Description: Develops, maintains, and enhances business applications providing specialized technical or business knowledge to projects. Utilizes a variety of computing architectures including client x2F server, intranet (more...)
Company: City National Bank
Location: Winnetka
Posted on: 01/29/2020

Drupal Developer
Description: Hi, Position Title: Drupal Full Stack Developer
Company: ATMECS
Location: Culver City
Posted on: 01/29/2020

Programmer Analyst III
Description: Develops, maintains, and enhances business applications providing specialized technical or business knowledge to projects. Utilizes a variety of computing architectures including client x2F server, intranet (more...)
Company: City National Bank
Location: Buena Park
Posted on: 01/29/2020

Sr. Digital Software Engineer
Description: As a member of the Digital Technologies Group, the Software Engineer is responsible for designing, developing and maintaining legacy and Cloud First applications written primarily in C and focused (more...)
Company: City National Bank
Location: Carson
Posted on: 01/29/2020

Lead Flight Software Engineer
Description: Position OverviewBoeing Phantom Works Advanced Missions is seeking a Lead Flight Software Engineer Level 5 for satellite development in Seal Beach, CA. The team will be working to develop various (more...)
Company: Boeing
Location: Santa Ana
Posted on: 01/29/2020

Senior Flight Software Engineer
Description: Boeing Satellite Division in El Segundo is seeking Senior Software Engineers, passionate about space and excited to work in a multi-disciplined, collaborative engineering environment to design, develop (more...)
Company: Boeing
Location: Sierra Madre
Posted on: 01/29/2020

Senior JAVA Developer
Description: We are looking for a Sr. JAVA Developer for one of our Biggest Telecom clients based out of El Segundo, CA. This is a long-term project for 3
Company: Collabera
Location: El Segundo
Posted on: 01/29/2020

Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Burbank RSS job feeds