Data Systems Engineer
The primary responsibilities for the Software Engineer position include development, administration, and troubleshooting of databases and associated environments in support of the Data Integration, Data Analytics, and Reporting/BI processes. This person is ultimately responsible for database design and data flow of new projects as well as ensuring compliance to Target Data data standards and best practices. This position is responsible for performing assigned tasks in the areas of database modeling, performance monitoring, data integration, capacity planning, and database performance tuning. The position will provide operational support and systems administration for development, test and production environments. This position is also expected to be a key contributor in development and maintenance of database administration procedures and operations and collaborate with other members of the Technology Team. Overall the person in this position is expected to demonstrate proficiency in database design, SQL programming, Shell scripting, Ruby on Rails, troubleshooting, teamwork, leadership, and customer service.
Responsibilities
- Work closely with the Infrastructure/Operations, Analysts, Client Services and other colleagues as needed to help troubleshoot and maintain production database environments and to resolve production issues.
- Proactively work on identifying and addressing system performance and capacity issues
- Work collaboratively with Technical Architects, Business/Data Analysts, and Project Managers to gather requirements and technical specifications
- Work independently and proactively in a rapidly changing team environment
- Assist the Technology Team in the development of full life cycle documentation and documents all activities
- Takes ownership of assigned responsibilities and follows through to effective solution
- Contribute to the development of technical design and development decisions
- Develop and implement new web-based applications and databases as needed
- Contributes to system development and deployment activities to ensure that data base systems management concerns are addressed
- Provides input to strategic IT goals, objectives, tools, methodologies, and infrastructure
- Evaluate new database technologies and data integration mechanisms
- Communicate complex technical information in a timely, concise and coherent manner.
- Maintain an in depth understanding of industry trends and evolving technology.
Education/ Experience:
Bachelor of Science in Computer Science or equivalent preferred with some progressively responsible technology experience. Professional training in scalable database technologies desired combined with experience in the analysis, design, and development of mission-critical data systems.
Related Skills & Other Requirements:
- 2 years of experience in the design and development of enterprise relational database management systems
- Understands basic underlying systems architecture, infrastructure and administration
- Experience with data warehousing and business intelligence environments
- Proficiency with SQL/PLSQL
- Experience coding with Java, Ruby on Rails, Python
- Experience identifying and addressing data base and environmental performance bottlenecks
- Experience with developing Cloud based (AWS) databases and migrating on-premise databases to Cloud based databases
- Experience setting up and developing applications with NoSQL databases (Hadoop, HBase, Hive, etc.) is preferred
- Excellent communication and interpersonal relationship skills, working in a distributed, remote team environment and supporting multiple, concurrent projects