Manager Sql Server
Resume:
Surname: Titus
Name: Ashraf
ID: 800-***-**** ***
Mobile: 081-***-****
Email: ******.*****.**@*****.***
Physical Address:
North Riding
2000
To whom it may concern
I highly value building and maintaining strong relationships with people.
I am a lifelong learner, passionate about continuously improving myself to enable me to contribute value to my team, employer and our customers.
I am a certified ETDP SETA Facilitator, ISETT registered Assessor, MCSE SQL graduate
and have been solving software, database and customer problems for more than 12 years.
My most recent position held at Chase Software (until August 2020 – Covid-19 related discontinuance) was a team leader role of in a highly specialised data support team in the advertising industry. At Chase, our motto was to always provide the highest quality support against apex benchmarks for industry standards.
My responsibilities exceeded managing routine SLAs and my role was focused on escalation items and crisis management events. I would typically manage and coordinate the problem identification and resolution across many clients. I am highly adept at spearheading the problem identification and managing the key pressure points to expedite resolution or and in some cases, would code TSQL custom solutions.
I am passionate about post mortem analysis of critical escalations, which results in more efficient diagnostics, interim solutions and long-term process correction and business value of prevention.
I am determined and highly motivated to bounce back immediately from the Covid-19 set-back. I am excited to join an innovative and creative team and to add value by combining my facilitation and technical capabilities to add value to customers by providing technical solutions and delightful service experience.
Thank you for your time and consideration.
Sincerely
Ashraf Titus
COMPREHENSIVE SUMMARY
Employment Summary
Team Lead: SQL Technical Support
Chase Software
May 2012 - Present: 8 yrs. 4 mos.
Key Accounts Trainer
Chase Software
May 2008 - May 2012: 4 yrs. 1 mo.
Senior Facilitator
Universal College Outcomes
Apr 2006 - Apr 2008: 2 yrs. 1 mo.
Junior Facilitator
Universal College Outcomes
Feb 2005 - Apr 2006: 1 yr. 3mos
Education Summary
Gordon Institute of Business Science - University of Pretoria
Predictive Analytic Statistics-Big Data analytics, Descriptive Analytics, Predictive Analytics, Prescriptive analytics, Evidence-based decision-making
2020
SimpliLearn
Database Administration Specialist:
Big Data Hadoop Administrator, Azure Administration, MongoDB Developer and Administrator
2019
Pluralsight
MS Advanced SQL Server Administration
2019
Udemy
2016 SQL Server & Azure Administration- SQL Provisioning, Azure Developing, Azure Architecture Technologies
2019
Pluralsight
MS SQL Adv. Data Corruption Recovery
2018
CTU Training Solutions
MS MCSA SQL Administration: TSQL, SSIS, SSAS, SSRS
2016
ISETT SETA
Assessor
2009
ETDP SETA
Facilitation: Train Trainer
2009
University KZN
Microsoft ICDL, MOS
2008
Oval International
Advanced Diploma Information Tech
2002
Work Endorsement
Martin Duncan
Product Support & Development Manager
Hussain Mohamed
2nd Line Manager
Mohamed Patel
Support Manager
Client Endorsement
Vicki Sternberg
Ops Manager: Cerebra Ad Agency
Lloyd Govender
CFO: MulenLowe
Mandy Davis
Finance and Ops Director: Penquin
Firza Adams
Finance Manager: Lowe Ad Agency
EMPLOYMENT
SKILLS & COMPETENCIES
Recent Summary of Skills & Competencies
Name of Company:
Chase Software
Period:
May 2012 - Present: 8 yrs. 4 mos.
Position Held:
Team Lead: SQL Technical Support
- SQL Technical Support
Installation, configuration and upgrading of Microsoft SQL Server software and related products.
Setup, maintain & support SQL based integration with Accounting systems like MS Navision, Sage etc.
Establish and maintain sound backup and recovery policies and procedures
Implement and maintain database security (create and maintain users and roles, assign privileges)
Lead Technical resource on database Projects, create, test & UAT TSQL solution.
Assist all clients with Financial month-end reconciliation.
Setup & Support Financial Dashboards.
Configuring, monitoring daily backup maintenance plans
Troubleshooting application problems related to the database
- SQL Administration
Performance monitoring of client SQL server
Index Tuning with SQL Profiler
Database tuning
Server-Side Trace
Auditing logins
Identifying and resolving SQL Locks, Blocks & Deadlocks
Basic configuration of VMware
Database Mirroring
Log Shipping
Transactional Replication
Peer to Peer Replication
- 2nd Tier Support Consultant
Technical lead for escalations.
Data imports and exports using SQL Server
Facilitate and manage inter-department resolution delivery.
Support financial integration queries
Lead Support for Data corruption recovery.
Provide 2nd tier application Support for support staff query
Provide administration support for Azure clients
Develop custom TSQL scripts for SQL Projects with risk mitigation.
EMPLOYMENT
SKILLS & COMPETENCIES
Summary of Skills & Competencies
Name of Company:
Chase Software
Period:
May 2008 - May 2012: 4 yrs. 1 mo.
Position Held:
Key Accounts Trainer
- Key Accounts Trainer
- Technical Support
- Key Accounts Trainer
Responsible for managing Key Client relationships effectively, fuse Application Training with Client HR process and align training to Client performance policy.
Lead 1st Phase Implementation Training with Client decision makers. Identifying key risk areas.
Manage stakeholder expectations, negotiating realistic achievable deliverables and owning process.
Aligning Client business requirements with application functionality.
Lead Training Facilitator of Key Client Roll-Outs, in alignment with 1st Phase structure and Key stakeholder outlines.
Developing accurate Quality Assurance Testing plans,
Review & Refine Implementation Project Dry-runs
Developing & facilitating User Acceptance Testing processes
Obtain Client-sign-off in accordance with client group policies for change control
- Technical Support
Provide 1st Level support, liaising with 3rd party service providers for application support where required
Troubleshoot technical queries and refine or update Test Cases for effective Hotfix release management.
Test and install new systems and provide on-site service to clients as required
MS SQL Server installation.MS SQL database upgrades, Application upgrades, IIS Webserver Installations.
Managing and owning queries within the SLA across departments or products and Escalate as needed.
Incident management, aligning Client expectation with escalation team’s achievable deadlines.
Define and implement communication strategy for high impacting incidents to keep customer informed.
Identify problem trends or Client hotspots and put in place measures to address
EMPLOYMENT
SKILLS & COMPETENCIES
Recent Summary of Skills & Competencies
Name of Company:
Universal College Outcomes
Period:
Apr 2006 - Apr 2008: 2 yrs. 1 mo.
Position Held:
Senior Facilitator
- Senior Facilitator
Preparation for assessment against NQF Unit Standard. Complete understanding of outcomes-based assessment
Collect, compile, assess a Portfolio of Evidence against Unit Standard. Conduct outcomes-based assessment.
Provide feedback on assessments. Aligning any training to SAQA unit standards.
Render judgment on competency based NQF principles. Provides strategic consulting in all aspects related to training
Technical training for organization-wide initiatives and projects.
Researches and studies advancements in educational technologies and methods;
evaluates effectiveness of training and development programs
EMPLOYMENT
SKILLS & COMPETENCIES
Recent Summary of Skills & Competencies
Name of Company:
Universal College Outcomes
Period:
Feb 2005 - Apr 2006: 1 yr. 3mos
Position Held:
Junior Facilitator
- Junior Facilitator
Conducts needs assessments to identify and evaluate training requirements for high impact technology training.
Define the key measurable outcomes. Plan and implement facilitation plan to meet desired outcomes
Design Training material and strategies, processes for effective facilitation aligned to ETDP principles.
Conducts or facilitates general or specific technology training programs.
Participates in effective training delivery including analysis, implementation.
Evaluates effectiveness of training and development programs, utilizing appropriate data collection instruments and procedures. Consults with cross functional project teams, leaders and/or stakeholders.
Administers training programs in accordance with business needs, regulatory requirements, and Quality Management System. Develops training materials to include training handbooks, job aids, models, multimedia visual aids, computer and web-based tutorials.
Summary of Studies
Institution
Gordon Institute of Business Science - University of Pretoria
Course Name
Predictive Analytic Statistics
Big Data analytics
Descriptive Analytics
Predictive Analytics and Prescriptive analytics
Barriers and challenges to Big Data analytics.
implementation Big Data analytics.
Tools and techniques to leverage internal data
Evidence-based decision-making
Basic Equations and Ordinary Least Squares (OLS) method.
Assessing accuracy of predicted coefficients.
Assessing Model Accuracy: RSE and R squared
Creating Simple Linear Regression model
Multiple Linear Regression.
The F - statistic.
Institution
SimpliLearn
Course Name
Database Administration Specialist
Big Data Hadoop Administrator Course
HDFS Hadoop Distributed File System
Hadoop Clients and Hue Interface
Data Ingestion in Hadoop Cluster
Hadoop Ecosystem Services
Hadoop Security
Hadoop Cluster Monitoring
AWS Technical Essentials
Intro to Cloud Computing AND AWS
Storage and content delivery
Compute Services and Networking
AWS Managed Services and Databases
Deployment and Management
MongoDB Administrator Course
Functionalities of MongoDB as document database
Identify the benefits of MongoDB
Replication and sharing features in MongoDB help in scaling read and write operations
Process of developing Java and Node JS applications using MongoDB
Administrator features of MongoDB
Azure Administrator AZ-103
Configure Azure files and Azure Backup
Windows and Linux VMs
Manage Azure VM and DNS
Manage VM Backups
Virtual Network Connectivity
Manage Virtual Networking
Network Security Groups
Azure Active Directory
Manage AD Objects
Hybrid Identities
Implement multi factor authentication (MFA)
Institution
Pluralsight
Course Name
Microsoft SQL Server : Advanced SQL Server Database Admin
Intro to Advanced SQL Server Database Admin
Setup and Installation of SQL Server 2008
Optimizing SQL Searches with Indexes
Full-Text Search
SQL Server Policy-Based Management
SQL Server Data Encryption
SQL Server Backup and Recovery
SQL Server High Availability
SQL Server Failover Clustering
SQL Server Database Mirroring
SQL Server Log Shipping
SQL Server Replication
SQL Server Resource Governor
Monitoring SQL Server
SQL Server Performance Tuning
SQL Server PowerShell
SQL Server Integration Services
Summary of Studies
Institution
CTU Training Solutions
Course Name
MCSA: SQL Server Administration
MS 462: Administering Microsoft SQL Server Databases
Administering SQL Server 2012
Planning a SQL Server 2012 Installation
Installing SQL Server 2012
Implementing a Clustered Instance
Identifying and Resolving Concurrency
Managing SQL Server Agent
Configuring SQL Server Components
MS 463: Implementing a Data Warehouse with Microsoft SQL Server
Designing & Implementing a Data Warehouse
Developing SSIS Packages
Enhancing SSIS Packages
Managing and Maintaining SSIS Packages
Building Data Quality Solutions
Advanced SSIS and Data Quality
Institution
Pluralsight
Course Name
SQL Server: Advanced Corruption Recovery Techniques
SUSPECT & EMERGENCY Mode Databases
Database status: Mode Repair
Un-Repairable Corruption
Recreating Damaged or Corrupted Log Files
Page Restore
Metadata Corruption
Rebuilding System Tables
Dealing with Corrupt backups
Advanced Repair Techniques
Developing SSIS Packages
Reconstructing Data
DBCC PAGE Recovery
Manual Repair
Ways to salvage Databases File Group
Dealing with Corrupt backups
Piecemeal Restore
Institution
Udemy Academy
Course Name
Microsoft SQL Server 2016 Administration & Azure Administration
2016 -MS SQL Server Admin.
SQL Server Security
Server & Database Level Security
Database User Account Types & mapping to Windows
Cross Server Authorization
Partially Contained Databases
Dynamic Data Masking
SQL Server Roles
SQL Server - Encryption: Asymmetric Vs. Symmetric
Transparent Data Encryption -Implementing TDE
Always Encrypted- Implementing Always Encrypted
Index Management - Database Engine Tuning Advisor - Fragmentation
MS SQL Server - Backup Plans & Recovery Models
MS SQL Server Transaction Tail-Log Backups
Point In Time Recovery
Log Shipping
Monitoring Microsoft SQL Server
SQL Server: Performance & Monitoring
SQL Server: Data Collector Configuration
SQL Server: Query Store
Microsoft SQL Server Extended Event
Microsoft Azure Administrator
High Level Governance of Azure and PowerShell
Managing Policy by PowerShell and CLI
Subscriptions and Management Groups
Monitor resources by using Azure
Diagnostics, Baseline Environment
Create Alerts, Create Metrics, Action Groups, Manage Costs
Deploy Linux VM using ARM Templates
RM Use Existing VHD
Encrypt a Virtual Machine Disk
Introduction to App Services
App Service Plans, Web Aps, App Settings, Scaling Web Apps
Azure Kubernetes Services (AKS) -
Installing Docker Hub or Docker Toolbox
ACI Azure Container Instances
Configure Azure Firewall
Configure Global Peering
Azure-to-Azure Virtual Network Gateway
Adding a Network Gateway Connection
Azure DNS Services, Create a Public DNS Zone
Manage Azure Active Directory
Hybrid Identities
Implement Multi-Factor Authentication (MFA)
Manage role-based access control
Monitor and troubleshoot virtual networking
Institution
ICP Training
Course Name
Power BI – Business Intelligence Analysis
Creating Reports in Power BI
Creating a Table, Formatting a Table, Sorting
Creating Multiples Measures,
Methods of Aggregation
Creating a Matrix Table
Slicers, Filters,- Visual Filters
Page Filters & Report Filters
Trend Analysis - Time Intelligence
Scatter Plots & Bubble Plots
Predictive Forecasting,
Hind Casting, Transpose Hind Cast,
Pareto Analysis, Trend Analysis,
Data Analysis Expressions (DAX) Measures
Creating time intelligence functions, Creating a date table, Data Analysis
Expressions (DAX)
Contact this candidate