Senior Database Administrator

Since opening our first self-storage facility in 1972, Public Storage has grown to become the largest owner and operator of self-storage facilities in the world. With thousands of locations across the U.S. and Europe, and more than 170 million net rentable square feet of real estate, we're also one of the largest landlords.

We've been recognized as A Great Place to Work by the Great Place to Work Institute. And, our employees have also voted us as having Best Career Growth, ranked us in the Top 5% for Work Culture, and in the Top 10% for Diversity and Inclusion

We're a member of the S&P 500 and FT Global 500. Our common and preferred stocks trade on the New York Stock Exchange.

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