Jenny Hernandez Email & Phone Number

Canada

• Manage and operate a medium and large-sized production database systems across multiple data centers including MS SQL Servers 2012-2019 on Windows 2012/2016.• Deploy Azure MI & VM and administer space and disk management.• Provide direct operational support across all areas of the production database infrastructure including database clusters, database replication, release management and disaster planning.• Perform installation, configuration, maintenance and administration of SQL Server 2012/2014/2016 on cluster and standalone environments, service-pack upgrades.• Experience in query tuning and Index Management.• Conduct performance tuning, capacity planning, query optimization and disk management by using performance monitoring tools like SQL profiler, Dynamic Management views (DMV), etc.• Administer all types of SQL server high availability and disaster recovery (HADR) strategies like Always On High Availability, Replication, Mirroring, Log Shipping, Clustering.• Work on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).• Implement and maintain database security (create and monitor users, server roles, alerts and assigning privileges), and provide security by encrypting databases.• Provide troubleshooting and resolve database issues such as integrity, performance, blocking, deadlocking.• Work with database backup tools like RedGate, Backup utility and Database monitoring tools like Idera, Grafana, Database Performance Analyzer.• Develop the automation of the database processes, tasks and procedures.• Perform SQL database partitioning to improve DB performance.Top AchievementsSuccessfully migrate 5000+ on-prem DBs and replications to Azure (Cloud).Executed migration and upgrade from SQL Server 2012 and SQL server 2014 Migration from SQL 2012 (5000+ DBs).Successfully completed Disaster Recovery drill.

Canada

• Managed 100+ SQL Servers consisting 4000+ databases with size between 100 MB to 14 TB.• Provided direct operational support across all areas of the production database infrastructure including database clusters, release management, and performance monitoring and troubleshooting.• Installed and configured database servers (MS SQL 2012/2016) both standalone and clustered.• Provided day-to-day database support and maintenance.• Monitored production system and proactively optimized database performance.• Designed and wrote T-SQL and scripts to automate database management tasks.• Investigated and resolved a variety of database issues.• Staged and deployed database changes to production. • Provided after-hours on-call support to promptly resolve issues or escalate, as appropriate.• Applied third-party backup compression tools (i.e. Red Gate Backup Pro).• Assisted in designing backup and recovery strategies.• Deployed database objects to run ETL processes that support new client’s implementation to PointClickCare software solutions using SQL server packages.• Ensured all data services packages, stored procedures, scripts and functions are updated as business logics are upgraded to meet PointClickCare standards.• Provided database technical assistance to implementation teams.• Worked in partnership with clients and the project manager to establish business requirements and solutions.• Worked with application developers and other database administration staff to research, define, and correct application data related issues. • Proactively managed cases/requests by using judgement and knowledge of operations to ensure cases are assigned priority and to escalate, as required and when appropriate.

Canada

• Assisted with the building, maintaining, monitoring and troubleshooting the database infrastructure that supports PCC’s mission critical SaaS application.• Participated in daily operations of the production database system across multiple data centres including MS SQL Servers 2005 and Windows server 2008 R2.• Downloaded and restored databases for development and QA.• Created and refreshed training databases for development and QA.• Created new databases based on requests.• Added database schedulers based on NetSuite tickets.• Swapped tape backups to ensure data is accessible.• Contributed to continual improvement of hosting operation team’s processes and procedures.• Monitored and worked on support tickets in NetSuite based on ticket priority.• Participated in off-hours support to execute important tasks requiring immediate attention.

Canada

• Gathered system requirements, evaluated business processes and built solutions.• Provided employee support and technical issue resolution in person or via email, phone and other electronic medium.• Provided training to employees in the use of business systems.• Identified and discussed operational process improvements while supporting employees.• Performed creation of new accounts requested by various stakeholders

Canada

• Provided direct support to students, faculty and staff who use technology in Sheridan’s teaching and learning environment (support includes network access, printing, installing software, resetting passwords, accessing Sheridan email etc.).• Undertook maintenance of open access computing labs to perform, for example, imaging computers and restoring or exchanging network cables.• Provided immediate classroom support for technology issues discovered by faculty. • Issued replacement photo ID cards to students and staff utilizing applicable software applications (C-cure and Episuite Guardcard).• Processed equipment loans using ATS (asset tracking system) and CRM (customer reference management) as well as use the ERIS (equipment reservation information system).• Provided IT support for the President’s Innovation Challenge event.• Completed administrative tasks using an internal website (Core) in which user’s information can be looked up, passwords can be re-set and equipment requests can be fulfilled.• Prioritized and coordinated activities to follow up on outstanding cases dealing with classroom support that are logged in the enterprise incident management system (PeopleSoft).

Postgraduate Degree, Computer Programming

Bachelor Of Engineering - Be, Computer Engineering