Build your professional network on facebook via our app Go to app
 
sandeep s Consultant Database, Microland
 
sandeep s's Profile
sandeep s
Consultant Database, Microland
Microland
confidential
confidential
Bangalore, India
Toostep 
Professional summary
sandeep s's Experience
Current :

Consultant Database, Microland

Technology Consulting

Working from 2007

Previous :

Services Integration Consultant, Success Factors , ---Services

Bangalore

Worked from 2011 to 2012

Brief summary :

+91-9740224160 sandeep.surendranmath@gmail.com Oracle OCP 9i/10g Upgrade, MCTS - SQL Server 2005, ITIL V3.0, SCSA - L1, MYSQL 5.0, Storage Fundamentals Jan11 - Till Date Success Factors, Bangalore --- Professional Services Integration Consultant Currently interacting with clients and sales, thereby providing leadership support in the development of a new business, in South east Asia region. Completing and in the process of implementing, SF projects within the time allotted, with high levels of customer success from the business process, and with high levels of customer delight Performed Integration of on-Premise databases with that of cloud databases, cloud to cloud database integrations. Conducted the Feasibility analysis as part of management operations for Talend Open studio ETL tool, BIRT reporting platform against specific customer requirements. Sound knowledge and skills in a variety of application and database tools, including SQL, MS SQL, Oracle, Sybase, MYSQL. Pursuing Boomi Atomsphere cloud integration platform certification. Business Transformation Services - Premium Reporting Lead the POC for the usage of BIRT reporting framework, which was established as the de-facto report rendering tool. Implemented process of agile for the custom reports development projects delivery cycle, which resulted in the on-time delivery of the custom reports with 99% acceptability. Implemented, evangelized and tracked the development of custom reports throughout the delivery cycle.

Previous :

Date Senior Database Administrator, MICROLAND ,

BANGALORE-

Worked from 2007 to 2011

Brief summary :

Objective To contribute significantly to an organization utilizing my academic background, work experience and information technology skills. Experience IT 7Yrs, Database 4+, Development 2+, Support 1+ May 07 - Till Date Senior Database Administrator - NETAPPS/MICROLAND,BANGALORE-INDIA Microland is Indias leading pure play IT Infrastructure Management Outsourcing Services Provider. Microland employs 1600 qualified and experienced professionals with over 10 years of experience in Infrastructure Management. Microlands IT Infrastructure Management Services are based on ITIL standards. Microlands Operations Management Center is ISO / IEC 20000-1 certified. Microland is a Gold Partner of Microsoft and a Microsoft Center of Excellence for Infrastructure. Client - NetApp (Bangalore)

Previous :

Consultant, Microland Limited

BANGALORE

Worked from 2007 to 2010

Brief summary :

