Description
Description – Database Developer
Since 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.
Responsibilities
About 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 systems
* Develop and optimize stored procedures, functions, and triggers using PL/pgSQL
* Create and optimize relational databases schemas, tables, indexes, views, and stored procedures
* Implement data validation rules and business logic at the database level
* Design and develop database transformation processes for mission-critical systems
* Optimize database performance through query tuning and index strategies
* Solid understanding of SQL and Data Modelling
* Implement database security measures and access control mechanisms
* Develop and maintain documentation for database structures and procedures
* Collaborate with application developers to ensure proper database integration
* Collaborate with cross-functional teams of business analysts, business users and IT stakeholders gathering, documenting, analysing and implementing requirements
* Participate in code reviews and maintain coding standards
* Perform data migration, transformation, and integration tasks between different database systems
* Provide technical guidance on database design and best practices
* Work directly with reporting manager to ensure clear and accurate communication of current status, dependencies and estimated delivery timelines
* Clearly communicate issues, risks and proposed solutions to relevant stakeholders
* Coordinate the release process with business groups, operations in compliance with ITIL Change Management discipline
* Communicate detailed descriptions of functionality changes and provide follow up support as required
* Support QA testing
Qualifications
EDUCATION, EXPERIENCE & SKILLS:
* 5-7 years of experience in database development and relational modelling
* Strong expertise SQL, relational databases (Postgres, Oracle and/or SQL Server) and procedural languages (PL/pgSQL, PL/SQL and/or T-SQL) or similar procedural languages
* Proven experience in designing and implementing database models for OLTP systems
* Advanced knowledge of PostgreSQL or similar RDBMS
* Experience with database performance tuning and optimization
* Proficiency in writing complex SQL queries and stored procedures
* Experience with version control systems for database changes
* Knowledge of database security best practices
* Experience with Version Control systems
* Must have excellent communication skills and be able present diagnostic, troubleshooting steps and conclusions to a varied audience including both business and technical stakeholders
* excellent listening and analytic skills
* excellent oral/written communication skills
* strong interpersonal and communication skills and ability to deal effectively in a team environment
* Bachelor's degree in computer science, or similar discipline, or equivalent education and experience
* Ability to work independently with or without direction and or supervision, portray professional demeanour
* Agile and SCRUM methodologies
* Banking or Financial systems industry domain experience
General
* Must have excellent communication skills and be able present diagnostic, troubleshooting steps and conclusions to a varied audience including both business and technical stakeholders
* excellent listening and analytic skills
* excellent oral/written communication skills
* strong interpersonal and communication skills and ability to deal effectively in a team environment
* Bachelor's degree in computer science, or similar discipline, or equivalent education and experience
* Ability to work independently with or without direction and or supervision, portray professional demeanour
* Agile and SCRUM methodologies
* Banking or Financial systems industry domain experience
Additional Beneficial Attributes/Skills:
* Agile and SCRUM methodologies
* Banking or Financial systems industry domain experience
This 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.