We provide IT Staff Augmentation Services!

Senior Database Administrator Resume

Bothell, WA

PROFILE SUMMARY:

Senior Oracle Database Administrator and Technical Project manager possessing 10+ years of IT industry experience.

TECHNICAL SKILLS:

  • Oracle 12.2 / 11.2..3. x / 11.2.0.4.x Internals
  • Oracle Real Application Clusters (RAC)
  • Oracle Data Guard
  • Oracle ASM
  • Backup and Recovery Manager (RMAN)
  • Database Design
  • Provide support to Dev Ops on Skytap / AWS cloud
  • Performance Tuning
  • Mview based data replication
  • Distributed Databases
  • Disaster Recovery Solutions
  • Data Modeling
  • Oracle cold cluster (OCC) HA solution.
  • Oracle OID migration
  • Oracle Partitioning

WORK EXPERIENCE:

Confidential, Bothell, WA

Senior Database Administrator

Responsibilities:

  • Production DBA Support and DBA Primary Point of contact for a number of customer facing 24x7 Large Oracle Database environments including Insurance agency apps named BenefitPoint insurance broker marketplace, ETL (Broker content extracts) and Oracle application Gateway databases on Oracle Enterprise Linux / Oracle 12.2 / Oracle 12.1 / Oracle 11.2.0.4 / Oracle 11.2.0.3 using Oracle RAC / Oracle Single Instance / Oracle cold cluster and Oracle Grid Control technologies.
  • Managed key database migration projects from 10g to 11g with Oracle Confidential (Transparent Data Encryption) and most recently into Oracle 12c.
  • Performed various Oracle database administration duties such as
  • Oracle Space monitoring and Pro - active database session monitoring.
  • 24x7 Production DBA on-call support and timely resolution of tickets.
  • Oracle software installation and Database creation.
  • Provided technical support for database environments, including testing and installation of DBMS upgrades and Quarterly Oracle PSU Patching.
  • Assisted in documenting database strategies and architectures.
  • Participated in tool evaluation, integration and support.
  • Monitored the performance of production systems and utilize appropriate tools to identify tuning requirements.
  • Participated in logical and physical database design and assist application developers in applying DBMS technology.
  • Primary point-of-contact for app/database related issues and worked on timely resolution.
  • Worked with Dev, Hosting, Deployment and Network teams to troubleshoot and resolve problems.
  • Managed Capacity planning, Performance and Tuning of databases.
  • Worked with team members in keeping the software solution consistency.
  • Participated and adhered to IT Change Management processes.
  • Evaluated new oracle (database) technology features and give quick overview to the DBA team members and management.
  • Researched, planned, communicated and helped various oracle database initiatives across DBA and Infra teams based on customer input.
  • Provided input and supported new projects.
  • Worked directly with Oracle support regarding product support SR’s and other database related questions.
  • Develop and Implement Data Archiving, Disaster Recovery and Data Encryption strategies.
  • Liaison between several IT work groups and database team for many internal projects.

Confidential, Bellevue, WA

Sr. Database Administrator / Consultant

Responsibilities:

  • Worked on a Database migration and modernization team at Boeing company.
  • Managed DB/App migration activities between Data centers which includes meet customers on a daily basis, come to agreement on DB and App migration plans/paths, create and establish test environments for testing the DB/App migration and plan and execute migration of Production DBs between Data Centers.
  • DB migration included a no. of flavors of Operating Systems and DB versions.
  • Sun-Solaris / HP-UX / Oracle Enterprise Linux 5 / Windows / Oracle11gR2 and RAC / Oracle10g RAC / Oracle 10g / MS SQL Server.

Confidential, Bellevue, WA

Sr. Systems Analyst (IT) / Sr. Database Administrator

Responsibilities:

  • Production DBA Support and DBA Point of contact for a number of 24x7 Large Oracle Database environments with terabytes of da ta including Wireless Billing, B2B online website and Data Warehouse systems on Sun-Solaris / HP-UX / Oracle Enterprise Linux 5 / Oracle11gR2 and RAC / Oracle10g RAC / Oracle 10g.
  • Performed various database administration duties such as
  • Space monitoring and Tuning Storage parameters.
  • Database capacity planning.
  • Monitor and administer User processes using UNIX scripts and OEM grid control.
  • Pro-active database session monitoring.
  • 24x7 Production DBA on-call support and timely resolution of severity tickets.
  • Oracle software installation, Database creation.
  • Plan and implement Oracle Software version and Database upgrades.
  • Research, plan, communicate and help implement, track various oracle database initiatives across DBA team.
  • Evaluate, Document, Implement and present new oracle features and implementation guidelines to the team.
  • Liaison between several IT work groups and database team for many internal projects.
  • Provide complete software lifecycle support to development, test and prod environments for various application upgrades.
  • Provide DBA Support to Database development / data conversion / software release teams in tuning SQL query and PL/SQL code.
  • Managing non-prod database environments such as Development, Unit Test, Production staging, Emer staging.
  • Provide support for load testing in pre-prod environment.
  • Backup & Recovery using BCVs, VERITAS Net Backup, Oracle RMAN, Exp/Imp and Oracle Data pump. Database cloning, Test Database refresh from Production.
  • Performance monitoring and Tuning using Oracle AWR and OEM Grid Control.
  • Perform Database maintenance activities such as rebuild table/ index / partitions.
  • Implement DB Audit and Security features per Oracle Payment Card Industry guidelines.
  • Develop and Implement Data Archiving, Disaster Recovery and Data Encryption strategies.
  • Database Functional lead experience in the areas of Database Tuning and Database Security.
  • Worked with IT Security in the capacity of DB Security lead for various enterprise initiatives such as Payment Card Industry and SSBCO audits on customer facing databases/applications. Drive the audits to success.
  • Protect Data from unauthorized users with the installation of Oracle Database Vault security realms.
  • Support MSSQL Server 2005 and 2000 Installs / Creating Databases / DB Administration and day-to-day support.
  • Experience working with the following compliance standards: Sarbanes Oxley, HIPAA, PCI audits.

Hire Now