Scrum Master,Sql,Plsql,Unix,Oracle DB

Saranya Erukkam Jayaraman

Email : *******.**@*****.*** Ph.No : +1-502-***-****

EXPERIENCE SUMMARY

The consultant has more than 7 years of experience which includes being a Scrum Master in coaching and handling cross functional teams that involve development and support.

Strong technical expertise in ORACLE PL/SQL Development, ORACLE Database Administration, Unix Shell scripting.

Strong knowledge on Endeca, MDEX 6.51,CAS,Informatica and OBIEE

Have good Presentation skills and task execution skills as a team.

Conceptual Knowledge of Project Portfolio Management and Database.

Skilled to manage multiple project teams focusing on data, business, and stakeholder engagement.

Good Knowledge of Scrum and Kanban across all domains.

Strong Analytical skills

EDUCATION

Bachelor’s Degree, B.E in Electronics & Communication Engineering - 79%

CERTIFICATIONS

Certified Scrum Master (CSM)

TECHNICAL EXPERTISE

Agile frameworks

Scrum, SAFe, Kanban

Programming languages

Oracle SQL, PL/SQL, Unix Shell Script

Tools

Jira, Rally, Azure Devops, MS Office

Project Tools

Confluence, Service Now

Database

Oracle 10g, 11g

E-Commerce

SQL Developer, WinScp, Putty, Toad, Informatica

Soft Skills

Manager, Coach, Trainer, Moderator

PROJECT DETAILS

Mar 2018 - June 2019

Client: St. Louis University,USA

Role: Scrum Master

Responsibilities:

Scrum Master for two teams with a focus on guiding the teams towards improving the way they work.

Resolving impediments by having an understanding on the control and release processes

Assisted with internal and external communication, improved transparency, and radiated information

Prioritization and resolution of software defects

Built relationship with Product owners and other stake holders to facilitate team's interaction with them

Coached Product Owners in creation and maintenance of Product Backlog

Coached team members on agile principles and providing general guidance.

Conducts scrum ceremonies (Backlog grooming, sprint planning, Sprint review and retrospective)

Address the issues and concerns specific to the team as well as the individual and coach them in exceeding expectations

Direct and lead development team from project initiation through the delivery of final product.

Effective usage of JIRA in tracking relevant information to maintaining all epics, features, enablers and bugs through backlogs and its respective objective stories.

May 2016 – Mar 2018

Client: Keysight technologies,USA

Role: Scrum Master

Responsibilities:

Scrum Master using Kanban for support projects.

Performed end to end analysis of SQL, PL/SQL Packages .

Report Generation

Fixing codes (DB, UNIX Shell Script) with Change Request and Production deployment.

Report generation and change implementation using PLSQL packages.

Problem Management Initiative, hence generating additional revenue for the organization.

Analyzing data base performance

by studying alert log files, trace files and monitoring database processes and activities, along with checking for any waits/bottlenecks at database/server level.

Constant monitoring for any memory latches in database, & resolving it by setting/changing relevant configuration/ parameter in database if required.

Application tuning which involves evaluating the execution path and cost of execution of SQL statements.

Tuning rollback segments, computing statistics by analyzing the data objects.

Generating ADDM, AWR, ASH Stats pack reports & analyzing them for better performance of database by capturing any wait within the database as well as on server level.

Daily/weekly maintenance of all the databases to improve its performance by gathering schema/table/index stats, rebuilding indexes on regular basis, reorganizing the database objects, also by moving database files, if required to reduce I/O contention.

Reorganize the databases and the segments having fragmentation, row migration and chaining intricacies to rip the optimum performance and resources benefits

Maintaining Index and Dgraph Servers

Monitoring Baseline run daily and fixing in case of issues

Worked on Pipeline components

Having good knowledge in Endeca Information Discovery

Enhanced client’s Employee Stock Purchase Plan (PL/SQL package) as per business requirements, thereby reducing the client’s waiting time stock payout.

As part of a vendor change, altered PL/SQL packages and UNIX Shell scripts to accommodate their terms.

Have created monitoring scripts and several automations for the process improvement

Jun 2014 – Apr 2016

Client: Agilebt technologies

Role: Coding, Oracle DBA, UNIX scripting & L3 Support

Responsibilities:

Migrating the code from old to new servers.

Code changes based on the new clients requirement.

Worked along with other teams to ensure integrity of all applications.

Migrating 10.2.0.4 databases to 11.2.0.3 databases.

Backup and recovery management using RMAN & export/import/Data pump utilities.

Cloning of database.

Implementation and management of DR site i.e physical standby database using RMAN.

Database/Schema refreshes (Export/Import/Data pump).

Used job scheduling like CRONTAB backup and recovery activities.

Creation of databases for Production/Testing/UAT

Database/Schema refreshes (Export/Import/Data pump). Management of Oracle Streams

Setup Mviews for Replication between production and DR sites.

Troubleshooting performance Related issue using AWR and ADDM

Exploring automation opportunities to reduce manual work and to minimize the possible errors.

Creating automation scripts to be used during downtime of servers to shut down and startup various old and newly created application instances.

Creating scripts to monitor jobs running on production and raising incident/ticket in case of failure

Creating Scripts to check replication status

End-to-End Environment refresh from production with automated scipt created in Unix.

Mar 2013 – Jun 2014

Client: Agilent technologies

Role: Application maintenance & Support

Responsibilities:

Performed end to end analysis PL/SQL Packages

Resolving issues faced by Clients and tracking the Incidents using SM9 tool.

Report Generation.

Implementing ITIL best practice.

Complete Deployment of Database and application

Providing Daily Production support for Databases, that includesTable space management, Schema management

Generating and monitoring Stats pack, AWR, ASH and ADDM reports

Session monitoring.

Database Backup, Restoration and Recovery (Export-Import/EXPDP-IMPDP)

RMAN Backup.

Performance tuning

Attending Daily status Meetings on Incident and Change Requests discussion with Client.

Adding value to client by improvising current process and thereby increasing Revenue and Productivity.

Involved in Code fix/enhancement in both SQL objects, PL/SQL packages and UNIX Shell scripts.

As part of value add, created PL/SQL packages from scratch to monitor stuck transactions.

Contact this candidate