VINAYAK KHARE

551-***-****, ad36r6@r.postjobfree.com

Summary

An excellent IT professional with 22+ years (15+ years in US) of focused experience in various domains including Banking, Financial, Healthcare and Manufacturing.

Experienced on AWS (EC2, VPC, IAM, S3, RDS, and DMS) / Azure / OCI.

Proficient in migration of databases using AWS Data migration services and IaC tools (Terraform).

Good understanding of Exadata architecture and storage cell administration using CELLCLI.

Proficient in Oracle 11g/12c/19c RAC database software installation, migration, backup & recovery, high availability, disaster recovery, performance tuning and capacity planning.

Experienced with Active Data Guard configuration, switchover and failover.

Experienced with complex designs of the logical and physical model of the databases using ERWin.

Experienced with Oracle Golden Gate replication and administration tasks.

Extensive experience with performance tuning and health check of Oracle databases using AWR/ADDM Reports, Explain Plan, SQL Trace, TKPROF and OEM 13c.

Installed and configured Oracle Cloud Control 12c/13c server and deployment of agents.

Experienced with administration of SQL Server, PostgreSQL and MySQL databases on AWS & Azure.

Programming expertise with PL/SQL, T-SQL, JavaScript, Unix Shell and Perl languages.

Experienced with ITIL/ ITSM best practices on Change and Incident management.

Created documents related to database standards and best practices.

Excellent team player with good communication skills and capable of working independently.

Flair to learn and implement new technologies.

Education

MS Computer Application, RGPV Bhopal, India – 2001

Full Stack Academy of Code, New York City - 2020

Certifications & Trainings

AWS Certified Solutions Architect Associate

Oracle Database 11g Administration Certified Associate

Exadata Storage cell administration with CELLCLI.

MongoDB Database Administrator course.

Technical Skills

Operating Systems

Linux, AIX, Windows 2003/2012

Tools/Utilities

RMAN, SQL Developer, OEM 13c/12c, Erwin, CELLCLI

Databases

Oracle 19c/12c/11g, Exadata, Microsoft SQL Server 2012/2008/Azure, MongoDB, MySQL, PostgreSQL

Languages

SQL, PL/SQL, T-SQL, Unix Shell scripting, Perl, Power Shell scripting, JavaScript

Professional Experience

Comcast Inc., Mount Laurel, NJ June 2022 – Nov 2023

Title: Database Engineer

Responsibilities:

Spearheaded the spinning up of databases in EC2 instances, ensuring efficient deployment and management of database infrastructure.

Managed both RDBMS and NoSQL databases, including MySQL, PostgreSQL, MongoDB, and DynamoDB, ensuring optimal performance and reliability.

Designed and implemented VPC networking in AWS, focusing on performance and security, ensuring compliance with best practices and organizational requirements.

Conducted database tuning activities to optimize performance and reliability, including query optimization, index tuning, and configuration adjustments.

Leveraged Terraform for infrastructure automation and management.

Migration of databases using AWS Data migration services (DMS).

Database design with ERWin (logical model & physical model creation).

Scripting database jobs and shell scripts for maintenance activities.

Creating schemas, tablespaces, partitions, indexes, packages, procedures, functions and triggers.

SQL performance tuning and database tuning.

Experienced with installation, configuration Oracle RAC (Primary & DR) database with Data Guard.

Working experience with customers for different RAC related issues.

Analyze and implement ETL solutions for huge data set using data partitioning, data compression, direct path loads, reconciliation and exception handling.

Supported replication solution using Golden Gate.

Analyze user requirements and perform database reporting using Minio, Perl and PySpark, Kubernetes.

Analyze the dependencies and bulk fix/update the Ping Directory database with Perl script.

Supported in 24X7 Follow-the-Sun shifts with Incident, change tickets and other scheduled activities.

Solution Environment: Oracle 12c/19c, ASM, Data Guard, RMAN, OEM 13c, Exadata, PL/SQL, MinIO, Perl, PySpark, Python Kubernetes, AWS - RDS, DynamoDB, MySQL, PostgreSQL, EC2, VPN, S3, Cloud Watch, DMS

