Resume Text:
|
Professional Summary
Over eleven plus years of professional experience including around 10 years of experience in Database Administration Worked as DBA for Oracle 8i, 9i, 10g, 11g databases with additional skills in Sybase, Informix and SQL/MP (Tandem) databases. Good experience in very large and heavy volume online transactional databases and analytical processing databases (data warehousing) with proficiency in Oracle RAC with ASM, Oracle Streams, various UNIX flavors , database Upgrades, configurations, Performance Tuning, database Export/Import, data pump, User Administration, Oracle Database Administration, System Administration, Backup/Recovery, Disaster Recovery, and Oracle Enterprise Manager maintenance. Strong team player & possesses quality leadership skills. Vast hands-on experience on database administration in different RDBMS systems, requirements gathering, analysis design, programming, all forms of testing, change control, database design/administration, production support. Excellent analytical, organization skills, time management and prioritization skills bring added value to any IT management.
Education
Bachelor of Engineering, B.E. (Electronics)
Certifications
PMI-001 PROJECT MANAGEMENT PROFESSIONAL CERTIFICATION (PMP)
Oracle 11g DBA OCP
Oracle 9i DBA OCP
Technical Skills
OPERATING SYSTEMS Sun Solaris, IBM AIX, HP-UX, Red Hat Linux, Windows NT/2000
LANGUAGES C, FORTRAN, SQL, PL/SQL
DATABASES Oracle, INFORMIX, Sybase, SQL/MP (Tandem)
GUI HP-Open View, HPSM, Erwin, TOAD/SQL Developer, DBArtisan,
SCHEDULER TOOLS AUTOSYS, OEM
WEB RELATED Oracle Enterprise Manager, HTML DB (Oracle Apex)
TOOLS & UTILITIES OEM, Oracle Streams, Data Guard, RMAN, Data pump, export import
DOMAIN KNOWLEDGE Banking, Finance, Insurance, Telecom, Roadside Services, Health Care
Trainings
SN# Title Organized by
1 PMP training Satyam Computer Services Ltd.
2 Oracle 10g new features Satyam Computer Services Ltd.
3 Oracle 9i DBA Training SQL Star International Ltd.
4 Oracle 8i Developer training SSI Ltd.
Projects Profile
Project Name: GEHC Global Database Administration Operations Support
Client: GE Healthcare
Location: Milwaukee, WI
Role: Sr. Database Administrator
Duration: Mar’ 2011 to till date
Environment: Oracle 8i, 9i, 10g, 11g, Informix, Sybase, BO, SAS, Toad, Sun Solaris
Databases: Oracle RDBMS – version (v.) 8-11g Microsoft SQL Server – v. 7.0, 2000, 2005, 2008 Teradata – v. 12.x MySQL – v. 5.1.x
Tools: Oracle Cluster Services – v. 10.x, 11.x Oracle RAC – v. 10.x, 11.x Oracle Enterprise Manager – v. 10.2.x Idera SQL Diagnostic Manager – v. 6.x Teradata Manager & Utilities – v. 12.x
Operating Systems: Solaris – v. 8.x-10.x RedHat Linux – v. 4.x HP-UX – v. 11.x Oracle Enterprise Linux - v. 5.x (OEL 5) Microsoft Windows – v. 2000, 2003, 2005,2008
Applications: Applications Oracle Applications (ERP) – v. 11.x, 12.x, SAP (ERP) – v. 6.x , Siebel (ERP) – v. 7.8, 8.x , PeopleSoft (ERP) – v. 8.x, 9.x ,Oracle Internet Directory – v. 10.x
Project Description
GEHC is a member of the General Electric group of companies. GEHC provides transformational medical technologies and services that are shaping a new age of patient care. GEHC expertise is in medical imaging and information technologies, medical diagnostics, patient monitoring systems, performance improvement, drug discovery, and biopharmaceutical manufacturing technologies to help clinicians around the world reimagine new ways to predict, diagnose, inform and treat disease, so that the patients can live their lives to the fullest.
GEHC's broad range of products and services enable healthcare providers to better diagnose and treat cancer, heart disease, neurological diseases, and other conditions earlier. GEHC vision for the future is to enable a new "early health" model of care focused on earlier diagnosis, pre-symptomatic disease detection and disease prevention. The business interests of the company are widely dispersed with clients across the globe. This makes it necessary for the company to maintain Information Systems, which provide reliable service to its clients with optimal response time and efficiency The Global Database Administration Team is part of the overall Global Data Management Team. It provides:
Database (DB) architecture, design, development, and build for new projects
Proactive DB monitoring, backup/recovery, capacity planning, performance tuning, lifecycle management
Complex DB troubleshooting and production support
Management of quality, compliance, and software licensing / maintenance
Technology innovation
Overall “data care”
Contribution
I have been actively involved from RFP stage of GEHC Global DBA Operations Support Project from questionnaire response, Due Diligence, Knowledge Transfer & then project execution phase. MSAT has been awarded GEHC Global DBA Operations Support in March, 2011. Before this period the project was being managed for almost 10 years by another vendor. A major contributor ensuring projects success & delivering high on customer expectations & MSAT promises. Within span of six months, I have been appreciated several times from customer front for technical & deliverable capabilities on high demanding, critical new projects & operational support for running databases on day to day basis which involves 1000+ Oracle databases. My roles and responsibilities involve below given tasks …
• Creation of databases based on the capacity requirements and standards.
• Installation and configuration of database/application binaries and High Availability software components (Cluster).
• Define and create the physical database design (e.g. data files, log files, undo segments, tablespaces etc.)
• Create definitions of logical data structures, tables, views, indexes, and program specification blocks (e.g., Database procedures, packages, functions etc.,) and define their relationships
• Create the data definition statements needed to create logical structures
• Estimating storage requirements (in consultation with application team) and provision the databases per needs
• Create all documentation required for the various stages of the project (e.g. Database design, build documents etc.)
• Follow all applicable quality procedures during the build and testing of database infrastructure environments and software installation specifications when creating /installing databases
• Review the security requirements and configure the database for the security needs.
• Maintenance of Databases e.g., recycling databases and application technology stack components, reorganizing data objects, patching, periodic password changes, reorganizing file system, database migration across servers etc.,
• Setup/configure database monitors. Monitor the health and performance of databases and take timely actions to resolve the incidents/alerts reported by the monitors.
• Develop and implement custom administrative/reporting scripts
• Disk space cleansing/archival by removing/moving unwanted/expired files that are no more required
• Design, Implement and execute system, database and application backup and recovery as per schedules/requests. Setup/configure monitors for backup success/failure. Perform root cause analysis on backup/recovery incidents to increase reliability of the backups.
• Perform restoration/recovery of database/applications (e.g., Time based, transactional recovery etc.)
• Setting up and implementing database reorganizations as per schedules/requests in collaboration with application teams whenever required
• Recommend/implement standards for databases
• Constructively collaborate with Application/Infrastructure/functional/Problem Management teams e.g., to fix the availability/performance incidents, to identify the root cause for problems involving multiple layers (application, database – Oracle, MSSQL, Teradata, and MySQL), infrastructure etc.)
• Perform investigation and diagnosis on performance incidents. Identify, recommend and implement fix for the performance incidents and problems through tuning measures (e.g., database parameters, memory structures, queries etc.).
• Perform impact analysis for the database changes/patches/upgrades and also for the infrastructure/application changes that could impact the database layer
• Publish the Forward Calendar of Changes and Maintenance windows to all the stakeholders
• Testing and implementation of patches (e.g., security, application patches etc.,) and upgrades of databases in consultation with application DBA
• Perform data collection on the database capacity (CPU, Memory, Storage etc.,) and report out capacity forecast and requirements
• Perform High Availability (e.g. Real Application Cluster) configuration, administration and management of databases in High available infrastructure
• Perform Cloning of databases/applications as per requests/schedules. Assist in migrating/refreshing data/schemas in collaboration with other support teams
• Adherence to the Qualification/Validation processes. Create all documentary evidences/documents required for Qualification/validation/SOX purposes.
• Participate in BI Project reviews and migrations
• Participate in build (e.g., installation, configuration, database creation etc.,), test (e.g., fix database defects, monitor during load tests, fix performance defects reported during load tests etc.,) and go-live activities (e.g., database/application patching etc.,) of releases across different application/database
• Update and retain the Configuration Management Database (CMDB) with accurate information to ensure information reliability at 100%
• Create and update the Knowledge database to enable reference to incident and problem management processes resulting in fast resolution/provision of services
• Engage the production vendors (Oracle, & application vendors through application teams) through the formal Vendor Service Request mechanism/process to seek support in Incident/Problem management
• Drive continual improvement initiatives achieving Operational Excellence by improving effectiveness and efficiency of processes, reducing defects/incidents/problems, improving service lifecycle, productivity gains etc.,
Project Name: Allstate Roadside Service PMG Applications Support
Client: Allstate Insurance
Location: South Barrington, IL
Role: Sr. Database Administrator
Duration: Jan’ 2009 to Jan’ 2011
Environment: Oracle 8i, 9i, 10g, 11g, Informix, Sybase, BO, SAS, Toad, Sun Solaris
Database: Oracle 8i, 9i, 10g, 11g/ Informix/Sybase
Tools: BO, TOAD
O/s: Sun Solaris
Hardware: SUN 15K, SUN 25K
Project Description
The Project Allstate Roadside Service PMG Applications Support involves integration of data between the different business applications. The integration solution involving MMA/ CTI / Map Quest / Sigma Dynamics / Web Claims, Web services, Infrastructure Management services, Mainframe (CMS, LCAP, Finance & Systems Operations), Data Transmissions, Customer Contact Apps, Portal Applications, Financial Systems (Java, VB & MF), Informatics, Web & Oracle Administration, Quality Assurance, Business Intelligence and Mobile Applications , thus providing a reliable support. This allows the users in various locations of Allstate Roadside Service across US to access required information from various applications using different databases.
Contribution
• Acquired Data Centre migration experience from initiation stage to closure stage by active participation at each & every stage
• Migrated 70+ Oracle databases to totally different hardware in GE & then upgraded all Oracle 9i databases to release 10.2.0.4 with out any issues
• Successfully migrated & consolidated 40+ Non RAC development databases to 6 RAC (2 nodes) databases with ASM from GE owned servers to Allstate servers
• Successfully migrated & consolidated 30+ Non RAC production databases to 6 RAC (2 nodes) databases with ASM from GE owned servers to Allstate servers
• Ensured that the best possible approach was followed for each database migration to minimize downtime
• Oracle 10g databases smaller in size were successfully migrated by using the best option of Oracle, data pump utility
• Production database of 400+ GB in size was taking approx 8 hours for migration, used the best possible approach Oracle Streams & the whole migration effort on the cut off date just took only 15 minutes by streams set up
• Implemented online migration strategy for 3 Oracle 8i instances & the approach took less than 30 minutes down time which was initially estimated around 12 hours for each database migration.
• All migration scripts were tested several times with all possible best options to overcome any issues at last moment
• Ensured that databases copy was available in to be new environment much ahead of scheduled migration date so that application teams were able to test their application functionality thoroughly, against the to be new environment
• Ensured that databases backups, restore, alerting & performance issues were duly taken care before the migration
• Active participation provided greater level of proficiency & immediate issues resolution for mission critical applications
• All & above the best point to mark is not a single migration (60+ databases hosting 100+ applications) had any issues because of databases. All the times, database migration was done very smoothly, well ahead of the scheduled window assigned for databases.
• All cron jobs successfully migrated to new environment to run through Tivoli scheduler
• AARP web deployment successfully launched in production with out any issues
• Old databases decommissioned successfully
• All databases migrated in new environment successfully registered through LDAP & now the LDAP (OID) is being used in the environment
• Guided Allstate team to administer AUTOSYS by helping them in installation & configuration of master server & client for AUTOSYS release 11.2 & then by explaining them the basic commands & their usages
• Acquired Informix & Sybase databases administration support along with Oracle database administration support primarily
• Learnt & implemented practically Oracle Streams, Data Guard, ASM, LDAP (OID) and many more new features of 10g
• Installation & configuration of master server & client for AUTOSYS release 11.2
• Database performance tuning using OEM, AWR reports & ADDM advisories
• Reviewing on backup strategies (logical/physical) for databases depending upon size, database availability & resources
• Validating RMAN backups regularly through RMAN commands without actual restoration
• Coordination with Oracle support through bridge calls, OWC for SRs for faster resolution of production issues
• To help business users to write the better code for faster query response time and lesser servers/databases resources utilization
Project Name: GE Money - Americas
Client: GE Money
Location: Shelton, CT – (02/2008) to (12/2008)
India -- ((02/2006) to (01/2008))
Role: Module Lead
Organization: Satyam Computer Services Limited, India
Environment (with skill versions): Software BO, SAS, Oracle
Database: Oracle 8i, 9i, 10g
Tools: BO, TOAD
O/s: Sun Solaris
Hardware: SUN 15K, SUN 25K
Project Description:
• GE Money is the largest Private Label Credit Provider in North America. GECF makes business critical decisions based on the data present in various data warehouse databases. Data is basically gathered from across the enterprise on daily, weekly and monthly basis from variety of media. Data Warehouse and Mart Infrastructure, 13 Functional Warehouses, 14 SAS Data Marts, around 40 TB size huge DWH in size are the major challenging databases which should be readily be available 100% of times for ETL & business user reports. GE Money OLTP systems support all applications linked to 24*7 online operations.
Contribution
• Have experience of GE Money Data Warehouse as OLTP environments:
• Installation of software, creating databases & upgrading as per requirement
• Applying patches/CPU patches to fix the bugs
• Provided support to RAC environment for OLTP (Midrange) environment.
• Actively lead the team for making databases PCI compliance.
• Installed HTTP server & HTML DB (Oracle Application Express)
• Query Optimization for better performance
• Database performance tuning using OEM, AWR reports & ADDM advisories
• Reviewing on backup strategies (logical/physical) for databases depending upon size, database availability & resources
• Managing archiving log destinations
• Supporting business users for reports & ETL Job Failure Resolution
• Analyzing/Rebuilding tables/indexes
• Ensuring security policy through column masking & Virtual Private Database (VPD) technology
• To Co-ordinate with onsite/off-shore team members
• ERT Involvement for Sev1 & Sev2 related issues
• Interacting with Clients regularly for time to time reviews related to databases implementations
• Ticket Management) ( Tickets are normally for the following issues : ETL Load failure, ETL Load long running issues, Performance Related Errors, Rollback Segment Error, Temporary Segment Error, User’s request for access/privilege to a table etc.)
• Databases cloning as & when required
• Backups (BCV/SNAP backups) validation before the backup is taken on tape
• Validating RMAN backups regularly through RMAN commands without actual restoration
• Performing recoveries as per scenarios (tables truncation/data file corruptions etc)
• Capacity planning & space management
• Automating various regular tasks to avoid manual interventions
Project Name: Webex Trading support
Client: Bombay Stock Exchange (BSE)–Mumbai
Role: DBA
Organization: Tata InfoTech Limited, India
Duration: (09/2005) – (01/2006)
Environment (with skill versions): Software SQL/MP
Database: Non Stop SQL/MP
Tools: Webex trading tool
O/s: Tandem
Hardware: Tandem Servers
Project Description
• Internet Trading System database (NON STOP SQL/MP) on TANDEM (HP NON STOP HIMALAYA SERIES SERVER).
• Tandem SQL/MP databases are the most preferred databases in stock exchanges & critical environments because of its robustness & real 24*7 guarantees in terms of hardware failure too.
Contribution
• Database administration (SQL/MP)
• Objects creation & ensuring necessary privileges
• Mock trading testing & ensuring its successfulness
• Daily backup activation & checking it through restoration occasionally
• Ensuring all necessary checklists are performed during BOD-EOD processes.
• Resolution of online errors during trading if occurring during trading
Project Name: Billing/Nonbilling Systems
Client: Hutchison Max Telecom Pvt. Ltd (Orange) –Mumbai.
Role: DBA
Organization: 3I InfoTech Ltd. (Formerly ICICI InfoTech Ltd.), India
Duration: (01/2005) – (09/2005)
Environment (with skill versions)
Tools: OMNI, TOAD, VERITAS
O/s: Compaq Tru64 UNIX V5.1A, SunOS 5.8/5.9, AIX Version 5, HP-Unix 11i Sun Solaris 6800, 4800, V880IBM Servers P690/P630, HP RP8420 & GS160/GS80
Hardware: VERITAS volume manager, Sun Solaris 6800, 4800, V880IBM Servers P690/P630, HP RP8420 & GS160/GS80
Project Description
• Worked as a Production DBA to one of the top most company in Telecom industry (Hutch-Orange), maintaining 17 production databases on EMC SAN database size varies from 300 GB to 3 TB, also worked on latest Sun Machines like 6800/4800/V880, HP RP 8420 & GS 160/ GS 80, IBM P690/P630 servers.
Contribution
Database: Oracle 8.1.7.3.0, Oracle 9.2.0.4.0
• Being a team member of DBA team, handled 12 Production Databases (24 X 7) my responsibilities include,
• Creation of Databases
• Installation and upgradation of Oracle Software on different OS
• Creation of new Data files and rollback segments in OLTP environment and assigning them to different processes
• Creation of different Database objects (Materialized view, Refreshing materialized views, Index Rebuilding etc.)
• Monitoring of Alert log files
• Tuning the production databases by altering system and session parameters for optimization of performance
• Granting and monitoring user access rights and privileges through roles and profiles.
• Daily Hot Backups (Physical and Logical) User-managed on disk and tapes (DLT, SDLT, DDS, LTO)
• SQL statement Tuning (TKPROF, Explain Plan)
• Performing Export – Import at user level & schema level.
• Performing Cloning of databases as and when required
• Restoration as per required scenario
• Performing Daily BCV backup for important databases
Project Name: Quotation System (AMC Contracts)
Client: Material Handling Division
Role: DBA
Organization: Macneill Engineering Ltd., India
Duration: (05/2003) – (12/2004)
Environment (with skill versions): Software Oracle 8, PL/SQL, Designer/2K
Database: Oracle 8.1.7.3.0
Tools: TOAD, VB
O/s: Sun Solaris
Hardware: Sun Servers
Project Description
This system was for Material Handling Equipments division. They give the client name, specifications regarding the vehicle number and details of machines (Mechanical, Instrumentation and Electrical equipment) that are used by the client. Based on this contract is made for AMC of the equipments.
Contribution
• Installation and configuration of the Oracle Servers
• Creation and maintenance of different database entity included managing tablespaces and organising data files on servers
• Performing back and guiding on back strategy to development team
• Creating indexes, rebuilding the indexes to improve the performance
• Managing Schema Objects - Tables, Views, Sequence, Synonym, Indexes
• Tuning databases involving Application Tuning (SQL optimization),
• Performing Export –Import, Using SQL–Loader to load data inside Oracle tables in the database
Project Name: Payment Management System
Client: Material Handling Division
Role: DBA
Organization: Macneill Engineering Ltd., India
Duration: (02/2001) – (04/2003)
Environment (with skill versions): Software: Oracle 8, PL/SQL, Designer/2K
Database: Oracle 8.1.7.3.0
Tools: TOAD, VB
O/s: Sun Solaris
Hardware: Sun Servers
Project Description
The system keeps track of the payment received by the organization from its various clients. It consists of purchase order entry, invoice entry, GRN entry, Payment detail entry etc. and generates various exception reports.
Contribution
• Database creation for development & production activities
• Regular monitoring of alert log files on day to day basis
• Creation and maintenance of different database entity included managing tablespaces and organising data files on servers
• Performing back and guiding on back strategy to development team
• Managing Schema Objects - Tables, Views, Sequence, Synonym, Indexes
• Tuning databases involving Application Tuning (SQL optimization), I/O balancing, Memory tuning and CPU utilization
• Performing Export –Import, Using SQL–Loader to load data inside Oracle tables in the database
|
|
Similar ResumesSenior Project Manager
FL
- hl7, cpoe, c2c, cerner, 5010, x12, ehr,...SAP Portal Lead Developer and Architect
Shreveport, LA
- webdynpro, homepage, dynpro, abap, hcm,...Sr Developer & Analyst
United States
- informatica, teradata, basel, ssis, ssrs, etl, ca7,...Project Manager / Business Analyst
Miami, FL
- wtx, cerner, websphere, operations research,...Oracle Financials Track Lead
United States
- software application, software application...Project Coordinator
Elkridge, MD
- lecturers, companion, aspnet, c cplusplus,...Sharepoint Server Management Sql New Jersey Information Technology
Stamford, CT
- web parts, cissp, vcp, infopath, active directory,...Developer
United States
- content management, vignette, drupal, data manager,...Regulatory Director
Libertyville, IL
- rac, pharma, regulatory affairs, dialysis,...Senior Developer
United States
- biztalk, silverlight, newyork, ssrs, ssis, jquery,... |