Involved in leading the development of business centric Custom reports of various complexities, for various clients of SuccessFactors. May 07 - Dec 10 Microland Limited BANGALORE --- Consultant - Database Value Add Client : Netapp Client : Telstra International As a consultant for database technology I am responsible for the day to day operations of one of the biggest clients for Microland limited - Telstra International, Remote Management Services and for Solution engineering group within Microland. Experienced in enterprise system planning, architecture, design, and development life-cycle. Performed capacity planning required creating and maintaining the Databases. Clients - Clifford Thames, Jobserve, Euromoney Performed ongoing tuning of the database instances with the assistance of external consultants. - Shoebuy,Remedy ,Agresso, VMWAREVC database environment. Integrated legacy database systems with new corporate content management systems (Documentum) HYPERLINK http://www.bankerssystems.com/ http HYPERLINK http://www.bankerssystems.com/ :// HYPERLINK http://www.bankerssystems.com/ www HYPERLINK http://www.bankerssystems.com/ . HYPERLINK http://www.bankerssystems.com/ bankerssystems HYPERLINK http://www.bankerssystems.com/ . HYPERLINK http://www.bankerssystems.com/ com HYPERLINK http://www.bankerssystems.com/ / Solution Engineering Group Unearth the root cause(s) of a clients pain points within the infrastructure. Validating the business opportunity or problem as an opportunity for a technical solution or an infrastructural transformation solution. Provide expertise in the area of business case development w.r.t database services. Facilitate workshops and sessions that generate the content for solutions thereby gaining buy-in for solutions provided. Create and articulate the big picture of the solution to delivery and client teams to understand cross functional inter-dependencies and impact Business Management. Daily Operations Created and maintained all databases required for development, testing, education and production usage. Installed new versions of the Oracle RDBMS and its tools and any other 3rd party tools that access the Oracle database. Monitored migrations of programs, database changes, reference data changes and menu changes through the development life cycle. Implemented and enforced security for all of the Oracle Databases. Performed database re-organizations as required to assist for performance and ensure maximum uptime of the database. Put standards/process in place to ensure smooth day to day administration of databases. Provided technical assistance to different application development teams/users by replicating and giving workarounds for the same. Assists with impact analysis of any changes made to the database objects. Troubleshooting the problems related to the databases, applications and development tools. Created and maintained Oracle Standby Configurations. Conceptual knowledge of Oracle Real Application cluster configuration. Implemented SQL Server cluster on Windows 2003/2005 operating environment for production systems. Leading a team of database Administrators to perform their day to day activities, responsible for service delivery also. Prepare technical documentation, to assist for smooth running of daily database operations based on KT knowledge provided by the onsite team. Representing the organization as SPoC for database technology. Identify areas of improvement in the process based on gaps in quality and service delivery. Maintain relationships with appropriate client managers in order to resolve operational/technical issues. Nurture talent to address technology challenges within the organization. Product support for application and database deployment of upgrades and patch releases. Supporting distributed/Global Production databases in a multi-server/multi-location environment, 24X7 including on-call responsibilities. Duration: May 2007 - June 2009 Designed, Remote installed, configured and maintained oracle standby configurations, for Oracle Identity Management environment. Installed, configured, maintained and recovered databases using Netapps Backup and Recovery technologys SNAP MANAGER tool for oracle and SQL Server configurations. Performed databases refreshes using Snapshot, NDMP technologies on Netapps ONTAP, wrote shell scripts to automate the tasks. Created Procedure/Technical documentation for day to day SQL Server administration tasks. Duration : June 2009 - Till date Planned and implemented backup/ recovery, disaster recovery solutions of the Oracle / SQL Server database using oracle RMAN and Veritas Netbackup. Responsible for Oracle, SQL Server, Mysql Database server/instances within the Telstra Infrastructure. Mentored and leading a team of 6 dbas from the days of knowledge transfer till go-live of the same.

Previous :

Q A Engineer, Aspect Software

Worked from 2004 to 2007

Brief summary :

Stabilized the entire database environment within 2 months of go-live. Sep 04 - May 07 Aspect Software, Q A Engineer - (Database Administration) The job profile includes day to day administration of oracle and sql server instances aligned specifically towards Quality organization of aspect software. Apart from the database administration activities like user management, Backup and recovery, Creating/Dropping of Oracle/SQL Server Instances, Refreshing of Environments etc Installed and configured Siebel eBusiness Server 7.X.8, Captaris RightFax; Installed, Configured and Maintained databases Oracle 9i on Windows/Linux, Oracle 10g on Windows / Solaris, SQL Server 2005 on Windows 2003 R2 and (DataMart) Oracle 10g on Solaris V240 (Sun fire) server. Entrusted with Measuring database physical server requirements and tuning for optimum performance using system counters; Accountable for Performance testing / Stress testing of various databases and benchmarking the same against the products of Aspect Software. Identified root cause of key events affecting database performance through fishbone analysis; responsible for reducing blocks and slow performance through SQL optimization, running database consistency checks and fixing bugs. Responsible for ensuring utmost customer satisfaction by resolving escalated issues routed by the FLAs and providing technical and process Created, configured and maintained Datamarts with oracle and SQL Server databases for both internal and external clients. Responsible for installation and configuration of third party Plug-ins / Products to be integrated with DataMart for Extracting data into the DataMart databases used for Enterprise Reporting/MIS/ERP systems. Building and Recovery of oracle databases DATAMARTs upon requests from clients of Aspect software. Conceptualized and set Proof of concept [POCs]in setting up a live call center lab environment for setting up test beds with Digital Communication Processors (for aspect software).

Previous :

Engineer, Network Appliance Inc.

Texas

Worked from 2004 to 2007

Brief summary :

