Oracle Manager

Abhijit Boro

Mobile: 416-***-****; Home: 905-***-****

*******.****@*********.**

CAREER PROFILE

Abhijit Boro is a Professional Service Provider to HP Canada for their client, Rogers Communication Inc. He is working as a Team Lead – Oracle DBA at Rogers. Throughout 12+ years of IT career he has provided a broad spectrum of technical expertise to clients in E-commerce, Financial, Human Resource, Chemical Manufacturing, Hi-Tech, Government, Retail and Telecommunications.

A sample of Abhijit’s DBA-Unix experience amply reflects this breadth. He has carried out system design & analysis that includes physical and logical design of databases, estimation of resources viz. CPU, Memory & spaces. As an Oracle DBA he was engaged in various projects such as Database design (Physical & Logical), Oracle installation and configuration, migration & upgrade, ERP Application such as PeopleSoft Financial/HCM, Oracle E-Business Suite as well as relocation of complete of data center, etc. Planned and implemented Backup and Recovery strategy with IBM TSM and Veritas NetBackup. He carried out disaster recovery test [DRP] for various ERP applications number of times at DRP sites. In addition to project works, he had supported production, test and development environments that include database, application, web tiers and Unix OS. Abhijit provided the performance tuning expertise in the area of databases, application and OS. Abhijit is well versed with Unix Administration works on various platforms such as HP-UX, Solaris, AIX and Linux.

An equally impressive educational and training background on specific to Oracle DBA, Oracle RAC, ERP Application such as PeopleSoft, Oracle E-Business Suite, etc. and Unix Administration supports these impressive experiences. Abhijit is an ITIL Certified and Oracle Certified Professional [OCP] and holds an Engineering Degree. He is an excellent team player whose engaging personality facilitates the communication requirements of demanding IT projects

TECHNICAL SUMMARY

Current Technical/Project Management Skills, and Technologies used:

Senior Oracle DBA [OCP] and Architect of Systems Design and Analysis Process Modeling and Diagramming using VISIO ProfessionalEnterprise Performance Analysis & Tuning – OS, Applications, Databases, SQLsProject Planning - Preparing specifications, estimates, (RFQ, RFI, RFP) and other project documentsProject Leading and Managing – Initiation, Team Coordination, Consultation and Implementation, Monitoring & Controlling and ClosingChange Management and Control ProceduresDBA Support for ERP Application – PeopleSoft HCM 9.0/8.8/8.4 [HR/Payroll/Benefit] and Financial 8.9, Oracle E-Business R12/11.5.10/11.5.9 [Financial & Manufacturing] Installation and upgrade of Oracle RAC/Standalone 11g/10G/9i/8i/8.x with/without Oracle ASMHigh Availability - Oracle in Cluster Environment [RAC] and Oracle Data Guard, Standby Oracle Databases IBM Tivoli Storage Manager, Veritas NetBackup and Oracle Recovery Manager [RMAN] Disaster Recovery Planning [DRP] and Testing System Monitoring and Reporting tools: HP OpenView, Oracle Enterprise Manager 11g/10g Grid Control, Veritas i3, QuestKnowledge of MS SQL Servers AdministrationUNIX Systems Administration: HPUX, AIX 7.1/6.1/5.2, Solaris and Linux; Virtual Software; Veritas Volume Manager / VxFS, HP-UX VirtualizationCapacity Planning and Sizing (Unix and Oracle) and Shell Scripting Best Practices & Techniques used in Oracle Database Administration (Development, Test, and Production) Excellent communication skills across various levels – management, internal clients, 3rd party vendors such as Oracle, PeopleSoft, Veritas, EMC, Brocade, Sun/HP/IBM and most importantly various technical groups such as development groups, networks, system administrator and DBAsAbility to lead team into a more ISO-9000 and 5900 audit compliant work environment where goals, objectives and processes are clearly defined, documented and implementedAbility to provide a better communication mechanism between the technical group and top management in identifying gaps and improving weak and inconsistent implementations

EXPERIENCE

Team Lead, Application Development and Architecture (DBA) June 2011 – Present

HP Canada/Rogers, Canada

Provided Oracle Apps and Physical DBA services to HP Canada at their client site Rogers Communication Inc.Performed architectural design, building, testing and maintaining of Oracle Maximum Availability Architecture (MAA) for E-commerce application that supports 46000+ concurrent users worldwide. This environment is constantly evolving with new functionalities. Projected to grow 15TB in a few years. Oracle 11gR2 RAC with Oracle ASM on Linux servers having 196GB memory and 64 numbers of CPUs.Installed and configured Oracle 11g/10g - RAC/Standalone with/without Oracle ASM on AIX, Linux, Solaris and HP serversCreated physical and logical database schemas based on the client’s requirements; Built schema objects based on the application requirementsSupported various mission critical applications that are running on Oracle 11g, Oracle 10g and Oracle 9iPerformed codes deployment, configuration and administration of databases for all environment such as Production, Business Requirement Testing, Staging, Quality Assurance – QA, Development etc.Carried out data modeling, physical and logical design of database schemas of Business Analytic ApplicationCarried out Backup and Recovery strategy and implementationInstalled and configured Oracle 11g Grid Control framework to monitor databases, weblogics, coherence, hosts.

