Surinder Saini

•Extensive experience of installation, upgrade, administration, migration, troubleshooting, implementation, and support of Oracle 19c/12c/11g / 10g / 9i / 8i and MS SQL Server databases 2012,2016, 2017 & 2019, AWS RDS(PostgreSQL). • Deployed and managed Oracle GoldenGate Microservices on Oracle 19c and 21c environments for multi-terabyte databases. • Configured and monitored GoldenGate components (Service Manager, Admin Server, Receiver Server, Distribution Server, Performance Metrics Server) via RESTful interfaces and web UI. • Designed and implemented end-to-end data pipelines on GCP, utilizing Python programming for data processing and transformation tasks. • Developed ETL workflows using Google Dataflow and Apache Beam to ingest, cleanse, and load data into BigQuery for analytics and reporting. • 14+ years of experience in Database Engineer/Data Architecture/Administrator and Developer for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005. • Expertise in AWS DMS, AWS SCT, AWS cloudformation, AWS athena, AWS Glue, Redshift, AWS SQS, AWS SNS, EMR, EC2,VPC, Expertise in Google like Platform for Data Pipeline services like ( Data flow, airflow) apache beam, Google big Query.. Snowflake, SnowSQL, SnowPipe • Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities. • Administering SQL Server High Availability and Disaster Recovery strategies. • Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert • Oracle software installation and database creation on Linux and windows. • Managing user, roles and profiles accounts like creating users, granting roles and privileges. • Creating, managing and monitoring tablespaces. • Checking database status using administrative tables. • Configuring RMAN and performing backup and recoveries • Loading data into oracle database using SQL*loader. • Analyzing tables & schemas, rebuilding the indexes. • 24*7 production database support with Support to developers & end-users. HADOOP, HIVE, PIG, HBase,SQOOP, Elastic Search Big Date ETL( Syncsort DMX-h, Podium), Spark, pyspark, Python Successfully Completed Cloudera Administrator Training for Apache Hadoop Successfully Completed Cloudera Analyst Training for Apache Hadoop Azure data factory, azure data bricks Expert in migrating data from on-prem to AWS RDS and GCP cloud, Git , GitHub, devops Oracle administrators and Golden Gate