Establishes, provides oversight, and insures optimum performance, reliability, recoverability, security and stability across all database environments.
Responsible for the design, development, installation, configuration, upgrade, administration, monitoring, security, and maintenance of on-premises and cloud database environments. Identifies and mitigates risk to eliminate or minimize impact on the organization. Provides continuous improvement analysis and action.
Develops rules and guidelines for the development of SQL objects. Optimizes indexes and tables. Creates and maintains database dictionaries and schema documentation. Designs and deploys data table structures, triggers, functions, stored procedures and views. Creates queries and reports. Fulfills data requests. Resolves database access and performance issues.
Participates in project team meetings with business analysts, QA and development staff to determine requirements for database design. Determines procedural changes and/or modifications to the database environments. Provides system integration assistance through database design. Works with the Infrastructure team on database issues that involve network, server, and cloud environment. Ensures that prompt and proactive communication occurs to the appropriate internal and external resources regarding the database environments.
Develops database security guidelines. Establishes appropriate database access control levels. Enforces adherence of database security standards and guidelines from development teams, operational staff and end-users. Performs audits.
Develops and integrates replication, archiving, log shipping, high availability, and backup and recovery strategies. Accountable for the IT Disaster Recovery database processes and procedures. Participates in Disaster Recovery testing.
Installs, upgrades and maintains database server and application tools that support the database environment. Evaluates and makes recommendations of new database products in accordance with the needs of the business.
Performs other duties as assigned.
Bachelor's degree in computer science/information systems or applicable job experience.
Minimum seven years of progressive information technology experience.
Minimum five years on-premises database administration and architecture experience.
Minimum two years cloud database administration and architecture experience.
Ability to work in a team environment. Excellent written and oral communication skills. Excellent problem solving skills. Understanding of application development lifecycle and formal methodologies. Understanding of process engineering. Understanding of project management concepts.
Technical expertise must include: Microsoft SQL Server 2008/2012/2014/2016/2017+; Microsoft Azure SQL Database/Managed Instance; SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS); Microsoft Windows Server 2008/2012/2016/2019+; Microsoft Office.
The following are preferred but not required: Azure Synapse Analytics, Azure Data Lake Storage, Azure Data Factory, Azure Stream Analytics, Azure Databricks, Azure Blob Storage, Azure SQL Server Backup, .NET Framework, Visual Studio, SQL Server Data Tools (SSDT), C#, VMWare; Microsoft 365, SharePoint.