Mike Caldwell – Get A Job BUM – V4.0

JoqrCode_CallMikeC_340x340b Type and Where:

1) PERMANENT – Maybe Contract to Hire

2) JOB LOCATION Wanted: Sacramento California DownTown, Citrus Heights, Carmichael, Fair Oaks, North Highlands, Roseville, Rocklin and outlaying areas like Downtown, Rocklin, Roseville,  Rancho Cordova

LinkedIN Profile – Connect with me! [Click Here]
Updated 4/10/2018

Print or View Mikes Resume PDF Version [Click Here]

Print or View Mikes Resume WORD Version [Click Here]

— ATS COMPLIANT RESUME —
ATS – Print or View Mikes Resume PDF Version [Click Here]

ATS – Print or View Mikes Resume WORD Version [Click Here]

MIKE CALDWELL

Sacramento, CA 95841 │ Email and Phone# On Resume ( Less Spamming )

Senior DBA / SysAdmin / Network Engineer / Business Analyst / Programmer

Highly experienced database professional with deep knowledge of all aspects of managing, maintaining, and updating databases. Expertise in Servers and networking a variety of programming languages, Electronic Medical Records, software programs, practice management software, and infrastructure software. Gifted trainer with staff and clients.  Adept communicator with both internal and external business partners. Ideally suited for a position as Database or Systems Engineer. Other experience would include Web Technology, Surveillance Cameras (NVR’s) and 30+ years as a mechanic.

Professional Experience

Finance of America Holdings, a Blackstone Company
January 2015 – PRESENT
System Engineer II, Senior Database Administrator

• Support BytePRO Loan Origination System and SSRS Reporting System
• Primary DBA for SQL Servers, AAG, Replication, Mirroring and SSRS Reporting Systems
• Primary Technical Support for the BytePRO Loan Origination System
• Installed and managed IIS servers and Document Auto Indexing Servers
• Built out the Nutanix Hyper Convergence BytePRO DEV and PROD platform
• Installation and Support for critical BytePRO products – DocVelocity , CloudVirga, Motivity, Lights Out
• Monitored the SQL Servers using Idera for real time monitoring and analysis
• Created Custom Powershell apps to monitor OS / databases / websites and place email/phones call alerts
• Resolved database integrity and performance issues, configuration, defragging and patching
• Resolved issues related to replication, mirroring, log shipping, connectivity, security
• SQL Performance Tuning, Query Optimization, Managed backups and restores
• Troubleshoot Server, SQL, CPU, Memory, I/O, network, disk space and other resource issues
• SQL Tools Used ( SSMS, SSRS, Database Health Monitor, SQL Profiler, PerfMon )
• Provide SQL Database Operational support to programmers and tech users
• 3rd party DBA tools Used: IDERA, RED-Gate, ApexSQL, DevART, SQLCentral,Ola Hallengren
• Programming: Powershell, TSQL, JScript, VBScript, .Net VB – VS2017 and C#, HTML, ASP, VBA
• Provided database documentation, including data definitions and scripts
• Provided support using Service Now, creating and working on Change requests and Incidents
• Ensure storage, archival, backup, and recovery procedures are functioning correctly
• Manage the performance and integrity of the data, optimizing database performance.
• Provided alternatives and solutions to problems and projects.
• Strong communication and collaboration skills and work independently and efficiently

