We provide IT Staff Augmentation Services!

Senior Database Administrator Resume

RestoN

SUMMARY

  • Oracle Certified Professional (OCP) with 11 years of extensive experience
  • All round experience analyzing, planning, developing, implementing, testing, maintaining and administrating
  • Extensive experience in installation, support, development, backup, recovery, daily auditing and performance tuning
  • Experience in transportable table spaces, data pump, flashback table, table space management, materialized views
  • Managed 100 to 150 databases (including production & non - production environments) from 100GB to 10TB
  • Experience in Oracle Exadata machine
  • Having knowledge on AWS concepts and experience on RDS oracle databases.
  • Experience in Oracle Golden Gate 11g/ 12c
  • Knowledge on Database Vault.
  • Experience in heterogeneous replication between Oracle & Microsoft SQL Server
  • Upgraded 10g ASM to 11g ASM Grid Infrastructure
  • Install, configure and test 11g ASM Grid Infrastructure
  • Experience in Database migrations including to ASM
  • Excellent Administration skills in handling Real Application Clusters (RAC) databases
  • Experienced with Oracle 10g/11g/12c RAC
  • Installed and Configured 2 nodes RAC
  • Converted single instance Databases to RAC
  • Added nodes to existing cluster configuration
  • Configured Services for Load balancing using TAF (TRANSPARENT APPLICATION FAILOVER) policy parameter
  • Worked on multiple platforms including UNIX SUN Solaris, Red Hat Linux and Windows.
  • Basic knowledge on AWS Cloud.

PROFESSIONAL EXPERIENCE

Operating Systems: Linux, Solaris, Unix, Windows, AIX.

Databases: Oracle 9i, 10g, 11g, 12c, 10g11g/12c RAC, Oracle Golden Gate 11g/12c, Oracle Exadata Quarter Rack, SQL Server, Oracle Cloud Service

Tools & Utilities: RMAN, OEM, SQL Loader, OEM Grid Control, SQL Plus, DBCA, Import/Export, Data Pump, Toad for Oracle, Sybase ASE 15,12.5, Cygwin, DBAAS

Programming Languages: T-SQL, PL/SQL, Shell Scripting, VB Scripting, C++, VC++

Office Tools: Microsoft Office Suite (Word, Excel, PowerPoint, Outlook)

Other Tools: VMware, Symantec Scheduler, Remote Desktop, Lotus Notes, Back office automation Tools

PROFESSIONAL EXPERIENCE

Confidential, Reston

Senior Database Administrator

Responsibilities:

  • Knowledge on DataStax Ops center for Cassandra.
  • Database creation for 11gr2 RAC upon on business request.
  • Analyze session related views and identify blocking sessions / resource hungry queries and resolve them.
  • Find out instance level issues and locking from grid/cloud control.
  • Working with users to solve the slowness queries.
  • Extensive knowledge on Dataguard both Standby and Logical.
  • Experienced on Golden gate.
  • Installing 10g/11g RAC Oracle databases using response file on Linux/Solaris servers.
  • Upgraded the RAC databases 10g /11g and 12c.
  • Experienced in applying PSU7 patches on rolling fashion on 3 node RAC 11gr2.
  • Experience in Data guard implementation (Physical standby database) with ASM storage on 3node RAC.
  • Handling database Jira tickets daily on priority bases.
  • Knowledge on AWS concepts and experience on RDS.
  • Experienced in Data migration from On-Premise Oracle database to AWS EC2 instance by using Golden Gate real time replication.

Environment: Oracle 11g/12c OEM, TOAD, SQL, PL/SQL, UNIX (Solaris, HP), Linux 3.x/4.x,Veritas VCS clusters. UNIX Shell Script, Windows NT/2000/2003, Oracle 11g/12c RAC, Data Gaurd, RMAN, Autosys, ServiceNow, GoldenGate 11g/12c

Confidential

Senior Oracle Database Administrator and

