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 [Number] years of experience in [Industry]. Excellent reputation for resolving problems and improving customer satisfaction.
Overview
24
24
years of professional experience
1
1
Certification
Work History
Vice President Of Information Technology
Jefferies LLC
10.2014 - Current
- Supporting various applications databases Like AML, Hyperion,FiveStar ,LoanIQ,Murex, Backlog,Peoplesoft Fin and HR , IBond , IAM and many more .,Risk Management, IAM and many more .
- Managed all Oracle Products and implementations at Jefferies
- Working with Postgres , MySQL databases , ,Aurora Cluster on AWS Cloud
- Maintaining Data Security and database auditing as per financial industry (FINRA) standard.
- Migrating Historical data to Snowflake.
- Lead and guided a team of 9 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 and SSL, and GoldenGate
- 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
06.2012 - 10.2014
- 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
Oracle Database Administrator
Time Warner Cable Enterprises LLC
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
Oracle Database Administrator
GDI Infotech
06.2005 - 10.2009
Oracle Database Administrator
Capgemini
06.2004 - 05.2005
Oracle Database Administrator
IndoSoft
02.2001 - 06.2004
- Team Lead Oracle DBA (Managing multiple clients of Indosoft)
Education
Oracle Certified DBA ver 10G -
Oracle Corporation
01.2005
IBM eserver Certified Specialist - pSeries AIX 5 System Administration
01.2004
Oracle Certified DBA ver 9i - undefined
01.2003
Oracle Certified DBA ver 8i - undefined
01.2001
Post Graduate Diploma - Client/Server Environment Oracle Database Administration and Developer
01.2000
Oracle Certified DBA ver 8 - undefined
01.2000
Oracle Certified DBA ver 7.3 -
Oracle
San Francisco, CA01.1999
Bachelor's - Physics
M S University
Vadodara India 09.1987
Skills
- Oracle 21C
- Mysql Server
- Postgres
- RAC
- Python
- SnowFlake
- Ansible
- Shell Script
- Data Security
- Performance Techniques
- Leadership
- AWS RDS
Certification
- Oracle Certified Professional - Oracle 9i Database Administrator, 01/01/99
- UNIX Systems Administration Certified Professional, 01/01/99
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
GDI Infotech
06.2005 - 10.2009
Oracle Database Administrator
Capgemini
06.2004 - 05.2005
Oracle Database Administrator
IndoSoft
02.2001 - 06.2004
Oracle Certified DBA ver 9i - undefined
Oracle Certified DBA ver 8i - undefined
Post Graduate Diploma - Client/Server Environment Oracle Database Administration and Developer
Oracle Certified DBA ver 8 - undefined
Oracle Certified DBA ver 10G -
Oracle Corporation
IBM eserver Certified Specialist - pSeries AIX 5 System Administration
Oracle Certified DBA ver 7.3 -
Oracle
Bachelor's - Physics
M S University
Similar Profiles
Dan FortierDan Fortier
Vice President of Information Technology (IT) and Chief Information Security Officer (CISO) at Ottawa International Airport AuthorityVice President of Information Technology (IT) and Chief Information Security Officer (CISO) at Ottawa International Airport Authority
Tracy RodrigueTracy Rodrigue
Vice President of Information Technology at Zurvita, IncVice President of Information Technology at Zurvita, Inc
Aaron B. ChristophersonAaron B. Christopherson
Vice President of Information Technology at Lucas Metropolitan HousingVice President of Information Technology at Lucas Metropolitan Housing