Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Oracle
Generic

Sanjay Kansara

Edison,NJ

Summary

Experienced Vice President of Information Technology with 20 years of expertise in managing Oracle, other products and implementations.

Skilled in leading offshore/on-site teams, providing technical support, and ensuring data security.

Successfully implemented AWS RDS for Oracle and migrated databases to AWS.

Highly proficient in performance tuning and lifecycle management of Oracle products. Collaborative and results-driven, consistently resolving configuration and performance issues for optimal system operations.

Over 20 years of experience in Database Management. Excellent reputation for resolving problems and improving customer satisfaction.

Information technology executive with strong leadership skills and track record of driving innovation. Expertise in strategic planning, cybersecurity, and Database infrastructure management.

Proven ability to lead cross-functional teams and deliver impactful results. Adept at adapting to changing business needs and fostering team collaboration.

Overview

25
25
years of professional experience
1
1
Certification

Work History

Vice President Of Information Technology

Jefferies LLC
Jersey City, New Jersey
10.2014 - Current
  • Managed all Oracle Products and implementations at Jefferies.
  • Led and guided a team of 10 Offshore/Onsite DBAs (India, UK) and provided technical support.
  • Demonstrated solid hands-on Oracle database administration skills, including performance tuning and data security.
  • Recommended, tested, certified, implemented, and maintained various Oracle database products.
  • Managed the lifecycle of Oracle products.
  • Implemented data security products such as Oracle Unified Directory, Oracle Database Vault, Oracle Key Vault, Oracle Data Masking/Redaction, Oracle database encryption,Guardium, Database auditing SSL, and GoldenGate.
  • Mentored junior team members to develop their technical skills and advance their careers within the organization.
  • Implemented robust project management practices to streamline planning, resource allocation, and execution for all Oracle projects within the organization.
  • Streamlined IT operations by implementing strategic infrastructure upgrades and modernizing legacy systems.
  • Developed in-depth analytics capabilities for improved decision-making processes across all levels of the organization.
  • Improved disaster recovery capabilities by designing resilient systems architecture and regularly testing backup procedures for critical applications.
  • Standardized software development processes to ensure high-quality code releases with minimal defects or security vulnerabilities.
  • Resolved workflow issues to optimize team productivity and improve delivery times.
  • Tracked departmental expenditures, project schedules and team performance and progress.
  • Created long-range IT plan to support projected growth and requirements for added capacity.
  • Worked closely with vendors and technology partners on integrations, infrastructure and enterprise solutions.
  • Managed life cycle replacement of hardware and software.
  • Implemented custom AWS RDS for Oracle and migrated Oracle Database from On-Prem to AWS.
  • Migrated historical Oracle Data Warehouse to AWS S3 using AWS DMS and converted to Snowflake.
  • Supported vendor manager for Oracle licensing.
  • Provided support for Peoplesoft Finance and HR, including database and tools upgrades.
  • Collaborated with internal customers to understand and resolve configuration issues and performance issues.

Oracle Principal Consultant

