WaveCreste is looking to hire a Senior SQL Database Administrator with Advanced SQL capable of performing both production and developer DBA skills. This position is responsible for monitoring daily jobs via SQL Agent, 2008 R2 SQL database performance, security and maintenance for two servers (DEV and PROD).
WaveCreste is an IT professional services, consulting and outsourcing company helping clients leverage technology to improve business results. WaveCreste has been delivering value for clients since 2002. Our clientele spans Fortune 100 corporations and emerging companies. WaveCreste employs more than 300 systems professionals nationwide.
Responsible for daily processes, monitoring daily jobs, fixing daily processes/jobs that fail.
Create new data flow processes (SSIS) and update existing data flow processes (SSIS).
SSIS Package maintenance and improvements
Database maintenance and SQL performance
Advanced SQL Script writing, setting up database security, adding new users, and creating database roles and groups
Create custom or edit existing SQL Stored Procedures
Ability to create and modify SSRS reports
Document database processes, SP, SQL Scripts, SSIS and SSRS.
Prefer strong communication skills with non-technical users and technical user
The ability to gather business requirements and create documentation
BI Tool experience is a plus (Example: TeraData, SSAS, MDX, ASP.net, and multi-dimensional cubes)
Ability to “own” your job requirements, meet deadlines, take initiative, adhere to standards but also offer creative solutions, and work independently
In-depth knowledge of Microsoft 2008 R2 SQL server and Microsoft Shared Services including SSIS and SSRS.
Business Intelligence (ETL): MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), MDX
Ability to write and update stored procedures
Experience with/knowledge of data warehousing and/or data mart solutions
Microsoft SQL Server /2008 R2 , SSIS, SSRS, SSAS, ASP.Net, T-SQL, TeraData, Sterling/IBM ConnectDirect, Visual Basic
At WaveCreste, our actions and decisions are guided by our corporate values. Incumbent is expected to subscribe to and model values of Client Centricity, Stewardship, Excellence, Innovation, and Respect for the Individual.
WaveCreste - 16 months ago