Meganathan Valavan
Roseville
Summary
Accomplished Senior Oracle DBA with extensive experience at JPMorgan Chase & Co, specializing in performance tuning and backup recovery. Proven track record in leading teams through Agile transformations while enhancing database efficiency. Expert in Oracle 19c and skilled in collaboration, driving operational excellence and reducing costs through automation.
Overview
27
27
years of professional experience
Work History
Senior Oracle DBA
JPMorgan Chase & Co
08.2023 - Current
- Manage and support hundreds of highly critical production 24x7 RAC/non-production databases (19c and prior versions) for various JP Morgan groups.
- As part of the Infrastructure Engineering Oracle DBA team, responsible for the delivery of outstanding database operational support across the regions.
- The role is focused on providing excellent customer support experience, partnership, and collaboration with multiple technical teams to solve complex technical issues and reduce operating costs through standardization and automation.
- Expert experience in Creating, maintaining, and administering various multi-terabyte 24x7 uptime Oracle databases.
- Extensive experience working on multi-node RAC clusters, RAC databases, ASM, Dataguard, Oracle Enterprise Manager 13c, Oracle Installation, Oracle PSU patching, and version upgrades.
- Oracle technical consultancy to Application Support and Development teams, including performance tuning, database security auditing, and deployment of Oracle database advanced features.
- Strong understanding of database architecture and performance-tuning skills.
- Extensive experience with Backup and Recovery using Oracle RMAN, and ZDLRA appliances.
- Executes work according to compliance standards, risk and security, and business objectives.
- Expert in DB Performance Diagnostic and tuning skills (both SQL & system levels), handling Golden Gate Setup, Hub architecture Replication, and migration using Golden Gate Hub.
- Providing technical guidance and training to team members.
- Knowledge in many areas of infrastructure engineering such as databases, storage engineering, deployment practices, integration, automation, scaling, resilience, database security policies, performance assessments, etc.
- Collaboration and partnership with all technical teams involved in database service delivery.
- Knowledge Transfer and mentoring for the global Oracle DBA support team.
- Provide 24/7 on-call production database support.
Senior Oracle DBA/Kanban Lead
Wells Fargo
CA
01.2008 - 06.2023
- Manage and support hundreds of highly critical production 24x7 RAC/non-production databases (19c and prior versions) and Data Warehouse databases for various Wells Fargo groups in Linux/Unix and Exadata environments.
- Oversee full-scale production support services, which include Oracle Grid Infrastructure software installation/configuration for RAC and standalone servers, Oracle ASM configuration, Oracle database binary installation, Grid/Oracle Cloud Infrastructure(OCI)/DB patching (CPU/PSU), upgrade/migration of databases, implementing and managing High Availability systems using RAC & Data Guard, troubleshooting, etc.
- I successfully led the Wells Fargo DBA team's transition to Agile Transformation using JIRA and Confluence through Scrum and Kanban methodologies.
- I am a skilled leader who has successfully managed teams of US and off-shore Wells Fargo DBAs on numerous projects that entailed Oracle 19c/12c/11g installation/patching, database upgrades, DB migrations, Semi-annual Disaster Recovery testing, etc. for hundreds of Oracle plus SAP specific Oracle databases.
- Architectural planning, configuring, and implementing high availability Oracle standby databases using Data guard (active standby) and SAN replication technologies.
- Manage all Service Requests (SRs) with Oracle Cloud Infrastructure (OCI) to coordinate and complete any system and/or data administration tasks.
- Extensive experience with Oracle Data Guard and Oracle Golden Gate setup, maintenance & troubleshooting.
- Managing performance tuning of databases, tuning of application SQL, PL/SQL code, DB maintenance, DB monitoring, etc., in all database environments.
- Manage and implement the RMAN Backup & Recovery solutions using the dedicated infrastructure servers.
- With my expertise in performance tuning, I specialize in instance tuning, SQL and PL/SQL tuning, and analysis using AWR, ASH, ADDM, Stats pack, Oracle Cloud Infrastructure Wait Analysis, and application tuning.
- Deliver database monitoring, configuring, and monitoring the databases using Oracle Enterprise Manager (OEM) 13c Oracle Cloud Infrastructure (OCI) Control, installing all database tools/OEM agents, etc.
- Maintain databases according to company security policies, procedures, and compliance standards and implement Oracle Advance Security options TDE, fine-grained access control, VPD, and Oracle Database Vault.
- Utilize knowledge and specialization in SAP Basis administration and provide complete Oracle DBA Support for SAP Applications.
- Expert-level skills in ETL & data transformation to meet all business requirements.
- Perform schema/space management and schema comparisons between environments and provide DBA/Development expertise for all application/data management group needs.
- Installation, Configuration, cloning, and patching of Oracle E-Business Suite R12.
- Experience with MongoDB, PostgreSQL & Yugabyte.
- Designed and architected Disaster Recovery solutions for various production databases.
- I excel at creating various technical documents, specifically for database patching, quarterly releases, database upgrades, migration, and data warehousing.
- I expertly led the upgrading of one of the bank's critical databases for the 'You Owe Me' (YOM) Application. For this initiative, I proficiently managed the DB upgrade, which had a complex setup of six standby databases.
- Unix Shell scripting for all database/data warehouse maintenance and automation needs.
- Provided 24/7 on-call production database support.
Senior Data Base Administrator
Verizon Business
Sacramento
01.2007 - 12.2007
- Senior Oracle DBA managing & supporting hundreds of highly critical 24x7 production databases(10g databases mainly and a few 9i), data warehousing, QC, and development databases in Unix and Linux environments.
- Manage full-scale production support services, including extensive Oracle installation/upgrade, patch upgrade, multiple DB migrations/upgrade (8i/9i to 10g), maintenance, full-scale monitoring, and troubleshooting of Oracle databases.
- Configure/implement/supporting of high availability Oracle standby production databases using Oracle 10g Dataguard.
- Extensive performance tuning of database servers and Oracle instance.
- Performance tuning of SQL and PL/SQL code using ExplainPlan, Statspack, tools/utilities, various Oracle features, Tkprof, etc., for all application and reporting needs.
- Planning and Implementing Backup & Recovery strategies for all production databases.
- Plan/Design/Configure/troubleshoot all RMAN production & non-prod database backups.
- Extensive multiple database monitoring using 10g Grid Control, HP OpenView, custom scripts, etc.
- Configuring/Implementing/managing advanced replication using Multimaster /MView / Triggers/snapshot replication etc., for all OLTP/Data warehousing needs.
- Storage management, Managing and migrating dictionary-managed tablespaces to locally managed tablespaces, indexing and table partitioning, parallel query, etc. to squeeze every bit of performance out of the database.
- Database architecture, capacity planning, database design, and implementation for all OLTP and Data warehousing databases.
- Design, development, and implementation of the Data Warehousing process and Data Mart. Planning and implementing the ETL process consisting of data transformation, data sourcing, mapping, conversion, and loading.
- SQL, PL/SQL coding for all database packages/procedures/triggers/ETL implementation, ETL support, etc., for all DBA/Development requirements.
- Administering, maintaining, developing, and implementing policies and procedures for ensuring the Security and integrity of the database system using Oracle Transparent Data Encryption(TDE), data encryption/decryption, various Oracle features, etc.
- Plan and coordinate with System Administrators in all new database configurations and implementation.
- Author of many technical design documents for new Database Technology Implementation using exceptional design and analytical abilities.
- Unix shell scripting, creating database monitoring scripts, alert scripts for all DBA/Development team tasks, Actuate report support, etc.
Senior Data Base Administrator
iTrade Network (ITN)
Livermore
03.2006 - 12.2006
- Senior Oracle DBA, managing & supporting highly critical 24/7 very large production, data warehousing, and development databases in Unix, Linux, and Windows environments.
- Manage full-scale production support services, including installation/upgrade, maintenance, configuration, DB migrations, & troubleshooting of Oracle 10g databases.
- Implementing Backup strategies and configuring Backups using RMAN & Veritas NetBackup.
- Performance tuning of databases, SQL, & PL/SQL code to meet sub-second response time.
- Performance tuning exercises utilizing Oracle partition strategies for data warehouse databases.
- Architect high availability and replication databases for all project needs.
- Creation, cloning, and troubleshooting of development and test databases for various project needs.
- Successful experience in providing all-round expertise (complete Production DBA/Dev. Support, Extraction/ Transformation/Loading), in the implementation and execution of various huge Data warehousing projects.
- Implementation and deployment of the Oracle 10g Grid Control for the management and monitoring of multiple Oracle databases throughout the organization.
- Mentoring and supporting the developers in all their database needs and issues.
- Logical and physical design and development of database schemas under Oracle 10g and 9i databases.
- Design, develop, and implement the Enterprise Data Warehouse (EDW) and Data Mart. Extensive work in ETL process consisting of data transformation, data sourcing, mapping, conversion, and loading.
- Data Modeling - Logical and physical database design for both decision-support and transactional systems.
- Unix shell scripting for all DBA/Development team tasks.
Senior Data Base Administrator
State of California Dept. of Developmental Services
06.2004 - 01.2006
- Perform all DBA functions, including full-scale production DBA support services, installation, configuration, upgrades of Oracle databases, database maintenance, performance tuning, troubleshooting, backup & recovery, capacity planning, data migration, database replication using Oracle Streams, Materialized view/Snapshots, etc. in all OLTP/Data warehousing databases.
- Overall Database architecture and design, architectural planning and design standard for all new Oracle projects, recommending and implementing all data warehousing databases.
- Backup & recovery planning and implementation using RMAN, Export/Import of databases, Log Mining, security administration, audit trail, etc.
- Performance tuning includes database instance tuning, I/O tuning, improving the data warehouse loading performance, Oracle application/data mart reports tuning, and Oracle SQL tuning using Explain Plan, StatsPack, all Quest-provided tools, etc.
- Mentoring and supporting the developers in developing all Oracle complex systems using SQL, PL/SQL, planning and implementing various database source data into a single large data warehouse, Data migration, and Data warehouse data loading using Oracle Streams.
- Providing all-round expertise (complete DBA/Dev. Support, Extraction/ Transformation/Loading) in all Data warehousing projects, performing detailed data analysis, Design of Logical, Physical Data Models, Star Schema Dimensional modeling for all data warehouse and OLTP databases utilizing Erwin, Data Marts schema design, coding of PL/SQL packages, procedures, db triggers, preparing SQL
- Loader scripts, etc.
- Supporting and assisting the data warehousing/conversion team in all data Extraction/Transformation/Loading processes, providing all-around DBA/Development expertise for all their needs, Unix shell scripting, supporting all release management group activities, etc.
Senior DBA/Senior Developer
Sun Microsystems, Inc
Newark
03.1999 - 05.2004
- Advanced technical operations, serving in various senior-level database administrations in huge data warehouses and OLTP databases, technical architect, and leadership roles.
- Manage full-scale production support services, including Oracle installation/upgrade, configuration, maintenance, backup/recovery planning and implementation, and tuning of databases, including Oracle instance tuning, Oracle SQL tuning, and Oracle application tuning.
- Led the development team to develop applications using Oracle, Java, and Trillium and implemented various Country projects supported by Trillium in both Batch mode and Online.
- Solid experience in multi-byte DB Migration, Table partitioning, Oracle Server/database upgrading, Data Loading, migration across databases, managing the standby databases, Log Mining, Oracle partitioning, etc.
- Perform database Replication using SharePlex/Materialized Views/Snapshots. Unix shell scripting for all DBA/Dev. Related tasks, Solaris Package creation, Basic Unix Administration support, etc.
- Exceptional skills in Coding Database procedures, functions, and triggers using SQL, PL/SQL, and Dynamic SQL; Data modeling (logical & physical database design) using Erwin, Silver Run, and Rational Rose tools, Reverse Engineering of OLTP/Data warehousing schemas.
- Configure/administer the Oracle Internet Directory (OID) servers.
- Providing all-round expertise (complete DBA/Dev. Support, Extraction/ Transformation/Loading) in all Data warehousing projects using traditional data warehousing techniques, star schema, data cleansing ETL, dimension and hierarchy maintenance, etc., migrating data from various OLTP servers/databases to the data mart using Informatica, translating the business processes into Informatica mappings for building the data mart, etc.
- Charged with System Analyst, Data Architect, Data Analyst, and Senior Developer responsibilities, including working with business users to gather requirements and develop specifications.
- Extensive experience in managing source codes using SCCS, &CVS.
- Senior Oracle expert in Oracle Expert Group formed by Sun Microsystems, Inc, IT Division. In this role, I assisted worldwide internal units of Sun in meeting challenging technical requirements and overcoming complex issues.
- Successfully planned and demonstrated the Fail-over database implementation using the SharePlex tool for vast data warehouses and executed various Database replications using Snapshots/Materialized views.
- Implemented 800GB plus databases for data warehousing applications by successfully planning and designing Disk Layouts in various Sun Enterprise servers.
- Demonstrated top-notch DBA ability in all Tuning efforts required for the various DSS/OLTP production databases and Led the Dev—team in tuning all SQL, PL/SQL application code.
- Author of many technical design documents for new systems implementation, using exceptional design and analytical abilities.
Database Administrator
EMC Corporation
Schaumburg
10.1998 - 02.1999
- Served as Database Administrator for Firestone Inc., providing 24x7 Production support, configuring, planning, and implementing terabyte-sized databases across EMC disks.
- Effectively supported over 500GB databases with hundreds of concurrent users.
- Providing production support, maintenance, and database tuning, including Oracle Instance tuning, SQL tuning, etc.
- Set up and configured Oracle servers on HP-UX platform/EMC storage devices, planning and designing hardware/software architecture and layout.
- Tuned Oracle server, optimizing memory, storage, and performance. Partnered with System Administrator to determine logical volume size, volume groups, file system size, stripe size, and width.
- Enhanced operations by tuning SGA size, all init.ora parameters, Redo logs, and Rollback Segments.
- Given a charge to lead the DBA team in improving the performance of the highly fragmented production database. Successfully carried out this massive effort after the detailed analysis, and the Production Database performance has improved more than the Business Team’s expectation.
- Improved performance by coding stored procedures/functions, triggers, and packages using PL/SQL and Dynamic SQL.
Education
Bachelor of Engineering - Mechanical
University of Madras
Chennai, IndiaSkills
- Production DBA 24x7
- Backup & Recovery
- Exadata
- RAC
- ASM
- Performance Tuning
- Capacity Planning
- Replication
- RMAN
- Datapump
- Exp
- Imp
- OEM Cloud Control 13c
- Data warehouse
- Data Marts
- Enterprise Business Intelligence
- Operational Data Store
- Red Hat Linux 7x
- Red Hat Linux 6x
- Oracle Linux 7x
- Oracle Linux 6x
- Agile - Kanban
- Agile - Scrum
- Linux
- Unix
- HP-UX
- AIX
- Sun Solaris
- Windows
- HP-9000
- Sun Enterprise
- Sun E-10K
- Sun E4200
- Sun Ultra
- IBM Servers
- Oracle 19c
- Oracle 12c
- Oracle 11g
- Oracle 10g
- Oracle 9i
- Oracle 8i
- SQL
- PL/SQL
- Erwin
- Informatica
- SQL Server
- MongoDB
- PostgreSQL
- Yugabyte
- AWS
- GCP
- Azure
- Data Modeling
- Data Guard
- Oracle Golden Gate
- Analysis
- Design
- Java
- J2EE
- JSP
- Struts
- JavaScript
- EJB
- JDBC
- HTML
- XML
- Designer 2000
- Developer 2000
- Quest tools
- Toad
- 10g Grid Control
- OCI
- OEM
- 10g dbconsole
- Share Plex
- SilverRun
- Rational Rose
- Trillium
- Unix Shell Scripting
- CVS
- SCCS
- ClearCase
- Oracle Streams
- Loader
- SVRMGR
- VISIO
- Crystal Reports
- StatsPack
- BigBrother
- TKPROF
- ExplainPlan
- Autosys
Timeline
Senior Oracle DBA
JPMorgan Chase & Co
08.2023 - Current
Senior Oracle DBA/Kanban Lead
Wells Fargo
01.2008 - 06.2023
Senior Data Base Administrator
Verizon Business
01.2007 - 12.2007
Senior Data Base Administrator
iTrade Network (ITN)
03.2006 - 12.2006
Senior Data Base Administrator
State of California Dept. of Developmental Services
06.2004 - 01.2006
Senior DBA/Senior Developer
Sun Microsystems, Inc
03.1999 - 05.2004
Database Administrator
EMC Corporation
10.1998 - 02.1999
Bachelor of Engineering - Mechanical
University of Madras