Senior Oracle Database Architect/DBA October 2006 – May 2011

City of BramptonPerformed as a lead DBA role in Data Center Migration and Oracle Upgrade projects that includes server migration and upgrading of Oracle 9i/10g to Oracle 11g for City’s mission critical applications such as GIS application, Information Management System for Citizen, TAX application, Fleet System for Transit, Primavira Application for engineering division, etc.Performed internal consulting role to system development and project teams for various initiatives such design analysis and solutions, managing resources, managing the development effort, gathering requirements and technical design of the projectsServed as a principle technical resource for the team in order to architect from inception to conclusion and to resolve problems related to installation, configuration and troubleshooting of Inventory Application upgrade for City’s Transit department that uses Oracle 10g/HP-UX 11.31 Itanium, Crystal/Apps on Windows Server (Virtual Server). This project last for 15 monthsPerformed data modeling; created physical and logical database schemas; created schema objects and managed Oracle 11g/10g/9i databases and related systems in support of production business applications and systems development work for various applications Integrated new environment and software/hardware with existing environment that includes databases and applications running on virtual and physical servers – Unix and WindowsManaged projects in relation to DBA team activity for systems development and implementationResponsible for coaching and mentoring junior DBAs and Developers; Also, provided advice, guidance and assistance to less experienced peers as requiredLead the Oracle 11gR2 RAC implementation project that includes architecture, setting up and upgrading of standalone Oracle 10g applications to Oracle 11gR2 RAC with ASM environment. Applied Oracle Security/Bug patches as well as Unix Patches to development as well as production environmentSupported Oracle RMAN/TSM backup and recovery that included backup and recovery strategy, daily monitoring of backup, restore of databases on user request, configuration of new backup, upgrade of TSM Storage/Oracle agent, etc. Installed and configured Oracle 11g/10g Grid Control framework to monitor various targets that host over 150 databases, PeopleSoft Application and Unix serversMonitored system performance, disk space usage, tablespaces, etc. and optimized configurations for the development and production environment as needed; also, involved in optimizing operating systemSupported SQL Server environment as SQL Server DBA whenever requiredPrepared and documented various standard operational procedures (SOP) for Database Management group Coordinated with various vendors such as Oracle, HP and IBM, etc. for troubleshooting and new initiatives

Senior Consultant, Technology Management June 2000 – September 2006

CGI Group Information and System Management Consultants, Inc

Performed several roles in the area of architectural design & implementation, project management, managing resources, managing the development effort, hands-on database administration, and system administration for various clients. Some of key highlights of work experiences at CGI:

Client: Cott Beverages, Brampton: 6 monthsInstalled and configured Oracle 10.2.0.4 on Windows platform; Designed and created physical and logical of databases schemas; Performed daily monitoring of databases; Automated database monitoring tasks against threshold; Configured and monitored nightly backup and refreshed development environment from production environment

Technology: Oracle 10g; Operating System: Windows 2003

Client: Air Liquide, Houston, Texas, USA: 42 monthsWorked as Oracle Apps DBA and Application System Administrator in a large complex Oracle E-Business Suite 11.5.10/11.5.9 [Financial and Manufacturing] environment that has many custom applications that integrated with Oracle E-Business suite. Database (Oracle 9i) and Application Tiers reside on Sun Solaris/AIX platform and Farms/Web Tiers reside on Windows/Linux. Responsible for code migration, troubleshoot issues with web server, forms server, and database; Cloned/refreshed databases/application tiers; Proactively monitored environment such as tablespace storage, concurrent mangers, long running jobs, runway processes, etc. Also, responsible for leading and coordinating release management, testing, job scheduling and on-call development support activities [30 months]

Build Sun Server that includes the installation of Oracle 9i and operating system – Sun Solaris 10, Veritas Volume Manager and configuration of disk [creating disk groups, mirroring of root and application files] for BroadVision and FabNet Application which are mission critical applications through which client do their sales; Migrated databases from 8.1.7 to 9.2.0.4 [Duration: 9 months]

Successfully carried out Disaster Recovery Test for Oracle E-Business, PeopleSoft and Data Warehouse Environments at Sun Guard, Philadelphia and Toronto [3 months]

Worked closely with the Systems Administration team to design and operate an optimal hardware infrastructure for database systemsEnsured that where ever applicable and feasible technically, operationally and economically, that processes and procedures are properly documented, understood and improved to meet SLAs, budget and deadlines constraintsPromoted a team-based technical work environment where core skills were shared in order to provide full coverage to various customer groups

