Sql Server Database Administrator

Ronald Riviere 925-***-****

IT Experience as Database administrator with implementation and Production\Application Support for critical application in a global 24*7 OLTP environment with SQL/ Oracle Administration.

Expert Experience in Database Architecture, Installation, Configuration, Maintenance and Administration of Oracle 10g, 11g,12g & SQL Server 2019, 2017, 2016, 2014, 2012, 2008R2, 2008, 2005 and 2000 in standalone and clustered environments.

Good exposure in subscribing the Azure subscription and setting up Azure for Organization.

Installs and configures and manage new SQL Servers VMs on Vmware, Vcad, Exagrid, configure retention time-lock, configure

Configure datastore using NetAPP-ONTAP and Backup using Veritas backup, RMAN, EMC Net Worker/EMC 2/Commvault LUN mapping/datafiles and datastore

Good security exposure of Citrix/F5/Unix/HP/Vmware Horizon/Azure

Provisioned and Configured SQL Server on Azure IAAS and PAAS Model

Configured and Troubleshoot High Availability and DR such as Geo-Replication and availability groups for Azure SQL database.

Secured Azure SQL databases: Firewalls, Authorization, Authentication.

Explored Advanced Security features and Auditing/DoD Training. Strong compliance to HIPAA/DoD standards.

Responsible for maintaining Master Server inventory with all the resources & Automated manual tasks using Power shell scripts.

Configured and scheduled an Index maintenance Plan on Elastic Database Agent Job For production databases

Experience in Pyton,R, Powershel, SAS Management Studio and SAS Base development, SAS Data Analytics Analytics/Reporing / Linux and Windows.

Exposure on creating the VM machines in Microsoft Azure and VMWARE: configured the transnational replication from Physical and VM servers to Azure SQL Server Database. Create Golden images and VMClone/Snapclones

Expertise in implementing efficient Disaster Recovery Strategies and High availability include Always On, Replication (Snapshot, Transactional and merge), Clustering (Active- Active and Active Passive), Log shipping and Database Mirroring (Sync and Async)

Good experience applying the GMSA service account to SQL Server services.

Expertise in configure, monitor and troubleshoot SQL server Always on High Availability in between the data centers and participated in DR test/create DEV/TEST servers environments on Vmware vsphere.

Experience implementing SQL Server mirroring and fail over with different data centers in different data domains .

Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler, Trace flags, Extended Events and other related monitoring and troubleshooting tools lide ider, solarwind DPA-Orion.

Experience in using SQL server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications, EDI.

Experience with scheduling tool and (Autosys/Tidal, Sqlserver Agent, Powershell, BournSHell etc), ServiceNow, Workday Integration

Experience on SQL Server reporting services(SSRS), creating subscriptions, configuring the SSIS reports.

