© 2002-2008 IT-Careernet.com Reproduction, retrieval, copying or transmission of the content of this site is not permitted without the publisher's prior consent. Last changed: 18 Nov 2008 Home SiteMap Terms & Privacy
-start of code- -end of code- &n
|
Professional Profiles |
IT-CAREERNET
.
|
From: Dominic Vivek SHANTHA KUMAR
Date: Thursday, January 31, 2008
Time: 08:21 AM
Dominic Vivek SHANTHA KUMAR Email - dominicvivek06@gmail.com Phone – (407)-967-7085 Summary ======= A professional Oracle DBA and MS SQL Server DBA with 8 years of experience in the Information Technology industry focusing on Database and Systems Administration in a 24x7 Production, Development and Test Environment. Extensive experience in conducting requirement analysis, design, development & implementation of Oracle and SQL Server Database systems. * Administered Oracle 9i, Oracle 10g, MS SQL Server 2000 / 2005 Databases of various sizes (700GB – 900GB) on UNIX and Windows based environment (Sun Solaris 9.0, AIX 5L, Red Hat Linux ES 3.0, HP-UX, Windows-NT, Windows 2000 and Windows 2003). * Migrated / upgraded database from Oracle Version 9i to 10g and SQL Server 6.5 to SQL Server 2000 and 2005. * Experienced in Designing, Implementing, Installing and Maintaining High Availability (Oracle Data Guard and MS SQL Database Mirroring) and Database Clusters (Oracle - Real Application Clusters and MS SQL Clustering) of Oracle and MS SQL Server Database. * Managing Database Structures, Capacity Planning, Space Management and Data Extraction of Oracle and SQL Server database. * Develop, document and enforce applications database standards, procedures and data security. * Planning Backup and Recovery Strategy for 24x7 operation supports that include skills in using RMAN, Customized Scripts, Legato Backup, Veritas Net Backup (Oracle Agent). * Work with extended Infrastructure team to plan and co-ordinate application and database changes, installations of upgrades, patches and resolve any cross function issues. * Evaluate, propose and implement new technologies to further System Productivity and Quality. * Propose and develop strategic improvements in all technical area of System Implementation, Support and enhancement. * A Competent, hard working, quick learner and result driven IT professional possessing excellent problem solving & interpersonal communication skills. Qualification ============== B. E. (Computer Science Engineering), University of Madras, India. Certification ============== * Oracle Certified Professional 9i and 10g. * Microsoft Certified Systems Administrator (MCSA). a. 070 - 228 - Installing, Configuring, and Administering Microsoft SQL Server 2000. b. 070 - 229 - Designing and Implementing Databases with Microsoft SQL Server 2000. Skills ======= Tools and Software: DBA Studio, Case Studio, Erwin, SQL Loader, Import / Export, Data Pump Import / Export, TOAD, UNIX Shell Scripting and DBArtisan. Operating Systems: MS DOS, Windows 2000/2003 Server, SCO UNIX, Red Hat Linux 9.0, Red Hat Enterprise Linux ES 3.0, AIX and Solaris 9.0 and 10. Hardware: Sun SPARC V890, Sun SPARC 490, Sun SPARC 1280, Dell PowerEdge 6950 and 6850 and HP ProLiant ML100 Servers. Professional Experience ======================== Senior Oracle Database Administrator (Application & Production DBA), -------------------------------------------------------------------- Safeguard Properties, Inc., Cleveland, OH ----------------------------------------- August 2007 - Dec 2007 ------------------------ Safeguard Properties, Inc. is the largest privately held field services company in the country. Located in Cleveland, Ohio. Safeguard has grown from a regional preservation company with a few employees and a handful of contractors performing services in the Midwest, to a national company providing services in 50 states, the Virgin Islands, and Puerto Rico. Safeguard is supported by a nationwide network of subcontractors able to perform any requested superintendence, preservation, and maintenance functions anywhere in the country. Safeguard is proud to provide services to over 100 clients nationwide. Our clients range from local loan servicing companies to national publicly held Mortgage Servicing Corporations. Responsibilities ----------------- * Installation, Configuration, Implementation and Administration of Oracle 10g R2 on Sun Solaris Servers, and MS SQL Server 2000 / 2005 on Windows 2003 Servers. * Reviewing and applying latest Patches for Oracle 10g R2 and Service Packs for MS SQL Server. * Reviewing and applying latest Security Patches for Microsoft Windows 2003 Server. * Designing and Implementation of RMAN, and integrating it with Veritas Net Backup. * Installation of Oracle and MS SQL 2000 Clients on Desktop PCs. * Upgrading Database from Oracle 9i to Oracle 10g and MS SQL Server 2000 to MS SQL Server 2005. * Migrating Oracle 10g database across Sun Solaris to Microsoft Server. * Generating Tablespace usage on a daily basis and notifying other DBA’s about the thresholds through emails or pagers. * Implementing MS SQL Server 2005 Replication. * Performing Export Data Pump and Import Data Pump for data refresh between the Production, QA, Test and Development Server. * Scheduling, Extracting and Loading Production Data to Data warehouse Servers for generating Reports. * Creating DTS Packages for data refresh from Oracle to MS SQL Server. * Using Change Control Custom software to update any changes to the Database. * Generating Custom Build Scripts using UNIX Shell Scripts for deploying the Application at the Customer site. * Generating AWR report, and enhancing the Oracle Database. * Scheduling Database backups using RMAN. * Raising Tickets in Oracle Metalink to resolve Oracle Related Issues. * Work closely with the Development Team and helping them in resolving Database related issues, like granting privileges, creating user, creating sequence, compiling invalid objects, restoring old-backup and running sql scripts in the Production. * Work along with a Team of Oracle DBA’s and System Administrators to resolve issues. Environment ------------ Languages - ASP .Net Databases - Oracle 10g, MS SQL Server 2000 and MS SQL Server 2005. Tools - SQL PLUS, PL/SQL Developer, Cognos, TOAD and Case Studio. O/s - Solaris 9.0 and Windows 2003 Server. Hardware - Sun 1280, Sun 480 and Sun 890. Senior Oracle Database Administrator (Application & Production DBA), -------------------------------------------------------------------- MEDai, Orlando, FL. -------------------- April 2007 – July 2007 ----------------------- MEDai, Inc. is a leading information healthcare technology company applying award winning predictive modeling techniques to advancing healthcare delivery. Providers and health plans use MEDai's solutions to improve outcomes by channeling high-risk patients into health management programs, rewarding high-quality efficient providers, and setting competitive premiums. One of their applications - Risk Navigator Clinical application applies evidence-based clinical rule sets and advanced mathematical process to claims, membership and other data (lab, health risk assessment, etc) to identify high-risk members and rank them by need. Use these clinically based forecasts to allocate resources efficiently and intervene before adverse outcome occur and dollars are spent. Results are presented in an easy-to-use web interface. A few mouse clicks generates a list of members with diabetes and a profile of Impact Opportunities - areas that provide the greatest potential for intervention and management. Standard reports present clinically relevant data about expected inpatient, pharmacy, and ER use, along with total expense projections. Responsibilities ----------------- * Installation, Configuration, Implementation and Administration of Oracle 10g R2 (Real Application Cluster) running on 4-Node Cluster. * Installation of Sun Solaris OS, Windows 2003 Server and SuSE Enterprise Linux 10. * Installation of Oracle 10g R2 on Sun Solaris OS and Windows 2003 Server. * Reviewing and applying latest Patches for Oracle 10g R2. * Reviewing and applying latest Security Patches for Microsoft Windows 2003 Server. * Installation of Oracle HTML DB for Web based Reporting. * Installation of Oracle Clients on Windows XP Professional, and updating TNSNAMES entries. * Upgrading Database from Oracle 9i to Oracle 10g. * Migrating Oracle 10g database across Sun Solaris to Microsoft Server. * Installing Nagios with Mobile and Email alerts for Oracle Database related messages. * Generating Tablespace usage on a daily basis and notifying other DBA’s about the thresholds through emails. * Performing Export Data Pump and Import Data Pump for data refresh between the Production, QA, Test and Development Server. * Scheduling, Extracting and Loading Production Data to Data warehouse Servers for generating Reports. * Using Change Control Custom software to update any changes to the Database. * Generating Custom Build Scripts using UNIX Shell Scripts for deploying the Application at the Customer site. * Generating STATSPACK report, and enhancing the Oracle Database. * Scheduling Database backups using RMAN. * Raising Tickets in Oracle Metalink to resolve Oracle Related Issues. * Work closely with the Development Team and helping them in resolving Database related issues, like granting privileges, creating user, creating sequence, compiling invalid objects, restoring old-backup and running sql scripts in the Production. * Work along with a Team of Oracle DBA’s and System Administrators to resolve issues. Environment ----------- Languages - ASP .Net Databases - Oracle 10g (4-Node RAC) Tools - SQL PLUS, PL/SQL Developer, Cognos, TOAD and Case Studio. O/s - Solaris 9.0, SuSE Linux and Windows 2003 Server. Hardware - Sun E3500, Dell PowerEdge 6950, DS4000 and PowerVault. Senior Oracle Database Administrator (Application & Production DBA), -------------------------------------------------------------------- Satyam Computers Services Ltd. ------------------------------ March 2006 – April 2007 ----------------------- General Motors - GMBuyPower.Com- GM Vehicle Showroom, USA. ---------------------------------------------------------- General Motors Corp., the world's largest vehicle manufacturer, employs about 284,000 peoples globally, more than half of them in the United States. GM today has manufacturing operations in 33 countries and its vehicles are sold in 200 countries. GMBuyPower.com - GM Vehicle Showroom is an Internet based Application gives information about Service, Information and Tools to find and purchase the exact vehicle the user wants. Service - gives Customized service from a GM Certified Internet Manager at a dealership near the user, Information - gives Comprehensive vehicle information, and searchable dealer inventory which is updated every 24 hours and Tools - GMAC Financing estimates payments and apply for credit online. Responsibilities * Installation, Configuration, Implementation and Administration of High Availability of Production Systems running on 2-Node RAC Cluster. * Setting up of Oracle Warehouse Builder system on AIX 5L (RAC – 3 – Node Cluster) Environment. * Coordinating with Data Warehouse Team for ETL Process. * Creating Materialized Views for Data Warehouse. * Loading flat files into Oracle Database using SQL*Loader. * Performed Database Monitoring, Capacity Planning and Tuning with UNIX Shell Scripts. * Managing allocated disk space usage, house-keeping and memory allocation for Oracle Database Management Systems. * Managing User Schema like adding, modifying, granting access, revoking access, and deleting of Users. * Administrating Oracle Server Security. * Installing and maintaining Oracle Server Database products, including Patch Application and Upgrade of the environments. * Troubleshoot and develop solutions for problems related to Oracle Database and Interfaces. * Co-ordinate with Oracle Technical Support by raising SR in the metalink.oracle.com. * Develop and execute back-up and recovery procedures using RMAN and perform periodic testing of the database of the database backup and recovery plan. * Work closely with Application Team, System Administration Team and Vendors to co-ordinate activities; resolve Application errors and Production Issues. * Co-ordinate and implement changes to development, test and production environments. * Provide 24 X 7 on-call troubleshooting and problem resolution. * Implement and maintain multiple database environments, including logical/physical design and data modeling. * Providing day-to-day support to development team and testing team to resolve various issues regarding the database. * Automated DBA Tasks using cron jobs in Linux to automatically check for any errors in alert logs and mail the errors. * Monitored Tablespace of important database using custom written Shell Scripts. * Resolved database issues using internal ticketing system. * Supported Database Design, development, bug fixes and DBA Support for Testing and Development Teams. * Provide leadership and mentoring in database design, development and design skills. Environment ----------- Languages Java and J2EE. Databases Oracle 10g (2-Node RAC) and MS SQL Server 2000. Tools SQL PLUS, SQL*Loader, Oracle Warehouse Builder and Case Studio. O/s AIX 5L. Oracle Database Administrator (Application & Production DBA), ------------------------------------------------------------- INFONOVUM Technologies Pvt. Ltd, USA. ------------------------------------- April 2005 – Mar 2006 --------------------- Executive Wealth Management Systems (EWMS), is an online stock management application. It is a global financial services company specializing in the administration of non-qualified deferred compensation plans for the executives of the world’s largest financial institutions. EWM needed a highly available, highly complex and secure Internet application to manage its clients' deferred compensation plans. To provide a complete solution to its clients, EWM’s challenge was to develop an application that allowed plan participants to manage their deferred compensation portfolios via the Internet, while maintaining complete data security and integrity. Responsibilities ---------------- * Installation of Oracle 9i and Oracle 10g on AIX 5L (2-Node Cluster). * Done Application Database cloning through Custom UNIX Scripts, and cloning the environment to Testing Database Servers for Testing Purpose. * Installed and Configure Oracle 9i instance on Sun Solaris Server. * Generated backup recovery procedure/scripts (Hot Backup) for the Production Database through Oracle Log Archiving and Legato Single Version. Performed database recovery more than 20 times. * Setting up of Oracle Warehouse Builder system on LINUX Environment. * Coordinating with Data Warehouse Team for ETL Process. * Creating Materialized Views for Data Warehouse. * Loading flat files into Oracle Database using SQL*Loader. * Performed Database Administration activities like Table, Tablespace, Datafile sizing and reorganization, Index rebuild, data loading, Analyzing Objects, Object Space Management, Data Modeling, Managing Rollback Segments using OEM, Quest – Toad and Case Studio. * Created Custom Build Shell Script for building new database on a new Sun Solaris Server. * Installation of layered products like Oracle Enterprise Manager, Developer 2000, Forms, Reports as Client/Server Applications. * Running custom scripts for auditing the User level access to the database. * Installation of Oracle Server and Oracle Client as and when requirements. * Checking of SQL Errors during the testing of Production Rollouts, and informing about the error to the developer. * Helping the developer in creating, granting and deleting functions, procedures, and triggers. * Taking STATSPACK report and making the necessary changes to Development, Testing, QA and Production Systems. * Providing 24 hours 7 days support for very large, high transaction and highly available production databases. * Providing day-to-day support to development team by cloning production database for testing and UAT * Managed System Security and controlled user access using Roles and Privileges. * Identifying and De-fragmenting the databases. * Installation of Oracle Clients and ensure SQL*Net connectivity from clients to Oracle Server over TCP/IP. * Resolved database space size by sizing Tablespaces, datafiles, and logfiles in Oracle. * Created methodology, SQL Scripts and Shell Scripts to load the Development Database in the Testing Environment for testing purpose. * Act as project liaison and coordinate with UNIX system administrators for application of OS patches and maintenance required for database servers. Environment ----------- Languages Java, JSP and J2EE Databases Oracle 9i and Oracle 10g (2-Node RAC) Tools SQL PLUS, SQL*Loader, Oracle Warehouse Builder, PL/SQL Developer and TOAD. O/s Red Hat Linux AS 3.0, AIX 5L and Solaris 9.0. Oracle Database Administrator (Production DBA), ----------------------------------------------- Signet Systems Pvt. Ltd. ------------------------ Jan 2000 – April 2005 ---------------------- HRMS, Human Resource Management Systems, is an application, developed using Oracle Forms as a Front-end and Oracle Database 9i as a back-end for Women Christian College. The main aim of the project is a Human Management System for both teachers and students. The modules in the Project were Recruitment, Employee details maintenance, Attendance management, Allocations, transfers and deputation management, Performance-appraisal management and Leave-details management. Responsibilities ---------------- * Responsible for installation of Windows 2000 Server (Production), Red Hat Linux 9.0 (Production) and Windows XP Professional (Client) machines. * Implementation of Windows Active Directory. * Implementation of Norton Security Center and scanning for ports communicating to the external world. * Designing the Security and Implementing the Group Policy throughout the network. * Installation of Cisco Switches and Implementing VLAN across the College Campus. * Responsible for Design, Installation and Implementation of Oracle Database (9i) on Linux 9 Server and SQL Server 2000 on Windows 2000 Server. * Installation of various software like Developer 2000, Visual Basic .Net, Forms, Reports, ASP .Net as Client/Server Applications. * Provide primary DBA support for establishing, upgrading and maintaining the RDBMS software environments. (Oracle and SQL Server) * Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations. * In conjunction with the security administrator, establish and manage user access, and design and implement user environments. * Create, maintain and refresh required Oracle instances/databases for development, test and production environments. * Monitor error log(s), database and log space, user activity and resource utilization of production environment. * Work with application programmers to insure that application problems do not adversely affect production operations. * Monitor system resources of database servers to assure production systems meet availability requirements and hardware enhancements are scheduled in a timely fashion. * Install, upgrade and maintain Oracle software products/versions for DBMS, server software and various tools software as appropriate for the project. * Monitor disk usage; plan acquisition and replacement of disk devices as needed. * Act as project liaison and coordinate with UNIX system administrators for application of OS patches and maintenance required for database servers. Environment ----------- Languages Visual Basic, PL/SQL, ASP. Net. Databases Oracle 9i and SQL Server 2000. Tools SQL PLUS, PL/SQL Developer and TOAD O/s Windows 2000 Professional (Development), Windows 2000 Server (Oracle 9i Servers) and Red Hat Linux 9.0.
|
|
|||
|
|
|||
|
© 2002-2008 IT-Careernet.com Reproduction, retrieval, copying or transmission of the content of this site is not permitted without the publisher's prior consent. Last changed: 18 Nov 2008 Home SiteMap Terms & Privacy |
|||
|
-start of code- -end of code- &n |
|
||