SQL Server/SSIS Database Developer

Responsible for supporting the development, implementation and ongoing day-to-day administration of SQL databases. Will also manage database applications and reports, support developers and help optimize / tune database queries. Collaborate with database Operations (DBAs) to understand database structural requirements by analyzing client operations, applications, programming and reviewing objectives with stakeholders. Net where applicable. Maintains database performance by identifying and resolving production and application development problems; Install, upgrade, and maintain multiple Microsoft SQL Servers in large scale standalone and clustered environments, replication, and database mirroring. SQL Versions 2005-2012.Develops database solutions by designing proposed system, defining database physical structure and functional capabilities, security, back-up, and recovery specifications. Partner with Database Operations (DBAs) to monitor and maintain database performance, helping identify issues and working together on resolution. Work with (DBAs) on installation, upgrades, and maintenance of SQL Server environments by providing application specific input and testing support. Provide support to the development staff optimizing stored procedures and Transact-SQL.Responsible for making improvement recommendations to the Manager of Database Systems concerning changes in business process, internal department process, software development tools. Assist in developing database-related solutions by contributing to design discussions around physical structures, functional apabilities, and intergration needs.maintaining personal networks; Experience using and responding to events from SQL monitoring software such as Confio Ignite and Microsoft Systems center. Knowledgeable in Application Lifecycle Management. Test to Production deployment. Provide support to the development staff optimizing stored procedures and Transact-SQL.Deliver excellent service through actively learning the companies business, responding to the needs of the internal customer, and following through on commitments. Other projects and duties as assigned. Bachelor's Degree in Computer Science/Engineering or related field of study; and 3-5 years relevant experience with MS SQL Server in a DBA or equivalent role – including extensive experience in T-SQL, SQL replication, ADO, and coding triggers and stored procedures. Previous experience working in a large financial and accounting environment. Previous experience in coding and supporting. NET desirable. Current technical expertise in Microsoft SSRS & SSIS.Microsoft Dynamics, Microsoft CRM, and Microsoft Sharepoint experience preferred. Oracle OBIEE and Hyperion Essbase experience preferred. Develops company reporting and dashboards using Microsoft standard tools such as PowerBI and SQL Server Reporting Services Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Visual ability correctable to 20/20.Ability to respond verbally in an understandable, professional manner in person and over the telephone. Manual dexterity to input data into the computer and the calculator and operate the equipment listed above. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Office/ Cubicle workspace.