Administrateur BDD PostgreSQL et SQL Server
Blue Soft · Paris, Île-de-France, France
- On site
- Full-time
- €65,000 / year
- Paris, Île-de-France, France
Job highlights
- Manage PostgreSQL and SQL Server databases.
- Perform version upgrades and patch management.
- Ensure high availability and data recovery.
- Automate operational tasks with Ansible/Python.
- Collaborate with clients on infrastructure projects.
About the role
About Blue Soft
We believe in the strength of the current and its ability to carry everyone, while respecting differences. This is how the Blue Soft group was built. The blue current symbolizes our determined desire to build an ambitious and collective company with our employees. Our blue talents unite to navigate together and live an experience that is both individual and shared, where commitment, excellence, and cohesion are at the center. So that we can achieve ourselves professionally and personally, the blue current is fluid, adapts, draws multiple paths that all go in the same direction, and takes the entire crew on the same boat.
At Cloud Infrastructure, a business unit of the Blue Soft group, we manage and transform our clients' infrastructures (Cloud & OnPrem), from design to management, including architecture, engineering, implementation, documentation, operational maintenance, and exploitation. Our network allows us to work directly and exclusively with our clients. As a long-standing specialist in infrastructures and its various professions in France, we now also support our clients on new cloud & automation issues driven by DevOps culture. Our talents are System Experts & Architects (Unix/Linux/Windows), Storage & Backup, DevOps, Cloud Experts, DBAs, Project Managers, etc.
Job Summary
For one of our major clients, we are looking for a PostgreSQL and SQL Server Database Administrator!
Your Missions as a Level 3 DBA:
- PostgreSQL Database Maintenance in Operational Condition (MCO): Versions 9.x to 15.x. This includes version upgrades, patch management, high availability setup and management, incident management, backup and restore troubleshooting, change task execution, backlog and priority management, performance optimization, and operational task automation/industrialization using Ansible and Python scripting. You will also be expected to proactively suggest improvements for supervision, configuration, and daily operations.
- SQL Server Database Maintenance in Operational Condition (MCO): Versions 2016 to 2022. Similar responsibilities to PostgreSQL MCO, including version upgrades, patch management, high availability setup and management, incident management, backup and restore troubleshooting, change task execution, backlog and priority management, performance optimization, and operational task automation/industrialization using Ansible and Python scripting. You will also be expected to proactively suggest improvements for supervision, configuration, and daily operations.
- Project Work: Ability to work in a project-oriented manner.
- On-Call Duties: Availability for on-call shifts and planned interventions outside of standard working hours (HNO).
- Documentation: Preparation of procedures, action plans, and analysis reports for DBA expertise and/or management. Updating architecture files.
- Industrialization: Focus on Ansible industrialization.
Technical Environment:
- PostgreSQL: 80%
- SQL Server: 20%
Your Profile:
- Minimum of a Bac+2 degree.
- At least 5 years of experience in database administration.
- More than just a diploma, we are looking for experience and personality!
- Written and oral English proficiency.
- Strong ability to write and document.
- Rigorous, methodical, and reactive.
- Autonomous and available.
- Ability to share, capitalize, relay, and communicate knowledge.
Additional Information:
- Location: You will be assigned to Ile de France.
- Start Date: As soon as possible.
- Compensation: Commensurate with experience level.
Benefits:
- Social Benefits: 60% coverage for mutual health insurance, 60% coverage for meal vouchers, 60% coverage for public transport subscriptions.
- Time Off: 5 weeks of annual leave, RTT according to Syntec convention regulations for executives, additional leave days based on seniority (1 day every 5 years).
- Bonuses: Holiday bonus (paid in two installments), co-option bonuses, business development bonuses, profit-sharing agreement with a company savings plan.
- Additional Perks: Year-end gift vouchers, access to the Hello CSE platform, annual contribution to sports or cultural activities, lifetime digital safe, 1% housing assistance for rentals and first-time buyers.
Recruitment Process:
- Phone or Teams interview with our recruitment team to discuss your background and expectations.
- Technical interview with an expert who speaks your language (on-site or remote).
- Candidate review by all stakeholders (HR, Technical Management, and General Management).
- Job offer extension.
Key skills/competency:
- PostgreSQL
- SQL Server
- Database Administration
- High Availability
- Backup and Restore
- Performance Tuning
- Ansible
- Python Scripting
- Incident Management
- Technical Documentation
Skills & topics
- Database Administrator
- PostgreSQL
- SQL Server
- DBA
- Database Management
- High Availability
- Backup and Restore
- Performance Tuning
- Ansible
- Python
- Ile de France
- Blue Soft
- MCO
- Level 3 Support
How to get hired
- Tailor your resume: Highlight your 5+ years of experience in PostgreSQL and SQL Server administration, emphasizing MCO, high availability, and automation skills.
- Showcase your technical skills: Detail your proficiency with Ansible and Python scripting for operational task industrialization.
- Demonstrate project experience: Provide examples of working in project environments and documenting procedures and analysis reports.
- Prepare for technical interviews: Be ready to discuss advanced DBA topics, incident management, and performance optimization for both PostgreSQL and SQL Server.
- Emphasize soft skills: Highlight your English proficiency, communication abilities, and your rigorous, methodical, and reactive approach.
Technical preparation
Master PostgreSQL and SQL Server administration.,Practice Ansible automation and Python scripting.,Prepare for performance tuning scenarios.,Review backup/restore and HA strategies.
Behavioral questions
Describe a complex database incident you resolved.,How do you prioritize your daily tasks?,How do you approach documentation and procedure writing?,Share an example of proactively improving operations.
Frequently asked questions
- What are the primary responsibilities for a PostgreSQL and SQL Server Database Administrator at Blue Soft?
- As a Level 3 DBA at Blue Soft, your primary responsibilities will involve the Maintenance in Operational Condition (MCO) of both PostgreSQL (versions 9.x to 15.x) and SQL Server (versions 2016 to 2022) databases. This includes version upgrades, patch management, high availability setup, incident and backup/restore management, performance optimization, and automation of operational tasks using Ansible and Python scripting. You'll also be involved in project work, documentation, and on-call duties.
- What technical skills are essential for this PostgreSQL and SQL Server DBA role?
- Essential technical skills include deep expertise in PostgreSQL (80% of the role) and SQL Server (20% of the role). You need strong experience with MCO tasks, high availability solutions, backup and restore strategies, and performance tuning. Proficiency in Ansible for automation and Python for scripting is also crucial. Familiarity with incident management and technical documentation is key.
- What kind of projects can I expect to work on as a Database Administrator at Blue Soft?
- You will be assigned to work for one of Blue Soft's major clients, focusing on the management and transformation of their database infrastructures. This can involve ensuring the operational continuity of critical databases, implementing new high-availability solutions, optimizing performance, and automating operational tasks to improve efficiency and reliability within the client's environment.
- Does Blue Soft require specific educational qualifications for the Database Administrator position?
- While a minimum of a Bac+2 degree is preferred, Blue Soft emphasizes experience and personality over specific diplomas. They are looking for candidates with at least 5 years of relevant experience in database administration, particularly with PostgreSQL and SQL Server, and a strong professional attitude.
- What is the recruitment process like for this Database Administrator role at Blue Soft?
- The recruitment process typically involves an initial phone or Teams interview with the recruitment team to discuss your profile and expectations. This is followed by a technical interview with an expert. Your application will then be reviewed by HR, Technical Management, and General Management before a potential job offer is extended.
- Is this a remote position or will I need to be on-site in Ile de France?
- The job description states that you will be assigned to Ile de France, indicating that this is not a fully remote position. While some interviews might be conducted remotely, the primary work location is expected to be on-site or hybrid within the Ile de France region for the client's projects.
- What are the benefits offered to employees at Blue Soft?
- Blue Soft offers a comprehensive benefits package, including 60% employer coverage for mutual health insurance, meal vouchers, and public transport. You'll also receive 5 weeks of annual leave, RTT, seniority-based leave, various bonuses (holiday, co-optation, business development), and access to perks like gift vouchers, sports/cultural activity funding, and housing assistance.