Professional Experience

Oct.**** to Current day- City of Autora, Colorado, USA

(City of Autora, Colorado, USA)

Database Engineer (DBE)/Senior Sql Developer responsible SQL Server and Oracle DBA, NetApp and SAS Statistics under UNIX, Windows, VMware platform

Essential Functions

SQL Server DBA 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

Schedules database maintenance and upgrades

Configures SQL Server monitoring utilities to minimize false alarms

As new systems are brought in-house, selects whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies

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 )

Deploys database change scripts provided by third party vendors, modify scripts accordingly mostly powershell, create necessary ETL packages

When performance issues arise, the SQL Server DBA determines the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes (optimize performance, work with solarwind engeener for purge etc.)

Creates and maintains documentation of the company's database environment

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

Defines and implements database-related policies, practices, and guidelines

Assists Development and Data Architecture in sizing new data sources

SQL Server DBA maintains/analyzes database growth trends

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

Keeps apprised of industry-wide best practices and the latest tools for monitoring various database usage

Multi-Terabyte, 24x7 up time databases as a Systems/Infrastructure

SQL Server DBA will be 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

Ensures all database servers are backed up in a way that meets the company's Recovery Point Objectives (RPO) prefered approved tools Commvaults and sql server, moniroring tools DPA from Solarwind

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

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

Schedules database maintenance and upgrades: Periodical verification and validation of Backups tapes or filesystem or AWS.

Configures SQL Server monitoring utilities to minimize false alarms

As new systems are brought in-house, selects whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies current project is a migration from On premises into VMWARE cluster

Installs and configures new SQL Servers 2019 VMs

Deploys database change scripts provided by third party vendors

When performance issues arise, the SQL Server DBA determines the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes

Creates and maintains documentation of the company's database environment

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

Defines and implements database-related policies, practices, and guidelines

Assists Development and Data Architecture in sizing new data sources

SQL Server DBA maintains/analyzes database growth trends

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

Keeps apprised of industry-wide best practices and the latest tools for monitoring various database usage, like high level security using Lastpass, and encryption delivery via Sftp with Kleopatra or Winscp.

Advanced knowledge of Microsoft SQL Server, to include SQL Always On, log shipping, clustering, and maintenance plans (Migration of On-premises into VMWare CAD). Configure a PolyBase cluster that lets you set up scaled-out groups. Scaled-out multiple sources to to provide parallel processing to handle huge quantities of data at a quick speed from multi databases and plateform windows (SqlServer) vs Informix (Unix).

Strong knowledge of RDBMS in order to help developpers with performance issues.

Experienced with Microsoft SQL 2016/2019 administration

Familiarity with Microsoft Azure SQL Services and automating database monitoring and alerting tools

Experienced with Data Warehousing databases.(Data migration from Informix/Db2 into Sqlserver2019)

Experienced with SQL database relication and mnitoring tools (Exagrid replication and Solarwind Orion)

Required to pass yearly Certification of HIPAA, Advanced Police Security CJIS (Criminal Justice Information Service)

Excellent analytical and troubleshooting skills (Using DPA,Cherwell)

Understanding of disaster recovery principals and implementation tools, technologies, and method (Mainly Commvault technologies)

Demonstrates support for the company's mission, vision, and values with strong verbal, written and interpersonal communication skills

Strong Analytical and organizational skills

Always demontrated greatv ability to work both independently and as part of a team

Required to manage or help with management of multiple priorities and projects with tight deadlines (Very intensive schedule often week end call duties)

Oct.2007 to August 2021 - Primed Management Services/Hill Physicians Medical Group

(San Ramon California, USA)

Database Administrator (DBA) and Developper responsible SQL Server and Oracle DBA, NetApp and SAS Statistics Administrator and Developer under UNIX, Windows, VMware platform

DBA responsible for security and in charge to analyze, develop, test and implement the Data warehouse for the network of Primed. 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

Multi-Terabyte, 24x7 up time databases as a Systems/Infrastructure.

SQL Server DBA (admin SQL,SSIS,SSRS,SSRS servers instances), AlwaysOn, WFSC responsible for all internal Server On Premise or Virtual under VMWARE environment/Vsphere, EXSi, SnapClone,, NextGen, EPIC

Design logical and physical data models aligned to business use cases, Snowflake, Synapse, AllwaysOn, Security/Roles, Statistics and Execution plan, Agile, OEM, ExplainPlan/DBMS_XPLAN. ADW,ADDR,ASH

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

