Sql Server Technical Support

Robert G. Orta *** Village Drive

Schwenksville, PA 19473

****.******.*@*****.*** Home: 484-***-**** Mobile: 610-***-**** Professional

Summary

IT professional with industry experience in management, and technical support. Expertise in deploying and maintaining advanced database and server application solutions for Fortune 500 clients. Searching for a rewarding opportunity to develop and apply my skills to drive the best experience for clients.

Professional

Experience

NextGen Healthcare 04/2023 - 02/2025

Senior Specialist Rep 04/2023- 02/2025

Senior technical specialist team member leading and supporting ETL services for clients using MS SQL Server within AWS cloud environment

Execute Data Transformation Projects with clients adapting to issues and tailoring the project to meet the needs and objectives of the client

Provide updates, maintenance and testing to proprietary in-house tools for data Transformation ETL projects and services using Github, SourceTree and Visual Studio Code

Developed, Implemented and maintained Knowledge Base documents for Technical Data Services Team.

Guided coding development to include best practices for testing and automation.

Cody Law Enforcement Software 10/2019-03/2023

Senior Technical/Data Services Team Rep 10/2019- Present

Senior technical support team member servicing 250 clients

Provide ETL services for clients using Oracle, MS SQL Server

Maintain ETL environments for Oracle and MS SQL Server

Deploy technical services support for Law Enforcement software system client and server applications to Cloud and On-Premise environments

Lead practitioner providing ITIL methodology guidance and implementation

Developed, Implemented and maintained Knowledge Base and run-book strategies for Technical Support Team.

Project lead for internal initiatives to stream-line ticketing system and provide guidance on best practice and efficiencies for internal team and business processes

Transitioning into Technology liaison for Docker, Ansible and automation implementation for new platform

Nextgen Healthcare 12/2010-06/2019

Manager MCS Technical Support Team 06/2017- 07/2019

Manage technical support team for portfolio of 540 Nextgen hosted clients Page 2 of 4 Robert G. Orta

Deploy technical support team resources in help desk technical issues related to cloud environment including connectivity, critical application functions, and performance

Coordinate training program for technical team members

Deploy standardized change management practices for environment

Coordinate and manage customer relationships with account management, sales and upper management

Develop 3rd party application integration and support for implementation within client cloud environments

Administrate team members based locally and remote 01/2015- 06/2017

Team Lead

Direct team resources for scheduling, planning and action on customer support issues.

SME for SQL performance issues for technical support and R&D teams

Provide R&D assistance to identify, manage technical issues, coordinate fixes with clients

Provide administrative support on team goals and development 12/2010-01/2015

Performance Analyst

Manage portfolio of high profile clients as a dedicated representative

Improve SQL Database Performance using query tuning, index tuning, hardware alignment/capacity planning, Windows Server memory and cpu analysis/tuning

Identify and implement SQL performance improvements and corrections within application query code for R&D team

Lead SQL Database recovery operations due to data corruption

Provide guidance and assistance on client IT infrastructure including Disaster Recovery for Nextgen application Database environments

Develop data recovery strategies for Nextgen clients

Introduce processes for SQL Server performance trouble-shooting SunGard 08/2008-12/2010

IT DBA\Systems Engineer

Provide trouble-shooting and standardized maintenance for enterprise MS SQL 2005 systems for Datatrax facilities management application for 15+ sites across the U.S

Manage updates, migrations, technical support for MS SQL back-end databases for application users for Livelink, San Suite, Altiris Hardware/Image Deployment

Provide database quality assurance and MS SQL subject matter expertise for Internet facing customer web portal

Page 3 of 4 Robert G. Orta

Deploy and manage Websense Web Filtering application supporting 3,500+ users using MS SQL 2005 and Windows 2003 R2 Server

Lead project on enterprise wide SQL High Availability consolidation project using HP Blades, VMWare ESX and NeverFail

Strohl Systems 09/1999-08/2008

Application Hosting/Integration Engineer 05/2006-08/2008

Support customer databases in SQL Server 2000/2005

Manage and monitor Windows 2003 web servers running IIS 6.0 for all web hosted customers

Manage and maintain enterprise SQL Server infrastructure for Strohl Systems Internet facing software service

Upgrade, migrate and patch web hosted customers Strohl Systems software

Perform administrative tasks on Windows 2000/2003 Servers

Build, configure, and maintain HP/Compaq Proliant family servers

Deploy HP server hardware imaging using HP Rapid Deployment solution for customer's Strohl Systems applications

Maintain Strohl Systems software MS SQL 2005 data replication and recovery infrastructure using SQL replication and Double-Take

Liaison for development and technical support teams in support of SQL database infrastructure

Lead for standardization of production environment operating procedures Page 4 of 4 Robert G. Orta

Application Hosting Lead 01/2005-05/2006

Manage customer Service Level Agreements and customer activations

Deploy Windows 2003 Server systems and Strohl Systems applications for customers

Manage customer contact for scheduled outages, updates and monthly SLA reports

Improved MS SQL 2000 system for version 1.0 of Strohl Systems web application deployment

Advise Sales and Support Teams on Strohl Systems Web application issues Senior Tech Support and Lead Field Engineer 09/1999-01/2005

Architect, manage and deploy on-site installations of Strohl Systems software solutions with enterprise customers across the United States and United Kingdom

Provide Strohl Systems web software instruction to customers

Maintain technical support for 60+ enterprise customers Technology Portfolio

Platforms:

● Windows 10/11, Windows Server 2019, Networking support, Cloud Environments (AWS), VMWare ESX, Docker

Coding/Scripting:

● T-SQL, Python, HTML5, CSS

Software:

● SQL Server 2019, Oracle 19g, SharePoint, proprietary Nextgen Healthcare Applications and related 3rd Party Applications and NextGen Data tools, proprietary Cody Law Enforcement software and suite of Cody server application services and data interfaces. Github, SourceTree, Visual Studio Code, SQL Server Management Studio.

Education

Oracle Certified Professional Oracle 10g Administrator 2008

Certified Microsoft SQL 2005 MCITP:DBA

2006

Certified Microsoft SQL 2000 MCDBA

2004

Albright College Reading, PA

Management of Information Systems - Bachelor of Science Rutgers University Camden, NJ

Information Systems Curriculum

Contact this candidate