Bridgesoft - Database Lead - SSIS/SQL Server

Description :

Technical Deep Dive Opportunities :

- SSIS Project Modernization: The role presents an opportunity to migrate or modernize existing SSIS packages.

- This could involve refactoring legacy packages for improved performance, error handling, and maintainability.

- Investigating newer SSIS features available in SQL Server 2022+ (e.g., improved control flow tasks, enhanced logging) would be a key component.

- Further, the encryption/archiving requirement suggests a need for expertise in security best practices within SSIS, potentially involving sensitive data handling procedures and compliance regulations.

- SQL Server Performance Tuning Focus: The role emphasizes database tuning and performance, suggesting a need for in-depth SQL Server internals knowledge.

- This includes query plan analysis, index optimization, statistics management, and understanding resource utilization.

The senior developer could implement strategies such as :

- Query Store analysis: Using Query Store to identify and fix regression issues after code changes or server upgrades.

- Extended Events: Leveraging Extended Events to capture detailed performance data for troubleshooting bottlenecks.

- In-Memory OLTP: Exploring the potential of In-Memory OLTP for performance-critical workloads.

- Advanced T-SQL Development: Beyond basic stored procedure writing, the role requires proficiency in advanced T-SQL concepts.

- This includes utilizing indexed views, user-defined functions (UDFs), triggers, cursors (though their use should be minimized in favor of set-based operations), XML handling, and distributed transactions.

- Understanding transaction isolation levels and concurrency control mechanisms in SQL Server is crucial.

- Specifically, the description calls for SQL Server 2017 or higher, meaning utilizing newer features of T-SQL.

Operational and Support Responsibilities :

- Root Cause Analysis and Problem Prevention: The job description emphasizes identifying root causes and proposing solutions to prevent recurring problems.

- This requires a strong analytical skillset and a systematic approach to troubleshooting.

- Implementing monitoring and alerting systems to proactively detect potential issues is essential.

- Developing a knowledge base of common problems and their solutions would also be beneficial.

- Database Topology and Documentation: Documenting database topology, architecture, processes, and procedures is a critical responsibility.

- This documentation should be comprehensive, up-to-date, and easily accessible to other team members.

- This also includes maintaining data dictionaries and data lineage documentation.

- The documentation should be kept in a centralized repository, following a consistent format.

- Operational Support and Problem Resolution: Providing operational support and resolving recurring problems requires strong communication and collaboration skills.

- This includes working with other members of the data team to understand their needs and providing timely and effective solutions.

- The ability to prioritize tasks and manage multiple competing demands is also essential.

- Capacity Planning and Resource Management: Assisting with capacity planning and resource expansion requires an understanding of database performance metrics and resource utilization.

- This involves analysing data to identify trends and predicting future resource needs.

- The senior developer may also be responsible for recommending hardware upgrades or software optimizations.

Collaboration and Communication :

- Working with Project Managers: Collaborating with project managers to understand business needs and opportunities for process improvement is crucial.

- This requires the ability to translate business requirements into technical specifications and to communicate technical concepts to non-technical audiences.

- Teamwork and Knowledge Sharing: Establishing and maintaining effective working relationships within the team is essential.

- This includes sharing knowledge and expertise with other team members, mentoring junior developers, and participating in code reviews.

Years of Exp :

- 05-09 Years.