Network Appliance, Inc. (NetApp) is a world leader in unified storage solutions for To TILLs data-intensive enterprise. Since its inception in 1992, Network Appliance has delivered technology, product, and partner firsts that simplify data management. NetApp storage solutions include specialized hardware, software, and services, providing seamless storage management for open network environments. Major corporations and service providers, including Citicorp Securities, Lockheed, Merrill Lynch, Oracle, Texas Instruments, and Yahoo!, utilize NetApp global data management solutions. Sept 04 - May 07 QA - Engineer (Database Testing), ASPECT Software, BANGALORE-INDIA

Previous :

Technical Support Engineer, GDIC ,

BANGALORE

Worked from 2004 to 2004

Brief summary :

Feb 04 - Sep 04 HEWLETT PACKARD - GDIC, BANGALORE - Technical Support Engineer Provided technical support to North American Customers for Laptops based on Windows OS and Networking of interconnect devices / products of HP. Managed customer centric operations and ensured customer satisfaction by achieving timely solutions delivery and service; resolved issues of interconnectivity between various wireless devices from a USB device to satellite connectivity deceives with that of LAPTOP as part of ASG - advanced support group.

Previous :

Technical Support Engineer, GDIC ,

BANGALORE-

Worked from 2004 to 2004

Brief summary :

Feb 04 - Sept 04 Technical Support Engineer, HEWLETT PACKARD - GDIC, BANGALORE-INDIA

Previous :

Programmer, ,

Mysore

Worked from 2003 to 2004

Brief summary :

Field Support Engineer (Database Administrator), Real soft Technologies, Bangalore-INDIA (Bangalore) [PART TIME] Feb03 - Jan04 Adithya Computer Consultany, Trainer / Programmer , Mysore, India

Previous :

Database Administrator, Real Soft Technologies

Worked from 2003 to 2003

Brief summary :

Feb 03 - Dec 03 Real Soft Technologies - Database Administrator Worked on Assignment basis implementing oracle and sql server rdbms for various clients of real soft technologies. Provided on call support to implementation team until the Go Live of the clients projects. Sep 02 - Jan 03 J.S.S.POLYTECHNIC, NANJANGUD - Lecturer Developed Software modules in Visual Basic, with oracle as backend for CDAC-India. Trained personnel on oracle and sql server administration as per course curriculum of Adithya computer consultancy/CDAC-India. Provided customer training lasting from 2 to 5 days to Systems Administrators, Team Leads, Engineers and Trainees in all areas of the organization on various aspects of database technology. Designed and conducted classroom and web-based training for the companys application suite of products consistently meeting bonus objectives by achieving a quarterly customer evaluation score of 3.4 or higher on a 1-4 scale. Acted as the senior trainer, responsible for providing support to new trainees through mentoring, observation, and feedback. Conducted Train-the-Trainer courses and Product Sales Training for internal sales people Demonstrated products to potential customers when company is selected as a final competitor in addition to conducting product demonstrations at trade shows.

Previous :

LECTURER JSSPOLYTECHNIC NANJANGUD

Worked from 2002 to 2003

Brief summary :

Sept02 - Jan03 LECTURER , J.S.S.POLYTECHNIC, NANJANGUD - INDIA

Previous :

Software Engineer, MASTISCA SOLUTIONS ,

MYSORE

Worked from 2001 to 2002

Brief summary :

Designed instructional workbook materials used in training including hands-on experiences, worksheets, review sheets, course objectives, and course agendas. Feb 01 - Sep 02 MASTISCA SOLUTIONS, MYSORE - Software Engineer Designed and developed application based on different Java technologies including Java Component Editable Table on Java Beans Technology, Java Based Intranet Chat Server with Instant Messaging and Computerized Voting System using Java Net API. Successfully Designed and Developed Products like Doc Pages, a Yellow Pages Application, Pharmaware, a Business Process Automation Solution / Enterprise Resource Management, Call Monitoring Report Generator, a process Automation Solution, Hospital Management Software (Infrastructure, Service and Pharmacy billing), etc Responsible for installation and configuration of various RDBMS on different platforms for the enterprise. Understanding of database sizing and resource utilization. Achievements Commended as Max Performer award from Telstra international. Commended as MAX Achiever for best performance, one of its kind with Microland limited. Conferred with Award of Excellence for setting up test beds with Digital Communication Processors for R and D and QA functional areas in ASPECT Software (for aspect software). Hold credentials of representing the institute as HOD of computer science department AT MODROBS (Modernization and Removal of Obsolescence in Technical Education) project of AICTE at New Delhi. The scheme aims to enhance the functional efficiency of Technical Institutions for Teaching, Training and Research purposes by modernizing and removing obsolescence in the Laboratories / Workshops / Computing facilities.

