Mahesh Kambli
Peoria,AZ
Summary
Highly motivated and results-driven Oracle DBA and Cloud DBA with over 5 years of experience in managing and maintaining complex database systems. Proven ability to design and implement effective database solutions that meet business requirements and enhance system performance. Knowledge of cloud computing and experience in managing cloud-based databases. Proficient in Oracle Database Administration, PL/SQL, MySQL, and cloud-based technologies like AWS & Google Cloud
Overview
24
24
years of professional experience
Work History
Manager Infrastructure Specialist
Cognizant Technologies Solutions
02.2010 - Current
- Experienced and knowledgeable as Manager with over 5 years of experience in managing, designing and maintaining databases for various industries. Skilled in database administration, performance tuning, data modeling, and SQL programming. Strong communication and leadership skills with proven track record of collaborating with IT staff and other departments to ensure organization's database needs are met. Demonstrated creativity and resourcefulness through development of innovative solutions.
PayPal
05.2018 - 09.2022
- Leading and managing 10 member team of Database Administrators with actively participation and co-ordination with various technology team
- Adhere to procedures & policies to follow any production database changes and during its maintenance.
- Resolving Data Guard and Golden Gate Lag issues, preparing technical documents to maintain Standard & Procedures for repetitive issues.
- Collaborated with database architects and administrators to determine client system limitations for capacity and data load.
- Provide enterprise-wide support, Oracle Database Administration support for production systems and provide DBA services to application development teams, including database design, database generation, coding, and database production support
- Monitoring and optimization of database performance, security, resource utilization, memory configuration, sessions, archive logs, and storage
- Responsible for installation, configuration, troubleshooting, support, and maintenance of all database systems including Production, Test, and Development database environments
- Implemented TDE encryption in Oracle Multitenant architecture, setting up wallet for data protection
- Experience with Oracle Maximum Availability Architecture including Oracle Real Application Clustering (RAC), Data Guard and Golden Gate
- Experienced in supporting Oracle Exadata databases
- Knowledge of supporting MySQL/Mongo/Cassandra/Couchbase database
- Managed user accounts and support systems within complex Oracle database and cloud systems
- Partnered with project management teams on development of scope
- Wrote scripts and processes for data integration and bug fixes
- Analyzed and developed technical and functional specifications
- Worked successfully with diverse group of coworkers to accomplish goals and address issues related to products and services.
- Learned and adapted quickly to new technology and software applications
- Demonstrated leadership skills in managing projects from concept to completion
Senior Oracle Database Administrator
AAA Insurance Company
01.2012 - 05.2018
- Specified user access levels for each database segment to protect database integrity and company information
- Developed scripts for index and table analysis actions
- Established hardware requirements and devised storage capacity solutions for OLTP and Data Warehouse databases
- Worked closely with team members to deliver project requirements, develop solutions, and meet deadlines
- Involved in Architecting and implementing Oracle Golden Gate with 2 Node RAC and Data guard system
- Involved in building Golden Gate Hub model that collects data from various source of database and distributes to Hadoop using Flume agents
- Preparing to migrate critical system to Oracle 12c standalone and RAC Flex ASM system
- Involved in building POT (proof of Technology) on Oracle 12c and convert it into real time system
- Implemented Multitenant architecture by consolidating various database into one system
- Extensively using OEM 12c for monitoring, managing ASM, performance tuning, building Active Data Guard, generation storage space reports with thresholds and deploying patches on Standalone databases as well as Oracle RAC databases
- Implemented Oracle TDE Transparent Data Encryption for new and existing database
- Resolving Golden Gate performance issues, RMAN performance issues and various undocumented bugs in support of Oracle SR
- Closely interact with Storage and OS admins during failure disk and performance issues
- Mentoring novice users and junior DBA's providing them right tool and knowledge transfer for support of critical application
- Involved in performing DR exercises every six months as per organization schedules.
- Developed and updated databases to handle customer data
- Developed scripts and processes for data integration and maintenance
- Wrote and maintained technical and functional specifications to document database intentions and requirements
Oracle DBA
Ascend Performance Materials
06.2010 - 01.2012
- Spearheading to define monitoring system for ORACLE and SQL SERVER databases
- Installed 10g Grid computing defining and deciding on monitoring of each environment
- Closely working with management decision in Migrating databases and application to Ascend Domain from Solutia Domain (Formerly parent Organization of Ascend Performance Materials) Support Oracle RAC 10g with 2 nodes environment on Windows
- Involved in migrating domain
- IP change address on RAC
- Supporting 24/7 all crucial and manufacturing plants DB's that are business critical
- Conducting periodical meetings with clients and team to improvising change control system
- Presented papers to client on SERVICE OPERATION GUIDE, on Database and UNIX environment
- Involved in establishing PEOPLESOFT environment on HPUX, installed oracle 9i database server, worked closely with PS admin to setup jobs and schedulers for PEOPLESOFT environment
- Involved in writing UNIX SHELL scripting to support SAP environment
- Conducting Status meeting with clients, DBA and UNIX administrators
- Installed 40 OMS agents to monitor oracle databases using 10g grid computing
- Working on alerts and co-coordinating with client and DBA’s
- Lead in establishing databases for FILNET SERVERS, defining backup and recovery strategies
- Involved in preparing documents on DISASTER RECOVERY PROCESS for FILENET, PEOPLESOFT and various third-party vendor application.
- Providing best backup and strategies on SQL SERVER databases on SHARE POINT APPLICATION
- Migrating to Ascend from Solutia Domain
- Participated on building New Servers and conducted installation of SQL Servers for various environment
- Involved in migration DTS PACKAGES from SQL SERVER 2000 to SQL SEVER 2008, worked closely with user in establishing business process advising on optimization of queries
- Defining monitoring system in Ascend Performance Materials, establishing performance counters, and sending alerts periodically to mailboxes
- Advising security level and defining roles and profiles for users on various environments
- Installed and configured SQL SERVER DATABASE for BIZTALK APPLICATION and STERLING COMMERCE APPLICATION
- Established linked between SQL SERVER and oracle database as user requirement need.
Oracle DBA
Takeda Pharmaceuticals
01.2010 - 06.2010
- Supporting various projects for COGNOS, DOCUMENTUM
- Involved in Installing and Upgrading Oracle 10g and 11g on HPUX, SUN SOLARIS and Windows
- Worked with Analyst to build structured requirements and designed Conceptual data models
- Wrote UNIX shell scripting to perform monitoring in various Database on Oracle
- Maintained voluminous tables by Partitioning tables and indexes into smaller chunks for more manageable components
- Upgraded databases using data pump utilities to 11g
- Installed & Upgraded SQL Server 2000 to SQL Server 2008 on Windows Clustered environment
- Actively Participated in DR test implementation for SQL Server databases
- Setting up maintenance plans and scheduling Backups, monitoring and resolving issues
- Involved in performance task by setting performance counters and defining events to capture performance issues using SQL Profiler
- Applied Security level roles for accessing database objects for different roles of users
- Involved in migrating objects between databases.
SQL Server DBA
IPG - SQL DBA
02.2009 - 12.2009
- Responsible for installation and maintenance of SQL Server database on Standalone and clustered environment Consolidated SQL Severs on SQL Server 2005, that helped in reducing licensing cost
- Involved in writing stored procedures triggers for monitoring SQL Server databases.
computer associates
Advanced
05.2006 - 12.2009
Oracle DBA
PepsiCo
06.2008 - 02.2009
- Supporting 150 Instances of oracle Databases on UNIX and Windows 2003
- Upgraded more than 25 instances of Oracle from 8i-10g, and 9i-10g
- Participated on DR test activities that include recovering database disaster
- Supported various SAP Databases financial/warehouse
- Exporting and importing full DB and schemas using Data pump DB upgrade using Export and import utility
- Involved in performance task setting performance counters and defining events capture performance issues using SQL Profiler
- Applied Security level roles for accessing database objects for different roles of users
- Involved in migrating objects between databases
- Performed refreshes using export/import and RMAN utility
- Performed cloning of SAP and non-SAP databases on different platform
- Configured and implemented RMAN
- Backups managed by TIVOLI, NETBACKUP, Omni Backup
- Implemented Data guard for high availability system
- Used TKPROF for SQL tuning on various performance issues
- Supported various databases on TABLESPACE Management wrote
- Monitoring scripts Implemented SOX compliance environment on various databases
- Performed RMAN recovery to restore and recover database
- SQL Server DBA
- Responsible for installation and maintenance of SQL Server database on standalone and clustered environment
- Involved in writing stored procedures triggers for monitoring SQL Server databases in HP POLYSERVE environment
- Involved in Setting up and Configuring POLYSERV (Clustering)
- Environment for SQL Server 2005 and MSSQLServer2000
- Migrating Database from standalone SQL Server 2000 to SQL Server 2005 clustered environments
- Installed configured SQL SERVER 2008 on windows 2008 server, played instrumental role in migrating SQL Server 2000 databases
- Developed and optimized database structures, stored procedures, views, triggers, and user-defined functions
- Performed daily tasks including backup and restore by using SQL 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
- Troubleshoot system issues and set up maintenance plans for proactively monitoring performance of SQL Server databases.
Oracle DBA
Cadbury Schweppes
06.2006 - 05.2008
- Involved closely with Siebel team to upgrade on Oracle 9i based on their recommendations also involved in performance tuning database
- Oracle Patches applied including DST patches
- Oracle kernel and init parameters are set as per requirement
- Automated UNIX shell scripts to imp/Exp, collecting database statistics, automatic memory tuning tunings based on transaction load
- Logical backups taken for schemas and database using export and import
- Automated shell scripts to gather day today alert logs on different database
- Performed cloning of SAP and non-SAP databases on different platform
- Configured and implemented RMAN Backups managed by TIVOLI
- Identified potential performance issues
- Configured STATSPACK to monitor performance level and took decision based on reports, scheduled STATSPACK using DBMS_JOBS package to run in regular intervals
- Implemented SOX compliance on multiple databases instances
- Initiated by writing scripts to monitor space management for various production databases and scheduled scripts as cronjob and UC4
- Involved in disaster recovery, data file recovery, recovered whole database till PITR recovered database using RMAN utility, recovered database ranging from 500GB to 1TB
- Migrated various oracle database from SUN SOLARIS to AIX platform and to remote location using manual log shipping and using DG technologies
- Maintained RAC and involved in setting up nodes
- SQL Server DBA
- Involved in maintaining and creating Replication of database for MS SQL Server 2000/2005 transaction replication setup and monitored activities
- Performed maintenance based on peak performances by rebuild indexes optimize paging
- Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability
- Worked closely with developers to implement optimize plan on developing efficient schema
- Analyzing and maintaining Log file growth on data warehousing databases
- Developed and implemented migration plans for production cutovers
- Involved in applying patches and upgrade of MS SQL 2000
- Involved in implementing updates on 100's of MS SQL by setting up inventory database and updating regularly on version patches applied
- Instrumental in installing and developing documentation of SQL Server installation and security policies.
System Analyst
Race Infotech
08.2004 - 04.2006
Project Lead
08.2000 - 02.2003
- Ava, Visual Basic, Java.
System Analyst
Emery Worldwide, Tampines
01.1999 - 08.1999
- Programming Languages: Power Builder.
Education
Bachelor of Arts -
University of Madras
Chennai,IndiaCertified ScrumMaster (CSM) DataStax Enterprise 6 Foundations of Apache Cassandra DataStax Enterprise 6 Operations with Apache Cassandra Oracle 9i Certified (OCP) Oracle 10g Administration (Brainbench) -
Mahesh Kambli
Skills
- Technical Skills
- Solaris, Linux, HP-UX, AIX, Windows server, VMware, Windows 95/2000/NT
- Exadata, ORACLE 19c/12c/11g/10g/9i/8i,
- Mongo, Cassandra, MySQL, MS SQL Server
- Golden Gate, Data Guard, SQL
- Loader, Export & Import utility,
- OEM, RMAN, Toad, PL/SQL developer, AWR, ADDM
- SQL, PL/SQL, HTML, Java, Perl Scripting
- ASP, JSP, XML, HTML/DHTML, VBScript, JavaScript
- ASP, JSP, XML, HTML/DHTML, VBScript, JavaScript
- ASP, JSP, XML, HTML/DHTML, VBScript, JavaScript
- ASP, JSP, XML, HTML/DHTML, VBScript, JavaScript
- ASP, JSP, XML, HTML/DHTML, VBScript, JavaScript
- ASP, JSP, XML, HTML/DHTML, VBScript, JavaScript
Timeline
PayPal
05.2018 - 09.2022
Senior Oracle Database Administrator
AAA Insurance Company
01.2012 - 05.2018
Oracle DBA
Ascend Performance Materials
06.2010 - 01.2012
Manager Infrastructure Specialist
Cognizant Technologies Solutions
02.2010 - Current
Oracle DBA
Takeda Pharmaceuticals
01.2010 - 06.2010
SQL Server DBA
IPG - SQL DBA
02.2009 - 12.2009
Oracle DBA
PepsiCo
06.2008 - 02.2009
Oracle DBA
Cadbury Schweppes
06.2006 - 05.2008
computer associates
Advanced
05.2006 - 12.2009
System Analyst
Race Infotech
08.2004 - 04.2006
Project Lead
08.2000 - 02.2003
System Analyst
Emery Worldwide, Tampines
01.1999 - 08.1999
Bachelor of Arts -
University of Madras
Certified ScrumMaster (CSM) DataStax Enterprise 6 Foundations of Apache Cassandra DataStax Enterprise 6 Operations with Apache Cassandra Oracle 9i Certified (OCP) Oracle 10g Administration (Brainbench) -
Mahesh Kambli