Database Administrator Specialist – Plano, TX & McLean, VA

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.