Database Administrator/Data Engineer

Robert G Orta

****.******.*@*****.*** linkedin.com/in/robertgorta 484-***-****

TECHNOLOGY PORTFOLIO

Platforms:

● Windows Server 2016/2019, Windows 10/11, Windows Networking, VMWare ESX, Cloud Environments (AWS), Microsoft .NET framework, Linux Software:

● Microsoft SQL Server 2019, T-SQL,Oracle 19c, PL/SQL, Oracle SQL Developer, SQL Server Management Studio, CODY Applications and Application Services, Nextgen Healthcare Applications and related 3rd Party Applications, Symantec AntiVirus, Microsoft Office Suite, Visual Studio Code, Visual Studio 2022 EDUCATION

Certifications:

● Python Crash Course 2021

● Web Design Course (HTML5, CSS) 2021

● Oracle Certified Professional Oracle 10g Administrator 2008

● Certified Microsoft SQL 2005 MCITP:DBA 2006

● Certified Microsoft SQL 2000 MCDBA 2004

Degrees:

Montgomery County College Blue Bell, PA

Coursework in Management of Information Systems 2021 Albright College Reading, PA

Coursework in Management of Information Systems 2016-2017 Rutgers University Camden, NJ

Coursework in Information Systems 1992-1993

PROFESSIONAL EXPERIENCE

CODY Systems Pottstown, PA

Data Services Engineer

6/2022 - Present

● Managed and executed data transformation projects for customers

● Transformed and Extracted data from Oracle and MS SQL using in-house database scripting, commercial software, and in-house developed toolsets

● Maintained and authored internal documentation for ETL projects, tasks and runbooks using Confluence and Salesforce

● Securely handled confidential customer data for ETL projects

● Managed process to perform Oracle patching for internal and customer facing systems

● Supported secure data disposal and data management for confidential customer data

● Collaborated on project to code proprietary data interfaces using C#

● Mentorship with Senior Developer on C# and Python Senior Technical Services Representative

10/2019 - 6/2022

● Serviced customer requests for CODY desktop and mobile application, application services, and interfaces technical service support for law enforcement agencies across Pennsylvania, Indiana, Texas and New Jersey

● Successfully improved Technical Services Team knowledge-base and runbooks documentation for training, technical self-service assistance, and project tasking

● Assisted with reductions in siloed institutional knowledge and non-standardized practices for Technical Service case management following ITIL methodology

● Led project to acquire a customer case management system for service requests, secured requirements, conducted trials, provided guidance to upper management

● Maintained and supported CODY application and database infrastructure in remote and locally managed MS Windows servers, Oracle database and RDS farm.

● Successfully executed upgrades, application service installations, and interface installs and configuration change projects for remote and hosted customers in a environment with highly customized application systems

● Maintained and supported customer hosted and on-site CODY data exchange services in Oracle and MS SQL Server

Nextgen Healthcare Horsham, PA

Manager MCS Technical Support Team

06/2017-09/2019

● Led local and remote technical support resources for two large-scale cloud environments supporting connectivity, critical application functions, and performance for 540 clients

● Initiated and designed technical training program for team members

● Increased standardized change management practices for cloud operations

● Coordinated and managed customer relationships with account management, sales and upper management

● Improved 3rd party application integration and support for client cloud environments

● Managed and supported SQL Database and Nextgen Application Integration

● Conditioned ITIL standards for change management within Technical Support Team/ Team Lead

01/2015-06/2017

● Directed team resources for scheduling, planning and action on customer support issues; collaborate for administrative support

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

● Provided R&D assistance to identify, manage technical issues, and coordinate fixes with clients

Performance Analyst

12/2010-01/2015

● Managed portfolio of high profile clients as an assigned representative, including developing data recovery strategies

● Introduced and developed a maintainable, reusable processes to improve resource-intensive queries via database tuning, hardware alignment, capacity planning, Windows Server tuning

● Increased performance within specific application query code, typically by a factor of 50 to 100 percent

● Lead SQL Database recovery operations due to data corruption

● Provided guidance and assistance on client IT infrastructure including Disaster Recovery for Nextgen application database environments

● Developed SSRS for Application SQL Databases for ad-hoc and monthly reporting SunGard Philadelphia, PA

IT DBA\Systems Engineer

08/2008-12/2010

● 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

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

● Lead project on enterprise wide fault tolerant SQL Server instructure project using HP Blades, VMWare ESX and NeverFail

Strohl Systems King of Prussia, Pa

Application Hosting/Integration Engineer 05/2006-08/2008 Application Hosting Lead 01/2005-05/2006

Senior Technical Support and Lead Field Engineer

09/1999-01/2005

Contact this candidate