Sign upLog in
See more jobs

SQL Server DBA (SQL Server Database Administrator)

Macpower Digital Assets Edge Private Limited

  • Las Vegas, NV
  • 2 days ago
  • $50 Per Hour

Highlights

Essential Job Functions: Perform database administration tasks (installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup, and recovery). Position Summary: Develop and maintain corporate SQL Server databases to ensure data integrity, security, retention, and recoverability.

Numbers & Facts

LocationLas Vegas, NV
Salary$50 Per Hour

Description

Position Summary:
  • 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.
Essential Job Functions:
  • 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.
Position Requirements:
  • 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.
Preferred Qualifications:
  • 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.
Must Have:
  • 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.

Similar Jobs