Lead Dba Resume
Washington, DC
PROFESSIONAL SUMMARY:
- Senior IT professional with over twenty years of experience in production and development environments• Proven IT experience to include organizational and supervisory skills to assure success
- Successful in meeting new technical challenges and finding solutions to meet the needs of the customer
- Highly motivated professional and team player
- Problem solving abilities and effectiveness in working independently or in a team.
- Good communication and interpersonal skills.
- Certified Information System Auditor from ISACA
- Certified Oracle Database Administrator
TECHNICAL SKILLS:
Operating System: Sun OS, Sun Solaris 2.x, Linux RedHat, Tru64 Cluster UNIX 5.1b HP - UXUNIX, Windows 2003 Servers, Veritas Cluster
Languages: PL/SQL, SQL, C, HTML, korn shell, sed, awk, COBOL, JAVA
Databases: Oracle 11g,10.x, 9.x, RAC (Real Application Cluster), ASM, Oracle clusterware, Sql server 2008
Tool: IBM Guardium v9, Oracle Golden gate 12c, Oracle Streams, OBIEE BI Publisher, OEM Grid Control, Oracle Data Guard, Oracle 10g Discoverer Web reports, Oracle Streams, Oracle 11g Grid Control, Veritas Net backup, Erwin, Developer2000, Oracle Forms 4.x, Oracle Reports 2.x, SQL*Loader, RMAN backups
Hardware: Oracle Exadata Servers,Sun Sparc, HP-9000, Compaq Dec Alpha
Application: ESRI Arcsde8.3, 9.1, Oracle*SPL Network Management System for Utilities, Oracle *SPL Business Intelligence
Data warehouse: Oracle *SPL Customer Care and Billing Business Intelligence System, MicroStrategy BI system
PROFESSIONAL EXPERIENCE:
Lead DBA
Confidential, Washington DC
Responsibilities:
- Design, Evaluate, administer and tune databases.
- Install/configure oracle golden gate 12c tool between various oracle databases.
- Designed and configured Oracle streams replication between two databases for web reports.
- Designed and configured Oracle Golden gate replication along with jagent
- Migrate databases from oracle 10g to oracle 11g
- Disaster recovery testing
- Design system and database architecture
- Maintenance and Administration (memory, processes, disk storage & file system) of Sun servers.
- Configuration of Veritas Cluster for Sun servers.
- Maintain and administer databases for NOC, GWD, NMS, Obvient and MDS systems
- Install and configure 11g Oracle Clusterware
- Install & Configure 11g/12c RAC databases using ASM (Automatic Storage Management) instances.
- Created and configured Data guard standby databases using OEM
- Installed and Configured 11g Oracle Enterprise Manger
- Installed and Configured SQL server 2008.
- Organize conferences/meetings with vendors and user groups to configure applications and troubleshoot issues.
- Configuration of Veritas OS backups and RMAN database backups.
- Creation, administration and tuning of Oracle instances in oracle 10g,11g & 12c environments
- Configuration and administration of Veritas Clusters on Sun servers.
- Configuration and administration of Veritas Net backup for overall systems.
- Maintenance of RMAN backups includes writing RMAN scripts
- Creation of shell scripts and schedule them for various maintenance jobs
- Unix shell scripts for monitoring golden gate replication and streams replication
- Unix shell scripts for monitoring sync between primary and standby databases
- Generating SOX user access reports
- Setting up audits on SOX dbs in guardium tool
- Generating audit reports of SOX dbs from guardium tool.
Environment: Oracle Exadata Servers,Sun Server M-4000, Tru64 Cluster UNIX 5.1b, Windows 2000, Windows 2003, Oracle 11g,10g, 9i, Oracle Real Application cluster and ASM, OBIEE BI Publisher
Sys Admin/Oracle DBA
Confidential, San Jose CA
- Installed/Configured HP-Ux and created Development instances.
- Monitored Production & Development Databases .Created and maintained database objects using ERWIN.
Environment: HP-UX, Oracle (8.1.6)
Oracle DBA
Confidential, CA
Responsibilities:
- Administered and Tuned Oracle Application Server.
- Created listeners, DADs, and cartridges (PLSQL, Perl, Java) in Oracle Application server
- Creating database and primary objects
Environment: Sun Solaris, Oracle (8.0.5), Oracle Application Server (Web Server)
Oracle DBA
Confidential, MI
- Designed and created the database, users, tablespaces, rollback segments, tables, and indexes. Monitored various database activities and performed database and application tuning using utlbstat, utlestat and tkprof, also performed reorganization of databases and tablespaces to eliminate fragmentation using export and import utility.
Software Engineer - Oracle DBA
Confidential
Responsibilities:
- As a production and development DBA, responsibilities included Installation of Oracle server/client and associated tools for Production environment, Database creation, Tablespace management, Monitoring database, Tuning memory and application.
- Created scripts for Backup.
- Performed Export and import of data.
- Configured the Network.