SQL Database Administrator
Artech LLC
Plano, TX
Apply
JOB DETAILS
SALARY
$55–$58 Per Hour
LOCATION
Plano, TX
POSTED
5 days ago
Title: SQL Database Administrator (SQL DBA)
Locations: Plano, TX 75093
Duration: 6+ Months
Salary Range: $55- $58/Hour on W2 Only (All inclusive) Applicant must be willing to work on W2.
Job Overview
We are seeking an experienced SQL Database Administrator (SQL DBA) to manage and administer Microsoft SQL Server databases in a hybrid environment. This role requires a strong background in database performance tuning, high availability, disaster recovery, and database maintenance. The ideal candidate will have experience in optimizing SQL queries, managing critical production systems, and working closely with developers to ensure seamless database operations.
Key Responsibilities:
Database Administration & Management:
- Manage and Administer SQL Server Databases:
- Oversee the daily management of SQL Server databases (2016 and above) ensuring they are highly available and perform at optimal levels.
- Administer SQL Server instances, including installation, configuration, and upgrading of databases and associated infrastructure.
- Perform regular backups, restores, and recovery procedures to ensure data integrity and availability.
- Configuration & Maintenance:
- Configure, monitor, and maintain database servers and associated processes to ensure high levels of performance, availability, sustainability, and security.
- Implement and manage database policies, security protocols, and access controls.
- Work with developers to provide solutions for query optimization, schema design, and indexing.
- Performance Tuning & Optimization (PTO):
- Monitor database performance and resolve issues related to query execution, system bottlenecks, and other performance-related problems.
- Analyze and recommend best practices for optimizing SQL queries and server resources.
- Utilize tools like SQL Profiler, Extended Events, and Performance Dashboard to troubleshoot and resolve performance issues.
- Ensure High Availability & Disaster Recovery:
- Design, implement, and manage High Availability (HA) and Disaster Recovery (DR) solutions for SQL Server environments, including Always On Availability Groups, SQL Server Clustering, Log Shipping, and Replication.
- Configure and test disaster recovery strategies to meet business continuity requirements.
- 24x7 Support for Critical Production Systems:
- Provide 24x7 support for production environments to resolve database-related issues and ensure minimal downtime.
- Participate in on-call rotations to provide after-hours support for critical incidents.
- Assisting Developers:
- Work closely with development teams to optimize SQL queries, assist with schema refinement, and address any database-related performance concerns.
- Offer advice on best practices for designing and maintaining efficient databases and queries.
- Refine & Automate Regular Processes:
- Automate routine database maintenance tasks such as backups, monitoring, and performance tuning using scripting languages like PowerShell and T-SQL.
- Regularly review processes and improve them to reduce manual interventions and ensure high reliability.
- Track Issues & Document Changes:
- Track and document all database changes, issues, and resolutions, maintaining comprehensive logs and reports.
- Document database configurations, high availability setups, disaster recovery plans, and tuning strategies for future reference.
- Scheduled Maintenance & Release Support:
- Perform regular database maintenance tasks such as patching, version upgrades, and optimizations to ensure system stability.
- Support release deployments and coordinate database changes with development and operations teams.
Essential Skills & Qualifications:
- 10+ years of experience in SQL Server Database Administration (Microsoft SQL Server 2016 and above).
- Strong expertise in database configuration, maintenance, and performance tuning.
- Hands-on experience with backup and restore processes and recovery models in SQL Server.
- Experience with High Availability (HA) and Disaster Recovery (DR) solutions, including Always On Availability Groups, SQL Server Clustering, and Log Shipping.
- Knowledge of Windows Server administration, including integration with Active Directory.
- Experience with query tuning, indexing, and schema optimization to ensure optimal database performance.
- Strong understanding of security protocols for SQL Server and managing user access and permissions.
- Expertise in troubleshooting SQL performance issues, database errors, and failures.
- Critical thinking and problem-solving skills, with the ability to handle complex database issues in real-time.
Desirable Skills:
- Experience with Cloud-based SQL Server solutions (e.g., Azure SQL Database, SQL Managed Instances).
- Familiarity with PowerShell scripting for automating SQL Server maintenance tasks.
- Knowledge of database monitoring tools such as Redgate, SolarWinds, or SQL Diagnostic Manager.
- Experience with database migration and upgrades.
Soft Skills:
- Strong communication skills to work effectively with both technical and non-technical teams.
- Ability to work under pressure, prioritize tasks, and manage time efficiently.
- Proactive approach to identifying and resolving database issues before they impact the business.
- Strong collaboration and teamwork skills for working with cross-functional teams.
Company Benefits & Culture
- Inclusive and diverse work environment
- Opportunities for professional growth and development
- Comprehensive health and wellness benefits
Appreciate your quick response and please feel free to reach me out for any query you may have.
Thanks
About the Company
A