| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate?Candidate's Name eniwalE-Mail: EMAIL AVAILABLECell Phone: PHONE NUMBER AVAILABLELinkedIn: https://LINKEDIN LINK AVAILABLEPROFESSIONAL SUMMARY? 19+years of IT experience as a Data Architect, Database Administrator, Migration Consultant, Certified PostgreSQL (9.1.1 till 16.1) DBA, Certified Oracle DBA (7.1 till 19c), Certified Snowflake DBA, Certified Yugabyte (2.1 to 2.6) DBA, SAP HANA DBA, SAP S/4 HANA Migration/ Implementation/ Support, SAP Basis Admin, Oracle Golden Gate (10.2 to 21c), Oracle OEM (11g to 19c), DB2 z/OS (Ver 9 to 12), DB2 LUW, PostgreSQL on AWS Aurora, AWS RDS, GCP CloudSQL and EDB PostgreSQL along with tools Bart, PAM, Barman, Python and Bash Shell Scripting.? Database Migration from Oracle to PostgreSQL, DB2 LUW to PostgreSQL, Snowflake to SAP HANA, PostgreSQL to SAP HANA 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, SAP S/4 HANA migration cockpit with Greenfield Implementation, Syniti Data Replication (SDR) with Bluefield Implementation, Python scripts, Bash shell Scripts, AWS DMS, AWS SCT, Oracle Golden Gate, SAP Business Object Data Services (BODS), Pipeline ETL.? PostgreSQL (Community and EDB) Installation, configuration, Replication (physical/logical), Stand-by Read Replicas, backup, recovery (up to table level), performance tuning, vacuuming, auditing, privileges, extension setup and configuration, upgrade (Major and Minor), foreign data wrapper, debugging and troubleshooting in in-premises Hybrid environment and in AWS EC2/RDS, GCP VM/Cloud SQL, Azure VM on Linux Redhat, Centos 6/7 and Windows platforms. Setup Azure Hyperscale (Citus) Multi-Node PostgreSQL Clusters and Streaming real-time data ingestion.? SAP HANA System Administration, Customization, Monitoring, Upgrade, backup / recovery, Migration, Cloud Integration, User and role security, Alert setting, Optimizing Micro services, System / tenant databases, property layers, Performance tuning / parameter optimization of global and *.ini files of Nameserver, Index server, compile servers, script server, streaming server. Using SAP Hana Native and Non-Native tools/ utilities. Size optimization and designing / altering row and column-based tables.? 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.? DB2 Mainframe and LUW installation, customization, maintenance, SysPlex Data Sharing, Backup, recovery, user and schema level security setup, Statistics gathering, optimization, performance tuning setting parameters (registry, DB manager, DB, Env), Cloning and Archival of tables, XML tables and Indexes management, Temporal tables on System and Application level, Catalog search and future forecasting, Migration of cluster/databases from in-house to Cloud (AWS and GCP), Replication using InfoSphere CDC from DB2 LUW to BLU Acceleration configuring Shadow tables, Synopsis tables, HADR setup/ replication/ monitoring, Omegamon, day to day DBA support on DB2 z/OS and LUW, problem solving at user and application level.? Snowflake design, setup, Tri-Secret secure keys, SnowPipe, loading bulk structured/relational, semi-structured / Array and JSON data, Loading automation using CDC (Change data capture), Unloading into AWS S3 / GCP Cloud Storage, Analytics using SQLAlchemy, Pandas for Hierarchical Data, Query performance and Cost Optimization. Setup/Configured Matillion ETL and ELT Jobs, Components, Canvas, Task along with CDC.? Domain knowledge of Retail (Retek ? subsidiary of Oracle), Government, Telecom, Transportation, Government, Engineering and Finance / 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, IndiaCERTIFICATION / TRAINING? Azure Cloud Certification (Certificate # H509-7065) (DP-900)URL: https://www.youracclaim.com/go/9g0dH7dSTR0j7FSjdDg69Q? Snowflake Cloud Analytics Architect (URL: https://verify.skilljar.com/c/nqywrkk7k3y7 )? Snowflake Cloud Analytics Master (URL: https://verify.skilljar.com/c/s45aqt34ymkm )? PostgreSQL DBA Certification (Brain Measure Transcript ID: 84815)? Oracle DBA Certification (Prometric ID: PR0075381)? Yugabyte Certified ? Yugabyte DB Fundamentals ? Associate? Yugabyte Certified ? Yugabyte DB YSQL Advanced? Best Thesis award of Indian Institute of Technology (IIT) Roorkee, India of 1995-96 SessionTECHNOLOGY STACKDatabase:PostgreSQL 9.1.1 to 16.1 (Community, EDB, AWS Aurora, AWS RDS, GCP CloudSQL, Azure Hyperscale), SAP HANA (1.0 to 2.0), Oracle Core 7.1 to 19c, Oracle RAC 10gR2 to 19c, DB2 z/OS (9 to 12), DB2 LUW, Snowflake.Languages / ToolsUnix Shell Script, Python 2.7-3.8, Psql, SQL*Plus, PL/SQL, PL/PgSQL, Pro*C, Python, 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, Oracle OEM 11g/12c, SAP Hana Cloud, SAP S/4 Hana, SAP C/4 HANA, SAP BASIS, SAP BTP, SAP Cockpit, SAP Studio, SAP HEC, SAP HCP, SAP OA, SAP DCC, SAP LAMA, SAP EarlyWatch Alert, SAP DMO, SAP SUM, HdbSQL, hdblcm, SAP DB Explorer, SAP Solution Manager, SAP Signavio Process Manager, SAP Signavio Data management, SAP BI, SAP ECC, SAP SCM, SAP PLM, SAP SRM, SAP CRM, STMS_IMPORT, SAP ADMM, SAP Syniti, SAP ODBS, SAP CI, SAP API, Storage, Pgadmin III, IV, Postgres EDB, Brat, Barman, ora2pg, Oracle_fdw, bigquery_fdw, s3_fdw, s3csv_fdw, orafce, ora_migrator, Rapid wiz, DB2 Omegamon, DB2 BMC, DB2 Sysplex, DB2 BLU Acceleration, DB2 InfoSphere CDC, SnowSQL, SnowPipe, Matillion, SnowCD, SQLAlchemy, Pandas, spilling / Encryption/ Tuning /Black hole / TPCH/ Staging / Driver / Exchange. Kintana, Retek RMS 9.x, GGSCI, ggsinfo, Oracle Golden Gate Director, Oracle Golden Gate Veridata, Toad, ErwinOperating SystemWindows Server 2003/2008/ 2012/2016/ 2019/2022, Windows 2000/ 98/ 95 /NT /Vista /XP, MS-DOS, UNIX, AIX, Sun Solaris, HP-UX, Linux Radhat, Centos-6 to 9, Ubantu, AWS EC2, AWS RDS, GCP VM, GCP Cloud SQL, Azure VM, Azure Hyperscale (Citus)Domain KnowledgeBanking, Finance, Retail, Travel, Transportation, Government, Government, Engineering, CloudPROFESSIONAL EXPERIENCEEmployer: CSS from Jan-2014 to Dec-2018 and Self-employed/C2C/W2 thereafter.Clients:? Nutanix from Feb-2022 to till date.? Huntington Bank / Remote: From Oct-2021 to Feb-2022.? HCL Tech / Remote: From Feb-2021 to Oct-2021? Finastra, Austin TX / Remote: From Dec-2019 to Feb-2021.? Omnitracs LLC, Minneapolis MN: From Aug-2018 to Dec-2019? Caterpillar, Chicago IL: From Jan-2018 till Aug-2018? DHS ? State of Maryland, Baltimore MD: From Apr-2017 till Nov-2017? DET/DOA ? State of Wisconsin, Madison WI: From July-2014 till Apr-2017Title: Cloud Backend Data Architect, Database Administrator (DBA), Migration Consultant of PostgreSQL, SAP HANA and SAP S/4 HANA, DB2 z/OS and LUW, Snowflake, Oracle and Golden Gate.Responsibilities:? PostgreSQL database (version 9.2.18 to 16.1) creation/configuration/maintenance into local and AWS cloud storage following Maryland State and agency level policies, rules and security.? Standby setup/configuration of PostgreSQL from In-house Redhat Linux server to AWS cloud and GCP Cloud SQL.? Database migration from Oracle to PostgreSQL into Azure VM, AWS EC2 and GCP VM 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? Data migration from DB2 LUW to PostgreSQL (AWS EC2, 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.? PostgreSQL Logical and Physical Backup into AWS S3 & recovery of server / database / object level using Pg_dump / psql / pg_restore, Bash scripts, Barman scripts into/from AWS S3.? Setup/ Configuration/ Monitor / Support of PostgreSQL Powa and pact tools.? Upgrading to PostgreSQL, 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 version 10.2? 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.? AWS cloud architecture design / setup and configuration with EC2 instance, VPC, S3 including data lifecycle management, Security groups, Alert and notifications (SNS, SQS, Cloud Watch, 53), privileges and encryption for devp, UAT and Production database servers of PostgreSQL? GCP cloud IaaS design /setup / Configuration of PostgreSQL and Oracle Data warehouse in VM, Cloud Storage including backup, recovery, Hot standby, data security etc.? Setup /Configured Data lake in Google Cloud Storage and to load from multiple sources using Python scripts, gsutil and source DB scripts.? Used/Customized Azure services, Storage account, Resource groups, IAM, RBAC, Azure AD, Azure DMS, IaaS, PaaS, Azure Data lake, Analytic services, Synapse (with and without SQL server), Data bricks, Data factory.? Experience in SAP HANA Database Administration (In-House and SAP HANA Cloud), SAP HANA Cockpit, SAP DB Explorer, hdbsql including post installation and upgrade.? Worked/supported in SAP Business Technology Platform (BTP) and associated objects.? Sizing and configuring O/S for optimizing SAP S/4 HANA and SAP utilities.? Monitoring and Diagnostics of SAP HANA Memory Utilization.? Customizing SAP HANA memory pool optimizing memory for row tables, system tables, column tables, DB management and temporary computations, Code and Stack.? Automation of SAP HANA Full backup (System + all Tenant DB), Individual Tenant backup, Log backup, compressed backup? SAP HANA database recovery and monitoring SYS.M_BACKUP_CATALOG_FILES? Automation, Cloning, Copying, Reporting, Virtualization, and refreshing SAP HANA System using SAP Landscape management (SAP LAMA) Non-native tool/utilities.? Greenfield Implementation on new SAP S/4 HANA system and Migrating data from SAP ERP to SAP S/4 HANA system using SAP S/4 HANA migration cockpit with staging tables, migration projects, template files, task mapping, auditing statistics etc.? Pre-configuration of Linux O/S, managing O/S users (sapadm/ s4hadm), File system (sapmnt, trans, SYS, ASCS20, ERS29, D21) for application servers ASCS /ERS/ PAS/ AAS.? Managed SAP HANA DB server (sapmnt/ data/ log/ shared) defining RFC destinations for method calls from SAP S/4 HANA EWM.? Designing, creating Integration patters, scenario, protocols for SAP Cloud Integration (CI) and SAP Backend Integration.? Setting dummy logical system and Scheduling QOUT assigning logical system with queue type.? Worked /resolved the errors/warnings in eCATT reusable test script?s logs related to BC sets, variable issues, BC set activation, Scope items etc.? Data Integration in batch-mode from Multiple Sources to SAP HANA using Job Server of SAP Business Object Data Services (BODS).? Configured/Used SAP BODS engine for parallel processing of data extraction, transformation, and movement to SAP HANA Database? Used SAP BODS Central management Console (CMC) for user management and repository registration.? Configured / used Syniti Data Replication (SDR) to migrate data from Snowflake to SAP S/4 HANA Database.? Setup / used SAP Advanced Data Migration and Management (ADMM) of Syniti to replicate data using Change data capture (CDC) from AWS RDS PostgreSQL to SAP HANA Database.? Data conversion setting data translation, splitting huge data into multiple chunks, mock conversion cycles with gate criteria, Comparing / Spot Check/ validating data load, indexing/re-indexing, error handling, reloading etc.? Query Federation and Virtualization using SAP HANA Smart Data Access (SDA) with? remote table replication (RTR) between SAP HANA Databases and SAP HANA SDA. Also used SAP HANA SDA to capture remote data from GCP BigQuery with DML_MODE.? Customized data replication, Flowgraph to design data flows and transformation using SAP HANA Smart data Integration (SDI).? Setup centralized monitoring and administration of all SAP HANA databases using SAP DB Control Center (DCC).? Monitoring, Administration and partial migration (upto object level) of individual SAP HANA databases using SAP HANA Cockpit.? Configured / Optimized SAP HANA Cockpit for Monitoring, Administration, using micro services cocckpit-landscape-svc, cockpit-adminui-svc, cockpit-hdbui-svc, cockpit-persistant-svc, cockpit-hdb-svc, cockpit-collection-svc? Configured / Optimized SAP DB Explorer MTA services sqlanlz-svc, sqlanlz-ui, hrtt-service, hrtt-core etc.? Configured SAP Signavio for workspace settings, BPTM Notation settings, modelling conventions, signaling in process intelligence, Sinnavio Data management, ETL, Process Gaps.? Experience in SAP HANA Studio for monitoring and administration of SAP HANA (Ver 1.0) databases.? Update SPS with new releases and worked with ERP application team to customize/ optimize the application parameters with the new release.? Experience using SAPCONTROL and HDB utilities / options.? Scripting / Automation of changing the Storage types of tables from Row-based to Column-based (and vice versa) for change in table architecture (columns), number of count, aggregation, partitioning, indexing, optimizing insert/update or utilizing Delta store? Configured Delta store for optimizing OLTP Update/insert into compressed column-based tables with DP agent and SDI Adapters.? Used Cloud Connector to Link on-premises connections with SAP HANA BTP applications.? Experience of customization and using trigger-based replication SAP Landscape Transformation (SLT) and ETL based replication SAP Data Services? Used SAP Replication server (SRS) to move transactional data through log-based replication method.? Created and used Virtual tables, Linked database connections using SAP HANA DB Explorer.? Optimized Linked database mode and automated housekeeping/dropping the internal virtual tables which were created while accessing remote tables.? Accessing data of different format from different database sources into SAP HANA database using Value Proposition, without replication data.? Used TOPK Statistics for query optimization of remote tables using Linked DB connection.? Integrating SAP applications to communicate with each other using SAP BASIS and between different modules.? Managed SAP System running transactions by different SAP services using transaction codes of SAP Basis (SM01/02/04/13/21/37, RZ20, PFCG? Snowflake design of Premier, Enterprise and ESD editions using Tri-Secret secure keys? Experience with account_admin role, time travel, cloning, materialized view management? Experience in managing roles (RBAC), users, accounts, parameters at account level, clean room, data shares.? Snowflake batch and streaming data load pipeline using SnowPipe and Matillion from data lake at AWS S3 and Azure blob.? Coding/testing/reviewing ETL and ELT programs using Matillion including tuning of Matillion mapping/ jobs link, / parallel processing/ canvas etc.? Tested cloud platforms/DWH based on Queries threshold, QPD, geomean? Setup/used Snowflake Python and SQL Alchemy connectors.? Loading bulk semi-structured and JSON data into Snowflake from AWS S3 / GCP Cloud Storage and automate loading based on CDC (Change data capture)? Used Snowflake Snow SQL, SQL Alchemy, Pandas for analytics including Hierarchical Data? Unloading Snowflake data into Azure blob, AWS S3 and GCP Cloud Storage.? Table design, Data optimization, Query Performance and Cost optimization.? Communicating with Snowflake customer support as and when required.? DB2 z/OS customization, maintenance, Backup and recovery, sysplex data sharing.? DB2 user and schema level security setup. SYSDBAUTH, SYSSCHEMAAUTH, SYSTABAUTH, SYSSYNONYMS, SYSSEQUENCEAUTH, SYSDEPENDENCIES, SYSRESAUTH, SYSCOLAUTH, SYSVARIABLEAUTH etc.? Optimization of parameters at cluster, database and session level.? Managed / supported DB2 Materialized view, Temporal tables with System and Application date/timestamp, Archival table setup, Cloning of tables, Temporary table usages? Indexes maintenance based on usages and composite Query / Application performance improvement.? Creation / maintenance / optimization / performance tuning of XML tables and Indexes.? Migration of cluster/databases from in-house to Cloud (AWS and GCP) using Oracle Golden gate configuration setup.? Replication using InfoSphere CDC from DB2 LUW to BLU Acceleration.? Configured DB2 Shadow tables, Synopsis tables, HADR setup/ replication/ monitoring.? Using 3rd party tools Omegamon and BMC? 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 from 7.1 till 19c 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.? Supporting 24/7 on call on rotation basis for all QA, UAT and Production databases.Employer: Coromandel Infotech, Chennai, India(5 Months) May, 2012 ? Oct, 2012Title: Oracle and PostgreSQL Database AdministratorWorked 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, 2011Title: Oracle DBA/ Golden Gate AdministratorWorked to support databases of third party clients Citibank, Ally bank, Pop MoneyEmployer: Hindustan Prefab Limited (HPL)(A Government of India Enterprise)(Under Ministry of Housing & Urban Poverty Alleviation) (www.hindprefab.com)(6 Months) May, 2010 ? Nov, 2010Title: 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 to support and maintain all departmental database processes.Employer: CSC India Pvt Ltd, Noida, India(5 Years 6 Months) Oct, 2003 ? Apr, 2009Title: Senior Oracle Database Administrator / 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. |