Azure Dedicated SQL pool (Azure Data Warehouse: ELT/ETL, using Hash-Distributed Tables, Round Robin Distributed Tables, and Replicated Tables 88 ESTATES DANVILLE CALIFORNIA 94526

RONALD RIVIERE 925-***-**** *********@*****.***

Dedicated SQL pool, know all the distribution methods and how to use them (Hash- Distributed Tables, Round Robin Distributed Tables, and Replicated Tabl EDUCATION/TRAINING/CERTIFICATION

Master of Science-Computer Information Systems (MIS), University of Montreal, 1992 - 1994 Bachelor of Applied Economics and statistics 1983 - 1987 Certifications:

HIPAA Certification

Microsoft Certified DB. Administrator, 2010

Microsoft Certified Database Administrator, 2009

Microsoft Certified Business Intelligence Developer, 2009 Microsoft Certified Database Developer, 2009

NetApp Engineer 2014

NetApp Database administrator 2014

Oracle Certification DBA and Maser Developer, 2000 Master Microsoft PowerShell, 2014

SQL Server 2016 Administration, 2017

Apache Zookeeper (Distributed Synchronization Services for tableau), 2017 Microsoft SQL Server: Linux, Docker Hands-On, 2020 Machine Learning Basics - SQL Server 2017, R, Python & T-SQL, 2020 TECHNICAL ENVIRONMENT

Skills:

OPERATION SYSTEMS/Environment: Windows 2003, 2008, 2008r2/2012,2016,2019 and 2022 Server, Unix-AIX. Vmware Esxi,

NetApp Ontap

TOOLS: SQL server management studio, SQL server

configuration manager, SQL server tuning

advisory, SQL server profiler, foglight, idera,

toad, vsphere, Solarwinds DPA – Orion etc

Cloud : Microsoft Azure & AWS

LANGUAGES: C, C++, Core Java, SQL Server, T-SQL, SQL, PL/SQL

DATABASES: MS SQL Server

7.0/2000/2005/2008/2008r2/2012 & SQL Server

2014, Oracle 10G/9i, Informix, Postgress, MySQL

ETL TOOLS: Informatica and SSIS, Powershell and Bourne shell scripts, SAS statistical

OLAP TOOLS: Business Object, SSAS, SAS

88 ESTATES DANVILLE CALIFORNIA 94526

RONALD RIVIERE 925-***-**** *********@*****.***

MAJOR ASSIGNMENTS

City of Aurora, Aurora, CO Aug 2022 -

Database Engineer (DBE)/Senior SQL Server DBA

Responsibilities:

Responsible for the securing of databases to protect against unauthorized access (internal or external) at all levels (database, tables, schema, etc.)

Works closely with the Information Security team to ensure protection of sensitive data.

Ensure all database servers are backed up in a way that meets the company's Recovery Point Objectives (RPO).

Tests backups to ensure the business' Recovery Time Objectives (RTO) are achieved.

Troubleshoots SQL Server service outages as they occur, including after-hours and weekend.

Installation of SQL Server 2019\2017\2016\2014\2012\2008 R2 and DB migration from SQL 2000\2005\2008 to SQL server 2012\2014\2016\2017\2019\2022.

Active directory user data profile, and security management

Migrate SQL Server databases to Microsoft Azure hosted DBs, Managed instances.

Schedules databases and servers maintenance and upgrades.

Configures SQL Server monitoring utilities to minimize false alarms.

Perform database migration from On-Premises SQL environments to Azure Database in Cloud Managed database security and ensure database integrity and setup maintenance plans via SQL Agent.

Configure, monitor and troubleshoot SQL Server Always on High Availability in between the datacenter.

Design, implement, and maintain database schemas, tables, indexes, and views etc.

Configure, monitor and troubleshoot efficient Disaster Recovery Strategies and High availability solutions include Clustering (Active-Active and Active Passive), Log shipping and Database Mirroring.

Perform database upgrades, patches, and migrations as necessary.

Configure and monitor Transaction and merge Replication, resolved critical issues.

Configuration and Maintaining as part of a team SLA’s, analyzed the different high availability solutions and implemented database log shipping, mirroring and replication.

Installs and configures new SQL Servers on VMware, Vcad, Exagrid, configure retention

time-lock, configure profile and accounts, enable 2 factor authentication, with OKTA, configure trusted certificates for https )

Responsible for all internal Server On Premise or Virtual under VMWARE environment/vSphere, EXSi, SnapClone, AlwaysOn, WFSC NextGen, EPIC, SQL Server

(admin SQL,SSIS,SSRS,SSRS servers instances)

Deploys database change scripts provided by third party vendors, modify scripts

(PowerShell), create necessary ETL packages.

Setup and maintained the SQLMI servers on Microsoft Azure Synapse.

Active directory user data profile, and security management

Creates and maintains documentation of the company's database environment, ServiceNow, WorkDay Integration

Performs code reviews of stored procedures and other SQL being deployed into production

Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions As part of a team, established security policy using windows domain accounts and implemented a security strategy to protect against threats and attacks.

Provides expert SQL knowledge to Development in the areas of SQL capabilities and individual SQL statement usage.

88 ESTATES DANVILLE CALIFORNIA 94526

RONALD RIVIERE 925-***-**** *********@*****.***

Scripting languages PowerShell and Unix shell scripting

Ensures all database servers are backed up in a way that meets the company's Recovery Point Objectives (RPO) preferred approved tools Commvault’s and SQL server, monitoring tools DPA from SolarWinds

Experienced with Data Warehousing databases (Data migration from unix Informix/Db2, Postgress, Oracle into Sqlserver2019/Azure)

Effective knowledge transfer to technical and non technical end users through written and verbal communication and effectively communicate technical concepts to non-technical stakeholders

Great ability to quickly learn new business processes and related tools in order to integrate the entire studio operations and production business process.

Azure Synapse

Gainwell Technologies Inc., El Paso, NM Jun 2021 - Aug 2022 Senior Application Developer: C Programmer

Senior C Programmer Tin Technology Solutions Companies. This is role as a support the Medicare/Medicaid programs on revamping their entire reporting process. Responsibilities:

Main responsibility is to interchange implementation (modular interchange) and are looking for Programmers that are skilled in Unix, Oracle, and C Coding.

Another aspect consist to code, test, debug, implement, and document complex programs. As well to design systems and programs to meet complex business needs and assist with complex program problems.

PRO#C in database programming with an ability to design and develop database programs and procedures.

Unix and Oracle

C coding

SQL statements for data extraction and reporting

Medicare/Medicaid working with claims/eligibility/providers

Understanding of data modeling tools (Team is currently using Eclipse)

Excellent communication skills as they will be working with junior programmers, business analysts, and project managers.

Experience in scheduling tool and (Autosys/Tidal, Sqlserver Agent, Powershell, BourneShell etc)

Problem-solving mindset and quick learning curve with customer and business process, SCRUM agile approach

Hill Physicians Medical Group, San Ramon, CA Oct 2007 - Feb 2021 Database Administrator (DBA) and Developer

Responsibilities:

Responsible for security and in charge to analyze, develop, test and implement the Data warehouse for the network.

Responsible for all internal Server On Premise or Virtual under VMWARE environment/vSphere, EXSi, SnapClone, AlwaysOn, WFSC NextGen, EPIC, SQL Server

(admin SQL,SSIS,SSRS,SSRS servers instances)

Write stored procedures and complex queries/Joins, View vs Materialized view in cooperation with developers.

88 ESTATES DANVILLE CALIFORNIA 94526

RONALD RIVIERE 925-***-**** *********@*****.***

Planning and implementing Migration of on-premise SQL Servers to Azure as IaaS and PaaS and supporting and the cloud infrastructure.

SQL Server Remediation/Upgrades from lower version of SQL Server to SQL Server 2019.

Upgraded Standalone SQL Server 2012, 2014, 2016 instances to 2019 instance.

Upgraded up to 6 node cluster SQL Server 2014, 2016 instances to 2019 up to 6 node cluster instances.

Planning and Implementing of Migration of Monolithic MSSQL Database to multiple Microservices MySQL Databases to OCI.

Azure POC (PaaS, IaaS) for analyzing existing on-premise SQL Server vs Azure environment for SQL Server migration and application support for Azure implementation plan, this includes creating and managing migration plans, VMs, SQL Server Managed Instance, Storage, Creating and Monitoring Alerts, Managing Resource Group, data replication, backups and deployment of the environments.

Requirement collection, design, installation, configuration and troubleshooting of the SQL Server 2008, 2012, 2014 and 2016, 2019 Hi-Availability technologies like Always On Hi- Availability Groups, Mirroring and Log Shipping in OLTP environments.

Responsible for security and in charge to analyze, develop, test and implement the Data Analytics environment and Support necessary upgrades, CRUD data driven,Docker, microservices SAS/SQL-SERVER/SAS, SAS Viya 4.0 and SAS Grid platform administration.

Implement SAS/Sql-server PYTHON/R analytical models (RevoscaleR PY Olap and Microsoft ML, Azure Data Migration Assistant (DMA),Dedicated SQL Pool (SQL DW), ISPS

(Ingest /store /Prep /Serve), ADM, SMP-Numa/MPP-Shard Processing

Develop secured environment, using intensively REDHAT Unix, Implement RAC systems

(dev, test and prod) of 2 Nodes each. Use Oracle 10.2 g and 11g ASM, as well as under WINDOWS 2008/2012

Active Directory user data management

Design logical and physical data models aligned to business use cases, Snowflake,

Synapse, AlwaysOn, Security/Roles, Statistics and Execution plan, Agile, OEM, Explain Plan/DBMS_XPLAN. ADW,ADDR,ASH

Develop and test SAS code and macro Programming and SAS enterprise guide/SAS Admin Console Administration : Installation/management of SAS servers & Statistics data analytics.

Served as TABLEAU Servers Administration: using 3 node clusters Zookeeper, Massive Parallel Processing (MPP) and Postgress, EUC/VDI, BI-express management, Quest Toad, Biztalk, HL7,Symmetry,SPLUNK -NoSQL-CAP DB System. Management

Implemented IDERA and SolarWinds DPA (Data Performance Analysis), RedGate, Power Shell scripts automation and monitoring, Oracle Database Performance Diagnostic, Microservices implementation and coordination, Oracle Sql Developer

To support TABLEAU cluster and Analytic/reporting systems: we administered very large EDB Postgres DBs that involve: performance tuning / index maintenance experience of backing up and restoring EDB Postgress database on a regular basis. Designing and Managing EDB Postgress database schemas experience in Security access control experience with testing experience with configuration management experience with version control. Knowledge of fault detection and resolution processes. Hands on position responsible for configuring, integrating, and maintaining, Development, Staging and Production EDB Postgress databases. Responsible for all backup, recovery, and upgrading of EDB Postgress databases. Monitoring databases to optimize database performance and diagnosing any issues. Installation of tableau’s EDB Postgress cluster databases on OnPremices and Vmware.

Responsible for Backup and Recovery using Oracle Recovery Manager (RMAN), NetBackup: NetApp core Snapshot™ and disk-to-disk replication, EMC 2, Commvault,Netapp Snap manger/Snapshot Copies Code version control and Patches/code deployment: PRISM/JIRA/SCCM/SMS/OPatches Analyze, develop, implement data in batch input files using Linux commands(Cshell,Perl).

Installed and configured disaster recovery systems in proper manner. 88 ESTATES DANVILLE CALIFORNIA 94526

RONALD RIVIERE 925-***-**** *********@*****.***

Formulated and executed data backup systems and services.

Developed and implemented NetApp locations for virtual machines.

Prepared operational designs for NetApp and SAN systems.

Designed and developed NetApp and backup solutions.

Implemented SCOM solutions and monitored NetApp filters.

Responsible for creating Change Management requests for upgrades, migrations and other changes.

Experience EDI record support and Data Migration With NEXTGEN and EPIC

Work with the backup team to configure Veritas NetBackup NAS backups.

Intensively involed on Corporate project for database migration in clouds

(Azure/AWS/GCP) using Kubernetes.deploying distributed apps with containers (Docker)

& orchestration (Kubernetes, Kubectl commands, etc) managing production Kubernetes infrastructure.

Experience using and optimizing monitoring and trending systems (Prometheus, Grafana)

Experience in SAS Viya 4.0 and SAS Grid platform administration.

Strong understanding of SAS, Linux, and SQL.

Experience of programming and administrating and data migration with SAS. Hospital San Mateo County, San Mateo, CA Aug 2006 - Sep 2007 Oracle DBA, Data warehouse and ETL/ELT Administrator and Senior Sql Developer Responsibilities:

Responsible for security and in charge to analyze, develop, test and implement the Data warehouse for the network of San Mateo County’s Hospitals.

Develop secured environment, using intensively, AIX, LINUX SUSE 9 and 10, Implement 3 RAC systems (dev, test and prod) of 2 Nodes each (Iteration 1), use SAN environment, Use Oracle Database, GRID, Data guard, ASM, RMAN, OEM manager, WINDOWS 2006

(admin), SQL server, INFORMATICA version XI (installation, security, designer, workflow), BUSINESS OBJECT XI.(installation, universe builder, security), Load RUNNER, Suse Linux 9 and 10 (root admin), YaST2

Write/debug Shell Scripting Unix/Linux/Aix/Solaris using C, C++, Objective-C, R, Python, Pearl, Korn/Bourn Shell Scripting using C.

Implement HIPAA standard for security and privacy and HL7 interfaces system for crossing messages between systems, 3com, Xtender, FileServ management, Active Directory, OEM, RMAN, Import/export, Complex join and RDBMS, Views, Procedure and Packages, ADDM Analyzer for performance statistics, Advanced SQL and PL/ Sql report procedures & functions and optimization. Explain Plan/BMS_XPLAN.DISPLAY,Sql Trace/Tkprof

Oracle Enterprise Manager(OEM GRID control environment ), Oracle Data Guard environment with maximum security and confidentiality.(STIG/DOD and HIPAA)

Develop Unix, Dos scripts and PL/SQL Stored Procedures and Packages to access data from Oracle Databases with SQL and NoSQL capabilities.

Responsible to create oracle instances for universes and repositories as well as maintain B.O. security, Datawarehouse, Snowflake, Synapse, data migration,develop Shell/PS script for ops automation.

Data management and governance concepts and solutions – layered data-warehouse/ data lake/hybrid architecture, ETL framework (audit, balance & control, scheduling, logging and monitoring), Data Modeling (dimensional, data vault)

Manage log files and interpret them to analysis defects and issues in application

Train developer and end users. Presentation to decision makers. User Empowerment through EUC/VDI

Write technical documentation and prepare meetings to communicate new skills or issues to business teams

88 ESTATES DANVILLE CALIFORNIA 94526

RONALD RIVIERE 925-***-**** *********@*****.***

Code version control and Patches/code deployment: JIRA/System Center Configuration Manager (SCCM) and Systems Management Server (SMS),Workday.

24x7 remote support and on call Database support for Database developers & end-use. Gerald Champion Regional Medical Center, Alamogordo, NM 2005 - 2006 Oracle DBA/Cerner Adminstrator

Responsibilities:

Responsible for hospital secured environment, using intensively UNIX AIX on IBM RS- 6000, AS-400, DB2.

Used HIPAA standard and Cloverleaf HL7 interfaces system for crossing messages between systems, 3com, Xtender, Cerner clinical, Bmcpatrol, FileServ management, Active Directory, Veritas backup, RMAN, EMC Net Worker

Import/Export and Muse, Exchange, CCL, DVdev, Visual Explorer, Explorer Menu, Explorer Analyser, Discern Launch, ccloraindex, create object in CCLUSERDIR, Complex join and RDBMS, Views, Procedure and Packages, CCLCOST, CCLSQLAREA analysis, Explorer Analyzer for performance statistics, RHO of Database, Advanced SQL and PL/Sql report procedures & functions and optimization,Crystal Report.

Setup/Support for Dataguard, Cross plateform communication, Grid infrastructure automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and Active Session History (ASH)

Database migration change management and data management through the various stages of the development life cycle SDLC and system integration and security management and data integrity.

Data Quality/Control, Business Glossary/Metadata Management/Data Cataloging, Data Lineage, Data Security & Privacy, Data Governance and Stewardship.

PL/SQL and SQL queries for Oracle Batch processing system,AutoSys,OPatches

Wrote end user documentation and procedures, was involved for migration, database change management and data management through the various stages of the development life cycle and system integration and security management and data integrity.

Oracle procedure, function, and package design and creation, cross platform DB communication/links.

Oracle & SQL Server tools (OEM, Toad, Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs).

Write disaster recovery plans and project documentation or managerial reports

Support and on call Database support, and manage tickets for Database developers & the providers/clients with ServiceNow.

Database Sizing, Tablespace Management and UNDO & TEMP Tablespace Management, Transaction Management and Security Administration

Define electronic CRF/RDC/EMR/EHR : Case report form (CRF) and Non-CRF data, define data guidance such as Controlled Vocabulary, Study Data Tabulation Model (SDTM), Clinical Data Acquisition Standards Harmonization (CDASH), Analysis Data Model (ADaM), electronic CRF (eCRF), electronic source data, digital health record, DDC (direct data capture), electronic data capture (EDC), remote data capture, electronic clinical outcome assessment, electronic patient-reported outcome, electronic diary, apps, patient engagement, compliance adherence, medical application, electronic data transfer, data mapping, EHR (electronic health records), interoperability of format and sources etc…, convergence into HL7 Cloverleaf format and/or ETL into Oracle/Cerner ER/DUML environment,EDI electronic data record.

Strongly Compliance/Implementation of HIPAA/DoD standards.

CERNER Edi full support system is minilar to similar to Credential Stream 88 ESTATES DANVILLE CALIFORNIA 94526

RONALD RIVIERE 925-***-**** *********@*****.***

88 ESTATES DANVILLE CALIFORNIA 94526

RONALD RIVIERE 925-***-**** *********@*****.***

Contact this candidate