Srikanth Vaidyanathan

adgr1l@r.postjobfree.com

647-***-****

PROFESSIONAL SUMMARY

Senior Database Consultant having over 18 years of extensive experience covering all phases of the System development, Database Administration, Database Design, Modeling,Development, Support and Maintenance in the Information Technology industry.

Proficient with AWS Elasticsearch and also with NoSQL databases.

Strong theoretical and practical understanding of Data Warehousing, Multidimensional Modeling (conceptual, logical and physical).

Database design, implementation, capacity planning, storage management, monitoring database environments, tuning and performance.

Proficiency and Expertise in Server Replication, Backup/Recovery, Disaster recovery and planning.

Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) with different methodologies like Agile, Scrum & Waterfall etc. and capable of handling responsibilities independently as well as a proactive team member

Proficient in programming/scripting languages such as Bash, PowerShell and Python

Experience and working in Agile environment

IT Service Management (ITSM) based on ITIL best practices

An effective problem solver, dedicated, hardworking, highly creative, resourceful self-starter and organized team player with good communication skills

TECHNICAL SKILLS

Database Version:

oSQL Server Database Administration (Microsoft Azure, 2016/2014,2012,2008,2005)

oOracle Database Administration (19c, 18c, 12c, 11g, 10g), Exadata (X5/X7/X8)

oPostgreSQL 9.5, EDB PostgreSQL 11

oMySQL 5.7/5.6/8.x, Cassandra.

ETL Tools: SSIS, DTS, SSAS, SSRS, SAP (BO) ETL v4.2, v3.1

Infrastructure Tools: Terraform, Ansible, MS Build, TFS

CI Tools: Jenkins

Other Tools: OEM, Oracle SQL Developer, TOAD, SQL Management Studio, IDERA, RMAN, Goldengate, Data Guard

MS Office (Excel, MS Project, Word, Power Point), MS Visio

Operating Systems: RedHat Linux, Oracle Linux, Unix, Windows Servers 2014/2012/2008

Modeling Tools: Erwin, TOAD, SQL Developer, PowerDesigner 16.5

Programming Languages/Scripting: Java, Python, Power Shell, Azure CLI, PL/SQL, SQL, T-SQL, SQL*Plus, Java, Unix Shell Scripts, Perl Python, Power BI, JavaScript.

Cloud Solutions: Microsoft Azure, AWS.

Networking Kit: Active Directory, Vsphere, Solarwinds, Wireshark, SCOM, Remedy, VPN Proxy Servers.

Web Stack : Nginx,PHP-fpm,Percona-DB

Others : Git, Jira

Virtualizations: VMWARE ESXI, HYPER V, VMWARE WORKSTATION.

Application Server: Apache http server,Tomcat, Oracle WebLogic, WebSphere(WAS), JBoss

EMPLOYMENT EXPERIENCE

HCL Technologies, TORONTO Aug 2017 - Jun 2020

Independent Contractor

Client - Rogers

Sr. Database Engineer

Project: Supported Rogers Data Centre on-prem to cloud databases

Oracle

Supported PROD and QA environment of around 2000 Oracle databases and more than 800 Goldengate replication on Exadata (X7/X8), Microsoft Azure, Hadoop, Oracle cloud database for Rogers Data Centre.

Managed and monitored daily around 9000 alerts, related to DB, Replication, DG lag performance, long running queries.

Done POC for migration of Oracle database from 12c to 19c, as well as support application migration testing .

Supported Oracle database on (Dev,QA, PROD) 12c, RAC, ASM, Data Guard, Goldengate.

Supported migration of old databases and applications from 11g to 12C with Grid infrastructure on a RAC environment with Data Guard (DR).

Configured Physical standby databases and perform switchover/failover activities as a part of the release and DR activities.

Installed, configured and tuned Goldengate (11g, 12c) on various environment like Oracle Exadata, Oracle Cloud, Microsoft Azure, Hadoop,

Actively done performance tuning (AWR, ASH) and monitoring with Enterprise Manager Cloud Control (12c/123c) for mission critical databases.

Managed and maintained the enterprise data warehouse database and providing housekeeping scripts.

Provided database technical expertise to other team members.

Supported RMAN backup and recovery.

Supported data compression and encryption on databases.

Provided Unix scripts for deployment and maintenance tasks.

Supported monthly release and patching activity.

MS SQL Server

Installed configured and administered databases on MS SQL Server 2016/2017

Installed, configured and maintained MS SQL Server Replication for production servers to provide high availability (AOAG).

Worked as Cloud Administrator on Microsoft Azure, involved in configuring virtual machines, storage accounts, resource groups.

Migrating on-premises SQL Server Database.

Experienced in providing analysis on High availability/Disaster recovery & scalability

Implemented Extended Events to replace custom scripts for monitoring & troubleshooting issues

Design and Implemented In-memory tables in 2016 OLTP database server

Scripting PowerShell to automate database/Server level activities like monitoring disk space, Status of services etc.,

Cassandra

Involved in upgrading the Cassandra test clusters.

Determining and setting up the required replication factors based on the input from application teams.

Creating required tables with appropriate privileges to the users and secondary indexes.

Set Cassandra backups using snapshot backups.

Used OpsCenter to monitor Cassandra clusters.

Implemented Spark solution to enable real time reports from Cassandra data.

