MAIN RESPONSIBILITIES:
- Maintain under operational conditions the SQL Server Infrastructure in respect of the Support processes
- Build, deploy and administer/manage the current and future SQL Server platforms.
- Senior level of operational support on:
- Troubleshooting, incidents and problem management,
- Reporting and communication.Troubleshooting, incidents and problem management,
- Pro-active in ensuring stability, response time, operational consistency and life cyde over the SQL Server databases.
- Implement automation via scripting
- Ensure appropriate documentation, including procedures for level2 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:
- SQL LANGUAGE: Fluent, trained with complex join, T-SQL programming, SQL Agent Jobs, linked servers
- SQL Server: comfortable with large databases, numerous instances, backup strategies, recovery model, linked servers, MSX, versions 2000 to 2016
- Installation, Administration, Setup, Tuning and Troubleshooting of SQL Servers
- Strong experience in operational support: incident management (diagnostic, impact analysis, workaround implementation, communication, reporting, permanent enhancement)
- Experience in High availability solutions
- 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 and abilities:
- 7-10 years of experience in Infrastructure IT, with 3 years specifically on DB Administration,
- Self-motivated, eager to learn in the IT profession,
- Team player must be able to work with people within and outside of the IT department,
- Customer service oriented,
- Excellent communication skills, verbal and written, English speaking mandatory (French reading would be appreciated)
- Ability to analyze and synthesize situations and understand the business constraints,
- Willing to do some traveling
- 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