Yanling Hao

Experience

• 

  Bowman Systems

  Nov 2002 - Aug 2007

  System Administrator

  As an IT System Administrator, I support the Senior IT professional in maintaining a reliable and efficient IT environment that meets the company's needs. My primary responsibilities include installing, maintaining and administering servers, as well as providing technical support and software deployment across remote-hosted, co-located and shared infrastructure. This work involves technologies such as Windows, Linux, SQL, PHP and IIS. Additionally, I provide helpdesk support to around 50 employees within the company. Show less

• 

  Mayo Clinic

  Jan 2008 - now

  As the manager of the Application Hosting unit overseeing 24 staff members across three teams (Linux Server, Windows Server, and Web Hosting), my primary responsibility is to ensure that our services meet the needs and expectations outlined in our service catalog. This involves overseeing all aspects of service delivery, from definition and design to implementation and operation, while collaborating with stakeholders, enterprise architect and Sr. Service Owner to evolve and enhance our service offerings. In addition to providing structure, guidance, and support for team leads, I am also responsible for overseeing budget planning and staffing for service delivery, ensuring that resources are allocated efficiently to meet our objectives. Furthermore, I continuously monitor and assess performance metrics to drive improvements and optimize service delivery processes. Show less Working with a team of SQL DBAs to provide support for all aspects of MS-SQL database environments; Establishing SQL Server build standards, ensuring consistency and best practices across environments; Defining high availability (HA), disaster recovery (DR), and reporting solution standards to meet business requirements; Implementing backup and recovery strategies to safeguard data integrity and facilitate disaster recovery; Automating routine tasks to improve efficiency and reduce manual workload; Engaging in capacity planning to anticipate future resource needs and prevent bottlenecks; Mentoring new team members, sharing expertise, and guiding them in best practices. Show less Performing SQL Server installations and upgrades, ensuring smooth transitions and compatibility; Conducting performance tuning activities to optimize database performance and efficiency; Maintaining database security, including user access controls, permissions, and encryption; Managing patching processes to keep SQL Server instances up to date with the latest security and functionality updates; Handling user requests, Participating in a 24/7 on-call rotation to promptly address any database-related issues or emergencies. Show less

  • IT Service Delivery Manager

    Apr 2023 - now

  • Lead IT Systems Engineer

    Jun 2012 - Apr 2023

  • Sr. IT Systems DBA

    Feb 2011 - Jun 2012

  • IT Systems DBA

    Jan 2008 - Feb 2011