Database Administrator Data Architect

Devraj Beniwal

E-Mail: *******@*****.***

Cell Phone: 608-***-****

LinkedIn: https://www.linkedin.com/in/drb3644

PROFESSIONAL SUMMARY

17+ years of total IT experience as a years of IT experience as a Data Architect / Database Administrator (DBA) / Data Governance / Data Migration Consultant / Data Analyst / Data Scientist in Oracle (7.1 till 19c), CockroachDB (21.1.9 to 23.1.11), Yugabyte (2.1 to 2.20), Golden gate (11g to 21c). PostgreSQL (8.6 till 17.2) in Community, Databricks, GCP CloudSQL, GCP VM, AWS Aurora, AWS RDS, AWS EC2, Azure VM, Azure Citus Hyperscale, EDB along with tools Bart, PAM, Barman, pg extensions, pg_bouncer, Pgvector with vector indexes HNSW and IVFFlat, Automation / Scripting using Python, Ansible and Bash Shell.

Database Migration from Oracle to PostgreSQL, DB2 LUW to PostgreSQL from In-Premises to AWS EC2, RDS, GCP VM, Azure VM using Ora2PG, PL/PgSQL, Oracle_fdw, bigquery_fdw, s3csv_fdw, ora_migrator, orafce, Oracle scripts, Python scripts, Bash shell Scripts, AWS DMS, AWS SCT, Oracle Golden Gate, Pipeline ETL.

PostgreSQL Installation, configuration, Replication (physical/logical), Stand-by Read Replicas, backup, recovery, performance tuning, vacuuming, auditing, privileges, extension setup and configuration, upgrade (Major and Minor), foreign data wrapper, debugging, troubleshooting in in-premises Hybrid environment and in Azure Hyperscale (Citus) Multi-Node, AWS EC2/RDS, GCP VM/Cloud SQL, Azure VM on Linux Redhat, Centos 6/9 and Windows platforms.

Yugabyte DB Multi-node Installation with distributed data, Horizontal Sharding, Upgrade, Configuration of node level parameters of YB-Master and YB-Tservers, Replication setup, Raft group, dashboard log monitoring setup, LDAP and SSL setup, backup. Automation using Python scripting.

CockroachDB Customization at database, Instance, and schema level. Node level certificate and key pair creation and customization. Setting up scenario and data correctness, Fault tolerance and Recovery, Configuration CockroachDB database, sessions, statements, transactions, insights, Network latency, Hot ranges, jobs, schedules, debugging, Performance tuning, Backup / recovery.

Oracle Installation, upgrades, maintenance, backup & recovery (Data Pump, Hot, Cold, Logical and RMAN using Full, Partial, Until Time/SCN), Performance Tuning (Tkprof, Explain plan, AWR/ADDM reports, Advisers), refresh, cloning (OEM, Manual), troubleshooting (OEM, Toad, scripts, cron job), Oracle Standby/Data Guard (Physical, Logical, Snapshot, Active Data guard), Upgrades (Manual, DBUA) of Oracle application and Oracle core databases.

Golden Gate Installation, Configuration of Extract, Replication, Manager, trails, parameters. Troubleshooting and fixing issues of LAG, Mapping, performance etc. Used Golden Gate Monitor, Studio and Veridata.

Working knowledge of Oracle 21c, Oracle 23ai, Immutable table, Blockchain table, Hybrid Columnar Compression (HCC), Vector database PineCone, Chroma DB, Vector Search indexes, vector embeddings (Semantic Search, Image search, Audio search, Recommender Systems, Anomaly detection), vector index algorithms (Random Projection, Product Quantization (PQ), Locality-sensitive hashing (LSH), Hierarchical Navigable Small World (HNSW)), K-NN and ANN Algorithm, Metadata Pre-Filtering and Post-Filtering with vector search, Eventual consistency and Strong consistency of data Replication, Automate Backup of data and specific vector indexes into collections, LangChain framework including components/libraries/utilities (langsmith, langserve, langchain-community, langchain-core, langchain-experimental, langchain-cli), Jupyter notebooks, JupyterLab, JupyterHub, Voilà, LLM Chain model using integrations Ollama, OpenAI integration package, Anthropic package and Cohere SDK package, Databricks.

