We provide IT Staff Augmentation Services!

Platform Lead Resume

PROFESSIONAL SUMMARY:

  • Over 15 years in IT Industry
  • Worked in all stages of the development cycle.
  • Over 10 years as Oracle DBA for Oracle 7,8,8i,9i,10G,11G(with ASM and RAC) on different latest platforms such as Solaris - UNIX, HP-UNIX, AIX,Windows-NT, Confidential Disk suit and HP-SAN, Hitachi disk array .
  • More then 6 years experience as a Sr. Architect and PL/SQL developer on a variety of applications
  • Set up streams (10G feature) and Advance replication (9i)in multinational organizations.
  • Trained staff for streams and Advance replication.
  • Superior understanding of logical and physical design.
  • Exceptional experience writing system specifications, system study, analysis and design using various tools
  • Experience in corporate multinational environment
  • Expert in Disaster recovery planning.
  • Currently Using new technologies like Real Application Cluster(RAC), replication with Streams and Data Guard for Disaster recovery solutions.
  • Worked and working on VLDB with multi terabyte Databases.
  • Full migration experience from 8i to 9i to 10g and 11G,
  • Also converted single instances to RAC.
  • Expert in backup and recovery and performance tuning.
  • Expert in table Partitioning.
  • Merger-Integration experience.
  • Development and operations both experience.
  • Worked on virtualization.
  • ITIL Certified

TECHNICAL PROFICIENCIES:

RDBMS: Oracle 11G R2 (RAC and stand alone Databases), Oracle 10G (10.2.0.4)(including RAC and CRS), 9i, 8i, Oracle 8, Oracle 7. Informix 7, Integra-IV, SQL-Server 2008, 2005. Worked on multi TB Databases.

GUI Tools: Oracle Enterprise Manager(web version), 10G and 11G Grid control, 10G and 11G RAC with Automatic Storage Management (ASM), Oracle Performance Manager, Replication Manager, DBA Studio, SQL-Navigator, Designer 2000, Developer 2000, TOAD, Database Configuration Manager

Computer Languages: SQL,PL-SQL,RMAN scripts and unix shell, Perl scripts.

Operating Systems: UNIX, WINDOWS, Novell, Linux

Application tier: Worked with JAVA,Weblogic,Websphere,TUXEDO and Oracle Application Servers.

Hardware: Sun Solaris (E25K)- Veritas file systems(VXFS), HP, Simens, Confidential, HITACHI and HP SAN, AIX,DELL servers Worked with Patabyte storage.

Networking: Worked with TCP/IP, IP and several protocols.

Managerial Experties: Motivated team, Building and merging teams (like Confidential and SIRI XM), get the things done. Grant bonuses per performance, promoted right talent. Performance appraisals. Bonus assignments. Hiring, Budgeting. License negotiations. Negotiations with vendors. Project and task assignments, Technical guidance to the team. Retaining staff. Remotely managed teams and Databases.

PROFESSIONAL EXPERIENCE:

Confidential

Platform Lead

Responsibilities:

  • I’m leading 12 DBAs from different locations. I’ve two teams one for SQL Database support and one for Oracle DB support,
  • Also I work closely with Windows support team, UNIX system administrators and Storage team to make sure storage is allocated properly to the Databases and to the applications.
  • For MS-SQL we are migrated to sql-2008 cluster.
  • For Oracle we migrated to 11GR2 RAC and ASM.
  • Also my responsibility is to make sure backups are running correctly and work with backup team.
  • Designed and supported Sirius and XM application merging project for several applications like Portal and Siebel, Order Management etc.
  • 11G RAC technology implemented, Disaster Recovery planning, design and implementation.
  • Set up Golden gate for Databases.
  • Total Database size is 400 TB, with multiple disk arrays.
  • Worked with storage on assigning and defining storage requirements up to several petabytes.
  • We use ASM technology for Database storage.
  • Designed and built DR site. Managed alerts and remedy queues for the team.
  • Worked on reducing monitoring alerts, worked with development team to design and implement solution for the data migration activities.
  • Worked on performance issues faced for development teams.
  • Also defined tools to support development and production support staff.
  • Resolved issues for BCV split mirror and helped storage team to shadow copy databases easily and effectively.
  • Designed solution for refreshing Databases via both split and rman to refresh Databases from production to Development and QA.
  • Supported successfully PCI and SOX audit, supported and passed compliance reviews successfully for Database and system / OS audits.
  • We support SMS (Portal and Siebel) application.

Confidential

DBA Manager

Environment: consists of SQL and Oracle Databases.

