The Senior Database Developer is responsible for analyzing, developing SSIS projects, custom reports, and working closely with the team on any SQL issues.
Requirements
- Develop SSIS projects to handle ETL, transmission, encryption, and archiving of files received and generated
- Design, develop, and maintain database tables, stored procedures, and supporting objects
- Build and support operational reports for company and clients
- Work with data team to provide operational support, resolve recurring problems
- Document database topology, architecture, processes and procedures
- Develop SQL queries and support ad hoc requests for data
- Assist with capacity planning and resource expansion through data aggregation and analysis
- Work with project managers to ensure that reports and metrics identify business needs and opportunities for process improvement
- Identify inefficiencies in the database platform and provide solutions to the management
- Use problem-solving skills to assist in resolution of business and technical problems
- Identify root causes for problems and propose solutions to prevent recurring