Sr Developer/DBA
Resume:
Girish Shastri
**********@*****.***
******.*******@*****.***
Experience Summary:
Extensive experience in the entire software development life cycle specializing in Database Administration, 24x7 Production On-call Support, Performance Tuning, Backup and Recovery, Capacity Planning, Designing, Data Modeling, Development, Testing and Project Management. Expertise in Maintaining and Tuning High Availability Database environments using Oracle 10g RAC, Oracle Data Guard, Oracle ASM Storage, Oracle Grid Control, Veritas Cluster and Quest Shareplex. An Oracle Certified Professional.
Educational Qualifications:
Master of Business Administration in Marketing (MBA), Pune University 07/1994 - India
Bachelor of Engineering in Electronics (B.E.), Pune University 08/1991 – India
Certifications:
Oracle 8i OCP, Brainbench Certified in Oracle 7 DBA, Oracle Programmer, Oracle PL/SQL and RDBMS Developer.
Major Companies / Clients Worked For:
T-Mobile USA, Seattle, WA, USA – Employer
Washington Mutual Bank, Seattle, WA, USA (Employer – Wipro Ltd., CA, USA)
Hewlett-Packard, CA, USA (Employer – Wipro Ltd., Bangalore, India)
National Grid Transco, UK (Employer – Wipro Ltd., Bangalore, India)
GE Power Systems, Schenectady, NY, USA (Employer – Birlasoft Ltd., Noida, India)
Quixi, USA (Employer – Birlasoft Ltd., Noida, India)
Priceline.com, Stamford, CT, USA (Employer – HCL Technologies Ltd., Noida, India)
CTC, Japan (Employer – Datamatics Ltd., Pune, India)
Pune Stock Exchange Ltd., Pune, India – Employer
Advani-Oerlikon Ltd., Pune, India – Employer
Key Projects:
1. T-Mobile USA, Inc. – Production Support of WIP Core, Edges, RMS, OTA, iHLR, Inform, Caller Tunes, Bookmarks, My Faves, PIM/NAB, CEG, Intec, MMSC, My Album, Oracle Grid Control, SDC, NAP Systems Dec. 2005 – Current
Company: T-Mobile USA Inc., Snoqualmie, WA, USA
Position: Database Administrator 3
Role: Senior Database Administrator
This position involves Database Production Support of WIP Core, Edges, RMS, OTA, iHLR, Inform, Caller Tunes, Bookmarks, My Faves, PIM/NAB, CEG, Intec, MMSC, My Album, Oracle Grid Control, SDC, NAP Systems amongst other systems at T-Mobile USA Inc., Snoqualmie, WA, USA within the Tier II Database Administration group.
Provided On-Call 24x7 Support to the Production Systems.
Worked on supporting Business Critical High Availability Database Systems like WIP Core, Edges, My Faves, PIM/NAB, My Album.
Deployed the Systems in Production and Implemented Best Practices for improved Stability, Availability and Performance.
Performed Database Media Recovery on Intec, Edge Systems after crash.
Installed and Configured Oracle 10g Grid Control Repository and Agents.
Identified and Resolved Performance problems within these Systems.
Used Flashback technology for Recovering Databases to point-in-time.
Worked with ASM Storage for managing database files.
Supported Oracle Streams Replication.
Set up and Supported Oracle RAC environments.
Set up and Supported Oracle Data Guard environments.
Performed Database Role Switchovers from Primary to Standby and vice versa.
Performed Database Role Failover from Primary to Standby.
Managed Data Guard environments using Data Guard Broker and also using SQL Plus.
Supported Veritas Cluster environments.
Set up and Supported Shareplex Replication.
Performed Database Upgrades from Oracle 9i to Oracle 10g.
Performed CPU and PSU patching.
Worked with AWR and ADDM for troubleshooting, identifying and Resolving Performance Bottlenecks.
Performed Work Order Deployments for Implementing enhanced features, fixes and Applying Patches.
Worked on Trouble Tickets for Database issues.
Provided guidance and support to vendors, engineering DBAs and team mates.
Environment: Oracle 10.2.0.5/10.2.0.4/10.2.0.3 / 9.2.0.7, Oracle 10g Grid Control, Oracle Enterprise Manager, Shareplex 5.3.3, TOAD Expert, Oracle 10g RAC and Data Guard, ASM, Data Guard Broker and OS was Sun Solaris 5.10
Team Size: 4
2. Washington Mutual Bank - Database Production Support Sep. 2004 – Nov. 2005
Company: Wipro Ltd., CA, USA
Position: Consultant
Client: Washington Mutual Bank, Seattle, WA, USA
Role: Senior DBA & Team Lead
This project involved Database Production Support from Seattle in Washington Mutual Bank, Seattle, USA.
Worked at Washington Mutual as a Senior DBA and Team Lead independently supporting multiple Production Databases ranging from a few Gigabytes upto 2 Terabytes located across various WaMu data centers in the US. Supported 500+ Oracle & SQL Server databases within a team of 14 DBAs. Handled Database Administration, Backup and Recovery & Performance Tuning activities. Successfully lead the transition of database support from the earlier vendor viz. IBM Global Services. The number of database outages since then considerably reduced due to implementation of proactive measures and better management and maintenance of the database systems. Much stricter monitoring of the databases was implemented with standardized scripts and Foglight monitoring across all databases The backup strategy was completely revisited to provide adequate backups as per the individual requirements of the various application teams. Capacity planning initiative was started to minimize sudden shortage of space. Change Control policies and procedures were strictly followed while implementing any change to the production environments. Remedy Ticketing (TIMS) and Change Management tool was used to handle and manage tickets and change requests. Tools such as Quest Central 5.0, Oracle Enterprise Manager, ERWIN were extensively used.
Interacted regularly with the WaMu System Analysts, DBAs for implementing Database requests on Production, Development & Test instances and 'Release to Test' & 'Release to Production' requests.
Successfully handled and resolved database performance issues using tools like Statspack, OEM and TOAD Expert.
Prepared and submitted weekly and monthly reports to client.
Performed regular database and schema refreshes from Production to Development and Test environments.
Performed Database Recoveries.
Migrated databases from 8i to 9i.
Environment: Oracle 9.2.0.6/8.1.7.4, Oracle Enterprise Manager, Quest Central 5.0, Remedy TIMS & Change Management and OS was Sun Solaris 5.8
Team Size: 11
3. Hewlett Packard - IPG-DC Database Administration and Performance Tuning Support Feb. 2004 – Jul. 2004
Company: Wipro Ltd., Bangalore, India
Position: Consultant
Client: Hewlett Packard, CA, USA
Role: Senior DBA
This project involved Database Administration and Performance Tuning Support from Offsite at Wipro, India
Worked as Senior DBA supporting 14 databases located in the US, Europe and Asia Pacific. Handled Database Administration & Performance Tuning for the Production, Development and Test environments.
Interacted regularly with the System Analysts, Onsite DBAs in US for implementing Database requests on the production, development & test instances and 'Release to Test' & 'Release to Production' requests.
Successfully handled and resolved database performance issues using tools like Statspack, OEM and TOAD Expert.
Suggested a lot of changes for improving performance of the databases and also implemented them.
Prepared and submitted weekly reports to the client.
Environment: Oracle 9.2.0/8.1.7, Oracle Enterprise Manager, TOAD Expert 7.6, Reflection, FTP, Telnet and OS was HP-UX 11i, Windows 2000 Professional
Team Size: 1
4. National Grid Transco - Database, Unix and Network Administration Support Feb. 2003 – Feb. 2004
Company: Wipro Ltd., Bangalore, India
Position: Consultant
Client: National Grid Transco, UK
Role: Lead DBA & Project Manager
This project involved Database, Unix and Network Administration Support both from Onsite in National Grid Transco, UK and Offshore in Wipro, India
Worked as a Lead DBA and Project Manager leading a team of 11.
Interacted with the developers and users on an ongoing basis for implementing database deploys and requests on the production, development and QA servers.
Designed and implemented the Disaster Recovery Plan for the entire Offshore Development Centre of NGT.
Designed and implemented the Backup and Recovery Strategy.
Coordinated with the various vendors viz. Hardware, Software and Telecom.
Coordinated between the Onsite and Offshore teams.
Prepared Project Plan and tracked the project activities.
Allocated and managed the work amongst the team members.
Performed Performance Appraisals of team members.
Prepared and submitted response to workpacks / workpack variations.
Prepared and submitted Weekly and Monthly reports to NGT.
Environment: Oracle 9i/8.1.7/8.1.6/8.0.5, Oracle RMAN, Oracle DBA Studio, Veritas Netbackup 4.5, Visual Source Safe 6.0, SQL Loader, TOAD, Reflection, FTP, Telnet and OS was HP-UX 11, Windows 2000 Professional
Team Size: 12
5. GE Power Systems - Database Administration Jul. 2001 – Jan. 2003
Company: Birlasoft Ltd., Noida, India
Position: Oracle DBA
Client: GE Power Systems, Schenectady, NY, USA
Role: Lead DBA & Project Manager
This project involved Database Design, Maintenance and Support both at Onsite in GE Power Systems, USA and Offshore in Birlasoft, India of the client's Production, Staging and Development Databases.
Worked as Lead DBA, Project Manager and Onsite Coordinator leading a team of 4.
Successfully transitioned Onsite DBA tasks including database administration processes to Offshore.
Provided On-call 24x7 Production Support for production databases.
Interacted with developers and users on an ongoing basis for implementing database deploys and requests on the production, development and QA servers.
Worked on migration of data and implemented structural changes from development servers to QA and production servers using Export, Import, Copy command and database links.
Performed Performance Tuning of SQL statements and Memory parameters
Worked on Embarcadero DB Artisan 5.4 too for performing DBA tasks
Used SQL Loader for loading external data into Oracle tables
Worked on ERWIN 3.5.2 for forward and reverse engineering
Used Visual Source Safe for version controlled execution and maintenance of scripts
Environment: Oracle 8.1.7/8.1.6/8.0.5, SQL, Embarcadero DB Artisan 5.4, Visual Source Safe 6.0, TOAD, PFE, ERWIN 3.5.2 and OS was Solaris 2.8/2.7/2.6, Windows 2000 Professional, Windows XP Professional
Team Size: 5
6. Quixi - Sales Metric Tool Testing and Support May 2002 – Aug. 2002
Company: Birlasoft Ltd., Noida, India
Position: Oracle DBA
Client: Quixi Inc, USA
Role: Senior DBA and Siebel Administrator
This project involved the Testing and Support of Quixi's new release of its Sales Metric Tool. This tool basically evaluates the return on investment on a Siebel implementation in an organization
Worked as DBA and Siebel Administrator
Installed, configured and administered Oracle 8.1.7, SQL Server 2000 and Siebel 7.0.3 on Windows 2000 Server
Creation of databases on Oracle 8.1.7 and SQL Server 2000
Loaded Siebel data on to Oracle 8.1.7 and SQL Server 2000 databases using Export/Import
Maintained Full Database Export and Cold Backup
Created new Opportunities, Activities, Contacts, Accounts and users in Siebel as part of the product testing
Performed Performance Tuning of SQL statements and Memory parameters
Environment: Oracle 8.1.7, SQL Server 2000, Siebel 7.0.3, IIS 4.0, SQL, ERWIN 3.5.2, Quixi Sales Metric Tool 3.7 and OS was Windows 2000 Server/Professional
Team Size: 7
7. Priceline.com – Internationalization Sep. 2000 – Jul. 2001
Company: HCL Technologies Ltd., Noida, India
Position: Member Technical Staff
Client: Priceline.com, Stamford, CT, USA
Role: Lead DBA
This project involved set-up and support of the Production, Staging and Development Servers and Databases for the client's UK operations from Onsite in Priceline.com, USA and then the ongoing support for the same from Offshore in HCL Technologies, India
Worked as Lead DBA and Onsite Coordinator leading a team of 4
Provided On-call 24X7 Production Support for the production databases
Worked on Oracle Recovery Manager (RMAN) for managing backups and recoveries
Responsibilities included Physical and Logical database design, Backup and Recovery, writing PL/SQL procedures, functions and triggers, Migration from Oracle 8.0.5 to 8.1.7
Suggested and implemented Backup and Recovery strategy
Installed and worked on Quest Shareplex replication software
Worked on Standby Database creation, maintenance and administration. A combination of shareplex and standby databases were used to maintain high availability
Wrote shell scripts for replication, export backups, refreshment of standby databases, etc.
Interacted regularly with the developers for implementing database deploys on the production, development and QA servers
Worked on migration of data and implementing structural changes from development servers to QA and production servers using Export, Import, Copy command and database links
Also worked on tuning of SQL scripts, tuning of memory and tuning of disk utilization
Monitored the production, development and QA databases through shell scripts and BMC Patrol software. Problems were identified in terms of severity and appropriate action taken
Used SQL Loader for loading external data into Oracle tables
Used Visual Source Safe for version controlled execution and maintenance of scripts
Trained and mentored junior DBAs
Other DBA activities included creation & management of Oracle databases, management of datafiles, redo log files, control files, tablespaces, segments, extents and data blocks & physical storage, creation, monitoring and management of database users, creation & management of user profiles, granting/revoking of system/object privileges, management of roles & resources and tuning of init.ora parameters
Environment: Oracle 8.1.6/8.0.5, Oracle RMAN, SQL, BMC Patrol, SQL Navigator, Shareplex, Reflection for Unix, Visual Source Safe 6.0, Visio, TOAD, PFE and OS was Solaris 2.6, Windows NT4 workstation
Team Size: 5
8. Employee Stock Option Plan Aug. 2000 – Sep. 2000
Company: HCL Technologies Ltd., Noida, India
Position: Member Technical Staff
Role: Oracle Developer
The project involved Design, Development and Testing of Reports using Oracle Reports 6 for the Employee Stock Option Plan project carried out for HCL Technologies ltd., India
Worked as Oracle Developer
Responsibilities included Design, Development and Testing of Oracle Reports using Reports 6
Used SQL Navigator tool
Used Export/Import utility
Handled programming in SQL and PL/SQL
Prepared technical documents and user documents for the reports developed
Prepared test cases for the reports developed
Environment: Oracle 8.0.5, SQL, PL/SQL, Developer 6, SQL Navigator and OS was Windows NT4 Server/Workstation
Team Size: 6
9. Databus Re-engineering and Migration Jun. 1999 – Aug. 2000
Company: Datamatics Ltd., Pune, India
Position: Senior Software Engineer
Client: CTC, Japan
Role: Senior DBA and Project Leader
This project involved the re-engineering and migration of CTC’s system on Databus platform to Oracle 8.0.5 and Visual Basic 6
Worked as DBA and Project Leader leading a team of 6
DBA activities included creation & management of Oracle databases, management of datafiles, redo log files, control files, tablespaces, segments, extents and data blocks & physical storage, creation, monitoring and management of database users, creation & management of user profiles, granting/revoking of system/object privileges, management of roles & resources and tuning of init.ora parameters
Performed Oracle installations and upgrades form version 7.3 to 8.0.5
Implemented Export, Online and Offline Backups
Used SQL loader extensively for loading various types of data into Oracle
Handled troubleshooting of network related issues
Handled SQL Statement tuning
Managed Database Objects & their Usage
Handled programming in SQL and PL/SQL
Environment: Oracle 8.0.5, SQL*Loader, SQL, PL/SQL, Visual Basic 6.0 and OS was Windows NT4 Server/Workstation, Windows 95/98, RMS 4.7.C, Databus
Team Size: 7
10. Database and Systems Administration Jan. 1999 – May 1999
Company: Datamatics Ltd., Pune, India
Position: Senior Software Engineer
Role: Senior DBA and Systems Administrator
This project involved the Database Administration, System Administration and Support of the servers and desktops in Datamatics, India
Worked as DBA and Systems Administrator
DBA activities included creation & management of Oracle databases, management of datafiles, redo log files, control files, tablespaces, segments, extents and data blocks & physical storage, creation, monitoring and management of database users, creation & management of user profiles, granting/revoking of system/object privileges, management of roles & resources and tuning of init.ora parameters
Implemented Export, Online and Offline Backups
Used SQL loader extensively for loading various types of data into Oracle
Handled troubleshooting of network related issues
Handled SQL Statement tuning
Managed Database Objects & their Usage
Handled programming in SQL and PL/SQL
Environment: Oracle 8.0.5, SQL Server 6.5, SQL, PL/SQL, Visual Basic 6.0 and OS was Windows NT4 Server/Workstation, Windows 95/98
Team Size: 1
11. Market Capitalization System Oct. 1998 – Jan. 1999
12. Bad Delivery System Apr. 1998 – Sep. 1998
13. Capital Adequacy System Feb. 1998 – Mar. 1998
14. Inward-Outward System Oct. 1997 – Jan. 1998
Company: Pune Stock Exchange ltd., Pune, India
Position: Manager - EDP
Role: Senior DBA & Project Manager
The project involved Design, Development, Testing and Support of the ‘Market Capitalization System’, ‘Bad Delivery System’, ‘Capital Adequacy System’ and ‘Inward-Outward System’ for Pune Stock Exchange ltd., Pune, India
Worked as a Senior DBA and Systems Manager heading the in-house Systems department and leading a team of 4
DBA activities included creation & management of Oracle databases, management of datafiles, redo log files, control files, tablespaces, segments, extents and data blocks & physical storage, creation, monitoring and management of database users, creation & management of user profiles, granting/revoking of system/object privileges, management of roles & resources and tuning of init.ora parameters
Implemented Export and Offline Backups
Used SQL loader extensively for loading various types of data into Oracle
Handled troubleshooting of network related issues
Handled SQL Statement tuning
Managed Database Objects & their Usage
Handled programming in SQL and PL/SQL
Developed forms and reports using Developer/2000
Environment: Oracle 7.3, Developer/2000, SQL*Loader, ERWIN 2.5, SQL, PL/SQL and OS was Windows NT4 Server/Workstation
Team Size: 5
15. MRP-II System Maintenance and Support Oct. 1995 – Sep. 1997
Company: Advani-Oerlikon Ltd., Pune, India
Position: Senior Engineer
Role: DBA
This project involved Maintenance and Support of the MRP-II system for Advani-Oerlikon Ltd., Pune, India
Worked as DBA. DBA activities included creation & management of Oracle databases, management of datafiles, redo log files, control files, tablespaces, segments, extents and data blocks & physical storage, creation, monitoring and management of database users, creation & management of user profiles, granting/revoking of system/object privileges, management of roles & resources and tuning of init.ora parameters
Implemented Export and Offline Backups
Used SQL loader extensively for loading various types of data into Oracle
Handled troubleshooting of network related issues
Handled SQL Statement tuning
Managed Database Objects & their Usage
Handled programming in SQL and PL/SQL
Developed forms and reports using Developer/2000
Involved in Customization, Migration of Forms 3.0 to Forms 4.5, Migration of Libraries, Creation of new Menus & Migration of Reports 1.1 to Reports 2.5, Data Migration and Implementation
Environment: Oracle 7.1, Developer/2000, SQL, PL/SQL, Forms 3.0, Reports 1.1 and OS was DG Unix 5.4.2, SCO Unix 5.3.2, Windows 95
Team Size: 6
16. Inventory Control System Apr. 1995 – Sep. 1995
Company: Advani-Oerlikon Ltd., Pune, India
Position: Engineer
Role: DBA & Developer
This project involved System Analysis, Design, Development and Testing of the ‘Inventory Control System’ for Advani-Oerlikon Ltd., Pune, India
Worked as Oracle Developer and DBA
Performed Systems Analysis and Design, Development and Testing activities
Handled programming in SQL and PL/SQL
Developed forms and reports using Developer/2000
Handled all DBA tasks related to the project
Environment: Oracle 7.1, Developer/2000, SQL, PL/SQL, and OS was DG Unix 5.4.2, Windows 95/3.11, DOS 6.x
Team Size: 3
17. Unify/Accell System Jan. 1994 – Mar. 1995
Company: Advani-Oerlikon Ltd., Pune, India
Position: Engineer
Role: Project Engineer
This project involved Development, Testing and Support of the ‘Unify/Accell System’ for Advani-Oerlikon Ltd., Pune, India
Worked as Developer.
Performed Development, Testing and Support
Handled programming in Unify SQL
Generated necessary reports for MIS and provided support & training to users
Environment: Unify 5.0, Accell 1.4, Unify SQL and OS was DG Unix 5.4.2, Windows 3.11, DOS 6.x
Team Size: 6
Contact this candidate