Principal Technology Specialist (IT)

McDermott International, Ltd
Houston, TX, United States
15 days ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
7 years minimum
Working hours
Regular working hours

Tech stack

Artificial Intelligence Business Analytics Applications Data Analysis Microsoft Azure Backup Devices Cluster Analysis Information Systems Databases Data Conversion Data Governance Data Infrastructure Data Integration
+23 more
Extract Transform Load (ETL) Data Transformation Data Warehousing Relational Databases Database Schema Disaster Recovery Microsoft Software Microsoft SQL Server SQL Azure NoSQL Performance Tuning Windows PowerShell Power BI SQL Databases SQL Server Reporting Services SQL Server Integration Services Transact-SQL Scripting Data Ingestion Database Performance Microsoft Fabric Information Technology Cloud Migration

Job description

  • Perform database administration including installation, configuration, monitoring, performance tuning, troubleshooting, SOX compliance, audits, backups, recovery, patching, and upgrades for on-premises and Azure SQL environments
  • Manage Development, Test, QA, and Production databases and implement enhancements to meet business needs
  • Monitor database health, availability, capacity, reliability, and performance
  • Configure and support Always On, clustering, replication, backup, and disaster recovery solutions
  • Execute database changes through established change management processes
  • Support database schema design, migration, data conversion, and performance optimization
  • Collaborate with application teams, vendors, and business users to resolve database-related issues
  • Administer and support Microsoft Fabric capacities, workspaces, lakehouses, warehouses, pipelines, and security
  • Design, develop, and support data ingestion and ETL/ELT processes using Fabric
  • Support Fabric deployments and promotions across environments
  • Administer gateways, datasets, workspaces, refresh schedules, and security
  • Support enterprise reporting, dashboards, analytics solutions, and data governance
  • Support AI initiatives and use modern AI tools for innovation and productivity
  • Participate in data modernization, cloud migration, and analytics projects
  • Provide after-hours support and maintenance as required

Key Tasks and Responsibilities:

  • Perform database administration including installation, configuration, monitoring, performance tuning, troubleshooting, SOX compliance, audits, backups, recovery, patching, and upgrades for on-premises and Azure SQL environments
  • Manage Development, Test, QA, and Production databases and implement enhancements to meet business needs
  • Monitor database health, availability, capacity, reliability, and performance
  • Configure and support Always On, clustering, replication, backup, and disaster recovery solutions
  • Execute database changes through established change management processes
  • Support database schema design, migration, data conversion, and performance optimization
  • Collaborate with application teams, vendors, and business users to resolve database-related issues
  • Administer and support Microsoft Fabric capacities, workspaces, lakehouses, warehouses, pipelines, and security
  • Design, develop, and support data ingestion and ETL/ELT processes using Fabric
  • Support Fabric deployments and promotions across environments
  • Administer gateways, datasets, workspaces, refresh schedules, and security
  • Support enterprise reporting, dashboards, analytics solutions, and data governance
  • Support AI initiatives and use modern AI tools for innovation and productivity
  • Participate in data modernization, cloud migration, and analytics projects
  • Provide after-hours support and maintenance as required

Requirements

Information Technology & Information Systems, Microsoft SQL Server, Database Administration, Microsoft Product Family, Microsoft Windows Azure, Power BI, Value Chain Model, Systems Administration/Management, Information Technology & Information Systems, Computer Science, * Bachelor’s degree in computer science, Information Technology, or related field

  • 7+ years of hands-on SQL Server DBA experience supporting production systems
  • Experience with SSRS, SSIS, Azure SQL, and Microsoft Fabric
  • Experience administering Power BI Service and enterprise reporting platforms
  • Strong knowledge of SQL Server performance tuning, HA/DR, Always On, clustering, replication, backup, and recovery
  • Experience with schema design, schema migration, data conversion, and database performance optimization
  • Strong knowledge of AI capabilities, tools, and usage trends
  • Proficiency in T-SQL and PowerShell or Python scripting
  • Experience with data integration, data warehousing, and analytics platforms
  • Familiarity with third-party RDBMS and NoSQL technologies
  • Strong communication, troubleshooting, and problem-solving skills
  • Ability to support U.S. Central Time business hours and work effectively both independently and within a team

Preferred

  • SQL, Microsoft Fabric, Azure Database offerings, Power BI related certification
  • Experience leading data platform, analytics, and cloud modernization projects
  • Experience Administration of pipelines, development, and troubleshooting

LI-CA1

DICE

About the company

This role is part of the US DBA Team responsible for the administration, support, and optimization of SQL Server, Azure Data Services, Microsoft Fabric, Power BI, and enterprise data platforms.

Our ingenuity fuels daily life. Together, we’ve forged some of the most trusted partnerships across the energy value chain to make what was once just an idea a reality: laying subsea infrastructure thousands of feet below sea level, installing platforms hundreds of miles from shore, using our expertise to design and build offshore wind infrastructure, and reshaping the onshore landscape to deliver the energy products the world needs safely and sustainably.

For more than 100 years, weβ€™β€˜ve been making the impossible possible. Today, weβ€™β€˜re driving the energy transition with more than 30,000 of the brightest minds across 54 countries.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerbuilder.com
Prepare application

Good distractions

Loading talks and stories from around this role…