Anne Johansen Email & Phone Number

Saint Paul, Mn, Us

Saint Paul, Mn, Us

Atlanta, Georgia, Us

Toronto, On, Ca

Assumed additional accountability to previous position, including increased server administration to 1.5K+ servers. Support was moved to a follow the sun model, working in shifts, rather than requiring folks to provide support 24x7.• Participated in solution design meetings, advising SQL version, storage requirements, HA or DR needs and backups required.• Served as integral part of team that performed operational readiness testing of EMC Avamar and NetApp Snap backup software, developing and documenting new standards. Also provided training to 20 coworkers and multiple customers. Collaborated closely with vendors, storage and Windows teams in rolling out changes.• Acted as point of contact for any DBA, delivering required assistance and / or training.• Facilitated handover between shifts, ensuring clear communication.• Involved in more complex database migrations / upgrades including high-visibility project involving transfer 15 TB of data in 2 days from 3 active-active clusters to 6 SQL instances on 3 active / passive clusters, saving money on licensing.

Toronto, On, Ca

Administered 450+ SQL Servers as part of global team providing 24x7 support. Installed and configured SQL Server (including SSAS, SSIS, SSRS) on 100s of servers. Provided tuning and troubleshooting services utilizing execution plans, Profiler and Performance Monitor as guidelines. Created databases, controlled login setup, generated maintenance plans and SQL jobs.• Performed SQL upgrades, migrations to new hardware and VMs, keeping clients on supported software in accordance with life cycle management.• Served as member of team that completed all database changes in DEV, QA and PROD environments. Excelled in completing client changes on time while maintaining perfect metrics in HP Service Manager as dictated by company’s change management policies.• Responded to all incident management tickets in timely fashion, immediately delving into and resolving issues as quickly as possible, while keeping with incident management metric policies.• Monitored backups, blocking, data consistency, database / disk-free space and resource utilization, circumventing impending issues.• Developed and documented standards and best practices that simplified support of large SQL server environment.• Interfaced regularly with other IT groups, coordinating maintenance efforts and releases.

Technical Support Analyst for an ERP ApplicationProduct Development Specialist