Sr. SQL DBA

2 months ago

Burbank, United States Teklead Corp Full time
Job DescriptionJob DescriptionREMOTE & 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 OLTP\OLAP 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-On\Microsoft 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.

  • Sr Business Systems Analyst

    2 weeks ago

    Burbank, United States STAND 8 Technology Services Full time

    STAND 8 provides end to end IT solutions to enterprise partners across the United States and with offices in LA, Atlanta, New York, Raleigh, and more.We are seeking a Senior Business Systems Analyst focused on backend Reporting to join our Technology Solutions team in support of our Media & Entertainment client build an incredible application solution built...

  • Sr Business Systems Analyst

    2 weeks ago

    Burbank, United States STAND 8 Technology Services Full time

    STAND 8 provides end to end IT solutions to enterprise partners across the United States and with offices in LA, Atlanta, New York, Raleigh, and more.We are seeking a Senior Business Systems Analyst focused on Application Integrations to join our Technology Solutions team in support of our Media & Entertainment client build an incredible application solution...

  • Sr Business Systems Analyst

    2 weeks ago

    Burbank, United States STAND 8 Technology Services Full time

    STAND 8 provides end to end IT solutions to enterprise partners across the United States and with offices in LA, Atlanta, New York, Raleigh, and more.We are seeking a Senior Business Systems Analyst focused on Application Integrations to join our Technology Solutions team in support of our Media & Entertainment client build an incredible application solution...