What you'll do:
- Design and create SQL databases based on business requirements.
- Develop and optimize SQL queries for data retrieval, manipulation, and reporting.
- Create and maintain database schemas, tables, views, and stored procedures.
- Develop data integration processes to import and export data from various sources and formats.
- Collaborate with ETL (Extract, Transform, Load) developers to ensure smooth data flow.
- Monitor and optimize database performance by identifying and resolving bottlenecks.
- Implement indexing and caching strategies to improve query speed.
- Implement and maintain database security measures to protect sensitive data.
- Create and maintain documentation related to database design, schemas, and processes.
- Keep documentation up-to-date to facilitate knowledge sharing.
- Collaborate with software developers, data analysts, and business stakeholders to understand data requirements and support application development.
- Work with DBAs (Database Administrators) to ensure database health and stability.
- Investigate and resolve database-related issues and errors.
- Provide technical support to end-users and troubleshoot data-related problems.
Skills needed for success:
- 4+ years of proven experience as a MSSQL/DB2 Developer or in a similar role.
- Strong proficiency in SQL and database management systems (e.g., Microsoft SQL Server and DB2).
- Knowledge of database design principles, normalization, and indexing.
- Experience with ETL processes and tools
- Working Knowledge of data warehousing concepts.
- Sound understanding of software development life cycle and successful management of multiple full lifecycle projects is required, Agile and CI/CD experience is highly preferred.
- Demonstrate broad knowledge of multiple business areas, and industry to identify and communicate how IT solutions can support the achievement of short-and long-term business goals
- Negotiation skills, with driving desire and high propensity to learn quickly and develop oneself
- Ability to work with people to proactively identify and evaluate risks associated with business decisions
- Ability to work independently, with little management direction, and within a team environment
- Skilled at asking questions and professionally challenging to uncover important facts and information