Previous :

Software Engineer, , MASTISCA SOLUTIONS ,

MYSORE-

Worked from 2001 to 2002

Brief summary :

Feb01 - Sept02 Software Engineer, MASTISCA SOLUTIONS, MYSORE-INDIA Certifications Oracle Certified Professional DBA 9i and 10g Prometric ID: PR0276723 Perusing Microsoft Certified Technical Specialist in SQL Server 2005 Technical skill set Languages C, C++, C#, Visual Basic, PL/SQL - SQL Operating Systems Windows 200X,Linux 7.2 / Redhat Linux ES 4.0 / SOLARIS 5.8 - 5.10 RelationalDatabases Oracle 9i, 10g Server, SQL Server 2005 Tools / Frameworks Winrunner, Auto IT, Test Director 8.0, Clear Quest (Defect Tracking), Siebel 7.X, .NET, Perl, Perl DBI module, Remedy Technical Experience Storage NAS/SAN Administration on NetApp filers DATA ONTAP Data Management: Performed NAS backup Operations using NDMP procedures between backup-and-restore facilities in Network Appliance filers and other network attached servers. In its third revision, NDMP is clearly the leading open data management protocol in the current technologies. Data protection and Availability SNAPSHOT: Configured, Maintained, Scheduled Snapshots of Oradata volumes. Snapshots can serve as daily backups from which users can recover their own files. SNAPRESTORE: Restored and Recovered Databases using Snaprestore Technology. Snapshots can serve as daily backups from which users can recover their own files. Configure and maintain the hosts in SAN environment. Maintaining and supporting issues related to Filers, Aggregates and Volumes. Maintaining Sanpshots. Restoring and recovering of databases using snapshot and snaprestore. Performing Hotbackup/coldbackup of oracle instances for Oradata volumes using Snapmanager/Snapdrive Technologies. Setting up of replication environment using SNAPMIRROR technology of DATAONTAP Database Administration Maintaining around 50 Oracle 8i, over 150 Oracle 9i and 40 10g Instances along with 36 SQL Server 2000/2005 instances in netapp environment. Actively involved in all phases of Tuning from the Designing (Including the Methodology of documenting the system and Identifying the bottlenecks and trouble shooting at various elements of the system) (Logical/Physical) to reactive tuning. Strong abilities to design the database and estimating the size various objects considering future development and growth Decent work Experience in PL/SQL development. Proficiency in installing Oracle software using Oracle installer and OUI on Standalone / Client Server / NAS / SAN environment. Installed Oracle remotely over san environment. Recent Experience in Utilizing Oracle Enterprise Manager 10g as the main tool to monitor databases and Application services. Installation and configuration of Oracle HTTP sever with Oracle Application Express Fine tune Transaction intensive servers i.e. OLTP situations (I/O bottlenecks, SGA, Pinning objects, Sort space, literal sql, Redo logs). Confident about using Explain plan, TKprof and identifying the Execution plan and tune queries, using Indexes, hints etc. Experience in using ESTAT/BSTAT and more recently with STATSPACK as the main tool to tune in Oracle environment also with SQL Server Profiler, SQL Query Analyzer in SQL Server Environment. Extensive use of Export and Import Utilities along with sqlldr. Database Testing Note: Gained very valuable Experience at this project because of my long association with this project i.e. almost 25+ months which gave me an opportunity to present and work with entire lifecycle of the project development. Experience in Test Scenario, Test Plan preparation, determining the Estimation and Scheduling of project. Evaluation of freeware and licensed Automation tools and recommending suitable tool for Database/Application testing. Also involved in designing the test harness system for automated script execution. Developing Automated scripts for database testing using tools like Winrunner and AutoIT. Hands on experience in improving process and productivity. Experience in SRS analysis and Reviewing. Test Case preparation and Execution (Manual / Automated). Test procedures, Test Scripts and expected results. Report and track Bugs and Maintaining Defect Database. Having Good knowledge of Software Development Life Cycle (SDLC) Having knowledge of CMM, CMMI, ISO and Six Sigma methodologies. Database Testing with emphasis on Schema/Metadata and Data Validation. Developed tests scenarios to properly load / stress the system in a lab environment and monitor / debug performance and stability problems. Installation and configuration of third party Plug-ins / Products that needs to be integrated with DataMart for Extracting data into the DataMart database used forEnterprise Reporting (Products integrated are Aspect Unison, Aspect Quality Management) Configuring the Testing Environments as well as Deploying Builds for different releases. Optimization of SQL statements. Index optimization study and implementation for performance enhancement in reporting. Measuring database physical server requirements and tuning for optimum performance using system counters. Creating/Dropping of Oracle/SQL Server Instances, Refreshing of Environments. Understanding of various data models. Involved in batch efficiency process, process improvement and enhancements. Experience in Evaluating Hardware and Software Requirements and Making recommendations. Worked on ASPECT Ensemble Pro, Unified Command Control, Unison, Call center, Aspect Datamart, running on SYBASE, SQL SERVER and ORACLE databases. Product / Database Support Used fishbone analysis to effectively and efficiently identify root cause of key events, which affects performance of databases. Handle technical or process related escalation routed by the FLAs (Front Line Agents). Accountable for customer satisfaction by providing technical and process solutions by taking control and ownership of the issue. Investigate and resolve escalated issues, which include communicating directly with the customer and or with third party vendors. Worked on assignments that are complex in nature where independent action and a high degree of initiative are required to resolve problems and develop recommendations. Acted independently to determine methods and procedures in work assignments in consultation with TCO (Total Customer Ownership) group. Installations / Configuration (Enterprise). Installed and configured Siebel eBusiness Server 7.X.8 Installed and configured Captaris RightFax Installed, Configured and Maintained databases Oracle 9i on Windows/Linux, Oracle 10g on Windows / Solaris. Installed, Configured and Maintained SQL Server 2005 on Windows 2003 R2. Installed, configured and maintained development database (DataMart) Oracle 10g on Solaris V240 (Sun fire) server. Setup of development labs which includes optimum resource planning, Individually responsible for Installation of ORACLE software on SUN SOLARIS/LINUX and creation of several instances and creating databases and setting up of replication environment with snapshots and snapshot logs. Configuring parameter files and SGA (System Global Area) to suit the replication environment. Expertise: Call Center / Telecom Understanding of basic telephony concepts and architectures (E1/T1, routing, companding, protocols etc). Worked from agent level to managing technical teams (CTAS- Computer Telephony Application Support) -providing telecom technology solution to both internal and external customers. Database/Storage- Installation and configuration of various RDBMS on different platforms for the enterprise. Understanding of database sizing and resource utilization. Technical Interests: Databases / Storage / Telecom Performance tuning of Oracle Databases using Stats pack, Oracle-Real Application Clusters, and Cost based Optimizer. SAN topologies, protocols, Fiber Channel Basics and products required to implement and manage efficient SANs. ATM-based Networking, which satisfies two of the most granular requirements, higher bandwidth, and Quality of Service (QoS). Awards / Achievements MAX achiever for bes

