Ajay Kumar Pandey

Newport Beach, CA ad23rc@r.postjobfree.com LinkedIn Ph: +1-949-***-****

SUMMARY

Over Twenty years of strong experience in On-Premises and Cloud Database, Data warehouse architecture, DBA support, Application maintenance, Project management, Software Design, Development and Implementation. Pre-sales, Bidding and provide Complete Technical Solution.

Strong experience in Snowflake Cloud Analytics Database, AWS RDS, Sybase Adaptive Server, Sybase Replication server, Sybase IQ, Oracle, MS SQL Server, Autosys, Influxdb, Oracle GoldenGate, Telegraf, Grafana, Power Builder, ETL tools Datastage, Informatica, DBT, f, HVR, FIVETRAN, Airflow,Brio Queries, APT, DWB, DB Library etc.

CERTIFICATIONS

Snowflake (SnowPro Core Certification)

Sybase Certified Associate – Sybase ASE (15.0)

Sybase Certified Professional – Sybase IQ (12.5)

Sybase Certified Professional – Sybase Replication server (12.5)

Sybase Certified Associate – Sybase Replication server (15.x)

Sybase Certified Professional – Sybase ASE SQL Developer (15.0)

MCSA Administering Microsoft SQL Server 2012/2014 Databases

TECHNICAL SKILLS

Snowflake Cloud database, AWS RDS, SYBASE ASE, SAP-Sybase Replication server, SAP-Sybase IQ, Power Builder, Oracle, MS SQL server, PostGRESQL, Autosys, Influxdb,Oracle GoldenGate, Telegraf, Grafana, Brio Queries, Tableau ETL: HVR, Fivetran, DBT, Datastage, Informatica, Crystal Reports, APT,,DWB, DB – Lib. SQL Loader, exp and imp, DFD: VISIO, Autosys, Airflow,Control-M, Python and Shell scripting, DevOps tools like GIT, CI/CD, JIRA, ServiceNow etc.

Data Modeling and Architect:

Power Designer, Erwin, S-Designer, ESSABASE, Axiom – Controller View

TOOLS:

Snowflake UI, SnowSight,SnowSQL, DBeaver, Rapid SQL, DB Artisan, Proactive Whitesands, DBA, Sybase Central, Bradmark Surveillance, SolarWinds, SQLbacktrack, SQL, Advantage, Cost workbench (SQL Builder), Sybase Server Manager, SQL Commander, TOAD, SSMS, SQL developer etc

WORK EXPERIENCE

CyberThink INC

Job Title: Lead Snowflake DBA/Architect

From: Dec 2022 till now

Client: Morgan Stanley

Responsibilities:

Implemented Cloud based datalake solutions architecture covering data pipeline ingestion, data processing, data cataloging, security, devops, data quality etc

Responsible for End to End setting up snowflake Infrastructure. Creating Account,database, schema, tables, view, stages, file format etc

Hands-on experience with Snowflake utilities such as SnowSQL, Snowpipe, Bulk Copy data ingestion

Implemented Snowflake components (Snowpipe, Function, Stored procedures, Streams, Tasks etc) for building end-to-end data pipelines

Setting up resource monitors, deploying RBAC controls, virtual warehouse sizing and Query performance tuning

Deploy snowflake features such as data share, replication, TimeTravel, ZeroCopy cloning etc

Setting up failover, Database group replication cross cloud cross region, client redirection…

Implemention of disaster and recovery for snowflake databases

Managing Multi-cluster warehouses in Business critical environment

Managing database refresh for lower environment (Prod/ Dev/ Beta)

Configure Storage integration and stages to access AWS S3 buckets, IAM user, Policy, role

Setting up all aspect of security features like Network Security Policy,Multi-Factor Authentication, SSO, Okta Integration, Tri-secret configuration, Row access policy, Data masking etc

Worked with version control tools (Gitlab CICD/ Terraform/ DBT/JIRA/ServiceNow)

Implemented snowflake Dashboard monitoring using Grafana and Influxdb

