We provide IT Staff Augmentation Services!

Sr Oracle, Applications, Sql Server Database Administrator Resume

Philadelphia, PA

SUMMARY

  • A qualified IT professional with more than 8+ years of industry experience in managing and working with leading edge projects that requires expert level knowledge on diverse OLTP environments.
  • I am a good team player with proven expertise in physical and Logical database design, installation, configuration and implementation.
  • I also have experience with support and maintenance of Oracle RDBMSs in LINUX and UNIX environments.
  • I have experience in consulting with a reputable and globally recognized IT consulting firm.
  • My Experience includes upgrade of Oracle databases on different versions, setup of ASM to manage storage for better performance, RAC 10g, 11g, as well as GRID installation and patching, troubleshooting RAC, using ASMCFS file system for Clustering, implementing Data Guard for real time disaster Recovery.
  • I also have a good understanding of OS level maneuvering, Capacity Planning and space shortage resolution in Databases.
  • I have excellent skills in applying quarterly patches and also experienced in automating database creation through Oracle response files and through Linux shell scripts; I am well versed in oracle management tools like Oracle Enterprise Manager Grid, ASMCA etc.
  • I consider myself a good communicator and versatile in establishing good client relationships to understand their business processes, user tasks & goals; then analyzing and defining requirements to ensure efficient and cost - saving technological solutions to meet and exceed the client’s needs.

AREAS OF EXPERTISE

  • Oracle 11g RAC installation
  • Oracle 11g/10g database administration
  • Systems Integration
  • Performance Tuning
  • SQL query tuning
  • Technical Documentation
  • Capacity Planning
  • Logical and physical database design
  • Technical Leadership
  • Database architecture

TECHNICAL SKILLS

  • Oracle RAC
  • Oracle ASM technology
  • Oracle RMAN
  • Oracle Data Guard
  • Oracle Grid Infrastructure
  • Oracle Applications
  • Linux Platforms - Red Hat, Ent. Linux
  • Oracle Data-pump
  • Oracle Enterprise Business Suite
  • Oracle Grid Control Management
  • Oracle EBS
  • SSMS
  • Oracle SQL Developer
  • Qwest Toad
  • SQL Server
  • Microsoft Office

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

SR Oracle, Applications, SQL Server Database Administrator

Responsibilities:

  • Manage EBS oracle and applications databases, running on 11G and 12i.
  • Monitor and remediate errors related to daily incremental and weekly full backups using RMAN.
  • Performed database cloning with RMAN from production to non-production databases servers
  • Designed, implemented and troubleshoot Oracle Dataguard for disaster recovery.
  • Manage tablespace shortage issues and extend datafiles as needed.
  • Apply Oracle quarterly patches as needed.
  • Managing SQL server Job failures and taking remediating steps.
  • Monitoring and Controlling access, permissions and privileges
  • Manage oracle performance related issues and mitigate performance degradation issues proactively as well as reactively.

Confidential, Washington, DC

Infrastructure DBA Team Lead

Responsibilities:

  • Responsible for project deadlines and ensuring the team meets goals set by management.
  • Adapts existing methods and procedures to create alternative solutions to moderately complex problems.
  • Operate in a project lead capacity on assigned projects, while managing assignments of junior colleagues.
  • Uses own judgment to determine optimal solutions to recommend.
  • Design, implement and deploy Oracle solutions to achieve defined business goals.
  • Maintain skills in Oracle applications process design and configuration;
  • Oracle application design, development, integration, testing and deployment;
  • Design, implement and deploy Oracle financial solutions for finance, accounting, cash management, treasury management and asset management.
  • Develop and deliver business solutions across all Products industries.

Confidential, Kansas City, MO

SR Database Administrator

Responsibilities:

  • Install ed and configure d Oracle 11g /10g RAC using ASM for storage,
  • Implemented and monitored daily incremental and weekly full backups using RMAN.
  • P erform ed database cloning with RMAN from production to non-production databases servers
  • Designed, implemented and troubleshoot Oracle Dataguard for disaster recovery.
  • Upgrade d Oracle database versions 9i and 10g to version 11g GRID while converting optimizer to CBO.
  • Responsible for managing SQL Servers running on 2012.
  • Monitoring and Controlling access, permissions and privileges
  • Troubleshooting and resolving database integrity issues, and deadlocking issues as well as performance issues related to blocking sessions.
  • Responsible for monitoring SQL Server related CPU, memory, I/O, disk space and other resource contention issues.
  • Perform ed database performance tuning activities using tools like AWR/ADDM reports, Active Session History Reports and SQL tuning advisors
  • Monitored and corrected performance issues on SQL Server via Query tuning, SQL Profiler, Execution Plan, Wait statistics etc.
  • Designed and implemented Oracle user audit collection (LPA).
  • Analyze d database failures, identified and document ed corrective measures needed to maintain our SLAs
  • Performed database hardening post development and testing duplications.
  • Identified and resolved performance bottleneck s, storage issues and other Operating Systems related optimizations hiccups.
  • Provide d customer support to hosted Clients while coordinating clients’ support with Oracle support
  • Provided technical direction, development, training and mentoring to new DBAs as well as team members and clients as needed.

Hire Now