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.