{"schemaVersion":"jobsearcher.job.v1","id":"7db0e45395010566158bab25","url":"https://jobsearcher.com/jobs/7db0e45395010566158bab25","canonicalUrl":"https://jobsearcher.com/jobs/7db0e45395010566158bab25","title":"Microsoft SQL Server DBA - US","description":"Client: Our client is a U.S. division of an international financial corporation. Their primary business areas include corporate financial services, maintenance leasing, real estate, investment and operations, retail, and international business.\n\nPosition overview: The Microsoft SQL Server DBA will play a key role in ensuring the stability, performance, and security of our client's mission‑critical data platforms. This role involves managing complex SQL Server environments, supporting high‑availability and disaster‑recovery strategies, and optimising large‑scale financial datasets used across reporting, analytics, and core business applications.\nThe DBA will collaborate closely with engineering, BI, and application teams to design scalable data solutions, maintain robust operational processes, and ensure compliance with regulatory requirements in a highly controlled environment.\nThe estimated salary range for this position is 130,000 to 170,000 USD per year.\n\nTechnology stack: MS SQL Server\n\nResponsibilities: Administer, configure, patch, and upgrade Microsoft SQL Server across development, test, and production environments.\nOperate and maintain high‑availability and disaster‑recovery architectures (Always On, Failover Clustering, Replication, Log Shipping).\nMonitor and tune database performance, including query plans, indexing strategies, I/O, waits, and resource utilization.\nDesign and maintain backup, restore, and recovery strategies aligned with RPO/RTO requirements and audit standards.\nImplement and enforce database security, encryption, auditing, and role‑based access control.\nSupport SOX compliance, internal audits, and regulatory requirements through logging, traceability, and access reviews.\nManage capacity planning, storage growth, and archival strategies for large financial and reporting datasets.\nSupport CI/CD pipelines and release management for database changes and schema deployments.\nDevelop, review, and optimise T‑SQL stored procedures, views, functions, and queries.\nCollaborate with data engineering, BI, and application teams to implement reliable and scalable data models (dimensional, star schema, relational).\nSupport data warehouses, ETL staging areas, and reporting databases.\nTroubleshoot and resolve production data issues across pipelines, reporting, and applications.\n\n7+ years administering Microsoft SQL Server in enterprise production environments.\nAdvanced expertise in T‑SQL, stored procedures, indexing, and query optimisation.\nStrong knowledge of SQL Server HA/DR and backup/restore architectures.\nDeep understanding of relational and dimensional modeling (star, snowflake).\nExperience with data warehouses, reporting platforms, and ETL pipelines (SSIS, Azure Data Factory, etc.).\nProven ability to manage security, encryption, auditing, and compliance controls in regulated environments.\nExperience working with large‑scale financial or enterprise datasets.\nFamiliarity with Power BI, SSRS, or similar reporting platforms.\nStrong troubleshooting skills across performance and operational issues.\n\nNice to have: Experience with cloud‑based SQL platforms (Azure SQL, Managed Instance, SQL Server on Azure).","company":"Dataart","rawCompany":"dataart","city":"Dallas","state":"TX","isRemote":false,"isActive":false,"createdAt":"2026-04-14T11:06:28.741Z","occupations":[{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"518210","title":"Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services","slug":"computing-infrastructure-providers-data-processing-web-hosting-and-related-services"},{"code":"541519","title":"Other Computer Related Services","slug":"other-computer-related-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Microsoft SQL Server DBA - US","description":"Client: Our client is a U.S. division of an international financial corporation. Their primary business areas include corporate financial services, maintenance leasing, real estate, investment and operations, retail, and international business.\n\nPosition overview: The Microsoft SQL Server DBA will play a key role in ensuring the stability, performance, and security of our client's mission‑critical data platforms. This role involves managing complex SQL Server environments, supporting high‑availability and disaster‑recovery strategies, and optimising large‑scale financial datasets used across reporting, analytics, and core business applications.\nThe DBA will collaborate closely with engineering, BI, and application teams to design scalable data solutions, maintain robust operational processes, and ensure compliance with regulatory requirements in a highly controlled environment.\nThe estimated salary range for this position is 130,000 to 170,000 USD per year.\n\nTechnology stack: MS SQL Server\n\nResponsibilities: Administer, configure, patch, and upgrade Microsoft SQL Server across development, test, and production environments.\nOperate and maintain high‑availability and disaster‑recovery architectures (Always On, Failover Clustering, Replication, Log Shipping).\nMonitor and tune database performance, including query plans, indexing strategies, I/O, waits, and resource utilization.\nDesign and maintain backup, restore, and recovery strategies aligned with RPO/RTO requirements and audit standards.\nImplement and enforce database security, encryption, auditing, and role‑based access control.\nSupport SOX compliance, internal audits, and regulatory requirements through logging, traceability, and access reviews.\nManage capacity planning, storage growth, and archival strategies for large financial and reporting datasets.\nSupport CI/CD pipelines and release management for database changes and schema deployments.\nDevelop, review, and optimise T‑SQL stored procedures, views, functions, and queries.\nCollaborate with data engineering, BI, and application teams to implement reliable and scalable data models (dimensional, star schema, relational).\nSupport data warehouses, ETL staging areas, and reporting databases.\nTroubleshoot and resolve production data issues across pipelines, reporting, and applications.\n\n7+ years administering Microsoft SQL Server in enterprise production environments.\nAdvanced expertise in T‑SQL, stored procedures, indexing, and query optimisation.\nStrong knowledge of SQL Server HA/DR and backup/restore architectures.\nDeep understanding of relational and dimensional modeling (star, snowflake).\nExperience with data warehouses, reporting platforms, and ETL pipelines (SSIS, Azure Data Factory, etc.).\nProven ability to manage security, encryption, auditing, and compliance controls in regulated environments.\nExperience working with large‑scale financial or enterprise datasets.\nFamiliarity with Power BI, SSRS, or similar reporting platforms.\nStrong troubleshooting skills across performance and operational issues.\n\nNice to have: Experience with cloud‑based SQL platforms (Azure SQL, Managed Instance, SQL Server on Azure).","datePosted":"2026-04-14T11:06:28.741Z","dateModified":"2026-04-14T11:06:28.741Z","hiringOrganization":{"@type":"Organization","name":"Dataart","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Dallas","addressRegion":"TX","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"7db0e45395010566158bab25"},"url":"https://jobsearcher.com/jobs/7db0e45395010566158bab25"}}