Database Administrator - PostgreSQL
Publication date:
11 July 2024Workload:
100%Contract type:
Unlimited employment- Place of work:Gland
Database Administrator - PostgreSQL
Database Administrator - PostgreSQL
- Full-time
- Managerial role: No
Company Description
Building the bank of tomorrow takes more than skills.
It means combining our differences to imagine, discuss, code, develop, test, learn… and celebrate every step together. Share our vibes? Join Swissquote to unleash your potential.
We are the Swiss Leader in Online Banking and we provide trading, investing and banking services to +500’000 clients, through our performant and secured digital platforms.
Our +1000 employees work in a flexible way, without dress code and in multicultural teams.
By having a huge impact on the industry, they are growing their skills portfolio and boosting their career in a fast-pace environment.
We are all in at Swissquote. As an equal opportunity employer, we welcome candidates from all backgrounds, experiences and perspectives to join our team and contribute to our shared success.
Are you all in? Don’t be shy, apply!
Job Description
As a Database Administrator (DBA) specializing in PostgreSQL, you will be responsible for managing, maintaining, and optimizing our database systems. Experience with Oracle is a plus. You will play a critical role in ensuring data availability, reliability, and security while supporting our Agile development methodology. You will work closely with our development and infrastructure teams to deliver high-performance, scalable, and reliable database solutions.
Key Responsibilities:
- Database Management: Manage and administer PostgreSQL and Oracle databases, including installation, configuration, performance tuning, and troubleshooting,
- Data Security: Implement and maintain robust security measures to protect sensitive data, ensuring compliance with industry standards and regulations,
- Database Monitoring: Monitor database health, performance, and availability. Proactively address issues and implement scaling strategies as needed,
- Backup and Recovery: Develop and maintain backup and recovery plans, ensuring data is consistently backed up and recoverable in case of data loss or system failure,
- Database Optimization: Identify and implement performance optimization strategies, including query optimization, indexing, and system tuning for PostgreSQL and Oracle,
- Scalability: Collaborate with the development team to plan for database scalability as the application grows,
- Automation: Automate routine database maintenance tasks to improve efficiency and reduce human error,
- Agile Methodology: Work closely with cross-functional Agile teams to support fast-paced development cycles and maintain a culture of continuous improvement,
- Documentation: Maintain comprehensive documentation of database systems, configurations, and processes.
Qualifications
- Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience),
- Minimum of 5 years of experience as a Database Administrator with a strong focus on PostgreSQL,
- Experience with Oracle database administration is a plus,
- Proficiency in database design, installation, and maintenance,
- In-depth knowledge of SQL and database query optimization,
- Experience working in Agile or Scrum development methodologies,
- Strong problem-solving and communication skills,
- Knowledge of cloud-based database services is a plus,
- PostgreSQL and Oracle certifications are a plus.
Additional Information
SQ3