Provided round-the-clock support to maximum 2618 databases having 668 productions for one of the client Motorola.

Domain knowledge of Retail (Retek – subsidiary of Oracle), Government, Telecom, Transportation, Civil Engineering, Health sector, Artificial Intelligence and Banking applications.

ACADEMIC BACKGROUND

M.Tech (Master of Engineering) from Indian Institute of Technology (I.I.T.) Roorkee, India

M.E (Master of Engineering) from Punjab Engineering College, Chandigarh, India

B.Tech (Bachelor of Engineering) from K.N.I.T. Sultanpur, UP, India

CERTIFICATION / TRAINING

Azure Cloud Certified (DP-900) (Certificate # H509-7065)

URL: https://www.youracclaim.com/go/9g0dH7dSTR0j7FSjdDg69Q

AWS Cloud Certified Database Specialty (Transcript ID: LNLnsw2zZkK7cpMPPxBj_A2)

Oracle DBA Certification (Oracle University Prometric ID: PR0075381)

PostgreSQL DBA Certification (Brain Measure Transcript ID: 84815)

GCP AlloyDB Instance Data Management Certificate

URL: https://www.credly.com/go/eDYGwBkJSwtR24IgB2cpCw

OCI Foundations Associate (Certificate # IZ0-1085-23) Oracle Testing ID: OC5108428

Cloud Analytics Architect (URL: https://verify.skilljar.com/c/nqywrkk7k3y7 )

Cloud Analytics Master (URL: https://verify.skilljar.com/c/s45aqt34ymkm )

Yugabyte Certified – Yugabyte DB Fundamentals – Associate

Introduction to Distributed SQL - https://www.credential.net/59c22734-5c96-41c4-b64f-17a8257cc279

Introduction to YugabyteDB - https://www.credential.net/4aa4361c-586a-45f7-a821-51de86e44468

YugabyteDB Managed Basics - https://www.credential.net/ae6ace48-6be6-497e-a2a0-09e5ce0579ac

YugabyteDB Fundamentals - https://www.credential.net/98ee8a7a-06c4-4379-bbea-6f78ef10e9d6

YugabyteDB DBA Fundamentals - https://www.credential.net/28289fc6-a077-4e48-afe0-90fd332d05df

YugabyteDB DBA Fundamentals Exam - https://www.credential.net/3f2e395b-fb0e-44ba-b90e-d8f251d67633

Yugabyte Certified – Yugabyte DB YSQL Advanced

URL: https://www.youracclaim.com/go/9g0dH7dSTR0j7FSjdDg69Q

Best Thesis award during Master of Engineering from Indian Institute of Technology (IIT) Roorkee,

India in 1996.

TECHNOLOGY STACK

Database:

PostgreSQL 9.1.1 to 17.2 (Community, EDB, Aurora, RDS, CloudSQL), Oracle Core 7.1 to 19c, Oracle RAC 10gR2 to 19c, Oracle 23ai, CockroachDB (21.1.9 to 23.1.13), Yugabyte DB (2.1 to 2.2), Azure Hyperscale (Citus) Multi-Node PostgreSQL, Golden Gate

Languages / Tools

Unix Shell Script, Python 2.7-3.8, Psql, SQL*Plus, PL/SQL, PL/PgSQL, Pro*C, Ansible, OEM, dbconsole, Tivoli, Oracle RAC, RMAN, AWR, ADDM, ASM, ACFS, Statspack, Tkprof, Data guard (Physical, Logical, Snapshot), Server Manager, SQL*Loader, dbca, GCP Dataflow/ Cloud pub sub/ Cloud SQL/ Cloud Storage/IAM/ VM/ bq/ gcloud/ gsutil, AWS S3/ EC2 / DMS / IAM / SNS / SCT / Pipe/ Glue, Azure VM, Storage, Pgadmin III, IV, Postgres EDB, Brat, Barman, ora2pg, Oracle_fdw, bigquery_fdw, s3_fdw, s3csv_fdw, orafce, ora_migrator, Rapid wiz, Cockroach SQL, CockroachDB Consensus Protocol, CockroachDB dashboards, CockroachDB MOLT, CockroachDB Raft Logs / Groups, SRID, ORM Framwork, yugabyted, ysqlsh, ysql_dump, YSQL, YCQL, yb-master, yb-tserver, yb-admin, Yb-ctl, Kintana, Retek RMS 9.x, Hasura, GraphQL, GGSCI, Oracle Golden Gate, Oracle GoldenGate 21.3 for PostgreSQL on Linux x86-64, Golden Gate Director, Veridata, Toad, Erwin, Datadog, DBmarlin, Kibana, pgtune, pg_bouncer, pgvector, HNSW, IVFFlat, PineCone, Chroma DB, LLM Chain model, Ollama, Anthropic, Cohere SDK, K-NN Algorithm, ANN algorithms, LHS, PQ, LLM Chain model, LangChain, langsmith, langserve, langchain-community, langchain-core, langchain-experimental, langchain-cli, Jupyter notebooks, JupyterLab, JupyterHub

Operating System

Windows Server 2003/2008, Windows2000/98/95/NT/Vista/XP, MS-DOS, UNIX, AIX, Sun Solaris, HP-UX, Linux Radhat, Centos-6/7, Ubantu, AWS EC2/RDS, GCP VM/Cloud SQL, Azure VM

Domain Knowledge

Banking, Finance, Retail, Travel, Transportation, Government, Civil Engineering, Cloud

PROFESSIONAL EXPERIENCE

Employer / Clients:

DAKSB LLC from Apr 2023 to till date

-Wells fargo /Merge IT

-Conduent / Inspyr Solutions

-HCA Healthcare

-State of Wisconsin - DOT

Nutanix from Feb 2022 to Mar 2023

Wipro Ltd from Jun 2019 to Jan 2022

-Best Buy

-US Bank

Concept Software & Services from Jun 2014 to May 2019

-BlueCross BlueShield

-Omnitracs LLC

-Caterpillar

-John Deere

-State of Maryland – DHS

-State of Wisconsin – DET / DOA

Title: Cloud Backend Data Architect, Database Administrator (DBA), Migration Consultant, Data Scientist, Data Governance, Data Analyst of PostgreSQL, CockroachDB, Yugabyte DB, Oracle, Golden Gate

Responsibilities:

-PostgreSQL database creation/configuration/maintenance into local (Community PostgreSQL) and AWS cloud storage (Aurora PostgreSQL and AWS RDS PostgreSQL) following client level policies, rules and securities.

-Standby setup/configuration of PostgreSQL from In-house Redhat Linux server to AWS cloud (EC2).

-Database migration from Oracle to PostgreSQL into AWS EC2 and GCP VM using AWS SCT, AWS DMS, Ora2Pg, orafce, ora_migrator, oracle_fdw, bash shell, Python scripts, Ansible scripts and Coding/ Converting Oracle shared procedures in PL/SQL to PostgreSQL PL/PgSQL

-Linked Oracle database tables into PostgreSQL database using foreign data wrapper oracle_fdw

-Data migration from DB2 LUW to PostgreSQL (EC2 and RDS) and setup/configuring applications with in-premises active directory access. Created Unix Shell, Python and PL/PgSQL scripts of loading data and test cases using PostgreSQL utilities, AWS Pipeline ETL

-Setup/configured PostgreSQL EDB tools Enterprise Manager (PEM), Full and Incremental backup (BART), Replication Server (EPRS) and day to day database support.

-Setup / Configured Azure Hyperscale (Citus) Multi-Node PostgreSQL cluster with real-time ETL setup and highly dynamic OLTP and Analytics.

-Day-to-day database support including Bug fixing / debugging/ User issues based on priority.

-PostgreSQL Logical and Physical Backup into AWS S3 & recovery of server / database / object level using Pg_dump / psql / pg_restore, Bash scripts, Ansible scripts, Barman scripts into/from AWS S3.

-Python scripting to create/modify PL*Python jobs / scripts.

-Databricks administration and managing, filtering ETL data based on application requirements and database structure.

-Data capture/filter from PostgreSQL to generate Hasura GraphQL APIs.

-Setup/ Configuration/ Monitor / Support of PostgreSQL Powa and pact tools.

-Upgrading to PostgreSQL Major and Minor Versions, setting related configuration parameters, migrating existing partitions with Inheritance to Native Range/List partition tables and changing automation scripts as per new / changed features / Syntax of PostgreSQL new versions.

-Created Table Level Logical replication in PostgreSQL using Publication and subscription at Primary/Secondary PG databases.

-Physical replication, WAL archive setup/monitoring of multiple PostgreSQL databases.

-Data modeling (Logical, Physical, Reverse Engineering) using Erwin, Toad and PgModuler.

-Performance tuning of highly busy databases in peak hours using pgpool and modifying/ scheduling database jobs and Linux cron jobs.

-Experience in installation / configuration / maintenance of pgvector extension.

-Used pgvector approximate nearest neighbor search with L2 distance, inner product, cosine distance.

-Used indexes HNSW and IVFFlat based on usages/priorities like Query performance, speed-recall, build times, memory utilized.

-Created / Used HNSW and IVFFlat indexes with different distance functions vector_l2_ops, vector_ip_ops, vector_cosine_ops.

-Optimizing HNSW index parameters like maximum number of connections, ef_construction considering cost of index build time / insert speed, ef_search, maintenance_work_mem, max_parallel_maintenance_workers

-Optimizing IVFFlat index parameters/ options like optimal number of lists for less than or greater than 1 Million count, max_parallel_maintenance_workers, appropriate number of probes ivfflat.probes for higher recall and/or better speed.

-Used full-text search, Reciprocal Rank Fusion and/or cross-encoder to combine results.

-Optimized query results using exact search instead of Index scan, encouraging the planner to use index HNSW/IVFFlat and monitor using pg_catalog views.

-Used PgTune to get approximate idea and set optimal/required initial values for Postgres server parameters.

-Used double precision to store vectors with more precision and expression indexing at a lower precision.

-Created / used check constraints to convert retrieved data into vector type with the expected dimensions 3.

-Installation / Maintenance of Yugabyte DB Cluster instance and nodes.

-Configuring YB-Master and YB-Server processes among nodes along with replication factor.

-Maintaining cluster roles, users, databases objects, privileges, foreign data wrapper of Yugabytee DBs.

-Setting alerts / notification in YugabyteDB load / memory consumption and optimization.

-YugabyteDb node configuration planning before high data load and update.

-Creation/authentication/security setup with ODBC, JDBC configuration.

-Managing YugabyteDB data slices, physical storage configuration, heartbeat configuration.

-Yugabyte server auto failover configuration with alerts/notification.

-Configuration / monitoring of Backup and restoring YugabyteDB at database, user, schema, table level.

-Collecting and evaluating history data and analyze/creating reports with objects/group of objects desc/asc on weekly/monthly basis.

-Data loading and managing Yugabyte workload management, capacity planning and overall query performance tuning.

-Experience in YugabyteDB views, materialized views, sequences.

-Object privilege setup with object, user level selects, insert, delete, update including showing/hiding objects display.

-Managing Yugabyte object level skew threshold, storage usages, data change, physical fragmentation etc.

-Adding / removing CockroachDB replication nodes, Cluster certificate, data store, HAProxy,

-Managing Roles/users, privileges at System, database, schema, table, sequence, type levels of CockroachDB and created/matched GCP cloud IAM Groups with the similar privileges as of related database roles.

-Automate full encrypted backup and recovery of CockroachDB Sigle region development database and daily full + hourly incremental backup of cockroach production DB having enterprise license.

-Cloning CockroachDB meta data from Production to UAT with exclude_data_from_backup

-Performance tuning, monitoring, DB Console matrices using CockroachDB dashboards like

Overview, change feeds, Queues, Distributed, SQL, Storage, Hardware, Slow request, Overloads, TTL Dashboards.

-Setting automation / notification with bash shell script for any changes in CockroachDB raft changes/modification

-Utilized Compute column facility of Cockroach DB, setting arithmetic functions in Stored and Virtual compute columns.

-Automation for reviewing column families on single table getting alert/notification for frequently updated and seldom updated columns of the same table(s)

-Experience in CockroachDB views, sequences, temporary objects, user-defined schema, SQL Shell, Table/Column Clustering, Data streaming/pipe line setup/filtering.

-Experience in CockroachDB Load-based splitting control, replication control, admission control.

-Cost-based optimization of CockroachDB overall usages with future forecasting considering data/usages growth.

-Automation using bash shell scripts, ansible scripts and static/ dynamic data in views/tables of CockroachDB system catalogs pg_catalog, crdb_internal, information_schema, pg_extension.

-CockroachDB Installation (Serverless, Dedicated and Self-Hosted on AWS EC2 and Azure VM) on multi nodes and customization considering horizontal scale, Load balancing (HAProxy setup), Distributed reads/transactions.

-CockroachDB Enterprise optimization for cost-based, load-based with geo-partitioning and multi-region in-house and cloud storage.

-Usages of CockroachDB Enterprise features user defined schemas, column families, multiple regions scaling on GCP cloud using data Resiliency, Scalability, Consistency, Replication and Rebalancing.

-Diagnostics and optimizing the resource consumption and cost optimization of CockroachDB serverless like SQL CPU, Network egress, Storage layers I/O, SQL Activities (rows processed, bytes read, identifying excessive queries and number of connections at a time etc. and other related resource consumptions.

-Configured and optimized for monitoring and debugging CockroachDB change feeds for high durability and high throughput considering timestamp recording, Latency, resolved options, batching, and buffering messages.

-Customized Change feeds jobs tracking row-level changes, notifications of real time data changes of specific columns, tables, clusters.

-Usages of CockroachDB auth-sessions, job-trace, list-files, ballast, statement-diag, user files get/list/upload/ delete, import, workload, full back up, incremental backup.

-Setup CockroachDB certificate (node level), user and role/group level authentications and privileges including SQL and Password level authentications.

-Database and Schema level migration using tools MOLT verify including MOLT LMS (Live Migration Services), AWS DMS (Data Migration Service) to migrate into AWS EC2, Flyway and Liquibase into Azure VM Self-hosted Cockroach DB.

-Oracle database installation, configuration wit RAC ( 2, 4 and 6 nodes clusters), setting users, roles, tablespaces, datafiles, tns entries, listener configuration etc.

-Oracle database Logical, physical, RMAN Backup/ recovery, scheduling and monitoring.

-Oracle Database hardware migration from Physical to Virtual environment. From HP-Ux to Linux environment using RMAN and Golden gate replication.

-Multiple Nodes Oracle Database RAC support (service, listener, srvctl instance level, service, listener) using ASM

-Oracle Database upgrade and quarterly CPU, Java Patching, Security patch.

-Active Data guard setup, Application database support, Linux/ Unix scripting

-Golden gate Uni-Directional replication setup/ monitoring / error fixing

-Creation/ Maintenance of Oracle Wallet.

-Quarterly database patching and communication with Oracle support using metalink

-Oracle Database Administration with HA setup / configuration

-Replication Lag monitoring and finding root clause. Automation of alerts for lag more than a threshold limit.

-Backup and recovery setup / configuration / monitoring / alert setup.

-Managing Oracle ASM, data directories, resource group, heartbeat configuration.

-Oracle Active Data guard setup, monitoring, HA failover configuration (criteria, timers, notification etc.), relocating to standby, Transition to/from maintenance to Clustering mode.

-Backing up and restoring Oracle databases at database, user, table level.

-Collecting and evaluating history data and analyze/creating reports with objects/group of objects desc/Asc on weekly/monthly basis.

-Data loading using SQL*Loader and managing Oracle workload management, capacity planning and overall query performance tuning.

-Creating/configuring databases, tables, views, materialized views, sequences, synonyms, users, groups.

-Pre-requisite of migration from in-house Oracle database to PostgreSQL into AWS EC2 considering dependencies, resources required, optimization required and cost.

-Database cluster migration from Oracle to PostgreSQL into AWS EC2 using AWS SCT, AWS DMS, Ora2Pg, orafce, ora_migrator, oracle_fdw, bash shell, Python scripts and Coding/ Converting Oracle shared procedures in PL/SQL to PostgreSQL PL/PgSQL

-Linked Oracle database tables into PostgreSQL database using foreign data wrapper oracle_fdw

-Upgrading to PostgreSQL Version, setting related configuration parameters, migrating existing partitions with Inheritance to Native Range/List partition tables and changing automation scripts as per new / changed features / Syntax of PostgreSQL

-Created Table Level Logical replication in PostgreSQL using Publication and subscription at Primary/Secondary PG databases.

-Pre-requisite of migration from Oracle data warehouse to GCP Big Query considering actual requirements, possible usages, dependencies and cost optimization.

-GCP cloud infrastructure architecture design / setup and configuration for Oracle migration into Big Query including Cloud Storage buckets with data lifecycle management, Security groups, Alert and event notifications, Query cost optimization, privileges, and encryption.

-Oracle data warehouse to GCP Big Query after testing/analyzing full load QPD, price/hour, Geo-Mean and Queries Threshold. Used TPC-DS sample queries and tools (DSQGEN) with varied concurrency levels.

-Re-configure objects, users/roles, ETL, materialized views into GCP Big Query

-Setup additional utilities of Big Query and Cost optimization / analysis at query/batch level.

-Oracle Golden Gate Installation, configuration, with direct and in-direct data loading.

-Configuring golden gate extract, data pump, target with timestamp and SCN #

-Monitor lagging, debugging, and troubleshooting.

-Setting alert automation and notifications.

-Setting Golden gate Veri data for comparing/matching data between source and target databases.

-Configure / optimize Golden gate master config file with available parameters / options.

-Configure Golden Gate Director between source and target databases.

-Configure/ setup Extract config files for filtering secured data values before going to data pump and target.

-Database administration and day to day issue resolution of Golden Gate and Oracle Database.

Employer: Coromandel Infotech, Chennai, India

(5 Months) May, 2012 – Oct, 2012

Title: PostgreSQL and Oracle Database Administrator

Worked as a Senior Oracle and PostgreSQL DBA to support multiple Production and development Oracle Core and Application databases, including third party client’s databases and have been part of the team of transferring data from 8 databases into a single Business Analytics Warehouse (BAW) using Informatica ETL and Data warehouse Administrative Console (DAC).

Employer: Braves Technologies, GA, USA / Braves OMS, Pune, India

(11 Months) Jan, 2011 – Nov, 2011

Title: Oracle DBA/ Golden Gate Administrator

Worked to support databases of third-party clients Citibank, Ally bank, Pop Money

Employer: Hindustan Prefab Limited (HPL)

(A Government of India Enterprise)

(Under Ministry of Housing & Urban Poverty Alleviation) (www.hindprefab.com)

(6 Months) May, 2010 – Nov, 2010

Title: Deputy General Manager (Process Management & Systems)

Hindustan Prefab Limited (HPL) is a Government of India Enterprises dealing in construction of Govt staff buildings, Bridges, Factory structures, Institutional Buildings, Hospitals, Autoclaved Cellular Concrete, Joinery Workshop, and other pre-cast concrete products.

I worked as a Deputy General Manager (DGM) in Process Management & Systems, responsible for supporting and maintaining all departmental database processes.

Employer: CSC India Pvt Ltd, Noida, India

(5 Years 6 Months) Oct, 2003 – Apr, 2009

Title: Senior Oracle DBA / Principal Consultant (G50)

Worked to support databases of SAM application (Focus-3, Focus-4) in Oracle database version 10gR2/9i.

Supported 2618 databases/instances (Oracle Apps 11.0.3 to 11.5.10.2, Oracle Core 8.x to 10gR2) having 668 production and rest development, training, and test databases.

Employer: Tata Consultancy Services (TCS)

(7 Years 3 Months) July, 1996 – Oct, 2003

Title: Database Administrator (Oracle)

Worked as a Lead Oracle DBA and managed 48 production and development / testing databases and provided round the clock support to production, development and test databases for client/projects P&O Nedlloyd, ISBS (Indian Standard Banking System), Standard Chartered Bank, GE Plastics, British Home Stores.

Contact this candidate