We are seeking a SQL Developer to join our international banking company based in Prague. As a SQL Developer, you will be responsible for designing, developing, and maintaining our SQL databases and ETL processes. The ideal candidate will have experience with T-SQL, ETL tools, SSIS, and AWS.
Responsibilities:
- Design and develop complex SQL queries, stored procedures, and triggers using T-SQL
- Design, develop, and maintain ETL processes using tools such as SSIS
- Perform database tuning and optimization to improve query performance
- Troubleshoot and resolve database issues
- Develop and maintain database documentation, including data dictionaries, standards, and procedures
- Collaborate with other developers and stakeholders to ensure database solutions are scalable, maintainable, and efficient
- Monitor and maintain database backups and disaster recovery procedures
- Participate in code reviews and contribute to the development of best practices
- Experience with T-SQL and SQL Server
- Experience with ETL tools, preferably SSIS
- Knowledge of AWS, including database services such as RDS and Redshift
- Understanding of database design principles and best practices
- Familiarity with database backup and recovery procedures
- Experience with version control systems, such as Git
- Excellent problem-solving and analytical skills
- Strong communication and interpersonal skills
- Bachelor's degree in Computer Science, Information Systems or a related field
Nice to have:
- Experience with DevOps methodologies and tools
- Familiarity with Shell scripting and/or Python
Praha