Database Administrator
Calgary, Canada Area
• Administrated/supported 700+ SQL Server instances and Oracle Databases.• Designed and implemented High Availability (HA) Solutions for SQL Server databases in failover configurations – Mirroring, Clustering and Always-On (SQL Server 2005-2012)• Upgraded databases from SQL Server 6.5 to SQL Server 2008.• Created detailed documentation for SQL Server HA and DR Solutions.• Planned Disaster recovery for business critical application's databases (such as Blackberry Enterprise Server's database)• Created SQL Servers in the Cloud using VMWare technology. (Database as a Service)• Setup point-in-time database recovery (Oracle/SQL Server)• Tested and set up monitoring tools for databases.• Created Monitoring Jobs and Tasks.• Troubleshot database and network performance issues.• Backed up and restored Databases and Schemas.• Ensured databases and servers met PCI and SOX compliance.• Created disaster recovery planning, scenario design, and implementation• Designed and set up SQL Servers as per application requirements• Coached DBAs with SQL Server installation, SSRS configuration.• Created a standardized operation documentation containing all information for installation and configuration for SQL Servers.• Designed RunBooks and created templates for all SQL Server databases.Tools:• Microsoft System Center Operations Manager (SCOM), Spotlight, Oracle Enterprise Manager Grid (OEM Grid), SQL Server Management Studio (SSMS), Putty, PL SQL Developer, SQL Plus, SnapManager for Oracle, BRTools, DBArtisan, WinSCP, VMWare View, Datapump, Import/ExportProjects:• Upgraded MS SQL Servers 6.5/7.0/2000 to 2008• Designed and built 6 SQL Server 2008 Mirroring solutions• Designed and built 2 SQL Server 2012 Always On High Availability SolutionsSenior Configuration Management 1998 -2009 • Senior level support for Husky Energy Inc. – Troubleshot network, server and desktop issues.• Supported Windows Active Directory