Power BI - SQL Developer

Power BI - SQL Developer

The Power BI - SQL Developer performs database design, installs, upgrades, backup, recovery, administration, management and support of SQL server databases in an enterprise environment. The ideal candidate will thrive in a fast paced, dynamic work environment made up of a global team that provides the highest level of service possible to both our internal and external customers by creating a stable, scalable, and secure enterprise SQL database environment, completing service requests quickly and proactively searching out opportunities for improvement and customer satisfaction.

Job Responsibilities     

  • Extensive experience with Power BI and Microsoft SQL Server required
  • Analyze data gathered and assist in developing solutions or alternative methods of proceeding.
  • Assist in reviewing forms and reports, and conferring with management and users about format, distribution, and purpose, and in identifying problems and improvement.
  • Assist with documenting findings of studies and preparing recommendations for implementation of new systems, procedures, or organizational changes.
  • Assist in preparation of manuals and training workers in use of new forms, reports, procedures or equipment, according to organizational policy.
  • Perform basic assignments to design, evaluate, recommend, and approve changes of forms and reports.
  • Assist in troubleshooting for T-SQL.
  • Assist with the testing of new or upgrades of the operating systems and system administrative software prior to implementing into the test and production environments.
  • Responsible for planning software lifecycle projects to ensure database environments is supported
  • Advanced performance tuning and troubleshooting skills
  • Work with Microsoft and other vendors to ensure best practices are followed and environment is optimized
  • Work with internal systems, storage, networking, and application teams
  • Ensure recovery time and recovery point objectives are met
  • After hour and on call support is necessary
  • Extensive knowledge of industry best practice standards

Skills and Experience

  • Advanced experience and knowledge of Power BI and Microsoft SQL Server 2008, 2008R2, 2012, and 2016 is required.
  • Knowledge of transactional and merge replication.
  • Troubleshooting skills with both databases and T-SQL queries.
  • Work with offshore operational teams to improve database quality.
  • Work with internal systems, storage, networking, and application teams
  • Advanced Understanding and experience with regulated systems (SOX, HIPAA, GMP, etc).
  • Must be available to work off hours or shifts as required for 24/7/365 support.
  • Oracle Golden Gate, Oracle, DB2, or Teradata experience is a plus.
  • PowerShell or other scripting language experience.
  • VMWare or Hyper-V experience and knowledge of SharePoint
  • BS degree (computer science or equivalent preferred)
  • Extensive knowledge of transactional and merge replication
  • Advanced database availability to meet business requirements
  • Knowledge of SharePoint