Get your dream job within 2 days (HURRY UP) ENROLL NOW or Call +1 (804)-715-8126
+

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

  • Lead Salesforce Developer

    LeadStack, Inc California City, CA

    Responsibilities: Your ability to quickly learn new features, technologies, and to communicate...

    View Job
  • Strong Appian Developer

    Simple Solutions San Ramon , CA

    Required Experience Experience in implementing projects with Appian 7.5 and above Appian ...

    View Job
  • Appian Developer

    ASK Staffing Inc San Ramon, CA

    Job Description : Analysis, design, implement, integrate and test multiple Appian BPM ...

    View Job
  • Appian Developer

    IT Trailblazers St. Louis, MO

    Job Description: Analysis, design, implement, integrate and test multiple Appian BPM ...

    View Job
  • Network Engineer (Azure networking, Palo Alto)

    VOX IT LLC San Francisco, CA

    Responsibilities: Deploy, Configure, Maintained Palo Alto firewall on Azure Cloud. ...

    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