Saxon Global
BI/SQL Developer
Saxon Global, Chesterfield, Missouri, United States, 63005
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
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