PEOPLEFINDERS.COM, Sacramento, CA                     
January
2015 – January 2016
DBA | Network Support
Manage databases to ensure efficient operations, optimal search capability, and content security for the largest people search website on the internet.  The site allows searches of public records as well as services such as reverse phone lookups.

  • Handled reporting systems, migrations, index management, integrity checks, configuration, and patching.
  • Managed issues such as: replication, partitioning, log shipping, connectivity, and security
  • Wrote complex SQL programs to handle adhoc reports, replication, partitioning, and data migration
  • Standardized daily SQL report processing to eliminate reporting problems.
  • Utilize SQL recovery models for backups, restores, and database recovery operations, as well as clustering, partitioning, and replication.
  • SQL Server tools (SSMS, SSIS, Oracle WorkBench, VisualDB, SQL Sentry, RedGate, Idera, CentralDB
  • Organized and standardized SQL jobs across servers to more easily identify and debug any issues.
  • Wrote over 50 software programs in Powershell to manage the inventory of all SQL servers, providing alerts to potential problems and developed web counterparts as needed
  • Created database documentation reference materials, including: processes and procedures
  • Plan and manage system capacity and plan for future needs.
  • Work independently or as part of a team to problem-solve database and network issues.


LIFEMED ID, INC., Citrus Heights, CA                                    
February 2013 – December 2014

Software Developer (ETL, MSSQL, Mirth Interface), Network Administrator, Programmer
Acted in several capacities for this leading edge identity solution provider, with customizable functionality for electronic registration, optimized for facilities and patients.

  • Developed software in ETL (extract, transform, load), utilizing various programs, including: MIRTH (HL7) channels, MSSQL, BI, Excel, Access, VB6, CSV, and scheduled jobs.
  • Created unique smart card system in Maine with two EMR (Electronic Medical Record) systems, CPSI and Centricity EMR. Created a mobile website and mobile client as a prototype for a very large client in Africa.
  • Devised a demonstration system for sales purposes, using the GE CPS Medical Program and the LifeMedID Smart Card program.
  • Transitioned email system from Google services to Office 365. Performed migration to Office 365 and managed the system. Repurposed available hardware.
  • As the Network Administrator, monitored the network to ensure secure, continuous, uninterrupted service. Identified weaknesses and any needed upgrades.


ALLIANCE HEALTHCARE (dba QUATRIS), Rocklin, CA    February 2003 – February 2013
 
Software Developer (ETL, MSSQL, Mirth Interface), DBA, Systems Administrator,
Programmer, Senior Support Engineer Other Carrier Experience

Once Alliance Healthcare Solutions, Quatris was created through a merger between Final Support and Alliance Healthcare Solutions, making it the largest value added reseller of GE Centricity, an EMR designed to interface with Practice Management and Electronic Medical systems.

  • Responsibly completed over 300 Centricity Practice Management and EMR installations, each requiring setup of SQL servers, terminal servers, and application servers. Prepared and maintained program installation documentation. Supported medical clients with a broad range of network and interface implementation services both local and remote
  • Completed over 100 Oracle to MSSQL Centricity EMR conversions.
  • Created over 300 TSQL scripts to diagnose and debug issues and to provide adhoc reports Trained staff in proper documentation, problem-solving, and system enhancements.
  • Produced a support website to distribute custom applications I wrote
  • Developed over 200 Mirth Interface channels required to Integrate systems ie. labs, PACS, process HL7 and XML, DiCOM, Export Various Text file formats, and read or update SQL databases.
  • As Senior Support Engineer, provided desktop support for approximately 12 individuals on GE Centricity, Networking, Integration and Mirth HL7 Engine.
  • Wrote 12 customized plugins to process Centricity billing (X12 837/835/ HL7 DFT-P03) to the clearinghouses of more than 800 insurance carriers, requiring in-depth knowledge of ANSI X12, Electronic Data Interchange.
  • Built and managed virtual machines to manage servers locally (VMware and Hyper-V) in ASP infrastructure.

Other Carrier Experience

California Federal Bank, Sacramento, CA, Sr. Business Systems Analyst

Western Sunrise Mortgage, San Jose, CA, IBM Systems Engineer, Programmer, Loan Origination Support

Education

Associate of Arts, Electronic Engineering, Monterey Peninsula College

 

Demonstrated Strengths

 Internet Technologies

·         System Engineer

·         DBA

·         Network Management

·         Integration

·         Mirth Interface

·         Interface

·         Mechanics

·         Programming

·         Policies and Procedures

·         Data Security

·         Multi-Platform Systems

·         Network Configuration

·         Data Recovery

·         Troubleshooting

·         Network Support

 Technical Expertise

Software:                    MS Office, VB6, Visual Studio, CodeOnTime, MIRTH, Terminals, Filezilla, Centricity PM/EMR, RedGate, Idera, ETL, LastPass

Languages:                 PowerShell, TSQL, Visual Basic, HL7, ASP, PHP, DOS, C#, JavaScript, ANSI X12, VBScript

Server Tools:              Windows Server Tools, SSMS, SSIS, Oracle 10-11G, MySQL 5.6, Oracle WorkBench, Visual DB, SQL Profiler, DTA, PerfMon, JumpDesktop

System Monitoring:    AppDynamics, Zabbix, Hobbit, SQLDm IDera, SQL Sentry, BigIP, 24×7, SOLR, SpiceWorks, Powershell

Performance Tools:    SQL Profiler, Performance Monitor, Resource Monitor