Scheduled jobs for Long running / Open transaction/ HeartBeat / Warehouse overload / Replication monitoring/ Process waiting queue/ Data Spillage /Replication

Setup weekly reports for each team for warehouse credit consumption, Storage usage, Disk spilling and warehouse overload reports using shell and python scripts

Mentoring snowflake dba and developers

Collaboration with multiple teams (Data science/Data Plateform /Data Engineering/Data acquisition /Analytics/ Reference data etc)

Worked in collaboration with Developers for data pipeline data ingestion in snowflake from AWS s3 bucket / Kafka/ DBT/ Matillion/Airflow/Informatica /Python and Shell scripting

Proficient in data modeling, Datamart, Dimension and factor modeling, Star Schema, snowflake schema, Data vault, Data Architect (Data Modeling –> Logical – Physical Database Design)

Executed data migration using ETL/ELT tools like HVR, FIVETRAN, Matillion, DBT, Tableau and Informatica

Employer Name: Pacific Investment Management Company (PIMCO), Newport Beach, CA

Job Title: Lead Snowflake Database DBA/Architect (Full Time)

From: Aug 2017 till Dec 2022

Responsibilities:

Leading a team of Snowflake Engineers (Onshore // Offshore) to support Snowflake database operation 24x7

Snowflake architecture & implementation. Manage snowflake (AWS/Azure) database complete lifecycle

Implemented Multi-Tenant snowflake Architecture (MTT/OTP/APT)

Implemented Cloud based data solution components and architecture covering data ingestion, data processing, data cataloging, security, devops, credit consumption, etc

Responsible for creating Account,database, schema, tables, view, stages, file format etc

Hands-on experience with Snowflake utilities such as SnowSQL, Snowpipe, Bulk Copy data ingestion

Implemented Snowflake components (Snowpipe, Function, Stored procedures, Streams, Tasks etc) for building end-to-end data pipelines

Setting up all aspect of security features like Network Security Policy,.Multi-Factor Authentication, SSO, Okta Integration, Tri-secret configuration

Implemented data encryption/decryption/masking policies/Row access policy to protect PII/PCI data

Setting up resource monitors, deploying RBAC controls, virtual warehouse sizing and Query performance tuning

Deploy snowflake features such as data share, replication, TimeTravel, ZeroCopy cloning etc

Setting up failover, Database group replication cross cloud cross region, client redirection…

Implemention of disaster and recovery for snowflake databases

Managing Multi-cluster warehouses in Business critical environment

Managing database refresh for lower environment (Prod/ Dev/ Beta)

Configure Storage integration and stages to access AWS S3 buckets, IAM user, Policy, role

Worked with version control tools (Gitlab CICD/ Terraform/ DBT/JIRA/ServiceNow)

Configure AWS PrivateLink to access Snowflake account

Implemented snowflake Dashboard monitoring using Grafana and Influxdb

Scheduled jobs for Long running / Open transaction/ HeartBeat / Warehouse overload / Replication monitoring/ Process waiting queue/ Data Spillage /Replication

Setup weekly reports for each team for warehouse credit consumption, Storage usage, Disk spilling and warehouse overload reports using shell and python scripts

Mentoring snowflake dba and developers

Collaboration with multiple teams (Data science/Data Plateform /Data Engineering/Data acquisition /Analytics/ Reference data etc)

Worked in collaboration with Developers for data pipeline data ingestion in snowflake from AWS s3 bucket / Kafka/ DBT/ Informatica /Python and Shell scripting

Configure Grafana dashboard for snowflake monitoring and alerting over slack

Database migration (On Perm Oracle and Sybase IQ to Snowflake Cloud database migration etc)

Account,Appication,Team and warehouse level monitoring to control cost

Created snowflake multiple utility store procedures to help snowflake users for monitoring and data governance

Setup automation processes for Database, User, Schema, warehouse and Application role onboarding

Provide Snowflake data governance guidelines. Tag all snowflake object by Application ID

Implemented Data Management Principles to Prevent Data Swamp

Proficient in data modeling, Datamart, Dimension and factor modeling, Star Schema, snowflake schema

Executed data migration using ETL/ELT tools like HVR, FIVETRAN, DBT, Tableau and Informatica

Sybase ASE/IQ/Replication/MS SQL:

Installation, configuration, maintain SAP Sybase ASE support, Sybase IQ, Sybase Replication, MS SQL Server, Oracle, GoldenGate, Influxdb, AWS RDS

CyberThink INC April 15 - July 17

Senior Sybase DBA

Client: Cargill Inc Hopkins MN, United Health Group Services (UHG)- Plymouth MN

Wipro Technologies Ltd

Kolkatta, India Jan 15 - April 15

Principal Consultant – (Sybase Practice Head)

IL&FS Technologies Jan 10 - Dec 14

Philippines/India

VP: Leading Software Dev/Maintance/Support/Database Practice/Pre-Salse for mupliple projects

Database Practice Head Sybase ASE/ Sybase Replication/ Sybase IQ/ Oracle/ Postgres/ MS sqlserver

Sybase Corporation Inc. Feb 06 - Dec 10

REMO Lead : Leading team of Sybase ASE/IQ/Replication Server DBA 24X7

Multiple clients: (Chevron/Vitas/Markit/BCN/BT/Tora trading/Avis/CHISHOLM/Fujitsu/Marten Transport/ACE)

Technology: Sybase ASE /Replication/Sybase IQ

Perot Systems Singapore (Apr 02 - Feb 06)

Client: UBS Singapore

Role: Data warehouse Architect/Application DBA (Project: Global General Ledger – RTB)

Project:

Global General Ledger (GGL) is the centralized accounting repository of UBS operations. GGL

is the summary of all debits and credits that have taken place across the globe on a day.

GGL receives trades and settlement data from 140 global upstream systems (feeding 450 files

daily) covering Equities / Fixed Income, Treasury and Forex / Wealth Management. Postings

data processed through 22000 jobs in Autosys scheduler, 10 million postings hit GGL Ledger

every day. 15 application and database servers and 20 terabytes of data storage.

RDBMS : ORACLE 9.0, SYBASE 11.9.2/12.0/12.5

Tools : Autosys, Informatica, Axiom Controller view, Toad, DB Artisan, VISIO, SAP/R3 etc

Data-Core Systems,

Client: National Semiconductor, CA Sept 00 - Mar 02

Analyst, Design, Developer and DBA

Environment: H/w: IBM RS/6000, HP9000 O/s: AIX 4.0, S/w: SYBASE 11.9.2/120.0.3, Crystal Report 7.0, Powerbuilder 6.5 Tools: Visio, Power Designer, Desktop DBA, DB Artisan, SQL Commander, Cost Workbench, TOAD. Shell script: csh, perl

Comtel Solutions Pte Ltd,

M/s. Standard Chartered Bank, Singapore Aug 99 - Sep 00

Production and Development DBA, Data Warehouse Architect

(Datamart /Star Schema using Data Stage/Crystal report/Sybase)

M/s. Raymond Synthetics Ltd. India Oct 97 - Aug 99

System Analyst, Designer, Developer and DBA

Environment: H/w: G40 (HP-UX -102) & Pentium O/s: UNIX, WIN’95 S/w Sybase - 11 (Backend) AND APT & P. B. 4.0 (Front-end).

M/s. TRF Limited India Jan 96 - Oct 97

Designer and Developer

Environment: H/w: OSF-PC, Dec Alpha & Pentium O/s: VMS (5.5), UNIX, Win'95 S/w Sybase - 11 (Backend) and APT & P. B. 4.0 (Front-end), DB Lib*c, DWB, RWB, csh

Magnus Software Pvt. Limited, India Jun 94 - Jan 96

Programmer

EDUCATION

B.Tech (Computer Science) 1994

H.B.T.I. Kanpur

Contact this candidate