Overview
On Site
Contract - W2
Contract - 6month(s)
Skills
DBA
microsoftsql
Job Details
Database Administrator Specialist
Location :Hybrid Plano, TX & McLean, VA Onsite (T,W,TH) Prefer Plano or McLean, but open to other locations.
Contract : 6 months to hire
Responsibilities:
- Performance Tuning and Optimization: Analyze and optimize SQL Server performance, including query tuning, index management, database configuration, and identifying and resolving performance bottlenecks.
- Advanced Scripting and Development: Develop complex T-SQL scripts for data manipulation, ETL processes, stored procedures, functions, triggers, and automation of database tasks.
- Database Design and Architecture: Participate in the design and architecture of SQL Server databases, ensuring scalability, security, and adherence to best practices.
- Database Administration (as needed): Perform database administration tasks such as installation, configuration, patching, backups, recovery, security management, and capacity planning.
- Troubleshooting and Problem Solving: Diagnose and resolve complex SQL Server issues, including performance problems, errors, and data inconsistencies.
- Data Integration and ETL: Design, develop, and maintain ETL processes using tools and scripting to integrate data from various sources into SQL Server.
- High Availability and Disaster Recovery: Implement and manage high availability (HA) and disaster recovery (DR) solutions for SQL Server environments (e.g., Always On Availability Groups, mirroring, replication).
- Security Implementation: Implement and maintain SQL Server security measures, including user and role management, permissions, auditing, and data encryption.
- Monitoring and Alerting: Implement and configure monitoring tools and alerts to proactively identify and address potential issues within the SQL Server environment.
- Documentation: Create and maintain comprehensive documentation for database designs, scripts, configurations, and procedures.
- Collaboration: Work closely with application development teams, system administrators, and other stakeholders to ensure seamless integration and optimal performance of SQL Server databases.
- Staying Current: Continuously learn and adopt new SQL Server features, best practices, and industry trends.
Qualifications:
- Proven experience as a Microsoft SQL Server Expert or similar role.
- Deep and thorough understanding of Microsoft SQL Server architecture, internals, and best practices.
- Extensive experience in performance tuning and optimization of SQL Server databases.
- Mastery of T-SQL scripting for complex data manipulation, stored procedures, functions, and triggers.
- Solid experience in database design, normalization, and data modeling principles.
- Familiarity with ETL concepts and tools (e.g., SSIS).
- Experience implementing and managing high availability and disaster recovery solutions for SQL Server.
- Strong understanding of SQL Server security principles and implementation.
- Proficiency in using SQL Server monitoring and diagnostic tools.
- Excellent analytical, problem-solving, and troubleshooting skills.
- Strong organizational and time management skills with the ability to manage multiple tasks.
- Excellent verbal and written communication skills.
- Ability to work independently and collaboratively within a team environment.
Nice to have: If they know additional Databases that would be a plus.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.