$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Cloud Architect and Database Administration
Manas Das
,
Ilford, United Kingdom
Experience
Other titles
Skills
I'm offering
I have 14 years of experience in activities relating to, Database Administration, Oracle Cloud Infrastructure Architect and Project Management. Involved in the areas of Devops for continuous delivery and continuous integration. Successfully lead and delivered projects on hosting services from on premise to Cloud. Supported delivery and team from due diligence to design, build and deploy to production phases for large complex systems with effective project management.
Summary:
• Oracle Cloud Infrastructure architect
• Experience in on premise to Cloud migration using various methods
• Experience working as DevOps Project Manager on AWS
• Oracle 18c standalone database creation
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, AWR, ADDM, SQL TRACE and SQLT
• Cloning RAC to RAC and RAC to NON RAC using RMAN.
• Experience in Managing the Oracle Databases using ASM Administration
• Experience in Managing Oracle Exadata Databases
• Experience in different OS platforms like SUN SOLARIS 10, OEL 6.4 and IBM AIX 5, HP-UX , RHEL 7.5
• Experience installing and configuring OBIEE 12.2.1.3.0
• Expertise in configuring and managing the Concurrent Managers, Workflow Notification Mailers and monitoring their operations.
• Oracle Database upgrade 10g to 11g & 11g to 12c
• Patching CPU/PSU/One-Off for databases and Oracle Applications
• Code moves like creating packages/package bodies/table creation etc.
• Handling Ticketing system and resolutions for End-user issues
• Checking the status of important services like concurrent manager, form server, web server, application listener, database listener is up
• Experience in Administration of 10g/11g/12c DataGuard databases using Dataguard broker.
• Experience with AD utilities and SYSADMIN activities of Oracle Applications environments.
• Involved in performance tuning of Oracle EBS Applications & Database systems.
• Good experience in Backup / Recovery using User Managed / RMAN, export / import (Data Pump) and SQL Loader, etc.
• Expertise in resolving the view log/out files issue of concurrent requests, MOS support, Apache and Forms issues
• Monitor growth of Database with scripts and resizing the tables, Responsible for High Availability.
• Monitoring Tablespace usage, Temp tablespace usage and undo tablespace usage.
• Worked on scripts for creating new schemas, assigning roles and privileges.
• Experience in the 11g Grid, OEM 12c,13c for the database tasks like adding the data file, resizing the data file,code compilation, User/Role creation and maintenance etc
• Extensive experience in supporting and managing multiple Production, Staging, Development and test instances and Oracle Applications environments of varied complexity
• Experienced with HP-PPM Tool for User/Environment & workflow configuration
• Daily health check like monitoring tablespace, mount points etc.
• JDBC Connection Pool configuration with Oracle.
• Responsible for 24x7 on server and environment availability and monitoring.
• Quickly adapting new technologies.
• Training (5 full days) completed on Big Data Analytics with hands on R studio
• Good Data analysis skill using Statistics (Algebra,ML Machine Learning Algorithms) and Python
• Good knowledge on Data warehousing,Apache,httpd , OBIEE
Summary:
• Oracle Cloud Infrastructure architect
• Experience in on premise to Cloud migration using various methods
• Experience working as DevOps Project Manager on AWS
• Oracle 18c standalone database creation
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, AWR, ADDM, SQL TRACE and SQLT
• Cloning RAC to RAC and RAC to NON RAC using RMAN.
• Experience in Managing the Oracle Databases using ASM Administration
• Experience in Managing Oracle Exadata Databases
• Experience in different OS platforms like SUN SOLARIS 10, OEL 6.4 and IBM AIX 5, HP-UX , RHEL 7.5
• Experience installing and configuring OBIEE 12.2.1.3.0
• Expertise in configuring and managing the Concurrent Managers, Workflow Notification Mailers and monitoring their operations.
• Oracle Database upgrade 10g to 11g & 11g to 12c
• Patching CPU/PSU/One-Off for databases and Oracle Applications
• Code moves like creating packages/package bodies/table creation etc.
• Handling Ticketing system and resolutions for End-user issues
• Checking the status of important services like concurrent manager, form server, web server, application listener, database listener is up
• Experience in Administration of 10g/11g/12c DataGuard databases using Dataguard broker.
• Experience with AD utilities and SYSADMIN activities of Oracle Applications environments.
• Involved in performance tuning of Oracle EBS Applications & Database systems.
• Good experience in Backup / Recovery using User Managed / RMAN, export / import (Data Pump) and SQL Loader, etc.
• Expertise in resolving the view log/out files issue of concurrent requests, MOS support, Apache and Forms issues
• Monitor growth of Database with scripts and resizing the tables, Responsible for High Availability.
• Monitoring Tablespace usage, Temp tablespace usage and undo tablespace usage.
• Worked on scripts for creating new schemas, assigning roles and privileges.
• Experience in the 11g Grid, OEM 12c,13c for the database tasks like adding the data file, resizing the data file,code compilation, User/Role creation and maintenance etc
• Extensive experience in supporting and managing multiple Production, Staging, Development and test instances and Oracle Applications environments of varied complexity
• Experienced with HP-PPM Tool for User/Environment & workflow configuration
• Daily health check like monitoring tablespace, mount points etc.
• JDBC Connection Pool configuration with Oracle.
• Responsible for 24x7 on server and environment availability and monitoring.
• Quickly adapting new technologies.
• Training (5 full days) completed on Big Data Analytics with hands on R studio
• Good Data analysis skill using Statistics (Algebra,ML Machine Learning Algorithms) and Python
• Good knowledge on Data warehousing,Apache,httpd , OBIEE
Markets
United Kingdom
Links for more
Once you have created a company account and a job, you can access the profiles links.
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2018 - ?
job
DBA Lead
JLT RE.
Environment Database 12.1.0.2 Red Hat Linux 7.5
Project Description
Jardine Lloyd Thompson Group plc, also known as JLT Group is a British multinational corporation. JLT provides insurance, reinsurance, employment benefits advice and brokerage services. Infosys has been engaged with JLT on multiple programs to provide IT solution. Gold Build is one of such new project to transform its current system to high scalable and available system.
Contribution:
• Identify requirements based on discussion with multiple teams and plan the project deliverables accordingly with meeting JLT standards.
• Building Prod/UAT/OAT databases using OEM 12c and 13c Administration
• Scheduled team meetings between offshore and onsite for open and close issues discussion and plan proactive measures to meet the SLAs.
• Perform database activities required for the health of the application and release processes (i.e., backup, restore, recovery, import, export, copy, move and performance tuning activities).
• Analyze database activity, perform application database performance and tuning activities in the pre-production and production databases.
• Perform activities of data maintenance, table maintenance, database re-organizations, cache tuning, data archival, data importing/exporting between environments and other efforts typically undertaken to improve the efficiency and reliability of applications and the databases.
• Weblogic Upgrade experience from 12.2.1.1 to 12.2.1.2 and 12.2.1.3
• Coordinate with Oracle On-Demand for infrastructure and environment related issues, product support team for an oracle product issues
• Supporting MS SQL Server 2008 and 2012 administration.
• JDK 1.8 ,httpd , Apache Tomcat 2.4 installation and configuration
• Daily health check like monitoring tablespace, mount points etc and accordingly work with ODBA team.
• Starting, stopping managed servers, admin servers as per the monitoring status.
• Involved in application (.rar/war files) deployments using weblogic server for FAST applications.
• Monitoring and Adminstering of different tools vSphere
• Monitoring all the Domain resources, servers, clusters, JMS, Connection Pools
• Plan DBA Schedule and activities, prioritize the work to ensure work is progressed and aligned with project delivery dates
• Identify an escalation plan for each critical situation
• To support in the build of the new Prod, OAT and DR to increase capacity and resilience of the environment by moving from independently hosted windows server to Linux to cope with system upgrade and expansion.
• Assessment of the current Infrastructure on Windows
• Analyze and design the build of Oracle 12C RAC on RHEL 7.5
• Trouble shooting using ASMCMD and DGMGRL
• Setting up Disaster Recovery and Active Data Guard
• Setting up backup using RMAN
• Configure Oracle Management Server
• Configure Materialized view for Day End and Month End reporting.
• Preparing Documentations as deliverables in all phases of the project
• Update progress to business and highlight risk
• Coordinate with different vendor team to get all the required information to carry out the build
2. Project Name: Starbucks Global Production Support
Project Description
Jardine Lloyd Thompson Group plc, also known as JLT Group is a British multinational corporation. JLT provides insurance, reinsurance, employment benefits advice and brokerage services. Infosys has been engaged with JLT on multiple programs to provide IT solution. Gold Build is one of such new project to transform its current system to high scalable and available system.
Contribution:
• Identify requirements based on discussion with multiple teams and plan the project deliverables accordingly with meeting JLT standards.
• Building Prod/UAT/OAT databases using OEM 12c and 13c Administration
• Scheduled team meetings between offshore and onsite for open and close issues discussion and plan proactive measures to meet the SLAs.
• Perform database activities required for the health of the application and release processes (i.e., backup, restore, recovery, import, export, copy, move and performance tuning activities).
• Analyze database activity, perform application database performance and tuning activities in the pre-production and production databases.
• Perform activities of data maintenance, table maintenance, database re-organizations, cache tuning, data archival, data importing/exporting between environments and other efforts typically undertaken to improve the efficiency and reliability of applications and the databases.
• Weblogic Upgrade experience from 12.2.1.1 to 12.2.1.2 and 12.2.1.3
• Coordinate with Oracle On-Demand for infrastructure and environment related issues, product support team for an oracle product issues
• Supporting MS SQL Server 2008 and 2012 administration.
• JDK 1.8 ,httpd , Apache Tomcat 2.4 installation and configuration
• Daily health check like monitoring tablespace, mount points etc and accordingly work with ODBA team.
• Starting, stopping managed servers, admin servers as per the monitoring status.
• Involved in application (.rar/war files) deployments using weblogic server for FAST applications.
• Monitoring and Adminstering of different tools vSphere
• Monitoring all the Domain resources, servers, clusters, JMS, Connection Pools
• Plan DBA Schedule and activities, prioritize the work to ensure work is progressed and aligned with project delivery dates
• Identify an escalation plan for each critical situation
• To support in the build of the new Prod, OAT and DR to increase capacity and resilience of the environment by moving from independently hosted windows server to Linux to cope with system upgrade and expansion.
• Assessment of the current Infrastructure on Windows
• Analyze and design the build of Oracle 12C RAC on RHEL 7.5
• Trouble shooting using ASMCMD and DGMGRL
• Setting up Disaster Recovery and Active Data Guard
• Setting up backup using RMAN
• Configure Oracle Management Server
• Configure Materialized view for Day End and Month End reporting.
• Preparing Documentations as deliverables in all phases of the project
• Update progress to business and highlight risk
• Coordinate with different vendor team to get all the required information to carry out the build
2. Project Name: Starbucks Global Production Support
Offshore, UP, Processes, Sql server 2008, Production, Tuning, Assessment, Server, Weblogic, Monitoring, Insurance, Health, Backup, Infrastructure, Tomcat, Design, Support, PLC, It, Windows, Windows server, Management, Apache, Database, Oracle, SQL Server, Administration, Linux, Sql
2014 - 2018
job
DBA Lead
Starbucks Inc.
Environment R12.2.4 Database 11.2.0.5 OEL 6.4
Project Description
Starbucks is a leading IT company who also is a giant Coffee Retailer. Starbucks Application Maintenance and Support is the centralized database services for all Datacenters. The Oracle DBA team serves customers in more than 180 countries and has offices in about 40 countries.
Contribution
• Upgrade expérience of Oracle Applications from 12.1.3 to 12.2.3, 12.2.3 to 12.2.4 and 12.2.4 to 12.2.5
• Cloning of 12.2.3, 12.2.4 oracle applications
• Oracle Applications R12.2.4 Clone and Support on EXADATA enivornment.
• R12.2.x installations and ADOP Online Patching Activities
• Installation of R12.1.3, Oracle Database 11g.
• Installation of R12.2 Multi& Single node
• Installation and support of Oracle Database 12c(12.1.0.2)
• Cloning of 12.2.3, Multinode to single node and single node to multi node.
• Cloning RAC to RAC and RAC to NON RAC using RMAN.
• Monitor and support of the Concurrent Scheduled jobs (Dresser Supply chain data collections, etc) run in ASCP environment under MRP admin user.
• Experience in Oracle Business Intelligence and supporting ETL and DW.
• Resolved the issues in conflicts between the target and source database in golden gate
• Patching CPU for databases and Oracle Applications
• Troubleshoot Oracle Applications and Oracle database issues
• Daily health check like monitoring tablespace, mount points etc.
• Involved in SYSADMIN activities
• Management and leadership of the Starbucks Database Services Team; Leading a team accountable for on premises and Cloud Services (IaaS), my role is to ensures uptime is guaranteed.
• Manage a technical team comprising of system administrators, DBA's and consultants to bring in projects/tasks on time and within budget.
• Leading the team and global delivery teams to design new architectures for the reduction of infrastructure costs and provide scalable infrastructures to support market place launches worldwide.
• Manage projects and work closely as a PMO to ensure support and administrative functions like time and material requests are completed accurately and on time.
• Lead effort in providing capacity planning, contingency planning (BCP/DR), IT project management, change management, configuration management and other ITIL related disciplines.
• Lead the implementation of the infrastructure strategy mapping back to business requirements.
• Making sure that the ITIL processed like Incident Management, Problem Management & Change Management are adhered.
• Identifying and implementing continuous improvement initiatives including process and technical tools.
• Identifying and implementing chargeable technical service offerings in addition to current installation services.
• Provide leadership and direction on customer issue resolution.
• Liaising and escalating issues where appropriate within the Legal Software Solutions leadership team.
• Technical Support of the Legal Software Solutions Department.
• Manage internal projects to support existing products & for the development of new products.
3. Project Name: New York Stock Exchange
Project Description
Starbucks is a leading IT company who also is a giant Coffee Retailer. Starbucks Application Maintenance and Support is the centralized database services for all Datacenters. The Oracle DBA team serves customers in more than 180 countries and has offices in about 40 countries.
Contribution
• Upgrade expérience of Oracle Applications from 12.1.3 to 12.2.3, 12.2.3 to 12.2.4 and 12.2.4 to 12.2.5
• Cloning of 12.2.3, 12.2.4 oracle applications
• Oracle Applications R12.2.4 Clone and Support on EXADATA enivornment.
• R12.2.x installations and ADOP Online Patching Activities
• Installation of R12.1.3, Oracle Database 11g.
• Installation of R12.2 Multi& Single node
• Installation and support of Oracle Database 12c(12.1.0.2)
• Cloning of 12.2.3, Multinode to single node and single node to multi node.
• Cloning RAC to RAC and RAC to NON RAC using RMAN.
• Monitor and support of the Concurrent Scheduled jobs (Dresser Supply chain data collections, etc) run in ASCP environment under MRP admin user.
• Experience in Oracle Business Intelligence and supporting ETL and DW.
• Resolved the issues in conflicts between the target and source database in golden gate
• Patching CPU for databases and Oracle Applications
• Troubleshoot Oracle Applications and Oracle database issues
• Daily health check like monitoring tablespace, mount points etc.
• Involved in SYSADMIN activities
• Management and leadership of the Starbucks Database Services Team; Leading a team accountable for on premises and Cloud Services (IaaS), my role is to ensures uptime is guaranteed.
• Manage a technical team comprising of system administrators, DBA's and consultants to bring in projects/tasks on time and within budget.
• Leading the team and global delivery teams to design new architectures for the reduction of infrastructure costs and provide scalable infrastructures to support market place launches worldwide.
• Manage projects and work closely as a PMO to ensure support and administrative functions like time and material requests are completed accurately and on time.
• Lead effort in providing capacity planning, contingency planning (BCP/DR), IT project management, change management, configuration management and other ITIL related disciplines.
• Lead the implementation of the infrastructure strategy mapping back to business requirements.
• Making sure that the ITIL processed like Incident Management, Problem Management & Change Management are adhered.
• Identifying and implementing continuous improvement initiatives including process and technical tools.
• Identifying and implementing chargeable technical service offerings in addition to current installation services.
• Provide leadership and direction on customer issue resolution.
• Liaising and escalating issues where appropriate within the Legal Software Solutions leadership team.
• Technical Support of the Legal Software Solutions Department.
• Manage internal projects to support existing products & for the development of new products.
3. Project Name: New York Stock Exchange
Continuous improvement, Online, Direction, Configuration Management, Incident Management, Monitoring, Software, Health, Development, Infrastructure, Implementation, Support, Cloud services, It, Service, Node, Design, PMO, Leadership, Management, Oracle database, ETL, Exchange, Budget, Cloud, ITIL, Database, Oracle, Business Intelligence, It project management, Change management, Project Management
2010 - 2014
job
Oracle Core DBA , SQL DBA
New York Stock Exchange.
Environment Oracle Database 9i,10g,11g ,SQL 2005,2008r2
Project Description
NYSE is a leading US Stock Exchange Company with a global consulting, digital technology and outsourcing expertise in driving digital strategy and business transformation solutions
Contribution
• Troubleshoot the Applications issues and performance problems.
• Performed DB upgradation from 11.2.0.2 to 11.2.0.3
• Review proposed changes and test them in a test and QA environment
• Applied the various patch sets, application patches and rdbms patches.
• Analyzing and applying the security patches
• Plan DBA schedules and activities, prioritize the work to ensure work is progressed and aligned with project delivery dates
• Database and application health check
• Coordination and communicate with Onsite/Offshore DBA team
• Identify an escalation plan for each critical situation
• Working with release management team to progress RP(release packages)
• Handling tickets raised by users through Service-now tool.
• 300+ Oracle servers were upgraded and migrated to Oracle 11g RAC respectively.
• 200+ SQL Server 2005 DB servers were patched and then were upgraded to SQL Server 2008R2 and 2012.
• Lead the DBA team providing leadership and strategic direction to ensure the availability and reliability of key systems and services to the business; enable innovation and leverage IT trends that can create business value consistent with the company requirements and expectations;
• Responsible for providing leadership for delivery of 24/7 service operations and KPI compliance.
• Established metrics, key performance indicators, and service level agreements to continually improve the performance of IT operations; Lead the implementation of the infrastructure strategy and set direction for continuous improvement.
• Accountable for managing the database requirements and involved in the transformation of the infrastructure and services available to end users.
• Involved in Dashboard monitoring & operational readiness.
• Ensured that the comprehensive disaster recovery architecture is maintained and operations are in place to ensure compliance with required Recovery Point Objectives (RPOs) and Recovery Time Objectives (RTOs) during business continuity events.
• Responsible for allocation of work with advice, coaching and training to enhance the expertise of individuals and the team where I'm required to set work objectives and manage performance of the team. Set direction for continuous improvement in order to better align infrastructure.
• Manage IT vendors/contractors, IT contracts and outsourcing management.
4. Project Name: IKEA Global Production Support
Project Description
NYSE is a leading US Stock Exchange Company with a global consulting, digital technology and outsourcing expertise in driving digital strategy and business transformation solutions
Contribution
• Troubleshoot the Applications issues and performance problems.
• Performed DB upgradation from 11.2.0.2 to 11.2.0.3
• Review proposed changes and test them in a test and QA environment
• Applied the various patch sets, application patches and rdbms patches.
• Analyzing and applying the security patches
• Plan DBA schedules and activities, prioritize the work to ensure work is progressed and aligned with project delivery dates
• Database and application health check
• Coordination and communicate with Onsite/Offshore DBA team
• Identify an escalation plan for each critical situation
• Working with release management team to progress RP(release packages)
• Handling tickets raised by users through Service-now tool.
• 300+ Oracle servers were upgraded and migrated to Oracle 11g RAC respectively.
• 200+ SQL Server 2005 DB servers were patched and then were upgraded to SQL Server 2008R2 and 2012.
• Lead the DBA team providing leadership and strategic direction to ensure the availability and reliability of key systems and services to the business; enable innovation and leverage IT trends that can create business value consistent with the company requirements and expectations;
• Responsible for providing leadership for delivery of 24/7 service operations and KPI compliance.
• Established metrics, key performance indicators, and service level agreements to continually improve the performance of IT operations; Lead the implementation of the infrastructure strategy and set direction for continuous improvement.
• Accountable for managing the database requirements and involved in the transformation of the infrastructure and services available to end users.
• Involved in Dashboard monitoring & operational readiness.
• Ensured that the comprehensive disaster recovery architecture is maintained and operations are in place to ensure compliance with required Recovery Point Objectives (RPOs) and Recovery Time Objectives (RTOs) during business continuity events.
• Responsible for allocation of work with advice, coaching and training to enhance the expertise of individuals and the team where I'm required to set work objectives and manage performance of the team. Set direction for continuous improvement in order to better align infrastructure.
• Manage IT vendors/contractors, IT contracts and outsourcing management.
4. Project Name: IKEA Global Production Support
Infrastructure, Security, QA, Technology, It, Outsourcing, Support, Offshore, Transformation, Implementation, Compliance, Health, KPI, Monitoring, Server, Production, Direction, Contracts, SQL Server 2005, Business transformation, Digital Strategy, SQL Server, Coaching, Innovation, Training, Oracle, Database, Consulting, Exchange, Sql, Oracle database, Management, Test, Contracts, Leadership, Continuous improvement, Architecture, Service
2009 - 2010
job
Oracle Core DBA
IKEA.
Environment Oracle Database 7,8,9i,10g,11g , HP-UX , Vmware , OEL 5x
Project Description:
IKEA Global production support comprises of the IT operations for Network, Storage, Servers, Databases. There are more than 2000 Oracle databases hosted worldwide. GDBA team was responsible to create, manage and troubleshoot database activities in DBA platform.
The environment includes pre-production and productions.
There are over 50 RACS in Linux and 10 RACs in AIX platform.
RACs containing 4 to 12 databases. Also standalone servers in AIX,Linux servers containing more than one databases in different Oracle versions i.e 8i,9i and 10g.
Contribution
• Plan DBA schedules and activities, prioritize the work to ensure work is progressed and aligned with project delivery dates
• Coordinate with Oracle On Demand for infrastructure and environment related issues, product support team for an oracle product issues
• Maintaining the health of Oracle applications system
• daily, weekly, monthly database and application health check
• Own the plan for each DBA task. The plan will include preparation time, launch, schedules, checklists, contact names, etc
• Identify an escalation plan for each critical situation
• Applying application patches in Test, dev and production instances.
• Troubleshooting of ongoing Oracle applications issues.
• Handling tickets raised by global users through GSC (Global Service Center).
• Team Member of team size 13.
• Providing 24*7 support
• Creation of standalone,RAC database in Linux or AIX platform.
• Configuration of RMAN backup for databases
• Backup restore and recover for standalone/RAC database
• Oracle binaries installation on AIX,Linux servers
• Oracle Agent installation on AIX,Linux servers
• Database Export/Import,Data pump,Automatic Storage Management (ASM),Data Guard,Streams
• Troubleshooting and resolving daily database issues.
• Contact Oracle Support
• Tuning SGA,Query Tuning, Tuning the code written in PL/SQL
• Trace and troubleshoot database issues using various utilities like explain plan,tkprof,oradebug,index rebuilt, analyze
• Understanding the database issues using event tracing
• Taking AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor) reports and analyze the reports.
5. Project Name: BT Retail Database Support
Project Description:
IKEA Global production support comprises of the IT operations for Network, Storage, Servers, Databases. There are more than 2000 Oracle databases hosted worldwide. GDBA team was responsible to create, manage and troubleshoot database activities in DBA platform.
The environment includes pre-production and productions.
There are over 50 RACS in Linux and 10 RACs in AIX platform.
RACs containing 4 to 12 databases. Also standalone servers in AIX,Linux servers containing more than one databases in different Oracle versions i.e 8i,9i and 10g.
Contribution
• Plan DBA schedules and activities, prioritize the work to ensure work is progressed and aligned with project delivery dates
• Coordinate with Oracle On Demand for infrastructure and environment related issues, product support team for an oracle product issues
• Maintaining the health of Oracle applications system
• daily, weekly, monthly database and application health check
• Own the plan for each DBA task. The plan will include preparation time, launch, schedules, checklists, contact names, etc
• Identify an escalation plan for each critical situation
• Applying application patches in Test, dev and production instances.
• Troubleshooting of ongoing Oracle applications issues.
• Handling tickets raised by global users through GSC (Global Service Center).
• Team Member of team size 13.
• Providing 24*7 support
• Creation of standalone,RAC database in Linux or AIX platform.
• Configuration of RMAN backup for databases
• Backup restore and recover for standalone/RAC database
• Oracle binaries installation on AIX,Linux servers
• Oracle Agent installation on AIX,Linux servers
• Database Export/Import,Data pump,Automatic Storage Management (ASM),Data Guard,Streams
• Troubleshooting and resolving daily database issues.
• Contact Oracle Support
• Tuning SGA,Query Tuning, Tuning the code written in PL/SQL
• Trace and troubleshoot database issues using various utilities like explain plan,tkprof,oradebug,index rebuilt, analyze
• Understanding the database issues using event tracing
• Taking AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor) reports and analyze the reports.
5. Project Name: BT Retail Database Support
Service, Agent, Utilities, Production, Tuning, Aix, Storage, Health, Backup, Infrastructure, Support, Hp-ux, It, Sql, Network, Pl/sql, Test, Management, Oracle database, Event, VMware, Database, Retail, Oracle, UX, Linux
2005 - 2009
job
Oracle Core DBA
British Telecom.
Environment Databases: 8.1.4, 9.2.0.6,10.2.0.3 & 11.2.0.2 Solaris5x, Linux5x & Windows
Project Description:
This project carried on a 24X7 onsite - offshore model with team size of 100 DBAs supporting 3500 databases across the World. Project is based on SLA. It's having different types of environments LINUX, Solaris, Windows & oracle 9i, 10g, 11g, RAC. All databases are registered with OEM Grid Control. Monitoring the databases Using OEM, databases alerts use to come in On Call DBA (Mail Box).British Telecom is having two types of environments like validated and non validated environments. Each environment is having Stage, Development and Production. Some of the databases are (validated) qualified and some of the databases are (Non validated) non qualified. For qualified databases if any code change like patching, user creations, code deployments, parameter changes etc., need to raise a (FCC) Full Change Control for production, stage databases. It involves business, compliance and technology (DBA) team. Other than qualified databases need to raise (RCC) Release Change Control. For Repetitive action need to raise (SRA) Standard Repetitive activity. Users use to notify the incidents using GRD (GetRDone) Tool.
Contribution
• L2 and L3 DBA support.
• Cloning of Oracle Applications, database refreshes and backups are automated with GE own customized shell scripts; those are scheduled and executed through APPWorx tool.
• Create and Manage Application Users, assigning Responsibilities.
• Troubleshoot the Applications issues and performance problems.
• Managing Oracle Applications using AD Utilities.
• Maintenance included relinking applications objects and regenerating forms and reports using all.
• Applied the various patch sets, application patches and rdbms patches.
• Daily Health check of Production environments and Space Management.
• Database Maintaince for Testing and Developments.
• Administering concurrent manager, defining concurrent managers and work shifts
• Troubleshooting issues raised by the support team through Incident Management clarify Bridge tool.
Project Description:
This project carried on a 24X7 onsite - offshore model with team size of 100 DBAs supporting 3500 databases across the World. Project is based on SLA. It's having different types of environments LINUX, Solaris, Windows & oracle 9i, 10g, 11g, RAC. All databases are registered with OEM Grid Control. Monitoring the databases Using OEM, databases alerts use to come in On Call DBA (Mail Box).British Telecom is having two types of environments like validated and non validated environments. Each environment is having Stage, Development and Production. Some of the databases are (validated) qualified and some of the databases are (Non validated) non qualified. For qualified databases if any code change like patching, user creations, code deployments, parameter changes etc., need to raise a (FCC) Full Change Control for production, stage databases. It involves business, compliance and technology (DBA) team. Other than qualified databases need to raise (RCC) Release Change Control. For Repetitive action need to raise (SRA) Standard Repetitive activity. Users use to notify the incidents using GRD (GetRDone) Tool.
Contribution
• L2 and L3 DBA support.
• Cloning of Oracle Applications, database refreshes and backups are automated with GE own customized shell scripts; those are scheduled and executed through APPWorx tool.
• Create and Manage Application Users, assigning Responsibilities.
• Troubleshoot the Applications issues and performance problems.
• Managing Oracle Applications using AD Utilities.
• Maintenance included relinking applications objects and regenerating forms and reports using all.
• Applied the various patch sets, application patches and rdbms patches.
• Daily Health check of Production environments and Space Management.
• Database Maintaince for Testing and Developments.
• Administering concurrent manager, defining concurrent managers and work shifts
• Troubleshooting issues raised by the support team through Incident Management clarify Bridge tool.
Offshore, Manager, Utilities, Production, Incident Management, Monitoring, Telecom, Health, Testing, Development, Linux, Support, It, Technology, Compliance, Windows, Management, Database, SoMe, Oracle
My education
Biju Patnaik University
Bachelors, Electronics & Telecommunications
Bachelors, Electronics & Telecommunications
Manas' reviews
Manas has not received any reviews on Worksome.
Contact Manas Das
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Manas directly in Worksome.
are ready to help you
and get specific bids from skilled talent in Denmark