Client: Deutsche Bank Oct 2021 – Jun 2022

Title: Database Administrator

Responsibilities:

Scaled up to handle the Bank-wide rollout of ExaCC and ExaCC-Autonomos multitenant databases and the resolving the issues related to database provisioning workflow.

Supported Oracle database in 24X7 Follow-the-Sun shifts. Handling Incident/change tickets in production and non-production environment.

Experienced with installation, configuration Oracle RAC (Primary & DR) database with Data Guard.

Working experience with customers for different RAC related issues.

Experience with backup and recovery issues related to corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Issues with block change tracking & FRA.

Experience with patching (GI & RDBMS) and upgrades of Clusterware and database 11g to 12c.

Coordinating with application teams during release cycles to identify and tune SQL queries using hints to use optimal plan, query rewriting, PL/SQL performance code design review and tuning suggestions.

Supported replication solution using Golden Gate.

Created scripts to monitor for alerting on lags, failures and issues on Golden Gate.

Solution Environment: Oracle 12c/19c, Data Guard, ASM, RMAN, Exadata, ExaCC, OCI Console, OEM 13c

Client: Horizon BCBS of NJ May 2017 – Oct 2021

Title: Database Administrator

Responsibilities:

Managed databases on AWS. Dynamo DB, RDS. Configured EC2 instances, Cloud Watch.

Designed and implemented VPC networking in AWS, focusing on performance and security, ensuring compliance with best practices and organizational requirements.

Conducted database tuning activities to optimize performance and reliability, including query optimization, index tuning, and configuration adjustments.

Experience in installation & configuration Oracle RAC (Primary & DR) database with Data Guard.

Experience with backup and recovery issues related to corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Issues with block change tracking & FRA.

Experience with patching (GI & RDBMS) and upgrades of Clusterware and database 11g to 12c.

Designed and implemented replication solution using GoldenGate.

Created scripts to monitor for alerting on lags, failures and issues on Golden Gate.

Installation, configuration, upgrade and support of MySQL databases.

Administration of SQL Server 2008/2012 databases with database backup and restore, schema, users and objects management.

Solution Environment: Oracle 11g/12c/19c RAC, Data Guard, ASM, RMAN, OEM 12c/13c, AIX, Linux, Windows, Golden Gate, SQL Server 2012, AWS - EC2, VPN, S3, Cloud Watch, DMS

Client: ARRIS Solutions, Inc., Beaverton, OR Jan 2016 – Apr 2017

Title: Database Administrator

Responsibilities:

Managed both Oracle and SQL Server databases in agile environment.

Managed Azure SQL Server databases, Blobs using Azure portal and storage explorer.

Creating Power shell scripts for database monitoring.

Performance issues resolution in production databases from AWR, ADDM reports,

Database management by creating schemas, tablespaces, partitions, indexes and coding in PL/SQL and T-SQL packages, procedures, functions and triggers.

User access management by creating roles, views and object/system privileges.

Performed cloning, schema refresh, patching, upgrade and migration of databases.

Solution Environment: Oracle 11g/12c, Linux, Windows, SQL Server 2012, Azure, Data Guard, Power shell, Azure Storage Explorer, Cloudberry Explorer, SSMS, SSIS.

Client: Caterpillar, Peoria, IL Oct 2011 – Dec 2015

Title: Database Administrator

Responsibilities:

Installation, configuration, upgrade, patching, migration backup and recovery of Oracle databases

Performance Tuning and monitoring using AWR, ADDM, SQL tuning advisor.

Application database support creation of schemas, tablespaces, partitions, indexes.

Solution Environment: Oracle 10gR2/11gR2/12c, AIX, Linux, Microsoft SQL Server 2012, MySQL, OEM 12c, RMAN, ERWIN, SQL Loader, TSM/TDPO, EMC Data Domain/AVMAR, Data Guard, ASM, ACFS

Other Clients worked with:

The Northern Trust Company, Chicago (Jun 2008 – Sep 2011), Morgan Stanley (Aug 2006 – May 2008),

Indian Railways (Oct 2003 – Jul 200), Save the Children UK (India) (Jul 2001– Sep 2003)

Contact this candidate