Technology: Oracle 9i/10g; Operating System: AIX/Solaris/Linux and Windows 2000/2003/XP; Oracle E-Business, PeopleSoft, Maximo, IBM Tivoli

Client: Purolator, Mississauga Duration: 10 monthsCarried out cost analysis for Unix Tower; Build Sun Servers [V880 and V450] that includes the installation of Sun Solaris 8, Veritas products - Volume Manager 3.5 and File System 3.5, setup and configuration of network interface cards, configuration of disks, mirroring and creation of file systems; Installed and configured Veritas Netbackup Unix Client and Oracle 9i SAP Database Extension; Carried out the backup and recovery strategy; Configured and performed Oracle Backup using SAP tools [sapdba]; Applied Solaris and Oracle Patches; Knowledge transferred to piers for supporting the environment, BAU [Business as Usual];

Technology: Oracle 9i; Operating System: Solaris and Windows 2000/2003; SAP, Veritas NetBackup, Veritas Volume Management

Client: Interac; Toronto; Duration: 14 monthsPrepared technical project plans and recommended resource allocations for DBMS and OS upgrades and Migration (capacity planning); Performed project management and change management procedures and controls; Carried out physical design of Oracle Database [Size 1 TB] for Data Warehouse Application; Installed Oracle binaries 9.2.0.4; applied patches and configured the Net8 [tansnames.ora & listener.ora]; Created databases, physical and logical objects; Carried out performance tuning and restructured Oracle databasesDeveloped backup and recovery strategy and implemented the same with Oracle RMAN/Veriats NetBackup that includes installation of Veriats software, installation and configuration of Tape Libraries, HP Sure Storage E 10/100 & E 20/700; Maintained ongoing maintenance of Catalog Repository;Prepared process diagrams and high level technical systems documentation for ISO-9000 and 5900 audit compliance; Performed on-call technical support to provide 7x24 production support

Technology: Oracle 9i; Veritas, HP-UX/Solaris and Windows 2000

Client: Internal Duration: 5 monthsArchitect and implemented Enterprise Backup and Recovery solution at CGI Mississauga data center using technologies such as Veritas NetBackup [Master/Media Server, Database agent-Oracle 8i/9i RMAN, SAP, Unix/NT/MS2000 client], Brocade Switches, HP Bridge, HP Sure Store 20/600, DLT/LTO drives. This multi-platform [HP, AIX, Sun Solaris, NT, MS2000, Windows XP] environment supports all the internal/external clients that are hosted at this data center; Prepared procedures, technical work plans and took overall lead and coordination with hands-on involvement

Performed project management as well as technical implementation ensuring that projects are tracked, delivered and implemented with the lowest cost of ownership but with best achievable quality

Technology: Oracle 8i/9i; Operating System: Solaris, HP-UX, AIX, Linux and Windows NT/2000; Veritas NetBackup, SAP, LotusNote, HP Sure Store Tape Library

Senior Engineer – Project Management August 1992 – May 1999

Engineers India Limited. Delhi

Worked as a project engineer in engineering consulting firm and managed various oil refinery and pipeline projects for Global clients. Some of the highlights of responsibilities that were performed at various stages as per PMBOK

- Prepared technical bids for various work packages and evaluated the offersCoordinated with global sub-contractors and vendors to ensure that project progress as per scheduleManaged technical resources that includes design engineers, site engineers and drafting personalsDocumented project closing information, operational information, etc.

EDUCATION

Bachelor of Engineering, Birla Institute of Technology, India

CERTIFICATION AND TRAINING/COURSES ATTENDED

Project Management University of California, BerkeleyOracle Certified Professional [OCP] Oracle University, USAOracle Grid Infrastructure 11g: Manage Clusterware Oracle University, USA

ASMOracle 11gR2 RAC Administrator Performance Tuning Corporation, USA Oracle Database 11g: New Feature for Administrator Oracle University, Virtual USA11i Install, Patch and Maintain Oracle Application Oracle University, Toronto, CanadaOracle 11i System Administrator Fundamental Oracle University, Toronto, CanadaPeopleSoft Data Management and Upgrade Oracle University, Toronto, CanadaPeopleSoft Integration Tools City of Brampton, Brampton, CanadaPeopleSoft Server Administration 8.8 People Soft Training Center, TorontoWebLogic Server Administration 7.0 BEA Training Service, Toronto,CanadaSolaris Cluster Server Administration Sun Micro System, Markham, Canada

with Oracle RACImplement and Maintain a SQL Server 2008 HP Education Central (RAIL), USA

Database Management ServerSolaris System Administration Sun Micro System, Markham, CanadaHP-UX for Experienced Unix Administrators HP Education Central (RAIL), USA HP-UX Ignite Server Administration HP Education Central (RAIL), USAHP-UX Virtual Server HP Education (RAIL), USABrocade SAN Design and Implementation Brocade Education Services, ColoradoVeritas NetBckup for Oracle Extension Veritas Corporation, Orlando, USA

Reference

Aavailable upon Request

Contact this candidate