Performance tuning a Cassandra cluster to optimize writes and reads.

Involved in the process of bootstrapping, decommissioning, replacing, repairing and removing nodes.

Troubleshoot read/write latency and timeout issues in CASSANDRA.

Technical Environment: Oracle 11g/12c, Exadata,MS SQL Server 2016/2017,Cassandra, AIX, Linux, Goldengate, ASM, RAC, DG, OEM Cloud Control 12c/13c, RedHat 7.3, Apache http server, Git, Azure Monitor, Oracle SQL Developer, TOAD, SSMS, IDERA, Ansible, PowerShell, Python.

BMO, TORONTO

Senior Database Consultant

Project: Migration of databases and its application from 11g to 18c of a number of critical wealth applications such as Retail Investment System (RIS), Invers Torline, SmartFolio and Nesbitt Burns Gateway. Achieved ramping up of the project and getting completed on-time.

Installed, configured and administered Oracle RAC (18c) in CDB/PDB model.

Re-platforming Oracle databases from HP-UX to x86(RHEL).

Migration of Oracle FMW Forms 11gr2 to Oracle Forms 12c.

Planning and supporting the GUI migration and testing along with the batch process.

Resolving issues with batch (around 100 programs), related to performance and other issues.

Installed and configured Oracle Data Guard as a part of DR strategy.

Configure and provide Goldengate support for migration (POC).

Setting up of Goldengate Active-Active Replication.

Refreshed data from Prod to QA and PET environments.

Setup and ssupported RMAN backup and recovery.

Hardening the database based on the internal security standards.

Technical Environment: HP-UX, Linux, Oracle 11g/12c/18c, Goldengate, ASM, RAC, DG, Oracle Forms

OEM Cloud Control 13c, Linux, RHEL, HP-UX, FMW, Jira, Git

Fujitsu Canada, Toronto SEP 2001 – Feb 2017

Database Consultant - Permanent

Project Description/Scope: Analyze, Design, Develop and Implement Projects/Systems:

Surveillance Data Repository (SDR).

Meter Trouble Report (MTR).

Commercial Reconciliation System (CRS).

Notice of Disagreement (NOD).

Transmission Tariff Demand System (TTDC).

Guaranteed Combined Generation (GCG).

Enhanced Day Ahead Commitment (EDAC).

Responsibilities:

Installed, Configured and supported Oracle,SQL Server, PostgreSQL database.

Designed the physical and logical data modeling design for development projects.

Designed backup and planned disaster recovery for all the databases.

Provide on-call support provided on rotational basis.

Oracle

Installing, monitoring, maintaining, and tuning production RAC database and databases supporting several lower environments.

Migrated legacy database and application to Oracle 11g .

Designed a autoloading of legacy data for 7 years archiving.

Designing and implementing redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.

Resolved database access and performance issues.

Supporting RMAN backup and restore activities

Apply patch and application fixes on the need basis .

MS SQL SERVER

Reviewed and optimized SQL queries, stored procedures, functions, Indexes,

views and triggers from other developers to achieve maximum efficiency.

Installed, configured and maintained MS SQL Server Replication for production servers

to provide high availability.

Implemented partitioning to handle tables with over 300 million rows.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files,

and XML) and loaded the data into target data sources by performing different kinds of

transformations using SQL Server Integration Services (SSIS).

Involved in SQL security and planning.

Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.

Created maintenance plan backup, reorganize index, rebuild Index, Update Statistics and Cleanup task.

Provide 2nd and 3rd tier support, meeting Company committed service delivery metrics;

delivery of VCR’s and Problem resolution according to estimate and schedule and using

industry best practices for service management (e.g. ITIL).

PostgreSQL

Installed, configured, troubleshooted, monitored, upgraded, and tuned new and existing PostgreSQL databases.

Designed database structures, indexes, views, partitioning.

Installing and configuring the PostgreSQL DB in multimode environment and implemented backup and recovery

Reviews database design and integration of systems, and makes recommendations regarding enhancements and/or improvements.

Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster.

Installing and configuring the PostgreSQL Monitoring tools like Postgres Enterprise Manager (PEM)

Installing and configuring connection pooling tool Pgbouncer (to reuse buffer connection between DB and APP).

Configuring PostgreSQL Streaming Replication and Pgpool for load balancing

Configured log analyzation tools like pgfouine and pgbadger.

Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.

Supported development team for performance testing and code testing.

Proactive in updating the latest security patches

Technical Environment: Oracle 8i/10g/11g, MS SQL Server 2005/2008/2012, PostgreSQL 9.5, Financials, Lawson, EXADATA, Oracle 11g/10g RAC, Unix HP-UX, Sun Solaris, WebSphere, Tomcat, Erwin, TOAD, EMC, Visio, Java, XML, Oracle ADM, Perl, Bits Query (BI)

EDUCATION AND TRAINING

Bachelor of Science in Engineering (Computer Engineering), CA, Newport University

Completed PostgreSQL Administration Essentials training from EDB

AWS Certified Cloud Practitioner

Certified Oracle Autonomous Database Cloud 2019 Specialist

DevOps for Databases (Microsoft: DEVOPS200.6x )

DevOps Practices and Principles (Microsoft - DEVOPS200.1x)

ITL v3 Foundation certified

Contact this candidate