SAS (Statistical Analysis System) servers Administrator 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, implement SAS/ql-server PYTHON/R analytical models (RevoscaleR PY Olap and,MicrosoftML, Azure Data Migration Assistant (DMA),Dedicated SQL Pool (SQL DW), ISPS ( Ingest /store /Prep /Serve), ADM, SMP-Numa/MPP-Shard Processing

Statistics data analytics, develop and test SAS code and macro Programming and SAS enterprise guide Administration : Installation/management of SAS servers

Polybase data virtualization support Cloudera (ambari)/CDF/HDF using Hadoop/Big Data/NO SQL for data transfer into SQL/Server DataWare house, POLYBASE data supports.:Leverage two Hadoop providers: HortonWorks Data Platform (HDP) and Cloudera Distributed (CDH )using Hadoop, HDFS, Hive, Impala NOSQL, Cassandra NoSQL database migration. ORACLE/SQLServer migration to Azure

.Experience in creating, coding, and implementing relational databases.

Database modeling, architecture design, development, backup & recovery, and administration.

Data modelling and design of database, creating new relational data models, analyzing data performance problems.

Experience in building new relational data models, tables, views, functions, grants, triggers, stored procedures, indexes, and other database components.

Professional level of experience on all major databases SQL queries troubleshooting, debugging Stored procedures, identifying Blocking sessions in backend, complex joins etc.

Great knowledge on any job scheduling tool, Control M would be added advantage.

Experience programminand and managing major databasea like with Oracle, MySQL, SQL Server, Oracle PL/SQL, DDL, DML, SQL queries.and troubleshooting performance issues with long running queries, tuning, optimization of queries

TABLEAU Servers Administration: using 3 node clusters Zookeeper, Massive Parallel Processing (MPP) and POSTGRESQL database, EUC/VDI

BI-express management, Quest Toad, Biztalk, HL7,Symmetry,,SPLUNK -NoSQL-CAP DB System

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

Commvault., NetApp/ONTAP (cluster,qtree,aggr) SAN/NAS/, Flex clone.WAFL, Raid, Iscsi, Cifs, SnapVault, FcoE, SnapMirror, WAFL,,FLEXPOD Deduplication.

Backup and Recovery using Oracle Recovery Manager (RMAN), NetBackup: NetApp core Snapshot™ and disk-to-disk replication, Commvault,Netapp Snapmanger/SnapshotCopies

PRISM and Workday Control system, JIRA

Oracle Real Application Clusters (RAC), Automatic Storage Management (ASM), Active Data Guard and Oracle Enterprise Manager Grid Control(OEM)/OEM Cloud Control (OEMCC)

Code version control and Patches/code deployment: PRISM/JIRA/SCCM/SMS/OPatches

Analyse, develop, implement data in batch input files using Linux commands(Cshell,Perl)

Be proactive in identifying, document, resolve technical issues

Archive/Knowledge base in PRISM/JIRA

Installed and configured disaster recovery systems in proper manner.

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.

Participated in volume migrations and developed igroups.

Created SQL queries, batch scripts and mappings.

Support the cDOT Flash Pool, SAN/NAS environment w/6 - node clusters.

Provisioning storage for SAN and NAS clients, including creating volumes, LUNs, CIFs shares & NFS exports.

Configured new nodes and new clusters including aggregates, SVMs, LIFs, ASUP and more. ]

Performing SnapMirror migrations of NAS volumes from 7-mode NetApps to cDOT clusters.

upporting multiple data center environment doing replication, deduplication and compression Supporting/configuring SnapMirror replication to remote filers/data centers.

erforming 7-mode DATA ONTap upgrades from 7.3.x to 8.2.4P4.

NetApp systems include FAS8040s with a mix of SSD, HDD drives, FlashPools, FlashCache also AFF 8080s with all SSDs.

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

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

August 2006 to Sept 2007 Hospital San Mateo County, Information System Department

(San Mateo, California, USA)

Oracle DBA, Data warehouse and ETL/ELT Administrator and Senior Sql Developer

Oracle DBA responsible for security and in charge to analyze, develop, test and implement the Data warehouse for the network of San Mateo County’s Hospitals (project HCDS). 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, Dataguard, 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

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.

2005 to 2006 Gerald Champion Regional Medical Center

(Alamogordo, New Mexico, USA)

Oracle DBA/Cerner Adminstrator

