Company Description

Public Storage is recognized as one of America’s Best Large Employers in 2022 by Forbes and our employees have also voted us as a Great Place to Work in 2022 and 2023 , having Best Career Growth , ranked us in the Top 5% for Work Culture , and in the Top 10% for Diversity and Inclusion.

With more than 3,200 locations nationwide, Public Storage is the leader in the self-storage industry, and given our number of tenants, we may very well be the world's largest landlord. We've experienced unprecedented growth over the past four decades, and it's in no small part due to the dedicated team that has helped us become an S&P 500 industry leader, the country's largest real estate investment trust (REIT), and the most recognizable name in self-storage.

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.

Additional Information

Workplace

• One of our values pillars is to work as OneTeam and we believe that there is no replacement for in-person collaboration but understand the value of some flexibility. Public Storage teammates are expected to work in the office five days each week with the option to take up to three flexible remote days per month.

• Our office is based in Plano, east of I75 near E. Park Blvd, just North of Historic Downtown Plano.

All your information will be kept confidential according to EEO guidelines.

#APC1234

We are united under one common goal – creating a diverse and inclusive environment where all employees feel valued, included, and excited to be part of a best-in-class team. With over 5,000 team members from all different races, backgrounds, and life experiences, we celebrate inclusion and value the diversity each person brings to Public Storage. We believe our commitment to diversity and inclusion makes us a stronger Company and instills a sense of pride across our teams and the customers we serve.