Previous :

Information Technologies

Mysore

Worked from 1996 to 2000

Brief summary :

Organized, Conducted and given seminars on Information Technologies / Techniques for Computer Society of India Mysore Chapter in promoting open source. Education July 96 - July 00 Bachelor of Engineering (BE), Computer Science and Engineering, Grade:

 
 
Featured Career Adviser
Leading Recruitment Firm
  • Create a confidential Career Profile and Resume/C.V. online
  • Get advice for planning their career and for marketing of experience and skills
  • Maximize awareness of and access to the best career opportunities
 
 
 
sandeep's communities
22054 members, 610 jobs, 812 articles, 391 questions, 592 debates, 256 idea contests.
386 members, 73 jobs, 126 articles, 45 questions, 90 debates, 23 idea contests.
585 members, 225 jobs, 98 articles, 8 questions, 4 debates, 4 idea contests.
sandeep's contributions
Looks like they really do not respond to anything
I would not suggest you to do RHCE yet. Its better you get some experience with Database administration which is a ocean by itself. after saying that i would say that having the knowledge of operating system does help a lot while working with...
Technologically speaking a solution comprising of NETAPP (storage) and oracle can be implemented within a week; i implement,maintain optimize databases on NETAPP storage. its my bread and butter ;)
At the end of the day i would support database virtualization and i believe that it can be achieved. break up the debate question to that it can responded efficiently
 
Related Topics
  Remote DBA Support and Remote DBA Services We have been providing Remote...
1 trends , 1 question