Donald . Email & Phone Number

Armonk, New York, Ny, Us

Hired by manager to support complex infrastructure setup, assists on 24/7 rotation, and troubleshoot database performances. Worked extensively on Snowflake Database to create VWH, manage resource credit, create snow pipe for data livestreaming, migrating databases into Snowflakes, creating shell, and users and series of the following tasks • Setup Azure Active Directory (ADD) where users connected in Azure gets access to Snowflake and get required privileges.• Capable of creating Cloud management which is essential for credit resource monitoring. • Strong ability in creating custom roles where I merged users with same job role and made them to use the Metadata cache, resource cache and DWH cache• Great knowledge in setting up resource monitor to monitor table such that if table limit threshold is attained, alerts are triggered for immediate action. • Creating a shell to point to an arbitrary DB and assigning users who want to connect to a specific DB read only access.• Setup DWH auto resumptions and delimiting access roles to users.• Experience in Oracle Golden Gate installation, configuration, and troubleshooting issues.• In depth understanding of Snowflake cloud technology, and knowledge AWS and Azure• Proactively maintained databases by working with Development Team to improve and optimize applications usage of database resources.• Resolving physical and logical block corruptions while recovering using RMAN • Experience in Oracle Golden Gate installation, configuration, and troubleshooting issues.• In depth understanding of Snowflake cloud technology, and knowledge on AWS and Azure.• In-depth understanding of Snowflake Multiclause Size and Credit Usage• Experience with Snowflake Multi-Cluster Warehouses• Experience in building Snow pipe pointing to S3 bucket or Azure blob.• Performed database reorganizations and schema refresh using Export/Import tool

New York, New York, Us

• Review Snowflake best practices & considerations for managing load operations and performance in both AWS and Azure.• Describe data governance in Snowflake, including column-level data security using secure views and dynamic data masking features• Ability to use Role Based Access Control (RBAC) to design, develop and grant access to objects in Snowflake.• Implement advanced techniques for Snowflake performance-tuning methodologies• Employ recovery methods and agile development with Time Travel & Cloning• Strong mastery in encrypting and sharing data securely both within and out of the organization• Recommend the Snowflake best practices for management, monitoring, and optimization • Creating and assigning appropriate roles and privileges to users depending on the user activity.• Performed database maintenance procedures to ensure optimal performance • Implemented shell scripts like the BASH for the automation of daily backup duties. • Applying regular Security Patches, Critical patch Updates (CPU) and Patch set updates (PSU) on Oracle databases.• Prepared backup strategy and disaster recovery management of the databases by using in-house tools written using UNIX Shell Scripts• Managing Users, Roles, privileges, profiles, schemas, SQL monitoring tools, SQL Advisor, SQL tuning and other database metrics required to enhance performance.• Experienced in monitoring database using Oracle Enterprise Manager (OEM).• Use of Snowflake Cloud Datawarehouse quickly share data across customersUsed the ETL-tool to perform data integration from various sources with goal to decrease stress on production systems.• In-Depth understanding of Snowflake Multiclause Size and Credit Usage • Experience with Snowflake Multi-Cluster Warehouses • Experience with Snowflake Virtual Warehouses.• Great knowledge in downloading, configuring, connecting and usage of SnowSql

San Antonio, Texas, Us

• Creating database objects like tables, views, indexes, constraints. • Experience in on-premise migration from oracle to postgresql using MTK and SCT. • Implemented automated monitoring of databases, backup, and recovery activities by running cron-jobs and customized Unix Shell Scripts.• Planned, evaluated, and implemented backup strategy using Oracle Utilities such as expdp/impdp or Rman.• Configure Data Guard for disaster recovery, golden gate for real time data replication and RAC for high availability and scalability solutions• Responsible in database network management and involved in a Client-Server environment using TNS names, listener, Net Configuration Assistant, and other configuration files. • Used Oracle Flashback technique with guaranteed restore point to create and restore databases • Applied security patches (Critical Patch Updates, Patch Set Updates) using “opatch” utility.• Expertise in implementing data refreshes (database, schema & table level) using RMAN utility and Data-pump, conventional Export/Import of Oracle 11g, 10g.• Implemented data confidentiality, integrity, availability, and audibility policies using access control policies. • Migrated and upgraded databases of different versions to different environments and platform• Migration of Postgresql database to AWS EC2 and RDS cloud instances using MTK and SCT• Implemented the consolidation and transformations of data from multiple sources into useful format using the Oracle Warehouse builder ETL tool.Manage multiple accounts across the Organization• Illustrate administrative tasks within detailed architecture of Snowflake and AWS and Azure.• Describe the DDL operations that work with fundamental database objects• Identify the various aspects of compute and storage management• Discuss transaction and concurrency models and DML considerations