The Database Administrator supports configuration, design, migration, performance monitoring, security, troubleshooting, backup, and data recovery of the SQL data warehouse. The role works closely with other IT functions to support mission critical business functions driven by data processing. This position requires a fundamental understanding of the business/operational requirements to determine successful data storage/warehousing, performance, and backup strategies. The successful candidate will be proficient with all aspects of data warehousing, advanced analytics, and process automation and has responsibility for a range of exciting and varied projects.
Job Requirements:
Responsible for all database servers in production, test, and development environments. Allocating system storage and planning future storage requirements for the database system Modifying the database structure, as necessary, from information given by application developers Monitoring and optimizing the performance of the data warehouse Planning for backup and recovery of database information Managing and monitoring data replication Backing up and restoring databases Writing data specifications for import/export operations Scheduling and support of data integrations Applies knowledge of industry trends and developments to improve data processing Effectively communicates and interacts with project teams using SharePoint team site Contacts database vendor for technical support Other duties as assigned
Qualifications:
4-year degree in data related IT field; and/or 4 - 6 Years experience with T-SQL data warehousing with a focus on integration and automation; or combination of education and experience Microsoft SQL Server 2008 R2, 2012, 2014, 2016 Microsoft SQL Server Management Studio Microsoft SQL Server Reporting Services (SSRS) Microsoft SQL Server Integration Services (SSIS) Microsoft SQL Server Analysis Services (SSAS) SQL Server development including stored procedures, creating queries, optimization Understand the impact of data quality and integrity on the Business with the ability to identify process improvements which enhance business performance Ability to manage multiple projects, activities and tasks simultaneously Ability to work off-hours as required Must have the personal communication and presentation skills that will represent the company professionally to outside agencies, financial institutions, business partners, employees and customers
Core Competencies:
Project management and communication skills Knowledge of database theory and design Expertise with Microsoft RDBMS Fluency writing advanced T-SQL statement Understands technical and functional design requirements Prioritizes multiple tasks effectively
If you ve got the skills to succeed and the motivation to make it happen, we look forward to hearing from you.