DescriptionDescription – Database DeveloperSince the 1940s Citco has provided specialist financial services to alternative investment funds, investors, multinationals and private clients worldwide. With over 6,500 employees in 45 countries, we pioneer innovative solutions that meet our clients' evolving needs, and deliver exceptional service.Our continuous investment in learning means our people are among the best in the industry. And our corporate social responsibility programs provide meaningful and fulfilling work in the community.A career at Citco isn't just a job – it's an opportunity to excel in an environment that genuinely supports your personal and professional development.ResponsibilitiesAbout the Role:We are seeking an experienced Database Developer with strong expertise in relational database modeling and procedural language development. This position is responsible for designing, implementing, and maintaining mission-critical OLTP systems with a focus on data integrity, performance optimization, and scalability. The role requires deep knowledge of database architecture and transformation processes to support our financial services operations.Duties include Design and implement complex relational database schemas for OLTP systemsDevelop and optimize stored procedures, functions, and triggers using PL/pgSQLCreate and optimize relational databases schemas, tables, indexes, views, and stored proceduresImplement data validation rules and business logic at the database levelDesign and develop database transformation processes for mission-critical systemsOptimize database performance through query tuning and index strategiesSolid understanding of SQL and Data ModellingImplement database security measures and access control mechanismsDevelop and maintain documentation for database structures and proceduresCollaborate with application developers to ensure proper database integrationCollaborate with cross-functional teams of business analysts, business users and IT stakeholders gathering, documenting, analysing and implementing requirementsParticipate in code reviews and maintain coding standardsPerform data migration, transformation, and integration tasks between different database systemsProvide technical guidance on database design and best practicesWork directly with reporting manager to ensure clear and accurate communication of current status, dependencies and estimated delivery timelinesClearly communicate issues, risks and proposed solutions to relevant stakeholdersCoordinate the release process with business groups, operations in compliance with ITIL Change Management disciplineCommunicate detailed descriptions of functionality changes and provide follow up support as requiredSupport QA testingQualificationsEDUCATION, EXPERIENCE & SKILLS:5-7 years of experience in database development and relational modellingStrong expertise SQL, relational databases (Postgres, Oracle and/or SQL Server) and procedural languages (PL/pgSQL, PL/SQL and/or T-SQL) or similar procedural languagesProven experience in designing and implementing database models for OLTP systemsAdvanced knowledge of PostgreSQL or similar RDBMSExperience with database performance tuning and optimizationProficiency in writing complex SQL queries and stored proceduresExperience with version control systems for database changesKnowledge of database security best practicesExperience with Version Control systemsMust have excellent communication skills and be able present diagnostic, troubleshooting steps and conclusions to a varied audience including both business and technical stakeholdersexcellent listening and analytic skillsexcellent oral/written communication skills strong interpersonal and communication skills and ability to deal effectively in a team environmentBachelor's degree in computer science, or similar discipline, or equivalent education and experienceAbility to work independently with or without direction and or supervision, portray professional demeanourAgile and SCRUM methodologiesBanking or Financial systems industry domain experienceGeneralMust have excellent communication skills and be able present diagnostic, troubleshooting steps and conclusions to a varied audience including both business and technical stakeholdersexcellent listening and analytic skillsexcellent oral/written communication skills strong interpersonal and communication skills and ability to deal effectively in a team environmentBachelor's degree in computer science, or similar discipline, or equivalent education and experienceAbility to work independently with or without direction and or supervision, portray professional demeanourAgile and SCRUM methodologiesBanking or Financial systems industry domain experienceAdditional Beneficial Attributes/Skills:Agile and SCRUM methodologiesBanking or Financial systems industry domain experienceThis is a challenging role in a highly visible position that will expose the candidate to mission-critical systems across Citco's business lines. The successful candidate will have the opportunity to work on sophisticated database solutions while ensuring the reliability and performance of our core business systems. Citco offers competitive compensation, vacation, and health insurance benefits in a friendly and fast-paced environment.