Senior Database Administrator Resume Profile
VA
Experience Summary
- 13 years of total IT experience with specialization in managing High Availability and Disaster Recovery sites.
- Worked as Senior DBA forConfidentialCoast Guard, Dept of Homeland Security, NC Government.
- Designed and implemented of High Availability solutions for Federal and Local Government Agencies.
- 10 Years Background Investigation MBI completed successfully by Department of Homeland Security.
- Supported databases used by Transport and Security Administration TSA .
- Subject Matter Expert in Oracle Real Application Clusters RAC , Grid Management and ASM.
- Managed Mission Critical Sites running using Oracle Cluster technologies.
- Experience with commercial enterprises like IBM, AT T and PriceWaterHouseCoopers.
- Proficiency in planning, designing and coordinating multiple complex projects concurrently.
Objective
As an IT consultant, I have a comprehensive strategic planning and large-scale implementation experience. I am seeking a Senior Database Administrator position in a creative and challenging environment. I carry a passion for development and strong communication skills with the demonstrated ability of successful completion of projects on schedule.
Professional Qualifications and Achievements
Confidential
- 2 Years Honors course in System Mgmt from National Institute of Information Technology
- Certificate of Achievement from Oracle Software India LTD.
- Recognized as best Database Administrator by U.S Department of Homeland Security.
- Awarded by Confidential. Transport Security Administration TSA in recognition of superb Customer Support Service.
- Attended specialized Oracle Corp. classes and workshops on High Availability and Business continuity areas.
- Technical Expertise Hardware Platforms : Sun Enterprise-6500, HP Superdome, HP L-Class.
- HP Compaq DL Series, IBM Blade,
- Operation Systems : Solaris, HP-UX, Red Hat Enterprise Linux. Oracle Products : Oracle 9i/10g Enterprise Servers, Oracle 9i/10g Application Sevrer, Oracle Mobile, Oracle Lite, Oracle 10g Grid Control, Oracle Real Application Cluster RAC , Oracle Recovery Manager RMAN , Oracle ASM, SQL, PL/SQL.
- Other Tools : HP Business Copy Volumes BCV , Toad,
- F5 BIG IP Load Balancer
WORK EXPERIENCE
Confidential
Environment : Oracle 10g RAC, Red Hat EL 5.0
Role : Senior Database Administrator
Responsibilities:
- Designed and Implemented High availability Solutions using Oracle Real Application Clusters.
- Managing 24/7 Oracle 10g Real Application Databases.
- Designed and deployed migration strategy from 32-bit Oracle 9i RAC to 64-bit Oracle 10g RAC.
- Experience with Automatic Storage Management ASM and Oracle 10g Grid Control.
- Configuration and administration of Oracle ASM.
- Responsible for an array of Production and Non-Production environments.
- Firm knowledge on SGA running and Oracle Internals.
- Conducted Performance Tuning, troubleshooting and Resource optimization at OS and Oracle level.
- Performance Tuning using AWR and ADDM.
- Configured Oracle 10g Grid Control for database monitoring and other maintenance activities.
- Configured Database Backup and Recovery Operations with Oracle Recovery Manager RMAN .
- Designed and staged Disaster Recovery site using Oracle RMAN and 3PAR storage array.
- Database Cloning and refreshes using SAN Snapshot refresh technologies.
- Work on Progress on Oracle Security and Auditing Projects.
- Recommended Storage and Server architectures for High availability applications.
- Aid in the development of Software and Application Standards.
- Expertise in the process of SDLC and Configuration Management.
- Worked with the developers for tuning and troubleshooting performance issues on development frame.
- Develop, and finalize Database Management and Database Platform Architecture processes and procedures.
- Documentation of Standard Operating Procedures and Database Inventories.
- Responsible for gathering requirements delivery of tasks and projects.
- Update and maintain Lotus Notes Project Control Book for all DBA initiatives.
Confidential
Environment : Oracle 9i, 9i RAC, 10g, 10g RAC, HP-UX, Red Hat EL 4.0
Role : Senior Database Administrator
Responsibilities:
- Managing multiple production databases under Performance Based Contract.
- Administration of Oracle 9i/10g RAC databases under 24/7 production environment.
- Implementation of Oracle Real Application Clusters Data Guard in a high availability environment.
- Experience in RAC software like Oracle Cluster Ready Service CRS and OCFS2.
- Designed high availability strategies using Oracle Data Guard.
- SGA and IO Tuning. Knowledge of Oracle Internals. Application debugging SQL Tuning.
- Database Cloning using Business Copy Volume BCV technology.
- Currently working on establishing a Disaster Recovery site for US Coast Guard.
- Management of backup/recovery and security policies of the production environment.
- Exposure to Oracle Recovery Manager RMAN .
- Worked with developers for debugging SQL and PL/SQL issues.
- Knowledge of various components of Oracle 9i Application Server.
- Evaluate new Oracle features and Oracle related products.
- Knowledge of session Load Balancing using F5/BIGIP in a 3-Tier web environment.
- Prepare and present audit remediation reports to the client.
- Evaluate and recommend innovative technologies and hardware.
- Through understanding of Software Development Life Cycle SDLC process.
- Coordinate projects as technical lead to furnish customer requirements.
- Responsible for managing a team of Database and System administrators.
- Responsible for project requirement gathering, resource allocation, planning and delivery.
- Coordinate technical deployments and post implementation support activities.
- Understanding of Configuration Management and Change Management procedures.
- Delivery of Project Status Reports, Documentations and Standard Operating Procedures SOP to the client.
ConfidentialEnvironment : Oracle 7.3.4 8i on Solaris 2.6.
Role : Oracle Database Administrator.
- Database Responsibilities
- Administered Production Development databases on Oracle 7.3 and 8i in a 24/7 on call environment.
- Use of Erwin for logical database designing reverse engineering of the databases for comparison of schemas. Used DB Artisan for managing and monitoring databases
Maintenance of Standby database. Cloning of databases from production to development.
Refreshes from production to development database through cold backups and exports.
Biweekly refreshes of Standby from production to roll forward using archives.
Support to the Development Team for Application Tuning.
Designed implemented backup procedures using RMAN.
Monitoring of backups and errors messages through emails.
Migration from 7.3 to 8.1.7
Exposure to EBU. Automated cold backup of the production system using EBU.
Conversion of backup procedures from EBU to RMAN.
Maintenance of database links from Oracle to MVS databases in IBM.
Responsible for implementation of new release of application on the production system.
Interaction with Oracle's World Wide support to deal with problematic scenarios.
Regularly operated under deadlines and subjected to heavy workloads.
PRICE WATERHOUSE COOPERS Fairfax, Virginia Oct'99 to Dec'99
The project involves maintenance of high-end HP servers for US Dept. of Housing Urban Development.
Project : Mortgage-Backed Securities Information System MBSIS
Environment : HP-UX 10.20 on K Class Servers
Role : System Administrator
System Administration Responsibilities
Installation Configuration of HP-UX 10.20. Troubleshooting of kernel level problems.
Managed disks and file systems using Logical Volume manager LVM .
Scheduled Backup Restore of the entire system using fbackup, frecover utilities.
Configured and maintained Optical disks Juke boxes for system backups.
Coordinated with HP response center to resolve Hardware Software related issues.
DSS MOBILE COMMUNICATIONS Ltd. New Delhi, India Oct 95 to Aug 99
DSS is one of the largest telecom service providers in India having 110 sites production sites.
Project : Management of Billing and Call Center Applications.
Environment : Oracle 7.0, 7.3 on Solaris 2.5, 2.6
Role : Oracle DBA/ SUN System Administrator.
Database Responsibilities
Installed Oracle 7.x on Sun Solaris 2.6.
Managed Production Databases with nearly 100-150 clients per sites.
Remote management of Production Database for 110 sites
Tuning - Memory Allocation SGA , I/O tuning
Wrote and automated the database administration and performance monitoring shell scripts.
Developed various database tools to monitor storage statistics.
Reorganization of the structure of existing databases as and when required.
Maintenance of system security. Controlled and monitored user access to the database.
Planned backup and recovery strategies.
Configured Basic Replication for Multiple Remote Databases using Replication Manager.
Configured the Oracle Replication Manager on NT for remote replication at Master Site.
System Administration Responsibilities
Installation of Solaris 2.6. Kernel configuration for Solaris.
Design different configurations for installation of SUN systems at different production sites.
Skills in the internal architecture of Solaris.
Tuning of OS for Oracle databases. Planned backups and recovery strategies
Installed and allocated different Storage devices on Sun Systems.
Knowledge on Jumpstart installations. Hands on experience with Veritas Volume Manager.
Prepared interfaces for Sun Server with other communication protocols
Maintenance of all serial communication links of the Sun machine Server like SPC Cards etc.
Configured maintained the connectivity's of Sun Server with various Radio Frequency, UHF and VHF devices. Worked in diversified telecom environment with equipment's like GL3000 of Gleynare, Switches from Siemens.