Database Administrator
WHEELER MACHINERY CO.
Salt Lake City, UT, United States
9 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.indeed.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Working hours
Regular working hours
Job source
Tech stack
Legacy Database
Artificial Intelligence
Data Analysis
Microsoft Azure
Backup Devices
Cloud Computing
Information Systems
Databases
Data Dictionary
Information Engineering
Data Infrastructure
Data Integrity
+34 more
IBM DB2
Relational Databases
Database Queries
Database Schema
Database Security
Disaster Recovery
Log Shipping
Microsoft SQL Server
SQL Azure
Operational Data Store
Operational Databases
Performance Tuning
Windows PowerShell
Power BI
Azure Active Directory
Software Deployment
SQL Stored Procedures
SQL Databases
SQL Server Agent
SQL Server Integration Services
Transact-SQL
Management of Software Versions
Data Storage Management
Enterprise Software Applications
Azure Data Factory
Database Optimization
Database Performance
Change Data Capture
Git
Database Migration
Microsoft Fabric
Information Technology
SQL Server Management Studio (SSMS)
Software Version Control
Job description
Database Administration & Availability
- Administer on-premises SQL Server instances, Azure SQL databases and the Microsoft Fabric capacity supporting enterprise applications (ERP, CRM, WHM), the reporting layer and the Data platform, including instance configuration, SQL Server Agent jobs, maintenance plans, and high-availability features.
- Own database backups, restore testing on a schedule with evidence kept, and disaster recovery for the database tier; ensure RPO/RTO targets are defined, documented, and tested.
- Monitor database health and availability; respond to alerts and resolve database incidents within SLA targets, including participation in the on-call rotation on the Data teamβs rotation, with IT Infrastructure engaged for host-level incidents.
- Own capacity planning and storage management across on-premises and Azure-hosted database instances.
- Own the on-premises data gateways: install, patch, rotate credentials, monitor, and retire them as data sources move to the cloud.
- Partner with IT Infrastructure on the host operating system, storage and disks, and scheduled OS-level maintenance (including PowerShell maintenance scripts) on the servers that on-premises SQL Server runs on; own the database-level impact and escalate host-level issues to Infrastructure.
Performance Tuning
- Monitor and tune database performance, including index analysis, query plan optimization, statistics maintenance, and resource governance.
- Partner with application owners, the Enterprise Solutions Software Engineer, and vendors to resolve slow queries, blocking, and deadlocks.
- Review new database objects, stored procedures, and schema changes for performance and standards before production deployment.
- Monitor and optimize Microsoft Fabric capacity unit (CU) consumption: track capacity metrics, identify and tune expensive items, prevent throttling, and keep the AI and BI shares of capacity visible. Administer the Fabric capacity day to day under the Director, Dataβs plan: the baseline, the dev/prod split, optimization, and a cost view by consumer including AI
Security & Compliance
- Manage database security, including logins, roles, least-privilege access, row-level security, Transparent Data Encryption (TDE), and auditing.
- Apply database patches and cumulative updates in coordination with the Manager, Infrastructure & Cloud Ops and per security directives from the Manager, Infrastructure & Cloud Ops.
- Support access reviews, audit evidence requests, and data protection requirements for regulated and sensitive data.
- Administer Fabric workspace access and Microsoft Entra groups for Fabric so access follows role, with no personal grants; manage service principals and their secrets for data-platform identities. The Database Administrator creates, owns and manages the row-level security roles and the Microsoft Entra group mapping and membership, with no access granted to individual users; Data Engineers implement access only through those roles, and Business Intelligence uses them in its certified datasets.
- Run the Microsoft Purview account, scans and access model that carry the data dictionaryβs term ids, history and lineage, with Business Intelligence writing the definitions and relationships; register and scan the databases this role administers.
Upgrades, Migrations & Standards
- Plan and execute database migrations and version upgrades with minimal business disruption, and support migration of legacy databases to the target platform agreed in the Data roadmap (Azure SQL or Fabric).
- Participate in database schema design reviews, working with software engineers and data engineers, and enforce standards for naming conventions, referential integrity, and normalization.
- Coordinate ERP, CRM, and WHM database administration with the Manager, Infrastructure & Cloud Ops (servers and hosting platform) and the Manager, Enterprise Solutions & Experience (application owners).
- Support decommissioning of legacy database servers as data sources are retired, in step with the Data teamβs retirement plan.
Data Platform Partnership
- Provide reliable, secure, and performant source-database access for Data Engineering pipelines that ingest ERP, CRM, and operational data into the Microsoft Fabric lakehouse, including change data capture where needed.
- Partner with the Director, Data and Data Engineers on extraction patterns that protect production database performance.
- Support Analytics Engineering with database-level troubleshooting for reporting sources.
Documentation & Continuous Improvement
- Maintain runbooks, the legacy data estate register (every legacy database, integration and gateway, including DB2 and MIMIX, CData, SSIS, DBSSQL3 and the on-premises gateways, each with a named business owner, a retire-or-keep decision and planned conversions, as the input to the retirement plan), database inventories, configuration baselines, and recovery procedures.
- Automate routine DBA tasks using T-SQL, PowerShell (including dbatools), and SQL Server Agent.
- Stay current with SQL Server and Azure SQL roadmap developments and recommend improvements.
- Work safely in all aspects of the role.
- Performs all other duties as assigned., * Frequent keyboard, mouse, and telephone use, including extended periods of screen work and virtual meetings.
- Occasionally lift and carry laptops, equipment, and materials up to 25 lbs.
- Occasionally bend, stoop, and reach to access equipment and workspaces.
- Must have visual acuity sufficient to read computer screens, detailed documentation, code, and data.
- Work is performed primarily in an office environment. Occasional visits to Campbell Companies field locations may include shop, yard, and job site conditions with noise and dust, and require site-specific PPE.
- Travel Details: Occasional local and regional travel to Campbell Companies locations.
Requirements
- Bachelorβs degree in Computer Science, Information Systems, or a related field; equivalent experience considered., * Minimum of 4-7 years of database administration experience, including at least 3 years administering production SQL Server environments.
- Demonstrated experience with backup/recovery, performance tuning, security, and version upgrades for business-critical databases.
- Experience supporting ERP or other enterprise application databases preferred.
- Experience with Azure SQL Database or Azure SQL Managed Instance preferred.
- Experience administering Microsoft Fabric or Power BI Premium capacity preferred.
Technical Skills
- Expert T-SQL, including complex queries, stored procedures, indexing strategies, and query plan analysis.
- SQL Server administration: backup/restore, SQL Server Agent, DMVs, Always On availability groups or log shipping, TDE, and Database Mail.
- Azure SQL Database and Managed Instance administration, including security, scaling, and monitoring.
- PowerShell (including dbatools) for automation.
- Familiarity with change data capture and data integration patterns used by Microsoft Fabric and Azure Data Factory.
- Source control proficiency (Git / Azure DevOps) for schema change management.
Skills and Competencies
- Strong analytical and root-cause problem-solving skills under production pressure.
- Meticulous attention to detail, documentation, and change control.
- Clear communication with application owners, vendors, and technical teams.
Certifications (Preferred)
- Microsoft Certified: Azure Database Administrator Associate (DP-300) strongly preferred, or active pursuit.
- Microsoft Certified: Azure Data Fundamentals (DP-900) acceptable as a foundational credential.
- Microsoft Certified: Fabric Data Engineer Associate (DP-700) a plus.
Benefits & conditions
operating system, and with the Manager, Enterprise Solutions & Experience and application owners on application databases. Within the Data teamβs plan, this role also carries the legacy data estate, security and governance, and the Fabric capacity. This position supports all Campbell Companies.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.indeed.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