Responsibilities:

  • Golden Gate up gradation on test, dev, staging and Production
  • Extensive knowledge on troubleshooting Golden Gate issues
  • Worked on Critical issues on Golden Gate and Bug fixes
  • Experienced in applying latest Golden Gate patches
  • Implemented Golden Gate 12.2 new features
  • Experienced on heterogeneous replication from Oracle to SQL Server
  • Extensive knowledge on Oracle database Performance Tuning
  • Installing 11g/12c RAC Oracle databases using response file on Linux/Solaris servers
  • Experienced in RAC troubleshooting issues
  • Analyze AWR/ADDM reports based on the issues. Using tuning advisors as required. If required force the execution plan to use required execution paths
  • Resolving the SQL performance issues using the tools such as SQLT, AWR, SPM
  • Analyzing the plan changes for the problematic SQL’s and fixing it by using SQL baselines, SQL profiles, hints, parallel degree and other resolvable factors
  • Provide and implement performance tuning recommendations of all components in Exadata database machine.
  • Work with developers in tuning SQL and suggesting changes, leveraged Real Time SQL Monitoring, SQLT extract, and trace analyzer tools to analyze poorly performing SQL
  • Working with oracle vendor for following up with Performance service requests and other issues
  • Configured Data guard on 3 node RAC for critical production databases
  • On support for ExaData databases
  • Upgraded classic extract to integrated extracts for all the environments in Golden Gate
  • Experienced Golden Gate on Exadata Machine with DBFS mount points
  • Configured XAG Agent on Golden Gate for High Availability
  • Configured JAgent on Golden Gate for monitoring and deployed GG plug-in through OEM

Environment: Oracle 11g/10g RAC10g/11g/12c,Exadata X4-2, Exadata X6-2, SQL, MSQL 2008R2, Linux, UNIX Shell Script, Incident Management, Change Management

Confidential

Oracle Database Administrator

Responsibilities:

  • Installed Golden gate replication for source and target databases
  • Extensive knowledge on Performance Tuning
  • Experienced on Golden gate
  • Installing 10g/11g/12c RAC Oracle databases using response file on Linux/Solaris servers
  • Experienced in applying PSU7 patches on rolling fashion on 3 Node RAC 11gr2
  • On support for Exadata databases.
  • Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash cache, etc.
  • Analyze and determine the feasibility of leverage the Oracle Enterprise Manager solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.
  • Applied Patch set for Golden gate from 11.2.0.12 to 11.2.0.24
  • Experienced on Golden gate up gradation from 11g to 12c.
  • Experienced on both bi directional replication in Oracle Golden Gate
  • Having knowledge on Oracle Exadata storage sever
  • Having knowledge on Oracle Exadata OEDA (Oracle Exadata Deployment Assistant)
  • Monitoring Exadata storage server through CELLCLI and DCLI
  • Monitoring Griddisks from CELLCLI
  • Creating Griddisks on all Exadata cells with the DCLI
  • Implemented TDE(Transparent Data Encryption) in Golden Gate for one of our customer to secure the data which is
  • Mnaging team of DBA’s (infra structure) on site and off site spread across the Confidential . DBA categorized administration.
  • Application, Operation, Production, Change Management, On-call support and performance optimization.
  • Implemented the automation scripts for the disk and mount alerts for the server’s to ignore the alerts.
  • Team Monitoring and One on One with individual team members.
  • Database migration From Windows to Linux Using RMAN.
  • Configured RMAN jobs through OEM and as well command prompt.
  • Responsible for the each and every individual tasks and updates from the team.
  • Applied CPU patches on various production databases.
  • Day to day resolving the incident tickets.
  • Managed archived redo files, DB-links & Partitions, loading data for users by using SQL*Loader.
  • Implementing and handling issues with Backup and Recovery strategies for Oracle databases
  • (Logical Export & Import, Physical Online and Offline & RMAN) & disaster recovery procedures.
  • Analyze, tuning and optimizing the database by using performance monitor. Assist the SQL

Confidential, Reston, VA

Oracle and Sybase Primary Production DBA

