Paid Internship - Database Analyst - Summer
AppleOne - Glendale CA

Internship Category: Paid

Description
Description
Map
Reviews
  • INTERNSHIP OPPORTUNITY:When you intern for AppleOne, you will join a team of forward thinkers in our 11-week innovative Intern-to-Dream program that focuses on turning you into a leader in the workplace. We offer unique internal corporate & branch internships in addition to networking opportunities with our leading partners. Our internships come with hands-on final projects, orientation, graduation & certification.

    JOB DESCRIPTION:
    As a database administrator intern in the Act”�1 company, and the selected intern will:

    • Monitor SQL server and migrating the licensed Software application to Open Source Product
    • Analyze data requirements, application and processing architectures, data dictionaries, and database schemas, and then designs, develops and optimizes database schema design to meet system requirements
    • Troubleshoot and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc
    • Gather, analyze, and normalize relevant information related to and from business processes, functions, and operations to evaluate data credibility and determine relevance and meaning
    • Create new stored procedures, functions and tables using T-SQL; modify existing ones to meet requirements
    • Monitor or update existing processes daily, weekly and monthly
    • Extract and load data to database from various files such as tab-delimited or csv format
    • Work with internal customers to produce customized reports

    QUALIFICATIONS:

    • Computer Science or equivalent degree
    • SQL Server Replication, LogShipping, AlwaysOn and Database Mirroring Experience
    • Strong knowledge of developing, deploying and optimizing SSIS and SSRS packages
    • Practical experience with monitoring, tuning, and troubleshooting production database issues
    • Strong T-SQL and query optimization experience
    • Follow coding standards for triggers and stored procedures and Database Objects
    • Microsoft SQL Server SQL 2016, 2017 , MYSQL
    • Cube Familiarity a plus
    • Linux, Unix, BSD
    • Hadoop
    • Develop using Hive, Map reduce, Python and Shell scripts in the Hadoop big data environment.
    • The desire to learn and grow with a cutting edge team

    TO PARTICIPATE IN APPLEONES INTERNSHIP PROGRAM, YOU MUST MEET THE FOLLOWING CRITERIA:

    • Applications must be able to complete the 11-week internship program and attend orientation on Monday, June 11, 2018 and graduation on Friday, August 24, 2018.
    • Applicants must be actively enrolled in an accredited university or college.
    • Applicants must be eligible to work in the United States without sponsorship by the company.
    INTERNSHIP OPPORTUNITY:When you intern for AppleOne, you will join a team of forward thinkers in our 11-week innovative Intern-to-Dream program that focuses on turning you into a leader in the workplace. We offer unique internal corporate & branch internships in addition to networking opportunities with our leading partners. Our internships come with hands-on final projects, orientation, graduation & certification.

    JOB DESCRIPTION:
    As a database administrator intern in the Act”�1 company, and the selected intern will:

    • Monitor SQL server and migrating the licensed Software application to Open Source Product
    • Analyze data requirements, application and processing architectures, data dictionaries, and database schemas, and then designs, develops and optimizes database schema design to meet system requirements
    • Troubleshoot and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc
    • Gather, analyze, and normalize relevant information related to and from business processes, functions, and operations to evaluate data credibility and determine relevance and meaning
    • Create new stored procedures, functions and tables using T-SQL; modify existing ones to meet requirements
    • Monitor or update existing processes daily, weekly and monthly
    • Extract and load data to database from various files such as tab-delimited or csv format
    • Work with internal customers to produce customized reports

    QUALIFICATIONS:

    • Computer Science or equivalent degree
    • SQL Server Replication, LogShipping, AlwaysOn and Database Mirroring Experience
    • Strong knowledge of developing, deploying and optimizing SSIS and SSRS packages
    • Practical experience with monitoring, tuning, and troubleshooting production database issues
    • Strong T-SQL and query optimization experience
    • Follow coding standards for triggers and stored procedures and Database Objects
    • Microsoft SQL Server SQL 2016, 2017 , MYSQL
    • Cube Familiarity a plus
    • Linux, Unix, BSD
    • Hadoop
    • Develop using Hive, Map reduce, Python and Shell scripts in the Hadoop big data environment.
    • The desire to learn and grow with a cutting edge team

    TO PARTICIPATE IN APPLEONES INTERNSHIP PROGRAM, YOU MUST MEET THE FOLLOWING CRITERIA:

    • Applications must be able to complete the 11-week internship program and attend orientation on Monday, June 11, 2018 and graduation on Friday, August 24, 2018.
    • Applicants must be actively enrolled in an accredited university or college.
    • Applicants must be eligible to work in the United States without sponsorship by the company.
  • No Records Found

    Sorry, no records were found. Please adjust your search criteria and try again.

    Google Map Not Loaded

    Sorry, unable to load Google Maps API.

  • Leave a Review