Overview
Skills
Job Details
Position: SQL Server Database Administrator (SQL DBA)
Location: Las Vegas, NV (Onsite)
Experience: 8 10 Years
Employment Type: Contract
Position Summary
The primary objective of the SQL Server Database Administrator (SQL DBA) is to develop and maintain corporate SQL Server databases-ensuring data integrity, security, retention, and recoverability.
The DBA will design, build, test, and deploy database solutions aligned with project objectives, technology architecture standards, and best practices.
This includes database strategy design, enterprise-wide data architecture administration, and daily management of production databases.
Key Responsibilities
-
Handle all aspects of database administration: installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup, and recovery.
-
Provide 24x7 on-call support, drive root cause analysis (RCA), and perform preventative actions.
-
Manage multiple environments (development, test, QA, production) through effective change management practices.
-
Perform database monitoring, performance tuning, query optimization, and T-SQL optimization.
-
Contribute to enterprise database projects, including design and implementation decisions.
-
Develop and enforce database security policies and procedures aligned with corporate objectives.
-
Implement high availability and disaster recovery (HA/DR) standards.
-
Create and maintain comprehensive database documentation and data architecture blueprints.
-
Manage ETL processing, data archiving, and data purging activities.
-
Conduct regular capacity planning and prepare management reports.
-
Collaborate with infrastructure and development teams for database-related enhancements and application integrations.
Required Qualifications
-
5+ years of hands-on SQL Server DBA experience (SQL Server 2012 2016; experience with 2019/2022 upgrades preferred).
-
Expertise in database backup, recovery, replication, and mirroring.
-
Proficiency in T-SQL, PowerShell, and SQL performance tuning.
-
Strong experience with SQL Server Management Studio (SSMS), Visual Studio, SSIS, SSRS, SSAS, and related BI toolsets.
-
Skilled in database security/access control for diverse user groups.
-
Experience with ETL and data management using native SQL tools.
-
Strong organizational, communication, and analytical skills.
-
Understanding of High Availability (HA) and Disaster Recovery (DR) solutions.
Preferred Qualifications
-
Microsoft Certified Database Administrator (MCDBA) or higher certification on SQL Server 2012+.
-
Knowledge of data modeling, metadata management, and .NET application support.
-
Experience with virtual environments and Oracle DBA support (a strong plus).