Sr. SQL DBA

Replies within 24 hours

REMOTE & ONSITE WORK (Hybrid)

Responsibilities

• Take Part in on-call support rotation for a 24x7, client-facing environment.
• Design, install and configure large and complex OLTP, OLAP, and SSRS environments with high-availability and disaster recovery, utilizing Microsoft Clustering, Always On, SQL native backup, within Google Cloud Platform.
• Provide administrative guidance maintaining MS SQL Server databases in an enterprise environment.
• Experience developing, deploying, administrating, supporting, and debugging SSIS data flows and packages.
• Deploy, maintain, support, and debug SQL Server Analysis Services cubes and Reporting Services reports.
• Develop and maintain OLTPOLAP environment documentation.
• Install upgrades and patches to existing databases.
• Investigate and resolve performance, data accuracy, and availability. issues.
• Develop processes for optimizing and maintaining database security.
• Utilize Idera Diagnostic Manager and Data Dog monitoring tools to proactively manage database jobs and system activity.
• Experience with indexes, index management, and statistics.
• Create automated processes for repeating database tasks with the use of Powershell, SSIS, or TSQL.
• Manage multiple tasks and projects to schedule, ensuring requirements are met. Report on weekly progress and measure against goals/initiatives to management for meeting project objectives.
• Responsible for working directly with development teams to deploy code changes to staging and production environments,as requested through the change management framework

Qualifications

• Bachelor of science in computer science or computer information systems, or Microsoft certification in database administration or comparable experience preferred.
• 10+ years' experience working in a fast-paced enterprise environment with various versions of SQL Server.
• Thorough Database administration knowledge working within the Google Cloud Platform.
• Excellent understanding of RDBM (Relationship Database Management).
• Knowledge of ITIL best practices, regarding Change Management, Incident Management and Problem Management.
• Knowledge of best practices and software development process (full SDLC).
• Advanced knowledge of database security, backup and recovery, and performance monitoring standards with VLDB's.
• Strong command of TSQL and SQL server tools.
• PowerShell shell scripting skills.
• Experience using SSRS, SSAS, and SSIS packages required.
• Working knowledge of SQL Litespeed for database backups a plus.
• Experience in troubleshooting and resolving database problems.
• Proficiency in Performance Tuning and Optimization (PTO) using either native (SQL Profiler), Idera Diagnostic Manager, and Data Dog.
• Deep knowledge of High Availability and Disaster Recovery models for MSSQL Server (Always-OnMicrosoft Cluster).
• Experience working with Windows server environments.
• Experience supporting a multi-database environment.
• Ability to work independently with little or no supervision.
• Outstanding analytical and problem-solving skills.
• Strong written and verbal communication skills.
• Ability to effectively prioritize and escalate issues.
• Demonstrated ability to troubleshoot software/database issues independently.
• Ability to work extended hours when needed.

Flexible work from home options available.

Compensation: $60.00 - $75.00 per hour

History

Teklead Corporation is a national Information Technology Consulting company, successfully representing a wide spectrum of clients and their IT needs since 1990. Teklead is dedicated to providing the highest quality software development/support and IT staffing services, both onsite and offshore, using top-notch IT professionals. Having a deep understanding of the IT industry and taking advantage of our extensive network, we've been able to distinguish ourselves by meeting our client's needs and challenges. Our success and reputation are supported by long-lasting client relationships, exceptional customer service and commitment to providing excellent IT solutions.

With more than 25 years of experience, Teklead has expanded to reach a global-level and now has offices in North America (Los Angeles, CA, New York, NY, Dallas, TX), Europe (London, UK) and the Asia Pacific (Banglore, Karnataka, India). As demand for IT - and more, specifically, high quality and cost effective ADM services - increases, Teklead plans to meet that demand. We are constantly looking to expand our operation through increased screening, hiring and IT training, in addition to expanding our delivery centers in North America and the Asia Pacific regions.