The SQL Database & Integration Developer is responsible for designing, developing, maintaining, and optimizing Microsoft SQL Server databases, creating business reports using SQL Server Reporting Services (SSRS), developing ETL processes using SQL Server Integration Services (SSIS), and supporting data integration between internal systems and third-party platforms.

The role requires strong expertise in SQL development, database performance tuning, reporting solutions, and secure integration within a fintech environment where data integrity, scalability, and availability are critical.

Key Responsibilities

Database Administration & Development

• Design, develop, and maintain Microsoft SQL Server databases.
• Create and optimize database objects including tables, views, stored procedures, functions, and triggers.
• Optimize SQL queries to improve database performance.
• Monitor database health and performance.
• Implement indexing and query optimization strategies.
• Support database backup, recovery, and disaster recovery planning.
• Maintain database security, user permissions, and access controls.
• Ensure data integrity and consistency across all databases.

Reporting & Business Intelligence (SSRS)

• Develop operational and management reports using SQL Server Reporting Services (SSRS).
• Design dashboards and scheduled reports for different business units.
• Automate recurring reports and data exports.
• Maintain existing reports and continuously improve report performance.
• Work closely with business stakeholders to understand reporting requirements.
• Ensure reporting accuracy and consistency.

Data Integration (SSIS)

• Design and develop ETL packages using SQL Server Integration Services (SSIS).
• Integrate data between internal applications and third-party systems.
• Automate data migration and synchronization processes.
• Monitor integration jobs and resolve failures.
• Optimize ETL performance and reliability.
• Ensure data quality during import and export processes.

 

Database Performance & Optimization

• Analyze database performance bottlenecks.
• Tune SQL queries and stored procedures.
• Monitor execution plans and indexing strategies.
• Improve database scalability and reliability.
• Perform database maintenance activities.

System Integration

• Support API-based integrations where database interaction is required.
• Coordinate with software developers during system integration projects.
• Assist in integrating payment systems, financial applications, and operational platforms.
• Maintain data consistency across multiple systems.

Documentation & Compliance

• Prepare technical documentation for databases, reports, and integrations.
• Document database structures and ETL workflows.
• Maintain version control for SQL scripts.
• Follow Paymera security and compliance standards.
• Ensure proper documentation for audit purposes.

Collaboration

• Work closely with Development, Operations, Finance, Risk, and Business teams.
• Support troubleshooting of database-related production issues.
• Participate in system enhancement projects.
• Provide technical recommendations for database improvements.