Qualifications:
· Experience in large MSSQL environments (5+ years preferred)
· Demonstrable skills in configuration, maintenance, and administration of MSSQL systems and applications
· Excellent communication and collaboration skills, excellent organizational skills, proven ability to prioritize multiple activities and objectives to thrive in a rapidly changing environment
· Ability to write effective technical documentation with attention to detail and accuracy
· Familiarity SQL Monitoring and Alerting Management systems
· In-depth knowledge of MSSQL HA (Stream, Clusters)
· Project Management skills
· Ability to manage maintain ETL & DW processes
· On-call troubleshooting within a 24/7 production environment and providing escalation support as necessary
· Expert knowledge of MSSQL 10 and up
· Ability to communicate clearly and effectively with various departments such as Engineering, IT Infrastructure, Project Management, etc...
· Solid experience with MSSQL in Kubernetes, VMware platforms
· Agile Methodology familiarity
· Experience using Bash, Python, Perl scripting techniques to manage a large environment
· In-depth Windows operating system knowledge
· Attend training conferences and sessions that may require travel
· While on-call be available by phone 247 and be able to get online immediately should an outage occur
Soft skills: Diplomatic, good communication skills, understands accountability.
Must: Good level of English, MSSQL experience, Operational work, Working on call. Automation skills (Ansible). Monitoring tools. Analize performance issues. Set up environments, restore databases, check up if backups are okay.
Desirable: knowledge of other database skills, Jenkins, working with incidents.
Job Duties / Responsibilities:
· Ensure production MSSQL maintain the company's requirements for HADR, Security, and RPORTO
· Provide on-call support (as part of a rotation) for production alerts or issues both during and outside normal working hours
· Provide support during maintenance windows or deployment/release activities
· Join war-room calls to triage and troubleshoot outages as they occur, including after-hours and weekends
· Build and improve automation around configuring and administering MSSQL
· Optimize performance of MSSQL and determine the most effective ways to increase performance including hardware purchases, server configuration changes, or index/query changes
· Continuous evaluation and implementation of proactive measures to improve performance and stability of MSSQL
· Create and maintain procedural and technical documentation
· Collaborate with other teams in enterprise level projects and provide support guidance as needed
· Lead assigned quarterly projects from initial concept and drive to successful completion
· Identify technical developmental opportunities and provide guidance to Mid and Junior Level DBA team members
