Invite Freelancer to Project
You don't seem to have an active project at the moment. Why not post a project now? It's free!Post a project
- 100%Jobs Completed
- 100%On Budget
- 100%On Time
- N/ARepeat Hire Rate
“Helped to solve the problems we agreed on. will take him for the next MySQL job for sure.”eyalreacheffect 1 year ago
Freelance DBAJul 2012
# GetResource Inc, USA - Online trainer for Oracle Partner Network trainer Working as trainer for online training on Oracle Database 12c Essentials Boot camp & Oracle Database 12c Implementation Specialist training (IZO-497 exam). It’s a online training program to be delivered using webex and providing hands on labs using VM labs provided by OPN. Participants include DBAs, Developers, IT Managers, and Application managers of Oracle Diamond and Gold partners. # Sankhya Infotech, Hyderabad: Performance Tuning of ELearning Portal to support the require number of concurrent users. The in house developed LMS product based on open source product Sakai. As part of the assignment had to review the complete system and identify opportunity for tuning to support the over 10000 concurrent users. Deployment and configuration of Oracle 12c database with ASM and Active Data Guard on Oracle VM instance on Microsoft Azure Cloud. Providing remote DBA support for development go-live and post go live support. These LMS were for SBI, largest bank in India & Etithad Airways. # Netreach Asia, Singapore (Via Elance) Database using tuning and installation for Oracle 12cg RAC on windows 2012 R2. The assignment involved reviewing the existing application & infrastructure and give solution to meet the growth in application usage in next 5 years. The proposed solution would reduce number of database from 8 to 1 and eliminate duplication of data by 80%, eliminate need to load master data into multiple database. Project is currently in POC stage. # Imberg Consulting GmbH, Switzerland ( Via ), Installation of Oracle 12c Cloud hosted server & on multiple VMWare instances running Windows 7, Oracle APEX configuration and other applications like Mediawiki required for the project. Activities include creating database, users and schema objects as required for application. Providing technical support regarding data management, SQL scripts for database creation and exporting data between multiple test environments. Working on Continuous basic and support for any database related issues for data migration, database design and automation of tasks. # SAPCLE, Dubai & Gulf Business Machine (GBS), Oman Working for Oman International Container Terminal (OICT). Installation on Oracle 11gR2 database on Redhat 6 and upgrading all the existing databases from 18.104.22.168 to 22.214.171.124 using import export process. The assignment involved installation and creation of new 11g database, creating database and importing application schemas, general tuning and setting rman backups. The project was done is stages as POC, UAT and Production Build. The project was part of the Migration to new Datacenter and system readiness for the anticipate surge in business volume. The new environment went live in April 2014 without any issues. # Project Management Technology and Services (Promatas), Oman - Performance tuning and database auditing of applications at Ministry of Manpower. Had done the complete 360 degree review of database covering application connectivity, Instance parameters, Physical layout, Identification for need of new indexes, Database design, Identifying & purging unused and redundant object (including application, OS, network). Assignment includes making recommendation, enabling the statistics gathering jobs, planning for validating the recommendations and overseeing the implementing the same. # Hazox Chemical Reporting Systems, NJ, USA (Via Elance) Trouble shooting existing issues, tuning database, general maintenance of Oracle 10g instance on Windows 2000 VM server. # Scitegrity Limited, UK (Via Elance) Installation and support for Oracle 11g database on Amazon EC2 server running Windows 2008 R2, Scheduling Maintenance jobs in first phase. # The Skill Enhancers (TSE), Hyderabad: Oracle 12c new features training program for their client Oracle Financial Technologies, Bangalore. The objective of the training program is to give orientation to development and support team towards to new features introduced in Oracle 12c database and assist them decide on early adaption 12c features into their products and services. # Photon Infotech Pvt. Ltd, Hyderabad – Install Oracle database and general administration, database backup, replication to local server for development for web based applications and website hosted by company. The job is call-on-need based. # Arich Infotech ltd, Chennai - Oracle related training at their client Cognizant Technologies in Hyderabad. These are typical 3 to 5 days training programs as requested.
Lead DBAMay 2006 - Jun 2012 (6 years)
# Worked as Offshore Lead for Hyperion Implementation & Infrastructure Support, involving in installation and supporting Hyperion 126.96.36.199 and on windows and Unix Platforms. Responsible for the building the environments and availability of services. And installing the client components (HFR and Smartview) on over 1600 users spread across globe. # Experience in installing and supporting all Hyperion components e.g., HFM, FR, FDM, DRM, ODI, Shared Services, Workspace. Build the entire setup consisting of Development, Test and Production environments, working with development teams and end users for the entire project from planning, development, go-live and post go-live support. # Upgrading HFM and HFR from version 188.8.131.52 to 184.108.40.206. # Creating & documenting procedure and process for application management, backup, upgrade and dependencies on other data sources base on business requirement. Application of patches Hyperion components as required. Following up with Oracle Support and other support teams for early resolution of issues. # Provide onsite support during critical business operations like half yearly and yearly closures and supporting over 800 users spread across globe # Lead a production support team consisting of over 8 members to provide 24x7 for over 3 years. Recruiting and mentoring new team member on Hyperion supporting to perform routine maintenance tasks, performance tuning and troubleshooting. # Served as Lead DBA for BI Databases for Cummins Filtrations, responsible to undertake the database upgrades, Patching, Database Tuning, Monitoring data loads provisioning for table partitions and MViews # Managed a team of over 30 DBAs for supporting over 300 production database and application associated with it from offshore. Accounted for shift schedule & work load management ensuring 24x7 availability of the support to customer. Interacting with IT managers and other infrastructure support teams for planning and coordinating major operation. # Coordinated with business managers, application & other support teams for planning and coordinating major activities like server setups, patching, upgrades, and other project requirements. # Served as Performance and Security Analyst for Cummins EBU. This involves Planning for Transitioning to the Production Support team, setting process for productions support, Security review of all DB changes as part of change management and training of teams. # Activity involved in Standardization and consolidation of DBA support across all applications and Business units in Cummins as part of new Global Support model. # Automation of tasks to using OEM, Shell scripts and VB script to reduce the manual efforts and avoiding possibilities of human errors. # Implementing Standard RMAN Backup over EMC Networker & Tapes. Implementing and Oracle OEM for centralize monitoring of all Oracle and non oracle databases, Server, Application server and automation of backups, administration performance tuning tasks across all Business units. # Played a key role in identifying opportunities to automate tasks, planning for installations, patching and upgrades, and value additions to the customer. # Efficiently worked with the Cummins Architect team as Performance and Security Analyst for setting up pro-active monitoring practices for databases, doing security review for new application and change requests, assisting teams for identifying and resolving Problem issues in application and databases. # As the Six Sigma black belt, mentored Six Sigma project projects in the areas of Improving SLA compliance, defect reduction, productivity improvements and process improvement.
Technical SpecialistMar 2003 - Apr 2006 (3 years)
# Served as Senior DBA with the BI horizontal at Wipro Technologies. Successfully worked on various assignments as Consultant DBA / Tech Lead. # Assisted project teams for Database requirements, hardware sizing, installation and database creation, Reviewing DB design and optimization. Gave recommendation for maintenance planning, database backups and availability, post installation reviews, data loading jobs. # Facilitated as Applications-Site-In-charge for Aviva life Insurance Company Ltd., at Gurgaon, accountable for availability and maintenance of the all business applications and databases. # Managed a team of 20 engineers consisting of Application Support Engineers, Oracle DBAs, and MSSQL DBAs as per the set SLAs, Incidence Management, Problem Management and Change Management. # Substantially build and established the “Application Support” practice in Wipro Infotech based on ITIL process & practices which was later adopted across other accounts of Wipro Infotech. # Setting of Network operations center (NOC) for remote support and automation of continuous operations and automation of Monitoring and administration task. # Planned infrastructure and procedures for Disaster recovery (DR) for all the core business applications and databases and successfully demonstrated continuity of critical services from Secondary data center. # Received the award for Best Support teams for two consecutive years.
B.Sc1993 - 1996 (3 years)
M.Sc2003 - 2005 (2 years)
OCP 9i (2003)Oracle Corp
Oracle Certified Professional - DBA track
OCP 10g (2008)Oracle Corp
Oracle Certified Professional - DBA track - Upgrade 10g
ITIL Foundation (2010)Exin
ITIL foundation certification V3