Job Summary:
MDAEdge is a company seeking a SQL Server Database Administrator to develop and maintain corporate SQL Server databases, ensuring data integrity and security. The role involves administering enterprise-wide data architecture, managing daily operations, and providing 24x7 support for database systems.
Responsibilities:
• Develop and maintain corporate SQL Server databases to ensure data integrity, security, retention, and recoverability.
• Design, build, test, and deploy database solutions aligned with project objectives and best practices.
• Administer enterprise-wide data architecture and implement complex data structures.
• Manage daily operations of corporate databases.
• Create and administer database objects to maximize availability, efficiency, and supportability.
• Perform database administration tasks (installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup, and recovery).
• Provide 24x7 rotational on-call support, including Root Cause Analysis (RCA) and preventative actions.
• Manage change processes across development, test, QA, and production environments.
• Proactively monitor databases and resolve issues.
• Optimize databases and T-SQL (performance tuning, query optimization).
• Participate in projects involving database enhancements and design decisions.
• Implement database security policies aligned with corporate standards.
• Evaluate patch releases and manage deployment timelines.
• Support high availability (HA) and disaster recovery (DR) architectures.
• Maintain documentation on databases and data architecture.
• Support data management (ETL, archive, purge).
• Conduct capacity planning and generate weekly/monthly reports.
• Assist in project sizing, design reviews, and cost/resource estimates.
• Perform other duties as assigned.
Qualifications:
Required:
• 8+ years of SQL Server DBA experience.
• Expertise in SQL Server versions (2012–2016); knowledge of 2019 & 2022 upgrades.
• Experience with database backups, ETL, and archiving using native SQL tools.
• Proficient in diagnostic tools (DBCC, SQL Profiler, third-party tools).
• Knowledge of partitioning architecture.
• Experience with BI tools (SSIS, SSAS, SSRS, SharePoint).
• Strong T-SQL, PowerShell, and tuning/debugging skills.
• Familiarity with SQL Server Manager, Visual Studio, DTS/SSIS, Profiler.
• Experience with replication, mirroring, and HA/DR solutions.
• Ability to manage security/access for diverse user groups.
• Work well under pressure with tight deadlines.
• Self-motivated with strong prioritization skills.
• Adaptable to fast-paced environments.
• Excellent communication and teamwork skills.
• Strong organizational and analytical abilities.
• 8+ years of hands-on SQL Server DBA experience.
• Expertise in backup/recovery, HA/DR, and performance tuning.
• Strong T-SQL, PowerShell, SSIS/SSRS skills.
• Experience with monitoring and optimization tools.
• Proficient in change management and patching.
• Knowledge of database security and access controls.
• 24x7 on-call support experience with RCA.
• Strong collaboration with development/infrastructure teams.
Preferred:
• Microsoft Certified Database Administrator (MCDBA) or higher.
• Data modeling and metadata management experience.
• Knowledge of .NET applications or virtual environments.
• Oracle DBA experience is a plus.
Company:
The world doesn't have a talent shortage. It has a talent alignment problem. MDA Edge exists to fix that. Founded in , the company is headquartered in Sheridan, WY, US, , with a team of 51-200 employees. The company is currently Growth Stage.