Senior SQL Server DBA (Power BI, SSIS)
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.
- Build efficient semantic/data models, relationships, calculated columns, measures, and KPIs.
- Develop complex calculations using DAX and perform data transformations using Power Query/M.
- Integrate data from databases, Excel, APIs, cloud platforms, and other enterprise sources.
- Optimize Power BI datasets and reports for performance and scalability.
- Manage Power BI Service, workspaces, gateways, scheduled refreshes, access controls, and Row-Level Security (RLS).
- Work closely with business stakeholders to translate reporting requirements into dashboards and actionable insights.
\n
\n
\n
\n
\n
\n
\n
\n
\n
Database Administration
\n
- \n
- Administer and support enterprise database environments such as Microsoft SQL Server and/or Oracle.
- Perform database installation, configuration, upgrades, patching, backup, restore, and recovery.
- Monitor database health, capacity, availability, and overall performance.
- Perform SQL/query optimization, indexing, execution-plan analysis, and performance tuning.
- Manage database users, roles, permissions, and security controls.
- Support high availability and disaster recovery configurations.
- Troubleshoot database and data-related production issues and perform root-cause analysis.
- Support data migration, database refresh, and environment management activities.
\n
\n
\n
\n
\n
\n
\n
\n
\n
