Search

Senior SQL Server DBA (Power BI, SSIS)

PublishedPublished: 6/14/2022
Technology
|

Job Description

Role: Senior SQL Server DBA (Power BI, SSIS)

\n

Location: Iselin, NJ 08830 Hybrid

\n

Contract

\n

\n

Power BI / Reporting

\n

    \n
  • Design, develop, and maintain interactive Power BI dashboards and reports.
  • \n

  • Build efficient semantic/data models, relationships, calculated columns, measures, and KPIs.
  • \n

  • Develop complex calculations using DAX and perform data transformations using Power Query/M.
  • \n

  • Integrate data from databases, Excel, APIs, cloud platforms, and other enterprise sources.
  • \n

  • Optimize Power BI datasets and reports for performance and scalability.
  • \n

  • Manage Power BI Service, workspaces, gateways, scheduled refreshes, access controls, and Row-Level Security (RLS).
  • \n

  • Work closely with business stakeholders to translate reporting requirements into dashboards and actionable insights.
  • \n

\n


\n

Database Administration

\n

    \n
  • Administer and support enterprise database environments such as Microsoft SQL Server and/or Oracle.
  • \n

  • Perform database installation, configuration, upgrades, patching, backup, restore, and recovery.
  • \n

  • Monitor database health, capacity, availability, and overall performance.
  • \n

  • Perform SQL/query optimization, indexing, execution-plan analysis, and performance tuning.
  • \n

  • Manage database users, roles, permissions, and security controls.
  • \n

  • Support high availability and disaster recovery configurations.
  • \n

  • Troubleshoot database and data-related production issues and perform root-cause analysis.
  • \n

  • Support data migration, database refresh, and environment management activities.
  • \n

\n


Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...