DBA / Developer/ Architect / Data Analyst

Rian Gilbert Hage ad5o32@r.postjobfree.com Tel. 917-***-****

SUMMARY

Expertise in Database Administration & Security, T-SQL, Performance Tuning and Optimization, VLDBs, Data Analysis, Database Architecture, High Availability & Disaster Recovery, Logical & Physical Design, ETL, Unix/Linux & Windows systems, coding and Shell scripting.

6+ years of Professional Services Consulting at a Fortune 100 company and a start-up, Pre-sales and Post-sales Support. Expert in IBM Guardium Data Activity Monitoring (DAM). Applications background in Trading Systems, Financial, Legal, Insurance & eCommerce.

IT Contractor (10/14 – 12/23)

HRSA

Developer/ DBA

• Safeguarded and encrypted production databases, masked sensitive data, and minimized locking and deadlocks in Production environments.

• Re-wrote and tuned reporting queries for performance (at time by x50), automated refreshes of several lower environments and managed AG.

Monat Global

DBA/ Data Analyst + Developer

• Administered Production database servers 24/7 operations for online e-commerce, ETL and reporting, on premise and Azure environments. Set up and maintained Availability Groups (AG) for HA/DR, and SQL Replication.

• Troubleshot and resolved long running processes, blocking, locking, deadlock & concurrency, tempdb & transaction logs, storage and other resource contentions, applications, I/O, Memory, CPU, disk and network.

• Improved performance of apps and complex report queries and optimized throughput by > 40% via query tuning, proper indexing, server configs and execution plans.

Microsoft Corp.

Data Engineer

• Designed and implemented the onboarding/ingestion of data from SQL Server databases into Azure Cosmos DB.

• Managed the execution of data extract, data generation, and deployment; diagnosed and resolved failure issues.

• Created improvements in automation and ensured pipeline processes completed within SLA.

• Member of Data Engineering responsible for the data integrity and reliability of ETL pipelines for XBOX. New Classrooms Innovation Partners

Sr. DBA/ Architect

• Provided 24/7 and subject matter expert support; monitored and resolved server/database issues, optimized queries and plans, indexes, schemas & SQL Server configurations; performed code reviews and assisted in T-SQL.

• Installed, configured, patched, troubleshot, monitored, optimized, set up and maintained HA & DR solutions (Failover Clustered Instance & Always-On Availability Groups), Security, backup/recovery schemes and encryption.

• Defined and automated processes, ETLs, issue tracking, and documented the database environment w/ Dataedo. Pro Teck Valuation Intelligence

Data Warehouse DBA/Data Analyst

• Administered, maintained and supported multiple SQL Server production servers databases with 60 TB.

• Performed tuning and troubleshooting of database and application server processes, developed and optimized T-SQL stored procedures/ triggers, and SSIS packages.

• Implemented High Availability using Failover Cluster Instance (FCI) and Always-On Availability Group (AG).

• Performed capacity planning, migrations, backups and data recovery, automated administrative and data integrity tasks, created deployment scripts.

• Perform T-SQL Code Review and code releases using Agile Project Development Methodologies, directed 3 junior DBAs, and assisted the Dev team with T-SQL.

World Wildlife Fund

DBA/ Analyst + Developer

• Supervised 3rd party vendors (Blackbaud CRM & SAS) to integrate their applications with in-house databases, applications and business operations.

• Configured and maintained database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

• Set up Disaster Recovery and SQL Replication, and mentored the Dev team on writing T-SQL. End Contracts

JPMorgan Chase & Co. 2/13 – 9/14

Ops Tech Lead (Guardium)

• Presided the global roll-out of the IBM Infosphere Guardium infrastructure and database on-boarding process, built the architecture and set up Guardium monitoring in the Production/ UAT/ DEV environments.

• Maintained the Guardium incident management, patch management, change and request management.

• Tracked key performance and capacity metrics to ensure the on-going uptime of the infrastructure of the appliances.

• Designed custom reports to use data from application repository along with Guardium data, and facilitated the review and audit for regulatory compliance.

• Performed testing and certification of the software component of Guardium (STAP) for Sybase, Oracle and MSSQL.

• Teamed up closely with Network Provisioning to install the taps/tap Aggregators and connect them to the Collectors. Howrey LLP + Ropes & Gray, LLP 2/08 – 1/13

Sr. DBA/ Database Architect + Developer

• Managed multiple instances of production SQL Server 2K-2012, including installation, configuration, patching, replication, indexing, backup/recovery, capacity planning, HA & DR solutions (clustering, log shipping, db mirroring).

• Performed tuning and troubleshooting of database and application server processes, developed and optimized T-SQL stored procedures and triggers - gains achieved were 50x at times.

• Analyzed technical requirements, designed new data model and developed an application for 'Patent Tracking', for which I was the recipient of the prestigious annual Star Award in 2010.

