As a member of the Software Development team, the MS SQL Database & BI Developer is responsible for the development of Business Intelligence components (ETL / SSIS packages and SSRS reports), stored procedures, triggers, views, and functions to support enhancements to critical SQL based business applications as well as all SQL Server maintenance, support, and upgrades (including monitoring, logging, performance tuning, capacity planning, migration, DR/BCP, PCI database compliance, and regulatory and security compliances). This position is best suited to someone that is self-motivated with regard to analysis and troubleshooting and able to remediate data integrity issues with minimal oversight.
Supports of all aspects of the software and database development lifecycle including: requirements definition, design, development, test, deployment, documentation, and support
Writing data warehousing/business intelligence queries
Building and maintaining multiple database environments, building and maintaining DTS/SSIS packages and SSRS Reports, supporting IRS and state compliance audits, and numerous other activities that require access to the company's data.
Participate in defining short-term and long-term database services direction and vision and will work with business process owners and IT team to deliver critical enterprise reporting services.
Participate in generating system documentation such as data dictionary, Business Intelligence (BI) reporting, policies and procedures.
Responsible for management and resolution of all database issues in a timely manner and share 24×7 support availability for critical systems, root-cause analysis and preventative maintenance.
Monitor, resolve and communicate status of outstanding defects/change requests.
Assist in the transition of system updates into the production environment.
Develop and maintain documented processes and procedures to ensure consistent delivery of assigned tasks and responsibilities.
Develop documentation and structured specifications.
Develop task estimates, report project status, issues, and recommended resolutions to support project plans.
Analyze and help define short-term and long-term services direction while working with business process owners to deliver critical enterprise reporting services.
Works with Software Developers to address issues of data migration and integrity (validation, clean-up, mapping, and data modeling).
Any other duties as assigned by management.
5 years relational database administration skills (including add/delete/modify, security, SQL schema, select statements, performance and system tuning, policy administration and enforcements.
Creation, enhancement, and maintenance of SSIS packages.
At least 5 years' of complex SQL query and stored procedure experience in support of both daily business operations as well as ETL and reporting operations.
Experience writing data warehousing/business intelligence queries.
Strong knowledge of SQL server 2012, 2016 and above.
Must have experience in a complex high-availability environment, VMware, clustering and replication.
Strong analytical skills.
Excellent communication skills and team attitude with ability to interact with a software development staff, technical support personnel, and management team.
Ability to utilize tools and reports to troubleshoot causes of issues.
Ability to prioritize and manage multiple tasks and assignments.
Effective translation of issue resolution and requirements into technical specifications.
Possess excellent written and oral communication skills.
Make sound, independent judgments.
Strong understanding of database administration in a Microsoft SQL Clustered Server environment.
Proficient with creating and deploying reports with SSRS.
Demonstrated proficiency in Transact SQL .
Experience with SAN storage solutions.
Experience in working with database and data transmission processes (FTP, API's, EDI, etc.)
Associate degree in Computer Science or related field and a minimum of 5+ years of equivalent work-related experience, in SQL database administration
Significant, demonstrated technical skills in developing and troubleshooting SQL databases
Bachelor's degree in Computer Science or related field and a minimum of 5+ years of equivalent work-related experience, in SQL database administration
Applicants for this opportunity must have an unrestricted right to work in the United States.
[Persons in H-l, L-l, and OPT EAD status do not have unrestricted right to work.]