Senior Database Administrator

Public Storage - Glendale, CA

Full-time - Senior

Glendale, CA

1,001-5,000 employees

Real Estate

About the position

The Senior Database Administrator at Public Storage plays a crucial role in ensuring the successful delivery of database services to both the organization and development teams. This position requires direct engagement with Information Technology and Business stakeholders to meet the expectations outlined in the Information Technology Department's Service Level Agreement. The Senior Database Administrator will be responsible for managing a client-facing production environment that operates 24/7, participating in an on-call support rotation to address any urgent database issues that may arise. In this role, the Senior Database Administrator will liaise with IT teams and business units to interpret business cases, leading to the design, installation, and configuration of large and complex OLTP (Online Transaction Processing), OLAP (Online Analytical Processing), and SSRS (SQL Server Reporting Services) environments. The focus will be on ensuring high availability and disaster recovery, utilizing advanced technologies such as Microsoft Clustering and Always On within the Google Cloud Platform. The position also involves providing administrative guidance for maintaining MS SQL Server databases in an enterprise environment, ensuring optimal performance and security. The Senior Database Administrator will be tasked with developing, deploying, and supporting SSIS (SQL Server Integration Services) data flows and packages, as well as managing SQL Server Analysis Services cubes and Reporting Services reports. Documentation of OLTP and OLAP environments will be a key responsibility, along with the installation of upgrades and patches to existing databases. The role requires investigating and resolving performance, data accuracy, and availability issues, as well as developing processes to optimize and maintain database security. Proactive management of database jobs and system activity will be conducted using monitoring tools such as Idera Diagnostic Manager and Data Dog. Additionally, the Senior Database Administrator will create automated processes for repetitive database tasks using Powershell, SSIS, or TSQL, and will manage multiple tasks and projects to ensure that requirements are met. Regular reporting on progress and measurement against goals will be expected, along with direct collaboration with development teams to deploy code changes in accordance with the change management framework.

Responsibilities

• Participate in on-call support rotation for a 24x7, client-facing production environment.
• Liaise with IT teams and business units to interpret business cases for designing, installing, and configuring OLTP, OLAP, and SSRS environments.
• Provide administrative guidance for maintaining MS SQL Server databases in an enterprise environment.
• Develop, deploy, administrate, support, and debug 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.
• Create automated processes for repeating database tasks using Powershell, SSIS, or TSQL.
• Manage multiple tasks and projects to schedule, ensuring requirements are met and reporting on weekly progress to management.
• Work directly with development teams to deploy code changes to staging and production environments.

Requirements

• 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.

Nice-to-haves

• Experience with indexes, index management, and statistics.
• Experience in troubleshooting and resolving database problems.