We are looking for a MS SQL Database Administrator
-As a member of the Infrastructure Shared Services, the Database Administrator will represent his/her department towards the Business Units and project teams and will assure a determining role in the management, support, maintenance, implementation, administration and lifecycle management of SQL Server platforms.
-He/she will be positioned as a level 3 in the organization, using his/her expertise for level of escalation in case of incidents and for the contribution in the qualification of new solutions, assisting in the deployment. The role is providing day to day operational support for existing infrastructure services and users of those services, and for project-based work to the development and deployment of new infrastructure services.
-This person must have deep knowledge in Microsoft SQL Server technologies and must be able to lead, operate and continuously improve the environments distributed across 600+ remote locations throughout EUROPE, Asia, US, Latam and Canada.
-Maintain under operational conditions the SQL Server Infrastructure in respect of the Support processes
-Build, deploy and administer/manage the current and future SQL platforms
-Senior level of operational support on: Troubleshooting, incidents and problem management Reporting and communication
-Pro-active in ensuring stability, response time, operational consistency and life cycle over the SQL Server databases
-Implement automation via scripting
-Ensure appropriate documentation, including procedure for level 2 and level 3 support
SECONDARY RESPONSIBILITIES
-Handle Oracle DB (preferred w/ SAP), PostGre and/or MySQL technology support
-Contribute to search and qualification of new solutions with Technical Architecture teams and Design Teams
-Provide monthly reports on activity, quality and performance
Primary technical abilities
1. SQL LANGUAGE: Fluent, trained with complex join, T-SQL programming, SQL Agent Jobs, linked servers
2. SQL Server: Comfortable with large databases, numerous instances, backup strategies, recovery model, linked servers, MSX, version 2000 to 2016
3. Installation, Administration Setup, Tuning and Troubleshooting of SQL Servers
4. Strong experience in operational support: Incident management (diagnostic, impact, analysis, workaround implementation, communication, reporting, permanent enhancement)
5. Experience in High availability solutions
6. Experience in Cloud solutions (ideally Azure)
Secondary Technical abilities
• Knowledge in ITIL framework
• Knowledge on Infrastructure (Servers, Storage, Network)
• Knowledge on PostGre / MySQL / Oracle Databases
BEHAVIOR ABILITIES
1. 7-10 years experience in infrastructure IT, with 3 years specifically on DB Administration
2. Self motivated, eager to learn in the IT profession
3. Team player must be able to work with people within and outside of the IT Department
4. Customer service oriented
5. Excellent communication skills, verbal and written. English speaking mandatory (French reading would be appreciated)
6. Ability to analyze and synthesize situations and understand the business constraints
7. Willing to do some travelling
8. Dedication
Technical Environment
• Microsoft-SQL Servers 2000 to 2016
• OS Server: Windows Server 2003 to Windows Server 2012 - Linux Redhat Enterprise 6 to 7
• OS Client: Windows XP to Windows 10
• Microsoft Active Directory
• McAfee, Trend, and Kaspersky Antivirus
• VMware 5.x and above - Nutanix NOS
• Hardware: Dell & Cisco UCS servers
• Storage: Netapp, SAN IBM & SVC, Dell Compellent, ISCSI Storage Dell Equallogic & MD, Pure Storage
• Veeam Backup & Replication, & Commvault backup
• BMC & Solarwinds Monitoring / Ticketing CMDB CA Service Desk Manager
• Network Cisco
Together, as owners, let’s turn meaningful insights into action.
Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…
You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.
Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.
You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.
Come join our team—one of the largest IT and business consulting services firms in the world.