Responsibilities:

  • Streams setup and maintenance.
  • Working on different security applications token based and knowledge based.
  • Create and Maintain RAC with 2 - 3 nodes in Linux environment, streams replication is used for DR purpose and deployment of releases. Monitoring thru Grid control.
  • Define strategies for database monitoring and implement them.
  • Currently we are working on the companies to merge with RSA which are taken over, VERID in USA and Cyota in Isreal and passmark in CA.
  • Standardizing all technical aspects of the Database across RSA.
  • Created logical and physical and logical standby Databases.
  • Created centralized monitoring thru Oracle management servers and defined what and how to monitor within Databases and clusters.
  • Defined and executed strategy for centralized backups for VTL.(Virtual Tape Library)
  • Helped Application developers in Performance tuning of SQL statements.
  • Performance tuning Databases.
  • Monitor SLAs for the organizations.
  • Define quarterly goals for the team.
  • Worked on all kinds of HW including Sun E10K, Sunfire / Dell/HP../ used most OS like Sun, Linux etc.

Confidential

Lead 10G Database Administrator

Responsibilities:

  • Lead Oracle 10g DBA consisting of 6 Oracle DBAs and 3 SQL DBAs
  • Provided Technical guidance to all DBAs,
  • Guide DBAs to/how to resolve all production issues as well as to define direction of monitoring.
  • Established monitoring system using 10G grid control
  • Support production Databases with on call rotation
  • FLEXNET is the first application with over 70 Databases going to be monitored remotely with servers located in field
  • Implementing RAC to reduce the cost of hardware
  • Implement Streams replication for disaster recovery.
  • Trained staff for RMAN backup and recovery, OEM monitoring, streams replication.
  • Moved scores of databases from Oracle 9i to 10g. (10.2) RAC environment.
  • Using LDAP for scalability
  • Centralized procedure and monitoring for backup and recovery thru grid control
  • Monitoring SLAs for production, development and QA Databases thru grid control
  • Installed, Used and monitored 10g CRS (cluster ready services) to save cost of Veritas cluster.
  • Created RAC Databases using ASM(Automatic Storage Management)
  • Used HP SAN and Confidential for RAC cluster and stand alone Databases.
  • Recovered successfully part of production and full production database in time.
  • Wrote and monitored SLAs for remote applications and local applications.
  • Wrote DR solutions for remote and local applications based upon business needs and SLAs(Used replication, data guard, remote archiving, BCV splits and RAC to achieve the goals)
  • Implemented Grid Control solution for monitoring all DBs for the company, also added self healing for some cases.
  • Planned and implemented Oracle upgrades to minimize the production outages.
  • Saved money by doing consolidations of Oracle Databases on to one server.

Confidential

Sr. Oracle Database Administrotor

Responsibilities:

  • Lead team of DBAs and developers
  • Create Databases
  • Apply patches, Maintain production, QA and Development of all Databases
  • Install new application releases
  • Migration to Sun E10K from Siemens m/cs and 8.0.5 to 8.1.7 Oracle upgrade
  • Migration from 8.1.7.4 to 9.2.0,6 Meta release planning and co-ordination between Canada, France, UK and USA teams
  • Replication management, Replication error resolution, reverse engineer replication for all systems and setup and implement replication
  • Performance monitoring:
  • Check wait events inside DB
  • Find out the queries performing poorly
  • Analyze and suggest changes
  • Monitor the SGA usage and tune the parameters if necessary.
  • Backups:
  • Used Legato and Reels for backup with RMAN
  • Write pre and post scripts for backups
  • Coordinate with S.A.s and monitor backups
  • Coordination of different teams Confidential different locations worldwide during releases
  • Minimize downtime during installations and new releases
  • Support QA and UAT phases
  • Currently lead for disaster recovery and 7x24 availability for Clarify trouble ticketing system
  • Using Streams and Data guard
  • Production DBA to maintain OPER (Reston and Frankfurt) databases
  • All the systems interact with these two database which are replicated in Reston (USA) and one in Frankfurt(Germany)
  • Implement advance replication for 14 groups and to resolve all replication issues
  • Database security, Recovery
  • Install new releases in QA environment and production (Size 50GB. OS: Simens- reliant UNIX)
  • Plan the strategy and choose the best method for migration which will minimize the downtime. Tune the queries.
  • Successfully migrated to SUN E10K and Oracle 8.1.7 and the down time was minimal during this
  • Migrated to Oracle 10g Database

Confidential

Sr. Oracle Database Administrator

Responsibilities:

  • Oracle 8.i Database running on Sun Solaris 2.6
  • Creation of instances, maintaining database, backup strategy, and recovery documentation
  • Solely responsible for the performance and health of Database, security, and user maintenance.
  • Planned, tested and implemented advance multi master replication
  • Planned and tested standby database creation of:
  • Production Database support
  • Development Database support
  • Work with developers and production support personnel to create new database objects and solve database related problems
  • Monitor tablespace storage on all instances (production, staging, dev, and prod support)
  • Monitor archive logs on production database
  • Monitor and maintain Oracle Net8 network environment for all instances
  • Move all database changes from dev/test and production support during all new releases
  • Maintain and monitor the Listeners on all database instances
  • Create and distribute tnsnames ora files for clients and app servers
  • Monitor alert logs on all database servers
  • Install client side Oracle software on developer machines and application servers
  • Install and upgrade Oracle Enterprise Database Server as required
  • Modify the Oracle instance initial parameter file as required
  • Reboot the Unix servers when required
  • Create and run ad hoc queries when requested
  • Monitor database performance and make necessary changes
  • Backup and Recovery of the Database

