Project Manager
Resume:
Search Resumes - Results
Job Description *: Database Systems Lead
Job Description 2: Database Systems Manager
Job Description 3: Lead DBA
Willing to Relocate?: No
Additional Info
Ramesh B. Ganta
(Permanent Resident)
50 Hampshire Drive, Plainsboro, NJ 08536
302-***-**** X3144(W); 609-***-****(H);
***************@*****.***
Objective
To seek a lead/senior oracle database administrator position, offer extensive hands-on experience in administering medium to very large databases (VLDB) on both production and development environment, designing and implementing OLTP(Online Transaction Processing) and data warehousing databases
EDUCATION
Bachelors in Electrical Engineering (Electronics), Indian Institute of Technology (I.I.T.), Madras.
SKILLS SUMMARY
? 12 years of experience as Oracle DBA with 6 years of experience in USA
? Proficient on both Transaction based database systems and Data warehousing systems.
? Worked in other countries ? Brunei, Barbados, Zimbabwe.
? Exposure to major industries ? Telecom, Financial/Brokerage, Information Services, Manufacturing, Retail, Government.
? Prior experience of working on applications migrating from mainframes to UNIX/RDBMS.
HARDWARE PLATFORMS
SUN Enterprise 10000&3000, HP 9000 K420, V2200; Sun Cluster V3&V2.2,Veritas Volume Manager, IBM RS6000 Models 590, 550 and 350; IBM HACMP,FujitsuICL J824s, K472s; NCR 3000 & 5100, EMC HA Clusters and Windows NT Server,Dell
OPERATING SYSTEMS
SUN Solaris 2.6/2.7/2.8, HP-UX 10.20,HP-UX 11.0, AIX3.2 and 4.2, AT&T SVR4.0 and SVR4.2, LINUX 6.2,Windows NT,.Linux
LANGUAGES
SQL/PLUS, PL/SQL, UNIX shell script
DATABASE and SOFTWARE TOOLS
Oracle 7.x&8.x&8.1.6(8I),9I,Oacle Parallel Server(OPS), Real Application Clusters(RAC), Oracle IAS (Web Servers), Oracle 11i Apps(Financial),Oracle Enterprise Manager, Oracle Forms, RMAN, Replication,, ERWIN, Modelmart, Power Designer, Autosys, Quest Toad, SqlLab,Sybase, Teradata, Ingres, Bteq, Fexp, Multiload, bcp, isql, ipm, abf, qbf, Sublime, ClearCase,SQLNavigatorPROFESSIONAL EXPERIENCE:
07/03PresentProject: Lead DBA for CSC,Wilmington,DE
Oracle 8I(8.1.7),9I(9.2.0),7.3.4,Sun E6500, Solaris 2.8, Windows NT, TOAD,
SQL,PLSQL,SHELL, SQLNavigator, Linux, SQLServer, Oracle Financials 11i, LDAP, Oracle Mail Server, PVCS
Databases: Development, QA, UAT, Production Databases
Application: Order Processing System, Knowledge Base, Litigation Management System
? Planned, drawn project plan and allocated work items to team members and coordinated with team to exevute and complete the project plan.
? Monitored, Provided on call support to 8i,7.3.4 and 11i production and associated development, QA and UAT databases.
? Supervised the DBA team on day-to-day dba activities
? Installed 9i on Linux and implemented RAC
? Analyzed performance issues on production databases and resolved
? Implemented. Application release upgrades
? Recovered the production database when a disk crashed.
? Tuned the databases based on Statspack reports.
? Configured the replication between the databases.
? Provided support to development team by providing them required database environment like new databases, new schemas, grants, synonyms, materialized views, database links, moving APIs
? Performed production database turnover requests using PVCS version control
? Supported the help desk to fix the problems of the users
? Created and Cloned the databases. Designed and maintained the rollback and redo logs.
? Created a data warehouse database for the company?s data warehouse requirement.
? Maintained databases on SQL SERVER.
? Worked with Unix SAs to resolve the database issues
08/02 ? 07/03 :
Project: Lead DBA for Financial Data Warehouse (FCIW) at AT&T, Piscataway, NJ;
Oracle 8I(8.1.7),9I(9.2.0),Sun E10k Cluster V3,Solaris 2.8, Windows NT, TOAD,
SQL,PLSQL,SHELL,ERWIN,CRYSTAL,HOLOS.
Databases: Development, UAT, Interim and Production Databases of FCIW and MRAL
Database Size 2.2Tb Production
? Led the team to plan, test and implement FGAC (VPD), external tables and other 9I features.
? Monitored, Provided on call support to 8 production and associated development and UAT databases.
? Supervised the DBA/Development team working on AT&T Standard Costing/Financial Profitability project
? Migrated 8I OPS to 9I RAC on Sun Cluster V3 using raw devices
? Tested for feasibility and performance and implemented some of the 9I features.
? Supported the help desk to fix the problems of the users
? Created and Cloned the databases. Designed and maintained the rollback and redo logs.
? Converted the tablespaces to locally managed tablespaces.
? Worked with Unix SAs to resolve the database issues
? Evaluated the performance of transactions and fixed the concerns.
? Implemented database event and DDL triggers.
? Gathered Business Conceptual Requirements, Designed, implemented a proof of concept to for Income and Balance Statements which would save substantial revenue for the division.
08/0108/02 :
Project: Lead DBA for FTI (Financial Technology International ),Iselin, NJ;
Oracle 8I and 9I; Sun 10K Solaris 2.7, Database Size 500Gb Prod &200GbDev,
ERWIN, SQL, PLSQL, Shell, TOAD,POWER DESIGNER, ClearCase
? Lead DBA for StreetReference, StreetClient, StreetBooks products of FTI.
? Supported Release upgrades and Data migrations for clients UBSW, London and Scudders.
? Visited UBS Warburg London to install the latest StreetReference Release.
? Led the team of 2 in data model, database administration and data migration tasks.
? Also guided and assisted the team in data loading, extraction and source control to ClearCase.
? Designed, implemented and maintained the conceptual and physical model of the business common names metadata for securities business model.
? Designed, implemented and maintained the logical and physical model of the Solution Initialization Data that hosts the reference and demo data for various applications.
? Performed day to day DBA activities such as schema creations, synonyms, Data loading and downloading, user support, database monitoring, backup, index evaluation, primary foreign key resolution and administered 6 databases.
? Tuned the performance of the queries and performed the query optimization.
? Partitioned the tables and implemented the materialized views.
10/0008/01:
Project: Lead DBA for Customer Information Facility at JPMorganChase, Midtown, NYC; Oracle8I(8.1.6,8.1.7),Oracle Parallel Server(OPS), Sybase 11.5, Sun E10k Cluster 2.2,E3k,RS 6000, Solaris 2.7, AIX 4.3, Linux 6.2, Windows NT, Database Size 1Tb Prod & 200Gb Dev, OEM, RMAN, SQL, PLSQL, ISQL, Shell
? Administered, tuned, proactively monitored 11 production (24/7) and development instances on multiple platforms.
? Configured application partitioning across multiple instances of OPS.
? Gathered data requirements, analyzed data, designed the logical and physical database and supported the production process.
? Designed and implemented the environment, staging area and database standards
? Interacted with users to tune the transactions.
? Developed scripts, plsql procedures, triggers to extract, massage and load the data.
? Designed, tested and implemented backup/recovery strategies.
? Designed and implemented database and application security policies.
? Installed and configured oracle 8I on Sun for development
? Configured OEM with repository and oms on solaris
? Configured RMAN with recovery catalogue for hot backups and performed recovery drills
? Implemented oracle 8I features - Partitioning, locally managed tablespaces on OPS, dbwr slaves, parallel partition loads.
? Installed, configured and administered Sybase 11.5
? Performed technical analysis on Sybase based application and created a project plan and detailed description to migrate the application to oracle.
? Mentored junior level dbas
04/9810/00 :
Project: Lead DBA for Financial Data Warehouse (FCIW) at AT&T,Piscataway,NJ;
Oracle 7.3.4.3,8.0.5,8I(8.1.6,8.1.7),Oracle Parallel Server(OPS), Sun E10k Cluster 2.2, NCR 5100, IBM PC, Solaris 2.7, Windows NT, OEM,
SQL,PLSQL,SHELL,AUTOSYS,SYNCSORT,ERWIN,CRYSTAL,HOLOS,SUBLIME
Databases: Development, UAT, Interim and Production Databases of FCIW and MRAL
Database Size 2.2Tb Production.
? Administered, tuned, proactively monitored 33 instances under OPS.
? Maintained raw devices and partitioned applications across OPS instances.
? Lead application release upgrades
? Upgraded all the databases from 7.3.2 to 7.3.4.3 and from 7.3.4.3 to 8.1.6
? Maintained manual partitioning process of FACT tables
? Implemented Oracle 8I features after migration to 8I
? Designed, tested and implemented Y2K disaster recovery plan
? Recovered the database to the point of failure using archive logs when a datafile is lost and when disk containing roll back segments crashed.
? Reorganized the history data releasing about 100Gb disk space
? Designed and tested changes to the existing security
? Developed proactive monitor tools which alert dbas by email and pagers
? Performed tuning activities to reduce query execution times.
? Using database cloning methods created interim databases for end users while production databases were undergoing release upgrades.
? Tuned temporary tablespaces, ops global parameters and bitmap indexes
11/97-04/98:
Project: Sr.DBA for Consumer Product Details Application at Lucent Technologies, Parsipany,NJ;
Oracle 7.3, NCR 3000, HP9000 K580, IBM PC, NCR UNIX, HP-UX 10.2,Windows NT, Database Size 200Gb Prod and 50Gb Dev
? Administered and monitored 6 instances
? Configured the replication between Parispany and France
? Did the incomplete recovery using archive logs when a online redo log is lost
04/9711/97 :
Project: UNIX SA/DBA at Datapro Information Services Delran,NJ;
Oracle 7.2/7.3, HP 9000 K420&K220 and RS 6000, HP-UX 10.2,AIX 4.2,Windows NT, Database Size 120Gb Prod
02/9404/97 : Lead DBA/Unix SA for SDS Systems (B) Sdn.Bhd, Brunei
10/8701/94 : Sr.DBA/Unix SA for FujitsuICIM Ltd., Hyderabad, India
AWARDS/APPRECIATION LETTERS
? Recognized with AT&T District Peer award for the TPOC implementation
? Recognized with AT&T Year end divisional award for performance.
? Recognized with AT&T CFO/CIO excellence award for Y2K support.
? Recognized with peer awards by AT&T for fixing the database performance problem, for the backup design, for disaster recovery plan, for disk space reorganization, for Y2k support, for helping Crystal Analysts with good performance views and for proactive space monitor tool.
? Best E.T. Award by BHEL
? Excellence Award By FujitsuICIM Ltd
? Excellent feedback from clients of from Clients of Barbados and Zimbabwe.
Back to Search Results
Job Seekers Employers Members Affiliates Post A Job Post A Resume About Employment911 Contact Us
? Employment911.com, 1998 - 2002. All Rights Reserved.
Click here for our Terms of Use Policies.
Contact this candidate