Metlife
Somerset, NJ
06.2012 - 10.2014
  • Sr. Oracle Peoplesoft DBA (Financial/HRMS/ Self services/EPM)
  • Build Offshore Team of 24 DBAs at Mumbai for Igate (CapGemini)
  • Primary DBA: Supporting 24x7 large production databases (FIN, EPM, HR, Reporting) on EMC hardware
  • Modules GL, AP, AR, PO, PC, Time and Labour
  • Supported migration of multiple VLDB from SUN to AIX
  • Supported People Tools upgrade from 7.5 to 8.48 from database perspective
  • Resolved numerous Post upgrade performance issue by tuning online/batch AE programs, SQR programs and reporting queries and stabilized the ERP system for optimal performance
  • Designed and implement new Combo process to run without / minimal downtime.
  • Installation, configuration and performance tuning of Oracle peoplesoft systems running on 10.2.0.3
  • Cloning of Peoplesoft database
  • Maintaining database security and implement database auditing
  • Database migration from 9.2.0.6 to 10.2.0.3
  • Troubleshoot post upgrade performance issue for App Engine Programs and SQR reports
  • Identifying & tuning long running jobs
  • Identifying & tuning performance issues associated with ERP (Financials, HRMS, EPM, Reporting Instance)
  • Suggest and Implement partitions for large
  • Regular monitoring, troubleshooting and resolving technical issues.
  • Standby database administration, Implement data guard broker and production database maintenance at tablespace, schema and object level.
  • Set up OEM grid control for multiple databases monitoring on AIX server and enterprise reporting portal.
  • Implementing backup strategy, backup retention, database recovery
  • Implement automation for several processes to minimize manual intervention of DBAs.
  • Capacity planning, growth analysis and database and table space level
  • Applied patches and bundles at database and application levels.
  • Identified and tuned resource intensive queries using explain plan, TKPROF, AWR Reports.
  • Install, Support Shareplex 5.3 and maintain replication environment for reporting.
  • Mentoring Offshore DBAs and assist them in performing day-to-day task.

Oracle Database Administrator

Time Warner Cable Enterprises LLC
New York, New York
05.2009 - 06.2012
  • Managed and maintained Oracle financial databases for efficient and reliable data storage and retrieval.
  • Performed regular database backups and ensured data integrity through regular audits and data cleansing activities.
  • Optimized database performance by analyzing query execution plans, indexing strategies, and implementing efficient data structures.
  • Implemented and managed database security measures to protect sensitive financial data from unauthorized access or breaches.
  • Collaborated with cross-functional teams to identify and resolve database-related issues, providing timely solutions to ensure uninterrupted system operations.

Oracle Database Administrator - Client Metlife

GDI Infotech
06.2005 - 10.2009
  • Oracle Database Administrator - Client Metlife

Oracle Database Administrator

Capgemini
06.2004 - 05.2005

Oracle Database Administrator - Sharp Electronics

IndoSoft
Mahwah, NJ
02.2001 - 06.2004
  • Team Lead Oracle DBA (Managing multiple clients of Indosoft)

Education

Bachelor's - Physics

Maharaja Sayajirao University of Baroda
Vadodara , India
09-1987

Skills

  • Oracle 19C , MySQL Server ,Postgres database
  • Oracle RAC
  • AWS Custom RDS ,Snowflake
  • Python
  • Ansible
  • Shell Script
  • Data Security
  • Performance Tuning
  • IT compliance
  • IT risk management
  • Disaster recovery
  • Information security
  • Application development
  • SDLC management

Certification

  • Oracle Certified Professional - Oracle 9i Database Administrator Jan 1999
  • UNIX Systems Administration Certified Professional Jan 1999

Languages

English

Timeline

Vice President Of Information Technology

Jefferies LLC
10.2014 - Current

Oracle Principal Consultant

Metlife
06.2012 - 10.2014

Oracle Database Administrator

Time Warner Cable Enterprises LLC
05.2009 - 06.2012

Oracle Database Administrator - Client Metlife

GDI Infotech
06.2005 - 10.2009

Oracle Database Administrator

Capgemini
06.2004 - 05.2005

Oracle Database Administrator - Sharp Electronics

IndoSoft
02.2001 - 06.2004

Bachelor's - Physics

Maharaja Sayajirao University of Baroda

Oracle

  • An “Oracle Certified DBA” & “IBM Certified System Admin” with Expert level skills in Oracle Database Administration running PEOPLESOFT, Oracle 11i E-business suite and SAP Applications.
  • Applications -
  • Enterprise data Service, Risk Database Management System, Hyperion, FISTAR, Oracle AML, Weblogic, LoanIQ, Algoore, Peoplesoft Fin and HR, Oracle Global Client On-boarding, Murex, IBOND

Similar Profiles

CREATE PROFILE