Position Summary
We are seeking a Senior MS SQL Database Administrator to administer, support, optimize, and maintain enterprise SQL Server and cloud database environments.
The ideal candidate will have strong hands-on experience with Microsoft SQL Server, high availability, clustering, database performance tuning, T-SQL, upgrades, patching, migrations, and cloud database technologies . The role will also provide application and database support as part of a technical operations team.
Key ResponsibilitiesAdminister and support enterprise Microsoft SQL Server and cloud database environments.
Monitor databases to maintain availability, performance, and reliability.
Troubleshoot database and application issues involving connectivity, access, security, and performance.
Diagnose and resolve SQL Server performance issues, including long-running queries, blocking, and deadlocks.
Perform SQL Server installation, configuration, upgrades, patching, and database migrations.
Support SQL Server high-availability environments, including clustering, mirroring, and failover configurations.
Write, review, and optimize complex Transact-SQL (T-SQL) queries and scripts.
Tune database workloads and optimize indexes, queries, and resource utilization.
Support very large databases and analyze workload performance and resource contention.
Use tools such as Query Store, Extended Events, and wait-statistics analysis for performance troubleshooting.
Review and improve existing database processes and maintenance procedures.
Use operating-system scripting utilities to support database maintenance, diagnostics, and troubleshooting.
Review existing database implementations and recommend or implement improvements.
Apply database modeling principles to support effective database design.
Collaborate with engineering, operations, application, and infrastructure teams.
Create and maintain technical requirements, design artifacts, and database documentation.
Participate in application and help desk support activities as required.
6+ years of hands-on experience administering Microsoft SQL Server databases.
Strong experience with SQL Server database administration, support, and performance tuning.
Strong knowledge of SQL Server high availability, clustering, mirroring, and failover technologies.
Strong T-SQL development and query optimization skills.
Experience installing, upgrading, patching, and migrating SQL Server databases.
Experience working in Windows Server environments.
Experience supporting large and high-volume SQL Server databases.
Experience diagnosing blocking, deadlocks, and database performance issues.
Strong knowledge of database monitoring, troubleshooting, and performance optimization.
Experience with Azure or other cloud database technologies.
Ability to communicate effectively using technical requirements and design documentation.
Experience upgrading enterprise SQL Server environments across major versions.
Experience with SQL Server compatibility assessments and database migration tools.
Experience using Query Tuning Assistant and Database Migration Assistant or similar migration/performance tools.
Experience diagnosing deadlocks and blocking in production environments.
Experience using Extended Events, Query Store, and wait-statistics analysis.
Experience tuning Very Large Databases (2 TB+), including index optimization, workload analysis, and resource contention management.
At least 1 year of experience with Azure, Snowflake, or Databricks , or equivalent certification.
Experience with SQL Server 2019+.
Exposure to cloud database platforms such as Azure, Snowflake, and/or Databricks.
Exposure to SSIS, SSAS, and SSRS.
Experience with enterprise database modernization and migration projects.
Experience supporting highly available production database environments.
Knowledge of data modeling principles.
Strong analytical and problem-solving skills.
Ability to work independently on complex technical assignments.
Strong written and verbal communication skills.
...Mail Sorter - Avenel, NJ At Job&Talent, we are recruiting for a Mail Sorter to work with a leading logistics company in Avenel, NJ. Join... ...to read labels Role for Mail Sorter Load, unload, and sort mail of various sizes Inspect mail and packages to ensure no items...
Professional Writing TutorTsaile Learning CenterStudent AffairsTsaile CampusDuty Schedule:Monday through Friday, 8:00 AM to 5:00 PM. May... ...Education setting. Preferred:Bachelor's degree in English, Creative Writing, and/or related field.Knowledge:Knowledgeable of quality...
Anthropologie (Terrain) is looking for a Creative Video Editor Intern for the Summer. This intern will support the creative team in editing social-first video content and PDP content capture. Looking for a creative who has an eye for storytelling, experience in sound editing...
AIR Communities is one of the country's largest owners and operators of multifamily housing, managing high-quality communities across the country! At AIR,we value integrity, respect, collaboration, customer focus, and performance. These values are brought to life...
...development team. The Account Manager will play a pivotal role in growing our client base and supporting partners within thegeology and hydrology industries in the United States & Canada. The ideal candidate will demonstrate a strong sense of responsibility, a solution-...