SAJAL BAISAKHIYA
Leander,TX
Summary
Accomplished Oracle Cloud Infrastructure expert with a proven track record at Oracle Corp, adept at leading cross-functional teams and spearheading complex database migration projects. Skilled in Oracle EXADATA and project planning, I excel in optimizing cloud infrastructures and enhancing database performance, ensuring seamless, efficient operations.
Overview
19
19
years of professional experience
1
1
Certification
Work History
Senior Escalation Manager
Oracle Corp
Austin, USA
12.2016 - Current
- For multiple Cloud Customers providing guidance and support to strategic accounts to ensure successful and effective use of our Cloud/Exadata Database technology
- Schedule cadence calls with Customers to understand the account status and provide regular updates about the progress to the higher management/executives
- Creation and presentation of weekly/monthly/quarterly account reports
- Taking ownership of executive level escalations and providing status updates using EMA tool with goal of efficient resolution
- Analysis of customer SR data and form Virtual team of engineers for the required skillset, mentoring of the Virtual team to efficiently work with Strategic Account
- Working with development teams on Bug fixes, Cloud Service improvement features & RCA/CAPA
- Providing Technical support for various DB Generic issues comprises DBCA, EM Express, Resource Manager, DBMS_JOBS, Database Scheduler, Database Migration Assistant for Unicode, NLS, Character set Conversion, Time zones related issues, DST, LOB’s
- Tablespace management and Undo management
- Provided Technical support for various Backup and Recovery/ Data Guard/ Corruption issues to Oracle customers worldwide
- Writing external/internal/Limited access Technical Articles
- Contributing to knowledge management content creation and maintenance
- Using various hidden parameters and internals tools to force the database open to get the valuable data in case when media, crash recovery not possible or no valid backups available
- Working with development on product improvement programs (Beta testing, New Feature assessment etc.) as required
- Done beta testing of RMAN features in 11gR2 and multitenant features for ‘Ease adoption of PDBs’ in 12.2
- Defining cloud migration strategy from on premises to Oracle Cloud infrastructure
- For ExaCS and IaaS (OCI)
- Integrate with IDCS, design and implement Oracle Cloud Infrastructure network using Internet gateways and Fastconnect and VPN, LBaaS
- (DW, Siebel, Java Applications)
- Discovery & analysis, Assessment & target cloud readiness design, cloud migration planning and
- Migration execution, manage services and CI/CD pipeline planning and execution
- Responsible for deploying overseeing a company's cloud computing strategy
- This includes cloud
- Adoption plans, cloud application design, and cloud management and monitoring OEM13.3c.
Data Engineer
American Express
Phoenix, USA
08.2014 - 12.2016
- Project Payback Global Production Support Tool Scotty ticketing tool, Service now ticketing tool Role I am responsible for managing American express Operation Databases Team
- My team of database Administrators provide 24
- 7 supports
- I (Lead Oracle DBA)
- Responsibility:
- Support of Oracle 10g, 11g, and RAC (10g and 11g R2) databases on Red Hat Linux
- Architecting and designing Oracle Databases
- Assist with the specifications and requirements for determining hardware requirements to support Timesten databases
- Assist with changes to the hardware or O/S on database servers
- Installing grid infrastructure with oracle ASM using silent installation
- Implemented ASM on RAC
- Managing disks and disk groups with ASM
- Keeping the databases up to date with respect to Latest PSU’s and very comfortable in applying patches
- Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control
- Installing oracle and creating oracle databases using DBCA
- Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment
- Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues
- Upgrade Grid Control from 11g to 12c -- Configuration OEM and automate the installation of OEM using Puppet via RPM install method
- Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts ) using OEM
- Successfully set up Golden Gate replication between the 2 sites for High availability
- I Set up GG over an VIP so that it will failover as a cluster resource in the event of failure
- Scheduling RMAN backup for the databases as a group through OEM 12c
- Developing Housekeeping scripts and maintaining the logs
- Assist engineering teams with performance and tuning (database parameters, indexes, and SQL code)
- Troubleshoot server and database problems to maximize database availability
- Trouble shooting and providing support on 24x7 window for the production environment
- Creating the databases, configuring the databases parameters, Configure Data guard Setup, RAC configuration with ASM
- Upgrading ORACLE database from 10g to 11g
- Data guard Setup Using RMAN duplicate
- Disaster Recovery testing using both switchover and failover
- Cloning of databases using RMAN, refresh of the databases from E3 to E2Data pump Export and Import of databases from one database to another database’s
- Promotion and deployment of database changes into production on change request
- Optimizing performance of databases
- Monitoring database using EM grid control and taking proactive measures
- Creation and monitoring of Job Scheduling for databases through cron jobs
- Creating unix scripts for automating various jobs
- Using logminer to dig log files
- Administering database security, Creating Users and granting/revoking roles and privileges
- Extending storage capacity
- Installing weekly server report which will mail the file system usage on weekly basis
- If there is low space we can add space
- Scheduling daily report through OEM to get the daily information of databases and can take proper action
- Reducing database fragmentation using shrink and other techniques.
Consultant
CGI Group
Tempe, USA
02.2013 - 08.2014
- Fannie Mae Production support
- Client
- Fannie Mae
- Tool
- Remedy
- Role :
- Lead Oracle DBA responsible for 4 onshore Oracle DBA’s liaising with offshore team leaders to share a resource pool of 6 offshore (India) DBA’s
- Responsible for the entire DB related maintenance activities of customer's environment with 2000+ Physical Servers
- Also responsible for the complete Oracle migration plan from Onshore
- Successfully in getting the tasks and cases in the queue cleared on a timely basis with 0 backlogs and 0 downtime-misses from the Off-Shore Operations, Performed Installation, Configuration, Designing, troubleshooting, performance tuning and production
- Support of Oracle 10g, 11g, and RAC (10g and 11g R2) databases on Red Hat Linux
- Implemented ASM on RAC
- Managing disks and disk groups with ASM
- Performed migration activities from 10g to 11g R2 for large databases
- Tons of experience in installation, configuration, troubleshooting and analyzing of RAC environments
- Keeping the databases up to date with respect to Latest PSU’s and very comfortable in applying patches
- Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control
- Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment
- Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts ) using OEM
- Monitored and trouble shooted database issues with OEM grid control
- Built physical standby using RMAN Active duplication method as well for Disaster recovery site
- Installing, configuring and maintaining Enterprise Manager Cloud Controlto monitor and manage Exadata and regular databases
- Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT)
- Implementing Best Practices for migration E-Business Suite and regular databases to Oracle Exadata
- Performed database recovery using GRP (Guarantee Restore Point)
- Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues
- Automated routine DBA tasks like backup’s and stats by using Grid control job’s
- Provided Assistance to application team at the time of SQL tuning in applications
- Upgrade Grid Control from 11g to 12c -- Configuration ops plugins, setup monitoring, configure Oracle VM 3.2 -- Tuning and Installation of 6 physical server OVM 3.2 environment
- 2 for DEV, 2 for TST and 2 for PRD, server pools, vlan, powerpath
- Migrate 11g to 12c Database, Upgrade 11,2 Rac to 12c RAC -- Configure Containers, Implement Audit Vault and new database security features
- Upgrade Weblogic to 12c -- Configure WLS Cluster, deploy Code, Maintain performance and best practices, monitor in Grid 12c
- Creation, configuration and setting up of RMAN catalog databases and registering target databases with the catalog
- Additionally, part of rotation oncall DBA to support databases 24X7
- Assist with the specifications and requirements for determining hardware requirements to support Timesten databases
- Assist with changes to the hardware or O/S on database servers
- Assist engineering teams with performance and tuning (database parameters, indexes, and SQL code)
- Environment: Oracle 9i/10gR2/11gR2/12c , AIX, RAC, Data Guard, Golden Gate, RMAN, Data pump, OEM Grid Control
Sr. Associate
Cognizant Techchology Solutions US Corp
Parsippany, USA
04.2012 - 01.2013
- Project Database Modernization (Migration/Upgrade)/Production support
- Client Merck
- Tools Remedy
- Role : Lead Oracle DBA and Associate Project Manager team leader responsible for 3 onshore Oracle DBA’s liaising with offshore team leaders to share a resource pool of 12 offshore (India) DBA’s
- Responsible for the entire DB related maintenance activities of customer's environment with 1200+ Physical Servers
- Also responsible for the complete Oracle migration plan from Onshore
- Successfully in getting the tasks and cases in the queue cleared on a timely basis with 0 backlogs and 0 downtime-misses from the Off-Shore Operations.
Oracle DBA Production Support
Vodafone India Pvt. Ltd
Pune, INDIA, Ireland
08.2011 - 01.2012
- Performed Installation, Configuration, Designing, troubleshooting, performance tuning and production
- Support of Oracle 10g, 11g, and RAC (10g and 11g R2) databases on Red Hat Linux
- Implemented ASM on RAC
- Managing disks and disk groups with ASM
- Performed migration activities from 10g to 11g R2 for large databases
- Tons of experience in installation, configuration, troubleshooting and analyzing of RAC environments
- Keeping the databases up to date with respect to Latest PSU’s and very comfortable in applying patches
- Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control
- Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment
- Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts ) using OEM
- Monitored and trouble shooted database issues with OEM grid control
- Built physical standby using RMAN Active duplication method as well for Disaster recovery site
- Performed database recovery using GRP (Guarantee Restore Point)
- Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues
- Automated routine DBA tasks like backup’s and stats by using Grid control job’s
- Provided Assistance to application team at the time of SQL tuning in applications
- Creation, configuration and setting up of RMAN catalog databases and registering target databases with the catalog
- Installing, configuring and maintaining Enterprise Manager Cloud Controlto monitor and manage Exadata and regular databases
- Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT)
- Implementing Best Practices for migration E-Business Suite and regular databases to Oracle Exadata
- Additionally, part of rotation oncall DBA to support databases 24X7
- Environment: Oracle 9i/10gR2/11gR2 , AIX, RAC, Data Guard, Golden Gate, RMAN, Data pump, OEM Grid Control, Project
- Vodafone (Germany, UK &, Client
- Vodafone
- Tools
- Remedy
- Description of the project: This project includes upgrades of various modules of Oracle E-Business Suite Release 12 and 11.5.10.2
- It also includes reports conversions to XML Publisher.
Assistant Manager
CalSoft India Pvt. Ltd, MH
Pune, INDIA
08.2010 - 08.2011
- Obtain and Maintain DBMS Software & Patches
- Oracle Database Up gradation 10g to 11g (10.2.0) to (11.1.0)
- Decommissioned of Databases
- Oracle Client Installation on Solaris10, Linux & HP-UX
- Manage ASM on RAC environments
- Extending the database storage capacity by creating new table spaces
- Adding data files as per requirement
- Troubleshoot Error-07445 & Error-4031
- Modify Static & Dynamic Parameters on RAC environments
- Refresh database using exp/imp and Data pump
- Remove audit logs older than 30 days
- Interacting with Oracle Support for technical assistance requests
- Configuring RAC for load balancing with other integrated applications
- Create and relocate services in RAC
- Managing Physical structure of Oracle database like Data files, Redo log file and Control files
- Three Node cluster failover test
- Creation of standby database as per requirement and maintenance
- Environment: Oracle 9i/10gR2/11gR2 , AIX, RAC, Data Guard, Golden Gate, RMAN, Data pump, OEM Grid Control, Project Accept global support
- Client Accept360
Designation Sr
Barclays Technology
Pune, INDIA
04.2009 - 05.2010
- Oracle DBA
- Responsibility:
- Upgradation, migration of databases
- Installation, creation of database and RAC
- Recovering the database in the event of a hardware or software failure
- Testing, and implementation of disaster recovery methodology
- Ensure production database is in sync with standby database
- Creation of standby database as per requirement
- Regular monitoring of database and troubleshooting the errors
- Determining and implementing the backup/recovery plan for each instance according to project’s needs
- Performing Oracle cold backups to ensure consistency of the data
- Performing Oracle hot backups while the database is operational
- Adding/resizing data files to the table spaces
- Performing Oracle import/export as a method of recovering data or individual objects
- Optimizing Sql statement using explain plan
- Taking cpu utilization reports daily
- MySql to Oracle migration
- Cloud machine setup
- Oracle silent installation on cloud machine
- Environment: Oracle 9i/10gR2/11gR2 , AIX, RAC, Data Guard, Golden Gate, RMAN, Data pump, OEM Grid Control, Project Barclays bank plc -global support
- Client Barclays
- Tools Service center, spotlight, foglight monitoring tool
- Description of the project:
- Barclays is a well know, 300yr old banking co-operation
- Its operations are mainly in UK, Africa and lately into emerging markets for Asia
- Barclays is known for providing best financial and banking solutions to its client.
Oracle database administrator
Amdocs India Pvt. Ltd, MH
Pune, INDIA
06.2008 - 04.2009
- Project Amdocs global support
- Client T-mobile(USA),Comcast(USA),Lightspeed(USA),Astor(Malaysia),comcast, Telstra(Australia), Excelcom (Indonesia), bmcc (China) etc
- Tools Clarify, clarity, precise(Symantec i3), toad, putty
- Description of the project: Amdocs, the world leader in driving innovation in the front- and back-office systems targeting the right customers, treating valuable customers well, crOSS-selling effectively and increasing efficiencies encompasses all of the software and services associated with BSS and OSS, including crm, billing, fulfilment, activation, inventory, etc
- We pioneered a business strategy called “integrated customer management” or icm.i m working in Amdocs as an Oracle DBA providing global support for various clients like astro (Malaysia), telstra(Australia), excelcom (Indonesia), Bmcc (China) etc
- Role
Designation Senior
MH
Mumbai, INDIA
04.2006 - 03.2008
- Installation, creation of database and RAC
- Recovering the database in the event of a hardware or software failure
- Testing, and implementation of disaster recovery methodology
- Ensure production database is in sync with standby database
- Creation of standby database as per requirement
- Regular monitoring of database and troubleshooting the errors
- Determining and implementing the backup/recovery plan for each instance according to project’s needs
- Performing Oracle cold backups to ensure consistency of the data
- Performing Oracle hot backups while the database is operational
- Adding/resizing datafiles to the tablespaces
- Performing Oracle import/export as a method of recovering data or individual objects
- Optimizing Sql statement using explain plan
- Oracle Golden Gate Implementation on Single & RAC Databases
- Oracle Golden Gate Implementation & L3 support
- Oracle Golden gate Replication for many servers
- Implement Oracle Golden gate monitoring for many Databases
- Oracle Golden Gate new builds Installation,DB creation on Oracle 9i & 10g
- Oracle Golden gate Day to day Oracle DBA activity
- Taking cpu utilization reports daily
- Provide Oracle Apps DBA support for 11i
- Environment: Oracle 9i/10gR2/11gR2 , AIX, RAC, Data Guard, Golden Gate, RMAN, Data pump, OEM Grid Control
- Reliance, Project name Reliance Billing, Clarity, Golden Gate, ICT revenue, BMC-Remedy
- Client Reliance, Wipro, sun
- Employer Reliance communication
- Description of the project: Reliance communication is a leading telecom service provider of INDIA
- It’s operation support system (OSS) unit uses billing and clarity software for network and service management
- This is used to manage business processes of service fulfilment and assure, network infrastructure
- I’m responsible for managing reliance billing clarity database in this project our team of database administrators provides 24
- 7 supports to various client databases.
Application Developer
IQSPL Pvt. Ltd
Pune, INDIA
10.2005 - 03.2006
- Worked in IQSPL, PUNE, Role: involved in preparing & giving presentation on such topics:
- Team member
- Analysis of approach
- Database design
- Installation of Oracle9i/10 on windows, Solaris
- Creation of databases in production environment database
- Adding/resizing datafiles to the tablespaces
- Created Oracle users
- Handling export and imports of database objects
- Taking cpu utilization reports daily
- Configure Sql net, net8 and Oracle net services
- Monitoring hot/cold backups and verify their success and return the backup in case of failure
- Check database alert log and trace file manually to detect problems
- Monitoring the billing servers
ENTERPRISE MANAGER
- ORACLE EXADATA, ORACLE GOLDEN GATE, DATA GUARD, , DATABASE CONSOLE, WEBLOGIC SQL
- LOADER,TOAD, FOG LIGHT, SPOTLIGHT ,SQL LOADER, ERWIN
Lead Oracle database
Oracle database administrator
BTCI PUNE
- As a part of Barclays plc was established with vision to spearhead the technology solutions for bank.
IT Infrastructure Analyst
- Provide production support for critical payments system of bank
- Provide support for various ongoing projects
- Designing the infrastructure for new projects and make implementation plan
- Determining and implementing the backup/recovery plan for each instance according to project’s needs
- Maintenance of different databases on AIX server
- Taking backup and restoration of databases with import and export utilities
- Or individual objects
- Optimizing Sql statement using explain plan
- Performing regular maintenance of production db’s
- Working with materialized view and managing the snapshot refresh
- Implementation of 10g RAC
- Tuning Sql statement using Tkprof, explain plan utilities
- Managing logical, hot and cold backups manually/RMAN
- Manual/RMAN database cloning to same/different servers
- Provide on call support
- Installed 11.5.10, including Financials, Purchasing and Public Sector Financials
- Upgraded 11.5.9 to 11.5.10
- Environment: Oracle 9i/10gR2/11gR2 , AIX, RAC, Data Guard, Golden Gate, RMAN, Data pump, OEM Grid Control
Database administrator
- Database design
- Installation of Oracle9i, Solaris
- Creation of databases in production environment database
- Adding/resizing datafiles to the tablespaces
- Created Oracle users
- Handling export and imports of database objects
- Taking cpu utilization reports daily
- Configure Sql net, net8 and Oracle net services
- Monitoring hot/cold backups and verify their success and return the backup in case of failure
- Check database alert log and trace file manually to detect problems
- Oracle Golden Gate Implementation on Single & RAC Databases
- Oracle Golden Gate Implementation & L3 support
- Oracle Golden gate Replication for many servers
- Oracle Golden Gate new builds Installation, DB creation on Oracle 9i & 10g
- Oracle Golden gate Day to day Oracle DBA activity
- Monitoring the billing servers
- Coding (pl Sql)
- Testing
- Environment: Oracle 9i/10gR2/11gR2, AIX, RAC, Data Guard, Golden Gate, RMAN, Data pump, OEM Grid Control
Education
B.E. - computer science
Indore public school academy
01.2005
Higher secondary -
01.2000
Senior secondary -
01.1998
Skills
- Oracle Cloud Infrastructure
- Oracle Cloud Engineering
- Oracle Fusion Middleware WebLogic Server Admin (WLS)
- Oracle Applications System Administration
- Clustering Technologies & Techniques
- Infrastructure Architectures
- Oracle EXADATA
- ORACLE Golden Gate
- Data Guard
- Enterprise Manager
- Database Console
- WebLogic
- SQL
- LOADER
- TOAD
- Fog light
- Spotlight
- SQL Loader
- Erwin
- Team leadership
- Complex Problem-solving
- Project management
- Cross-functional teamwork
- Project planning
Certification
- Cloud Infrastructure Architect Professional
- Oracle Autonomous Database Specialist
- Oracle Cloud Infrastructure Foundations
Affiliations
- PACESETTER TEAM Award, Spot Award,
Timeline
Senior Escalation Manager
Oracle Corp
12.2016 - Current
Data Engineer
American Express
08.2014 - 12.2016
Consultant
CGI Group
02.2013 - 08.2014
Sr. Associate
Cognizant Techchology Solutions US Corp
04.2012 - 01.2013
Oracle DBA Production Support
Vodafone India Pvt. Ltd
08.2011 - 01.2012
Assistant Manager
CalSoft India Pvt. Ltd, MH
08.2010 - 08.2011
Designation Sr
Barclays Technology
04.2009 - 05.2010
Oracle database administrator
Amdocs India Pvt. Ltd, MH
06.2008 - 04.2009
Designation Senior
MH
04.2006 - 03.2008
Application Developer
IQSPL Pvt. Ltd
10.2005 - 03.2006
ENTERPRISE MANAGER
Lead Oracle database
Oracle database administrator
BTCI PUNE
IT Infrastructure Analyst
Database administrator
B.E. - computer science
Indore public school academy
Higher secondary -
Senior secondary -
Similar Profiles
Ron ParkRon Park
Field Support Engineer at Oracle CorpField Support Engineer at Oracle Corp
Pavan KumarPavan Kumar
Service Delivery Manager at Oracle CorpService Delivery Manager at Oracle Corp
Kai PiggKai Pigg
Senior Director Fusion Application Development at Oracle CorpSenior Director Fusion Application Development at Oracle Corp
Jason AndrewsJason Andrews
Shift Lead at The GoodlotShift Lead at The Goodlot
Sean LeeSean Lee
NPI Quality Engineer at Athena ManufacturingNPI Quality Engineer at Athena Manufacturing