SR Data Platform Engineer

Titan Professional Resources is seeking a Senior Data Platform Engineer to join one of our clients. This position will focus on administering, securing, and optimizing enterprise data platforms across on-premises and cloud environments. The ideal candidate will have extensive experience with SQL Server administration, Azure data services, and Microsoft Fabric, along with strong troubleshooting and automation skills.

Senior Data Platform Engineer Responsibilities

• Administer, maintain, patch, upgrade, and troubleshoot Microsoft SQL Server environments across Development, UAT, Production, and Disaster Recovery.

• Manage SQL Server components, including Database Engine, SQL Server Agent, SSIS/SSISDB, SSRS, linked servers, and supporting services.

• Design and maintain high-availability and disaster-recovery solutions, including Availability Groups, backup and restore strategies, failover testing, and recovery procedures.

• Monitor and optimize database performance, including queries, indexing, statistics, blocking, deadlocks, CPU, memory, storage, and TempDB.

• Maintain database operations, including integrity checks, backups, SQL Server Agent jobs, alerts, scheduled tasks, and automated maintenance.

• Support database migrations, environment refreshes, server consolidation, version upgrades, and modernization initiatives.

• Implement and support data movement technologies, including Change Data Capture (CDC), Change Tracking, and replication.

• Troubleshoot complex database issues involving connectivity, performance, failed jobs, storage, corruption, availability, and recovery.

• Evaluate opportunities to modernize SQL Server workloads using Azure SQL Managed Instance, Azure SQL Database, Microsoft Fabric, and other cloud platforms.

• Administer SQL Server authentication, logins, users, roles, permissions, and access controls.

• Implement security best practices, including least-privilege access, privileged access reviews, database auditing, encryption, and secure connectivity.

• Partner with Cybersecurity and Infrastructure teams to address vulnerabilities, patching requirements, audit findings, and remediation activities.

• Administer and optimize Azure and Microsoft Fabric services, including Fabric Warehouse, Lakehouse, OneLake, capacities, workspaces, gateways, and connections.

• Support data integration and movement using Azure Data Factory, Fabric Data Factory, pipelines, notebooks, Mirroring, Copy Jobs, and other integration technologies.

• Monitor Fabric capacity, resource utilization, workload performance, and On-premises Data Gateway availability and connectivity.

• Develop monitoring, alerting, dashboards, and automation for platform administration, maintenance, deployments, access reviews, and environment configuration.

• Use PowerShell, T-SQL, Python, Azure CLI, and REST APIs to automate routine platform tasks.

• Participate in production incident response, root-cause analysis, capacity planning, and preventative maintenance.

• Implement source control and CI/CD practices using Azure DevOps, Git, database projects, DACPACs, and deployment pipelines.

• Establish controlled deployment processes across Development, UAT, and Production, including rollback planning and post-deployment validation.

• Collaborate with Data Engineering and Architecture teams to establish standards for security, performance, monitoring, backups, availability, and disaster recovery.

• Maintain architecture diagrams, configuration documentation, operational procedures, recovery plans, and technical standards.

Senior Data Platform Engineer Qualifications

• Bachelor's degree or diploma in Computer Science, Information Technology, Engineering, or a related field, or equivalent professional experience.

• Minimum of 5 years of experience in database administration, data platform engineering, cloud engineering, or a related technical role.

• Strong hands-on experience administering Microsoft SQL Server in enterprise production environments, including on-premises and cloud platforms.

• Strong understanding of SQL Server architecture, configuration, security, backup and recovery, performance tuning, and troubleshooting.

• Experience with SQL Server Availability Groups and high-availability and disaster-recovery technologies.

• Experience administering SQL Server Agent jobs and database maintenance processes.

• Experience with Microsoft Fabric administration and architecture, including Warehouse, Lakehouse, OneLake, Fabric Capacity, and On-premises Data Gateway.

• Experience with data integration technologies such as SSIS, Azure Data Factory, or Fabric Data Factory.

• Proficiency in scripting and automation using PowerShell, Python, T-SQL, or similar technologies.

• Understanding of enterprise networking, Active Directory/Microsoft Entra ID, service accounts, managed identities, firewalls, private endpoints, and secure connectivity.

• Experience supporting business-critical production systems and troubleshooting complex technical issues.

• Strong analytical, problem-solving, and organizational skills.

• Knowledge of enterprise security, governance, access control, reliability, and operational risk management principles.

• Ability to manage competing priorities, respond effectively to production issues, and maintain secure, reliable, and highly available data platforms.