Senior Database Administrator

Job Description

The Senior Database Administrator engages directly with Information Technology and Business stakeholders to ensure the on-time and successful delivery of database services to the organization and development team as defined by the Information Technology Department’s Service Level Agreement.

KEY RESPONSIBILITIES

• Participate in on-call support rotation for a 24x7, client-facing production environment.
• Liaising with IT teams and business units to interpret business cases to 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.
30+ days ago