Responsibilities:

  • Worked as Oracle and Sybase DBA across all Confidential databases approximately 1100 Oracle and 400 Sybase databases.
  • Worked with application team on database requirements and designed the database as per the application.
  • Performed all phases of administration support like user administration
  • Upgraded 10g to 11g on many production and acceptance databases and applied CPU patches.
  • Setup Data guard Configuration using Physical Standby Configuration.
  • Setup active standby using 11g.
  • Installed and Configured RAC on Oracle 10g/11g on Linux and Solaris.
  • Extensively worked performance tuning.
  • Used Data Pump Export/Import and RMAN for Backup and recovery.
  • Used RMAN tool for Backup/Recovery of Databases.
  • Improved the performance of the existing system by re-sizing the Database objects such as Tables, Indexes and rollback segments to make the performance at optimal levels.
  • Tuning memory areas with Emphasis on Tuning Rollback segments, Buffer cache, library cache, Dictionary cache and shared pool to obtain optimal System performance.
  • Capacity planning - Based on volumetric from a data model, calculate size of tables and associated indexes, accounting for fragmentation and growth.
  • Applied Security Patches (CPU) to Databases.
  • Wrote Unix Shell Scripts to monitor system status.
  • Deciding on Logical Structures such as Table spaces, Number and Size of Rollback Segments
  • Tuning the SQL, stored procedures and instances using AWR reports.
  • Database Backup Strategy Design and Implementation.
  • Backup and Recovery of databases including use of export/import.
  • Monitor and set up replication between production and contingency database
  • User and security maintenance creating users, dropping users, alter users etc
  • Perform backup and recovery of user databases.
  • Trouble shooting performance issues.
  • Performed backups and restorations and re-syncing data.

Environment: Oracle 11g/10g/9i OEM, TOAD, SQL, PL/SQL, UNIX (Solaris, HP), Linux 3.x/4.x,Veritas VCS clusters. UNIX Shell Script, Windows NT/2000/2003.

Confidential

Oracle DBA

Responsibilities:

  • Assisted in Database Installations (all versions up-to 10g and 11g).
  • Work with software developers to develop and enhance applications.
  • Maintain the Oracle 10g RAC environment and troubleshoot performance problems.
  • Conducted optimization and performance tuning of database, SGA.
  • Managed archived redo files, DB-links & Partitions, loading data for users by using SQL*Loader.
  • Effective troubleshooting of Performance and tuning problems in Oracle databases by taking 10046 and 10053-errorstack traces.
  • Handling issues related to Database Upgrade/Migrate and Patching.
  • Handling RAC, DATAGUARD, and ASM issues.
  • Installed Oracle 10G RAC on Linux platform using ASM & OCFS2.
  • Implementing and handling issues with Backup and Recovery strategies for Oracle databases (Logical Export & Import, physical Online and Offline & RMAN) & disaster recovery procedures.
  • Monitoring the database growth, checking for the performance bottlenecks and taking backups for disaster recovery.
  • Finding fragmented objects & reorganizing them.
  • Gathering optimizer statistics using dbms stats procedure.
  • Creating & rebuilding the indexes.
  • Support developers in tuning Database and applications for optimal performance.
  • Upgrade, analyze and testing of the test and production database.
  • Analyzing STATSPACK, AWR, ADDM and TKPROF and 10046 traces for diagnosing the root cause of the issues.
  • Creating and maintaining table spaces, tables, indexes, users, roles, privileges and security.
  • Tuned the multiple databases for Performance. Involved in security audit of databases and servers.
  • Wrote packages, functions and procedure for reporting.
  • Experience in installation and configuration of Oracle 10g RAC software.
  • Used table partitioning to store year to date transactions in the database.
  • Requirement capture, analysis of requirements, design solution based on clients needs.
  • Exposure to full life cycle of product development starting from requirement analysis to deployment and maintenance.
  • Used PLSQL Records, Collections (Nested Tables and Arrays) in complex backend packages.
  • Wrote SQL*Loader script file for reading data from text file and loading into oracle table.
  • Involved in the management of customer logged issues by providing priority based timely resolution.
  • Assisted in design of tables, databases, forms and reports.
  • Coded, tested debugged, documented, and maintained programs.
  • Documentation of user manual and other generic documentation required for the module.

Environment: Oracle 9i, SQL, PL/SQL, SQL Loader, Linux, UNIX, Toad.

Hire Now