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 24 x 7, client-facing production environment. Liaising with IT teams and business units to interpret business cases to design, install and ... more details
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
Compensation
Base Pay Range: $132000 - $165000
Compensation may vary outside of this range depending on a number of factors, including a candidate’s qualifications, skills, competencies and experience, and location. Base pay is one part of our total awards approach to compensation which is provided to compensate and recognize employees for their work, and this role may be eligible for additional discretionary bonuses or incentives.
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 located in west Glendale, near Interstate 5 and Western, just south of downtown Burbank
Public Storage is an equal opportunity employer and embraces diversity. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or any other protected status. All qualified candidates are encouraged to apply.
Job Abstracts is an independent Job Search Engine. Job Abstracts is not an agent or representative and is not endorsed, sponsored or affiliated with any employer. Job Abstracts uses proprietary technology to keep the availability and accuracy of its job listings and their details. All trademarks, service marks, logos, domain names, and job descriptions are the property of their respective holder. Job Abstracts does not have its members apply for a job on the jobabstracts.com website. Additionally, Job Abstracts may provide a list of third-party job listings that may not be affiliated with any employer. Please make sure you understand and agree to the website's Terms & Conditions and Privacy Policies you are applying on as they may differ from ours and are not in our control.
We would like to take a second to Welcome You to Job Abstracts, the nation’s largest Pure Job Board. With over 3.1 million job listings from 15,000+ Companies & Organizations, we help job searchers find careers that match their interests. As an anonymous user, you have probably discovered how easy our system is to use. However, you have just scratched the surface of what we can offer.
We encourage you to Register so you can use our most powerful features: searching with multiple terms, setting up multiple locations, establishing favorite companies, and accessing your search history. If you find a job you like, you can apply directly for it, and then, keep notes on it. We will also keep a lookout for jobs that match your search terms and email you when we find something you may like.
You can register for free and the system is free to use. If you like our system so far, click on Register and unlock the power required by serious job searchers.
Any time you conduct a search, the system shows you job matches, ranked by their Relevance Score (RS).
The score is calculated by a proprietary algorithm that uses Intelligent Machine Learning.
The Relevance Score tells you how well the job opportunity matches your search term or terms.
When not logged in, the system is limited to one search term. Scores for single term matches are usually lower.
When you register, log in, and set up multiple terms prioritized by importance, the jobs found for you will receive a much higher Relevance Score.