Get your dream job within 2 days (HURRY UP)ENROLL NOW
+

Database Administrator & Software Engineer


Job Id : 5442

Jobtitle : Database Administrator & Software Engineer

Location : Alpharetta, GA

Company Name : Competent Systems

Industry : Information Technology

Salary : $45,000 - $108,000  YEAR

Job type : Fulltime

Posted on: 2019-10-11


Required Skills : SQL, ETL, SSIS, SDLC, Oracle, Ms Access, SQL Server, Schemas

Benefits : No benefits are available


Job Description:

  • Write complex SQL queries involving inner and outer join, store procedures, triggers and user defined functions
  • Perform Performance Tuning, Query Optimization
  • Manage Alerts, Operators and Jobs through SQL Server Agent
  • Create Dimensional Modelling and ETL design.
  • Work on ETL process using SSIS packages
  • Create packages to extract data from DB2 (AS/400), ORACLE, MS ACCESS and FLAT FILES and load it to SQL SERVER use DTS/SSIS and implement Incremental load in SSIS packages
  • Deploy SSIS Packages using Team Foundation Server and migrate SSIS packages,
  • Design STAR, SNOW FLAKE Schemas
  • Report writing using SQL Server Reporting Services (SSRS) and create various types of reports like Drill Down, Drill Through, Parameterized, Cascading, Table, Matrix, Chart, Adhoc and Sub Reports,
  • Creating Data Visualizations using Tableau/Power BI, Work with Data Modelling Tools like Erwin and Microsoft Visio
  • Good understanding of (SDLC) Software Development Life Cycle process methodologies and principles

 

Requirements:

Master’s Degree in Science, Information Technology, Electronics or a related field and 2 years’ experience, or a Bachelor’s Degree in Science, Information Technology, Electronics or a related field and 5 years’ experience must include at least two years in T-SQL, SSIS, SSRS, SSAS, Power BI, and Tableau

Associated topics: .net, c c++, c#, develop, java, perl, python, sdet, software developer, sw

Latest jobs for you

  • .Net Programmer - H1B/GC

    Avtech Solutions Inc Pittsburgh, PA

    Responsibilities: Develop and maintain custom Web applications and interfaces using VB.NET or ...

    View Job
  • Dot Net Developer - H1B/GC/USC

    IT-SCIENT LLC Cleveland, OH

    Primary Skills: 5+ years’ experience in .NET, Classic ASP, ASP.NET, Javascript, ...

    View Job
  • .NET Technical Lead - H1B/GC/USC

    Future Focus Infotech pvt ltd Monterey Park, CA

    Required Skills: Strong development experience on .NET, C# Strong database fundamentals ...

    View Job
  • .Net Developer - H1B/GC

    Stellentit LLC Eagan, MN

    Job Description :   Responsibilities: Senior-level research, design and development ...

    View Job
  • .Net Developer - OPT/CPT/H1B/H4/TN

    AVTECH SOLUTIONS, Inc Menomonee Falls, WI

    Job Description: Proficient in .Net and associated technologies; MSSQL, MYSQL, Spanner DBs ...

    View Job

Thanks For Your Feedback

We’re an equal opportunity provider.
All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
OPTnation.com is not a Consulting Company/Training Company/H1B Sponsor.

Attach A Resume First