About Purple Drive Technologies
Sourced by ZipRecruiter
Industry
It services
Company size
51 - 200 Employees
Headquarters location
Irvine, CA, US
Year founded
2016
$47.75 - $59.75/hr
Contractor
Posted 6 days ago
Job description
Overview:
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
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.
- 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.
- 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).
purpledrive.com
Most Popular Jobs Similar to Sql Database Administrator
sql server database administrator
sql database analyst
sql dba
senior sql dba
sql server dba
ms sql dba
database administrator
sql database developer
db2 database administrator
sql server dba developer
Other Helpful Pages Related To SQL Server Database Administrator (SQL DBA)
Sql Database Administrator Salaries
Sql Database Administrator Career Research
Frequently asked questions
Q: What skills or qualities help someone succeed as a SQL Database Administrator?
A: To succeed as a SQL Database Administrator, key technical skills include proficiency in SQL programming languages, database management systems (DBMS) such as MySQL or Microsoft SQL Server, and data modeling techniques. Additionally, soft skills like strong analytical and problem-solving abilities, effective communication, and adaptability to changing database requirements are crucial for troubleshooting, optimizing database performance, and collaborating with stakeholders. These strengths enable SQL Database Administrators to efficiently manage and maintain databases, ensuring data integrity and supporting business growth and decision-making.
Q: What is the career path for a SQL Database Administrator?
A: A SQL Database Administrator's typical career progression involves starting as a Junior Database Administrator, responsible for database maintenance and troubleshooting, then advancing to a Senior Database Administrator, overseeing database performance, security, and scalability. Along the way, they can develop skills in areas like data warehousing, business intelligence, and cloud computing, as well as obtain certifications like Oracle OCP or Microsoft MCSA. Ultimately, experienced Database Administrators can transition into leadership roles, such as Database Architect or IT Manager, or pursue specialized careers like Data Scientist or DevOps Engineer.
