Data Engineer / DBA / BI Analyst
Resume:
ROBERT K. BOLES
******.*****@*******.***
INFORMATION TECHNOLOGY PROFESSIONAL with extensive experience in systems engineering, database administration and development, cloud-hosting technologies, security, web development, project management, support management, customer relations management, multi-media applications, and documentation. SKILLS
OS and Cloud: Windows, Linux (RHEL/CentOS, Ubuntu, Kali, Slackware), Microsoft Azure, Oracle Cloud, Google Cloud Platform Software: SQL Server (version 6.5 through 2022, all editions), Oracle Database (v.9 - present), MySQL, SSMS, Azure Data Studio, Azure Synapse/Fabric, Power BI, Azure Data Factory (ADF), Azure DevOps, Syteline, Docker, Kubernetes, Azure Resource Manager (ARM), Git, Active Directory, Qlik Replicate/Compose, Sentinel, Log Analytics, Datadog, Prometheus, Splunk, Nagios, SolarWinds, WireShark
Languages, Protocols, Frameworks: SQL, PowerShell, C#, .NET, TypeScript, JavaScript, Python, Go/Golang, Rust, Perl, PHP, React, Node.js, PyTorch, TensorFlow, BeautifulSoup, Selenium, HTML, CSS, XML, JSON, jQuery PROFESSIONAL EXPERIENCE
Enstar Group (SeaBright acquisition) Seattle, WA (Remote) Nov 2012 – Present Database Administrator Manager / Database Solutions Specialist Directed team of Database and SharePoint Administrators for large insurance corporation and its subsidiaries with many international locations. Primarily responsible for 400+ SQL Servers instances hosting 7500+ databases and data warehouses ranging in size up to multiple terabytes.
Responsible for design, implementation, licensing, and ongoing maintenance for Microsoft SQL Server on Windows, Azure SQL Managed Instance, Azure SQL DB (including elastic pools and serverless), Oracle on Linux servers and OracleCloud.
Successfully reduced technical debt by 75% through system demises, consolidations, and optimizations.
Orchestrated strategies to maximize cost benefits, including server decommissions, SKU downgrades, and database migrations to more cost-effective Azure SQL technologies.
Developed PowerShell modules and cmdlets to manage CMDB and inventory management tasks, patch management, event monitoring, backup management and monitoring, security audit, performance metrics, and other administrative processes.
Designed and implemented several high-availability, disaster recovery solutions based upon Always on Availability clusters. Implemented replication solutions using Microsoft native options and Qlik (Attunity) Replicate.
Created comprehensive documentation for various procedures and systems, including ERDs and data dictionaries. Conducted knowledge-sharing sessions and provided guidance and mentorship for team members. SeaBright Holdings Phoenix, AZ (Remote) Dec 2008 – Nov 2012 Senior Systems Engineer / Database Administrator
As the sole DBA on a small core team of four Systems Engineers, supported the complete infrastructure for a medium-sized insurance company and its subsidiaries. The company was configured as 13 branch offices with a centrally located primary datacenter and a secondary warm disaster recovery datacenter.
Primarily responsible for 30+ SQLServer 2005, 2008R2 servers hosting databases.
Responsible for design, implementation and ongoing maintenance for 180+ Windows servers and 4 Red Hat Enterprise Linux servers. This included both physical servers (HP and Dell) and virtual servers running on VMware ESX.
Supported storage infrastructure hosted on EMC Clarion CX3 and then migrated to Dell EqualLogic.
Administrator for internally and externally hosted client and application servers including a Citrix XenApp 4.5 farm of 90+ servers, IIS 6.0 - 7.5 servers, Microsoft Team Foundation Server, FICO Business Rule Management servers, SunGard Enterprise Accounting Servers, Symantec Total Management Suite (Altiris) servers, Microsoft DFS enabled file servers, and other "home-grown" and off-the-shelf application servers.
Administrator for Backup and Recovery using Backup Exec, Veeam, Mimosa, RedGate, and ExaGrid technologies. Successfully completed DRP/BCP testing annually without incident.
Served on the change-control board performing code review, risk mitigation and planning procedures for all system changes including system configuration, database changes, and application development.
Executed domain admin duties including Active Directory administration, DNS configuration management, and system patching using WSUS, Shavlik and VMware vCenter Protect.
Developed PowerShell cmdlets, VBScript, and Batch scripts to automate administrative tasks and reporting. ROBERT K. BOLES
******.*****@*******.***
PROFESSIONAL EXPERIENCE (continued)
Capgemini Phoenix, AZ Oct 2006 – Apr 2008
Senior Lead Database Administrator
As Senior Lead Database Administrator my responsibility was installation and maintenance of client’s servers hosted in the Capgemini datacenter. I maintained all aspects of software and hardware for approximately 60 physical and 30 virtual servers (MS Terminal Server, SQL 2000 database servers, various application servers.) The core application supported was Syteline, an Enterprise Resource Planning application used by approximately 1000 end users.
Primary database administrator for over 200 Microsoft SQL 2000 databases ranging up to 250GB in size.
Utilized system monitoring utilities such as Solarwinds, What’s Up and Nagios.
Implemented custom backup and restore maintenance plans utilizing SQLBackup.
Implemented EMC SAN system to improve disk performance and storage capacity.
Designed and implemented change management protocol for SOX compliance. Database Consultant Phoenix, AZ Sep 2005 – Dec 2008 Database Developer / Administrator
Developed and administered database solutions across multiple short-term contract positions, including roles at The Arizona Republic, Honeywell, and Ryland Homes. These roles involved designing and implementing enhancements to existing database systems, developing new database objects, and performing data migration and conversion.
The Arizona Republic: Engineered enhancements for the Draw Messenger application and Sybase ASE database system, creating database objects such as tables, stored procedures, and triggers, and tuned procedures for performance optimization. Developed shell scripts to perform batch data migrations and synchronization between multiple Sybase databases.
Honeywell: Maintained several applications and database servers running Microsoft SQL 2000, performed system monitoring, performance analysis, and tuning on mission critical databases.
Ryland Homes: Engineered a data conversion process to migrate and merge data from Ryland Homes National Customer Service and Warranty databases (Access 2000) and JD Edwards (AS400) to a new Onyx CRM database (MS SQL 2000). This involved utilizing MS-DTS and T-SQL to create approximately 50 stored procedures, SQL scripts, and transformation packages, transforming customer data from over 30 divisions into a single SQL 2000 database.
Across these roles, utilized T-SQL, DTS, and shell scripting to develop data conversion processes and automate tasks. Conducted performance analysis and tuned databases and procedures for improved efficiency. Musicmatch, Yahoo! Inc., San Diego, CA Oct 1999 – Aug 2005 Technical Support Manager / Operations Manager
Directed technical support and billing support department personnel for a pioneering MP3 music software company. Oversaw customer-relations management (CRM), defect tracking, and quality of service monitoring systems.
Administered IIS and SQL servers hosting multiple support operations databases and websites, ensuring 99.99% uptime. Engineered backup and disaster recovery plans.
Designed physical and logical data models from business requirements and developed custom database schemas for CRM and support diagnostics applications. Modified existing databases for data integration.
Developed DTS packages, stored procedures, and T-SQL scripts to migrate and transform data between multiple data sources.
Developed multi-dimensional dynamic online reports and web-based admin interfaces, utilizing technologies including SQL, OLAP, ASP, JavaScript, VBScript, and Flash.
Monitored, analyzed, and debugged systems using SQL Profiler, Query Analyzer, and Microsoft Performance Management Console.
Documented product plans, requirements, training materials, support policies, and knowledgebase articles.
Designed and utilized custom diagnostics telemetry system to analyze usage and quality patterns from application installations worldwide.
EDUCATION
Major focus: Chemical Physics
Schools attended: University of California San Diego San Diego, CA 1999 – 2001 Palomar College San Marcos, CA 1997 – 1999
Contact this candidate