Oracle DBA 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 NetWorker

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

Oracle Enterprise Manager (OEM) . Backup Recovery policy/strategy RMAN/dpump, imp/exp, rsync, scp

Oracle Real Application Clusters (RAC), Automatic Storage Management (ASM), 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 for Database developers & the providers/clients.

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

Data ingestion/data storage/ETL

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.

Strongly Compliance/Implementation of HIPAA/DoD standards.

Languages

English, French and Spanish

Education

1983-1987 : Bachelor of Applied Economics

1987 : Diploma-computer programmer

1988 : Diploma-Accounting programming for computer

1989 : Diploma-Management Information Systems

1990 : Seminar-maintenance of Micro computer

1992-1994 : Master of Science-Computer Information Systems (MIS), University of Montreal

1994-1995 : Seminar-Management and Marketing Techniques

1995 : Seminar-Management & Accounting Computer systems

1996 : Courses-Novell and UNIX Administration

1997-1998 : Diploma-Intensive course – Oracle (Train the trainer).

2000 : Certification DBA Oracle

2005 : Cerner Certificates

2010 : Microsoft Certified DB. Administrator

2014 : NetApp ONTAP Certified Engineer (NCIE)

2014 : NetApp ONTAP Certified Database Administrator (NCDA)

Official Corporate Certifications Exams (Training Paid by companies)

Oracle Certified Database Administrator (2000)

Oracle Certified Master Developer (2000)

Cerner Cerner Infrastructure Deployment (2005)

Cerner Millennium database Administration (Oracle) (2005)

Cerner CCL (Cerner Command Language) (2005)

Cerner Discern (2005)

Cerner PowerInsight (PI) (2005)

IBM AIX Administration bootcamp (2005)

Microsoft Certified Database Administrator (2009)

Microsoft Certified Business Intelligence Developper (2009)

Microsoft Certified Database Developer (2009)

Developing Business Process and Integration Solution Using Microsoft Biztalk Server (2012)

SharePoint for Database Administrator (2012)

VMware vSphere Administration: ESXi, vCenter (2013)

NetApp/ONTAP Certified Data management Administrator (NCDA) (2014)

NetApp/ONTAP Certified Implementation Engineer (NCIE) (2014)

Related Courses/Training/Attestations (Paid by myself)

Programming Basic, Pascal, Cobol (1991)

Programming COBOL, RPG, PL/I and NATURAL,ADABAS (1993)

Applied Statistics and Econometrics with IBM SPSS (1992)

Unix System Administration (1997)

Ingres Database Administration (1997)

Oracle Java: Mastering Java for Beginners & Experts (2002)

Lotus Notes/Lotus Domino (2001)

IBM AIX Administration bootcamp (2005)

Master Microsoft PowerShell (2014)

Hadoop Developer Course with MapReduce and Java (2014)

Statistical Data Analysis with SAS (2015)

Regression Analysis for Statistics & Machine Learning in R (2015)

CentOS Linux Administration (2015)

SQL Server 2016 Administration (2017)

Cloudera CDH Cluster Administration 4 nodes Administrator Master Course(Hive, Impala-nosql, Hbase etc) ((2017)

Apache Zookeeper (Distributed Synchronization Services for tableau) (2017)

Statistics Masterclass for Data Science and Data Analytics (2018)

Database Services on Microsoft AZURE (2018)

Postgres Database: The Complete SQL Bootcamp (2018)

Advanced Analytics with R and Tableau (2018)

Applied Statistical Modeling for Data Analysis in R (2019)

Oracle Database 12C Architecture Administration (2019)

Microsoft SQL Server: Linux, Docker Hands-On (2020)

Python with Oracle Database (2020)

Machine Learning Basics - SQL Server 2017, R, Python & T-SQL (2020)

Incoming /Interest /R&D

Data Science: Machine Learning and Statistical Modeling in R (In progress)

MongoDB certification (in progress)

Python for Data Science and Machine Learning Bootcamp (In progress)

Python + SQL + Tableau: Integrating Python, SQL, and Tableau (In progress)

Oracle Database 19c/21c Multitenant (In progress)

Oracle Java for 19c/21c Multitenant (In progress)

SQL Server 2019 Administration (In progress)

SQL Server 2019 with Docker and Linux (In progress)

SQL Server 2019 Big Data Cluster with Kubernetes (In progress)

Microsoft Azure (in progress)

Contact this candidate