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 -
MBN Govt Girls Hr Sec School, Chrompet, Chennai, Chennai
04.2001 - 03.2002
High School -
Hilton Matriculation Hr Sec School, Chennai
04.2002 - 03.2004
Bachelor of Science - Mathematics
Meenakshi College For Women, Kodambakkam, Chennai, Chennai
Senior Associate, Product Owner/Specialist, SME at Standard Chartered GBS Pvt. LtdSenior Associate, Product Owner/Specialist, SME at Standard Chartered GBS Pvt. Ltd
Manager,Country Regulatory Reporting for Singapore at Standard Chartered GBS Pvt Ltd.,Manager,Country Regulatory Reporting for Singapore at Standard Chartered GBS Pvt Ltd.,