• Developed scripts to automate database management processes; wrote and maintained technical documentation, defined & enforced database standards, practices and methodologies.

• Monitored database capacity, identified potential data growth, assessed current virtual hardware and software performance and capacity loads, and proposed solutions in a proactive manner.

• Built, deployed and maintained SSRS & SSIS artifacts and designed and generated reports using BIDS. Guardium, Inc. (acquired by IBM in 2009) 10/03 – 12/07 Professional Services Consultant Engineer

• Managed onsite implementation and system integration of Guardium software security of this Linux-based network appliance that safeguards databases, facilitates Audit & Compliance, and addresses regulatory compliance (SOX).

• Provided outstanding customer service during engagements by troubleshooting complex technical situations, and resolving issues, problems and concerns to customers' satisfaction.

• Performed pre- and post- sales technical presentations, support and customer training as needed per engagement.

• Responded to technical components of Request for Proposal (RFP) and Request for Information (RFI).

• Identified, isolated and reported bugs in Guardium software that were fixed by interfacing with QA and Development; proposed few improvements that were implemented.

• Acquired and maintained expert knowledge of Guardium products and implemented solutions for over 50 customers.

• Provided timely and professional customer interaction (verbal, written or Webex) and solicited customer feedback to improve service and respond to customer requests and ideas.

• Created and maintained a knowledge-based system, technical documentations, best practices and methodologies.

• Gained proficiency in MySQL, the RDBMS in this appliance-based technology, and was the internal MySQL Development DBA.

Mint Investment Management Company 10/98 – 4/02

Developer/ DBA/ Analyst

• Developed and supported trading systems for the Futures, Forex, Options, and Equities of a Hedge Fund. Applications included Price Collection, Trading Signal and Order Generation, Slippage Reporting, and P&L reporting.

• Managed a production environment consisting of 30+ databases, and 10 production workstations, with large data load cycles and OLTP-based mission critical trading systems.

• Administered Price Collection operations and oversaw daily operation of batch systems for portfolios totaling $800m.

• Engineered a database and code migration from Informix-SQL/4GL to Sybase using T-SQL, ‘C’ & DB-Library.

• Built UI/UX (PowerBuilder) for a Risk Management System that enabled analysis of trading positions.

• Performed Database and System administration for the distributed client/server environment: a network of 30 Sun SPARCstations running NFS/NIS and a hot Sybase site.

• Extensive experience with the following systems: SYBASE (T-SQL, APT-SQL, DB/Library), PowerBuilder, Sybperl, Solaris, Bash & Korn & 'C' Shells, awk & sed.

IBM Global Services 4/95 - 9/98

IT Architect/ Specialist (Professional Services Consultant)

• Reengineered mainframe insurance apps and converted VSAM files to run on SUN Ultra E6000 (36-nodes SMP under Solaris) with SYBASE 11 and an IBM SP (MPP architecture under AIX) with IBM DB2.

• Engaged appropriate technical resources during the pre-sales process, and performed data modeling, database administration, performed data conversion, data migration, data analysis and data transformation.

• Was a major technical influence in the sale of IBM SP hardware and DB2 Parallel Edition RDBMS to Prudential.

• Provided technical support in sales presentations and sales support, and prepared sales proposals for IBM hardware and software solution systems.

EDUCATION

Boston University

M.S. Computer Information Systems

Northeastern University

B. S. Computer Science (Graduated with Honors)

Académie de Nancy/Metz, Nancy, France

Diplôme de Baccalauréat Français

TECHNICAL SKILLS

• Databases: Sr. DBA -> MS-SQL Server v7 - v2019

DBA -> MySQL 5, Sybase ASE, Oracle 11, IBM DB2, Informix RDS, MS-Access, PostgresDB

• Analytics & CRM : SAS Administrator, Blackbaud Raiser’s Edge Administrator/User

• Languages: T-SQL, PL/SQL, 'C', Informix 4-GL, HTML, VBA, XML, SybPerl, Unix/Linux Shells, PowerShell

• O/S: Windows Server, Solaris, AIX, Mac iOS, Linux

• ETL: IBM InfoSphere DataStage, Informatica ETL, Microsoft SSIS

• CASE Tools: ER/Studio, RAD Studio

• Cloud Migration & Storage: AWS DMS, AWS S3, Azure Blob Storage

• Software Dev Tools: Azure DevOps, Git, Bitbucket

• Reporting Tools: Microsoft SSRS & Power BI

• Cloud Technology: Azure SQL, Azure Data Factory, Azure Synapse

• Collaboration Tools: Jira, Confluence, Slack, Teams, Zendesk

• Enterprise Tools: Red Gate, VMWare, Quest LiteSpeed

• Monitoring Tools: SolarWinds DPA & SQL Sentry, Quest Spotlight

Contact this candidate