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 / or4 - 6 Years experience with T-SQL data warehousing with a focus on integration and automation; or combination of education and experienceMicrosoft SQL Server 2008 R2, 2012, 2014, 2016Microsoft SQL Server Management StudioMicrosoft 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, optimizationUnderstand the impact of data quality and integrity on the Business with the ability to identify process improvements which enhance business performanceAbility to manage multiple projects, activities and tasks simultaneouslyAbility to work off-hours as requiredMust have the personal communication and presentation skills that will represent the company professionally to outside agencies, financial institutions, business partners, employees and customersCore Competencies :
Project management and communication skillsKnowledge of database theory and designExpertise with Microsoft RDBMSFluency writing advanced T-SQL statementUnderstands technical and functional design requirementsPrioritizes multiple tasks effectivelyIf you ve got the skills to succeed and the motivation to make it happen, we look forward to hearing from you.Skills Required
Sql, Performance Tuning, Backup Recovery, Database Security, Data Modeling