We provide IT Staff Augmentation Services!

Senior Database Administrator & Architecture-consultant Resume

Columbia, MD

SUMMARY:

  • Oracle Certified Professional: DBA in Oracle 10g & 11g and 12C for Grid Control with more than 18 years of experience on all releases of Oracle database on Red Hat Linux, Sun Solaris and Windows. Also working knowledge of Microsoft SQL Server 2000, 2005 & 2008.
  • Virtualization, Installation of 10g/11g on Virtual machine, Configuration, Upgrade and administer Terabyte of Oracle Databases on Oracle 11g,10g /9i/8x, Setup of Oracle Data Guard 10g and 11g as Physical Standby, Oracle Clinical Application TMS (Thesaurus Management System) Installation, Configuration & Grid Control 11g Management and Configuration
  • Managed OLTP databases having 24 * 7 activities, Handled all the aspects of database design, administration, performance tuning, backup and recovery in Test, Development and Production environments including DDL and DML commands and writing Scripts. Table partitioning for very large tables, data archiving etc
  • Used oracle provided tools like Stats pack, OEM, AWR, ADDM, ASMM, Oracle packages, Auto trace and cost of executing queries, SPM Plan management, SPA (SQL Plan Analyzer), Statistics Collection using DBMS STATS package, SQL Profiles and Oracle 11g new features
  • Configured and used RMAN for backup & recovery, Planned for backup strategies for Mission Critical databases, and configured Flashback Technology for faster recovery. Created and Configured RMAN - Recovery Catalogue
  • Managed, Configured, and administered Oracle 10g RAC (Rel.1&2) on Sun Solaris and Linux platforms.
  • Also configured and managed Oracle 10g Data Guard as physical standby database, SQL Server Cluster database Management.
  • Used features of RAC 11g .
  • Lead role & Team Member in architecture, design and documentation of database infrastructure and administration technologies
  • Oracle Data Pump (EXPDP and IMPDP) for export and Import. SQL Loader for loading the data in Oracle, External tables, Used M.S SQL SSIS Tool for data migration and integration
  • Used PL/SQL for Stored Procedures, Functions, Triggers & Packages, Security through views and other objects like Materialized views. Fine Grained implemented for column level security, Erwin tool used for forward and reverse engineering, E-R Diagrams
  • Worked as Team member and Team Lead in Education, Entertainment, Non-Profit, Medical, Govt. and Semi govt. sectors

TECHNICALSKILLS:

Operating Systems: Sun Solaris, Linux, Fedora, Ubuntu UNIX, Windows 2000, Windows XP.

Programming Languages: Oracle SQL, PL/SQL, T-SQL, MYSQL,M.SAccess

Web Design Tools: Html, Java Script, Active Server Page, IIS

Databases: Oracle (11g, 10g, 9i, 8i, 8, 7.3 v), SQL Server (2005, 2000 & 2008)

Data Modeling Tools: Data Modeling (Erwin Tool), MS- Visio

ETL- Tools: DTS, SSIS, Informatica

Reporting Tools: Crystal, Oracle, Cognos

Other Applications: Ultipro, DB artisan, TOAD 11.6

PROFESSIONAL EXPERIENCE:

Confidential, Columbia, MD

Senior Database Administrator & Architecture-Consultant

Responsibilities:

  • Handling Customers Tickets using “Serena Business Manager” for issues related to database access, fixing errors, creating schema, granting roles, export/Import etc.
  • Upgrading 10g databases to 11g - more than 15 databases
  • Developing Test environment from RMAN backup from production
  • Worked as Oracle Application DBA with developer to improve performance of an Application
  • Performance Tuning- I/O and CPU Utilization Monitoring, tracing user sessions, Suggesting better plan for SQL statement with high CPU usage.
  • Working with Developers, enhance SQL Query performance, Rewrite code, Tracing the session etc.

Confidential, Washington, DC

Senior Database Administrator & Architecture-Consultant

Responsibilities:

  • Migration of 11g from old Server to new server
  • Upgrading 10g databases to 11g database
  • 11g Database Installation on New Server
  • Developing Test environment from RMAN backup from production
  • Working with developers, Storage Management, CRONTAB and NOHUP Jobs
  • Performance Tuning- I/O and CPU Utilization Monitoring, Writing Scripts

Confidential, Washington, DC

Senior Database Administrator/ architecture

Responsibilities:

  • Virtualization and installation of 10g,11g oracle databases
  • Migration of Database Oracle10g and M.S SQL 2005 on new system
  • Restore of Production database backup to Development and Test environments.
  • Oracle Database Data Guard Management for 10g, 11g databases using DGMGRL
  • RAC Setup and configuration for two nodes , used tools like CRSCTL,SRVCTL User creation, RMAN setup and Grid Control for Database management for different databases

Confidential, Washington, DC

Senior Database Administrator & Architecture

Responsibilities:

  • Migrated oracle 10g system to oracle 11g manually on new Sun Solaris box(environment)
  • RAC with two node environments on Linux managed with all the administrative activities like backup, setup of RMAN, Export and Import etc.
  • Used oracle provided tools like ADDM, Stats pack, TKPROF, Explain plan, SQL Analyze, Oracle enterprise manager.
  • Configured Oracle Data Guard to ensure high availability, data protection, and disaster recovery for enterprise data.

Confidential, Herndon, Virginia

Team Lead (Senior Database Administrator and Architecture)

Responsibilities:

  • Handled database size ranging from 25 GB to 4 TB on Linux / Windows environments
  • Created RMAN based backup & recovery scripts for database.
  • Performance Tuning of Production Databases using oracle provided tools like Stats pack, TKPROF, Explain plan, SQL Analyze, Oracle packages
  • Writing production support documentation for supporting production RAC databases.
  • RAC Setup and configuration, User creation, backup, RMAN setup

Confidential, Washington, DC

Senior Database Administrator

Responsibilities:

  • Supported Payroll , HR and Planning departments clients
  • Establish and maintain backup and recovery policies and procedures. RMAN Implementation with recovery catalog.
  • Migration of database using DBUA from 9i to 10g, Export/Import, Data pump & using scripts.
  • SQL tuning using explained plan, TKPROF, AWR, ADDM
  • Administration of all database objects, including tables, clusters, Indexes, views, Sequences, packages and procedures
  • Development patches deployment in test , development and production environments
  • Interacting with Business analyst for enhancement of the application based on client requirements
  • Data integration, Migration using M.S SQL Server DTS packages.
  • Performance tuning, Stats pack Report and Individual SQL Statement Tuning -consuming High CPU Usage.

Hire Now