Confidential

Sr. Oracle DBA

Responsibilities:

  • Install and tune Oracle database on NT machine
  • Design and develop schema common for both systems viz:cable and telephone
  • Write procedures for updating the data from cable and telephone systems into new schema
  • Transfer this data to other systems, which in turn will talk to automated customer inquiries
  • Automate the data updating procedures
  • Write procedures for backup and recovery
  • Add procedures in automated Window NT's Confidential jobs
  • Tuning the database
  • Tune IVR inquiries
  • 7x24 production support
  • Check for the data consistency
  • Maintain multiple databases
  • Define and implement backup strategy for the databases

Environment: Windows NT Servers. Oracle 8, Sybase Power Designer (for logical and physical Schema design).

Confidential

Sr. Oracle DBA

Responsibilities:

  • 24x7 support
  • Replicated servers using RAID technology
  • Define standards for database performance to monitor the performance of the database and to improve it.
  • Monitor growth of the database and take appropriate action in advance
  • Solve any problems related to database and minimize the downtime
  • Backup and Recovery
  • Create and test reliability of standby database server (Texas Local Factory)
  • Install software version releases
  • Assist software development team in optimizing the SQL queries
  • Write scripts and cron jobs for monitoring the Database
  • Upgrade/Install the Oracle versions
  • Assign the exact storage clauses to database objects and to distribute them correctly across tablespaces
  • Create and maintain users and security to pin the more frequently packages and procedures into memory.

Environment: Oracle 7.3.4,8.0.5.1 HP UX10.2, Sun Solaris 2.6

Confidential

Sr. Oracle DBA

Responsibilities:

  • Backup and recovery
  • Assure system Y2K compliant
  • Maintaining the production and Development Database
  • Tuning the production database for optimum performance
  • Solving all database related problems as well as programming problems. Write cron jobs to monitor the database
  • Writing PL/SQL scripts in triggers and packages
  • Assigning the tasks to system analyst and programmers
  • Providing technical solutions to programmers and analysts
  • Technical coordination between testing, development and configuration management teams
  • Planning and coordination of new software releases with government persons

Environment: Oracle 7.3 (UNIX) Designer 2000 ( Windows 95) PVCS ( Program Version Control System)

Confidential

Sr. DBA and System Coordinator

Responsibilities:

  • Defining standards for the database and system Creating and maintaining tablespaces
  • Creating and maintaining schema
  • Defining extents sizes of the database objects
  • Creating users and assigning the privileges
  • Analyzing the tables periodically
  • Creating database links
  • Perform hot backups
  • Recovery from user faults as well as media recovery
  • Upload the data from old x-base system into oracle via SQL*Loader

Environment: Oracle 7.3(UNIX), Developer 2000 (Windows 95), Lotus approach (for documentation)

Confidential

Sr. System analyst and DBA

Responsibilities:

  • Defining standards for the database and system
  • Preparing system specification documents
  • Creating database and tablespaces
  • Responsible for schema of the system (Creation of tables, sequences, views, synonyms, packages and procedures etc)
  • Identifying and defining the database triggers
  • Imposing the business rules using oracle constraints
  • Distributing the load between client(windows 95) and the server (Unix)
  • Creating users and assigning privileges
  • Giving specifications to programmers and fault finding
  • Solving user problems.

Environment: Oracle 7.3(UNIX), Developer 2000 (Windows 95), Lotus approach (for documentation)

Confidential

Sr. System analyst and DBA

Responsibilities:

  • Responsible for schema of the system (Creation of tables, sequences, views, synonyms, packages and procedures etc)
  • Identifying and defining the database triggers
  • Imposing the business rules using oracle constraints
  • Creating users and assigning privileges
  • Supplied specifications to programmers and fault finding
  • Writing the control scripts to load data via SQL*Loader
  • Defining and executing the test plan
  • Solving user problems

Environment: Oracle 7.3(UNIX), Developer 2000 (Windows 95), Novell NetWare 4.0x, Lotus approach (for documentation)

Confidential

Sr. System analyst and DBA

Responsibilities:

  • Defining standards for the database and systems
  • System design
  • Schema and scripts of the system
  • Writing common procedures
  • Distribution of the load between client and server
  • Creating users and maintaining users. System specifications and assignment of work to the programmers and fault finding.

Environment: Oracle 7.3(UNIX), Developer 2000 (Windows 95).

Hire Now