Sindhu Murugappan
Oracle Database Expert In PL/SQL, RAC Infrastructure, Oracle DBA, Blue Green Implementation, Automation Using Rundeck, Etc
Chennai,TN
Summary
- Technocrat with 13+ years of exceptional experience in Oracle 10g & 11g PL/SQL, Oracle RAC Architecture, Oracle DBA, OGG replication, Unix Shell scripting, Python scripting, BigData, Hive, Spark, Data Analytics, Machine Learning, etc
- Strong people management; managed a high performing technical team of 16 members
- Expertise in Design, performance improvement, fixing heated production issues, problem solving with a passion for technology with skills in grasping the big picture and applying technology / mix of technologies that meet business needs while minimizing risks
- Have achieved Zero Downtime implementation with Blue-Green method adoption; resolved various lock/dead-lock, slowness issues in production; performed online reorg on tables and indexes; worked on Oracle Text Indexes for fuzzy pattern matching
- Automated (application) DB object implementation in production using Shell Scripting and Run Deck
- Provided DevOps solutions for database related source/script maintenance and implementation
Overview
9
9
years of post-secondary education
13
13
years of professional experience
Work History
Senior Manager
Standard Chartered GBS Pvt Ltd
Chennai, TamilNadu
07.2017 - Current
- Working on wholesale banking payment system - STS (Straight Through Processing) system and Cash Data Lake systems.
- Working on a huge DB environment with 46 schemas in 4 DBs built on 2 nodes RAC architecture with SAN storage; handling Manual Load management of nodes.
- Overall Database technical manager taking End-to-End responsibility of anything related to database activities including design and code review and sign-off, production issues fixing, System Improvement Plan and implementation, performance improvement, release management, automation, etc
- End-to-End control of all non-production environments including Database creation, Storage management, Access Management, RMAN backup, OGG/CDC replication setup and management.
- Migration of multiple stand-alone databases to an existing RAC environment.
- Done a POC in building machine learning model for deriving appropriate Rejection Codes with the user input Rejection reason for payments.
- Contributed for building Data Lake for our portfolio in the bank, using BigData Hive, Spark, Python scripting and Microstrategy reporting in T1/T2/T3 architecture.
Delivery Module Lead
Mphasis Pvt Ltd
Chennai, TamilNadu
07.2014 - 07.2017
- Worked for American International Group (AIG) - Legal Entity management (LEM) system.
- Lead a team of 3 members
- Individual contributor - handled requirement gather, design, development, testing and implementation from offshore
- Used advanced concepts like DBMS_PARALLEL_EXECUTE, Bulk collection, RefCursors, DBMS_PROFILER, SQL Loader, Partitioning, Table Audit Management, etc
- Created Autosys jobs to execute a PL/SQL proc or shell script
IT Analyst
Tata Consultancy Services
Chennai, TamilNadu
08.2010 - 07.2013
- Worked for SCB client from their location in Chennai in projects like STP (Straight Through Processes) and STS (Straight Through Service)
- Used advanced concepts like Oracle Text Server and developed a text pattern matching application, Materialized Views, External Table, SQL Loader, etc
- Have done Performance tuning, requirement gathering, development, implementation support.
Programmer Analyst
Cognizant Technology Services
Chennai, TamilNadu
06.2007 - 08.2010
- Joined as fresher through Camus selection and worked for various clients like Abbott, Astrazeneca, etc from off-shore
- Worked on Oracle, Cold Fusion, ASP.NET, etc
- Worked on Development and Support projects
Education
10th Std -
04.2001 - 03.2002
High School -
04.2002 - 03.2004
Bachelor of Science - Mathematics
04.2004 - 03.2007
Master of Computer Applications -
04.2007 - 03.2010
Skills
Oracle 10g & 11g (SQL & PL/SQL), Oracle RAC, Oracle DBA
Unix Shell Scripting, Python scripting
Zero Downtime implementation - Blue Green method, Deployment Automation of DB object changes
Design Expert, Performance improvements, Heated production issue fixes, DB Lock expert
BigData Hive, Spark, Data Analytics, Machine Learning
OGG Replication
Timeline
Senior Manager - Standard Chartered GBS Pvt Ltd
07.2017 - Current
Delivery Module Lead - Mphasis Pvt Ltd
07.2014 - 07.2017
IT Analyst - Tata Consultancy Services
08.2010 - 07.2013
Programmer Analyst - Cognizant Technology Services
06.2007 - 08.2010
Madras University (Part-Time) - Master of Computer Applications,
04.2007 - 03.2010
Meenakshi College For Women, Kodambakkam, Chennai - Bachelor of Science, Mathematics
04.2004 - 03.2007
Hilton Matriculation Hr Sec School - High School,
04.2002 - 03.2004
MBN Govt Girls Hr Sec School, Chrompet, Chennai - 10th Std,
04.2001 - 03.2002