We provide IT Staff Augmentation Services!

Database Administrator Resume

4.00/5 (Submit Your Rating)

Orlando, FL

SUMMARY:

  • Over 7 years of hands - on experience as an Oracle Database Administrator and about 8Months as a RDBMS Security Administrator with ORACLE SUPPORT TEAM.
  • I have complete life cycle knowledge including Installation. I have worked on different versions of Oracle release ranging from 9i, 10g, 11gR2 12c involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security.
  • Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK.
  • Expert in implementing High Availability solutions with Oracle 11g and 12c RAC, Oracle Data Guard Extended Cluster setup with RAC 12CR2 and FLEX ASM.
  • High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance.
  • Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
  • Wallet creation and Transparent Data Encryption (TDE) to protect data at rest.
  • Setup of Access Control List (FGA), HTTP, SMTP, MAIL SERVER.
  • Setup Secure Socket Layer (SSL)/Transport Layer Secure (TLS) and Native Network Encryption (NNE) to prevent data from hackers on the network.
  • Experience with Oracle 11g/10g in Installation, Administration, Monitoring, Database Backup and Recovery.
  • Proficient with Database Cloning, Migration, and Patching of Oracle Databases.
  • Upgrade/Migration of oracle databases from 11.2.0.1 to 11.2.0.4 and 11.2.0.4 to 12c
  • Worked on Set up, configuration and maintained Oracle Data Guard/Active Data Guard to control Primary and Secondary databases and also to ensure disaster recovery using various data protection modes.
  • Expert in RMAN backups including full, incremental and cumulative.
  • Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.
  • Extensively worked on Import/Export and Data Pump Import/Export tools.
  • Knowledge in configuring ASM (Automatic Storage Management)
  • UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
  • Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.

TECHNICAL PROFICIENCIES:

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

RDBMS: Oracle 10g, 11g, MySQL

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL.

Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM, Toad, Putty, NX client, Winscp, SPOTLIGHT

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Table spaces, SQL*Loader, RMAN, Data Pump, Export, Import, 12C Grid control, TDE, SSL, TLS, ACL

PROFESSIONAL EXPERIENCE:

Confidential, Orlando, FL

Database Administrator

Responsibilities:

  • Database CLONING from either PRODUCTION to Test or QA environment using RMAN UTILITY, and also doing SCHEMA REFRESH using DATA PUMP UTILITY.
  • Scheduled daily PUMP job running from Splunk.
  • Support Applications like COSTPOINT, HYPERION, Etime, DATA WAREHOUSE, ENTERPRISE DATA WAREHOUSE, TIME and EXPENSE, PEOPLESOFT.
  • Worked on application and database security (data access, passwords resets and users account management, network, Account provisioning etc).
  • Work with Auditors to manage system compliance and also to follow the SOP of the company.
  • Monitor jobs which are setup to manage the SOP. Jobs like TLX and DORMANCY which monitors users account when a user is either Transferred, on a Leave, or Terminated wallet & encryption key creation, configuration and maintenance
  • Experience in configuring TDE encryption
  • Scheduled and monitor Unified Audit UAT Job running from Crontab and Tidal.
  • Monitor databases using Oracle enterprise monitor technologies leveraging Oracle Enterprise Manager (OEM), 12c, TOAD.
  • Scheduled daily backup from TIDAL and CRONTAB using RMAN UTILITY.
  • Worked extensively with Developer and application managing teams in helping to deploy scripts to the databases.
  • Tuning and Validating Backups and Monitoring All Database Backups.
  • Configured and installed Oracle Enterprise Manager cloud console and Deploy/add Agents to the console.
  • Working with Oracle Advance Security Options like TDE, SSL, TLS, DB VAULT, MASKING
  • Monitor databases using Oracle enterprise monitor technologies leveraging Oracle Enterprise Manager (OEM), 12c, TOAD.
  • Worked extensively with Developer and application managing teams in helping to deploy scripts to the databases.
  • Working on both AWS and DBaas cloud. Working on Bare Metal servers and compute node on the DBaas,
  • Installing and configuring Data guard from Bare Metal server on DBaas.
  • Tuning and Validating Backups and Monitoring All Database Backups.
  • Handled daily production problems/service requests with Oracle.
  • Oracle Database monitoring, troubleshoot and resolve the issues.
  • Troubleshoot performance issues within the databases.
  • Monitor and troubleshoot the alerts on disk space, memory and job failures etc.
  • Troubleshoot and resolve RAC\Cluster issues.
  • Expertise in maintaining Database Security using auditing. And also SQL SERVER login Auditing
  • Strong skills with Visual Studio 2008, 2012, 2016
  • Expert skills in SQL SERVER performance Tuning, creating Indexes, PK, queries, table joins, where causes, grouping, temp tables in T-SQL.
  • Expert skills in inserting and updating SQL statements in T-SQL
  • Knowledge in applying SERVICE PACK and UPGRADE SQL SERVER database from 2012 to 2016 version
  • Expert with Online (Simple $ Full Recovery Model) and Offline backup (Detach $ Attach method) to TAPE, DISK or URL (AZURE)
  • Migrate SQL Databases to AZURE
  • SQL SERVER Export/Import using SSMS and Command line ( BCP)

Confidential, Lehi, UT

Database Administrator/ Security Analyst

Responsibilities:

  • Working with Oracle Advance Security Options (ASO) for My Oracle Support (MOS) Team, TDE, NETWORK ENCRYPTION, DATABASE VAULT, SSL/TLS, KERBEROS, ACL, Web SERVER Encryption SMTP,HTTP,HTTPS,LDAP, TCPS using wallets and HSM PKCS#11. professional exposure to and use of Oracle 12c / 11g RAC database technology deployments
  • Filling BUG with developments on issue from customers who need enhancements or fixes on their current version of oracle they supporting.
  • Expert in troubleshoot and fixing issue for different customers who log in Service Request. ORA Errors like ORA-600, ORA-7445, ORA-700 (internal error), ORA 24247 Access control list denied by server. ORA 28374: typed master key not found, 28365 DURING A BROKER SWITCHOVER WHEN USING A WALLET, 0RA-29024 Certificate Validation Failure, ORA-01031: insufficient privileges, ORA-01017 professional exposure to and use of Oracle 12c / 11g Automatic Storage Management (ASM) storage option deployed to support Oracle RAC and standalone databases professional exposure to and use of Oracle 12c / 11g RMAN backup/recovery technology integrated to centralized backup solutions such as Veritas Netbackup, IBM Tivoli.
  • Database CLONING from either PRODUCTION to Test or QA environment using RMAN utility, and also doing SCHEMA REFRESH using DATA PUMP Utility. professional exposure to and use of enterprise level database Disaster Recovery solution using Oracle Dataguard 12c / 11g for Oracle RAC databases . professional experience with OS/DB platform migrations of legacy Oracle database releases involving multi - terabyte databases between UNIX and LINUX platforms. experience to Oracle enterprise monitoring technologies leveraging Oracle Enterprise Manager (OEM)11g, 12c, TOAD
  • Lead successful project implementation like Transparent Data Encryption on RAC, DG and Standalone Servers, SSL/TLS Implementation, Data Migration, Upgrade/patching projects, Data Guard setup.
  • Help customers on setting up AUDIT POLICIES depending on their database version. “STANDARD AUDITING, MIXED MODE and UNIFIED AUDITING”.
  • Installation of 12c RAC 2 NODE WITH EXTENDED CLUSTER, HUB NODE and LEAD NODE. Also managing FLEX CLUSTER and FLEX ASM.
  • Creating and managing oracle wallet using tools like ORAPKI, OWALLET MANAGER, MKSTORE.
  • Creating Secure External Password Store (SEPS) using MKSTORE Utility to authenticate database users externally. professional exposure to Upgrade database from 11g to 12c with TDE enabled either Manually, DBUA, DATA GAURD METHOD or Transportable Tablespace Method.
  • Expert in helping customers download and apply either the PATCH SET UPDATE (PSU), CRITICAL PATCH UPDATE (CPU), WINDOWS BUNDLE PATCH, or ONE OFF PATCH (OOB) using the latest version of OPATCH UTILITY
  • Setting up Data Redaction policy using DBMS Data Redact policy, Data Masking and Subsetting to prevent the exact copy of production data to Tester and Analyst. There by enforcing company security policies using OEM TOOL

Confidential, Raleigh, NC

Oracle Database Administrator

Responsibilities:

  • Deployment Team: Assess and validate Scripts, Working with Developers and Sys Admins.
  • Wallet creation and Transparent Data Encryption Under 11g, 12c
  • Installation and maintenance of Oracle 12c/11g/10g on Linux OS, Window OS
  • Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.
  • Patching and Upgrades (CPU and PSU). Upgrade/Migration of oracle databases from 11.2.0.1 to 11.2.0.4 and 11.2.0.4 to 12c
  • Applications and users support, maintaining a 0% down time
  • Designing and developing SQL procedures, query performance tuning.
  • Performed hot and cold backup and recovery using RMAN and UNIX Scripts
  • Monitored database (RAC and STANDBY) and SQL performance, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.
  • Worked on application and database security (data access, passwords resets and users account managment, network, etc).
  • Handled daily production problems/change requests with Oracle.
  • Monitoring of all Oracle Databases both Prod, Qa,Dv,Sit, Training using OEM Grid Control 12c
  • Tuning and Validating Backups and Monitoring All Database Backups.
  • Handled daily production problems/service requests with Oracle.
  • Performed daily database administration tasks: Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
  • Performed Physical backup as well as Logical backup (Export/Import).
  • Installation and Configuration of new Database.

Environment: ADMS, APPS DB, Winscp, SQL Developer, Service Now, Windows Server 2008, Oracle 11g 12c, SQL*Plus, Script guard, Putty

Confidential

OBALOracle Database Administrator

Responsibilities:

  • Worked extensively on Oracle Installation, Oracle Version Upgrade, Migrations (from 10.2.0.4 to 11.2.0.3 and from 11.2.0.3 to 12.1.0.2) on both Single Instance and RAC Servers.
  • Applied quarterly patches both CPU and PSU on standalone database and RAC environments.
  • Configuration, installation and administration on 2 NODE RAC,
  • Configured Bi-Directional Golden Gate, for replication, Migration and Upgrade of production Servers with Zero downtime.
  • Proactive database monitoring using 10g/ 11g/12c grid monitoring tool OEM.
  • Weekly Change Approval Board (CAB) meetings to meet internal goals of keeping customer security compliance and preventing security Vulnerabilities.
  • Setup backup and recovery procedures using RMAN and Net backup. Used hot backups and cold backups, incremental and full backups.
  • Performed database Cloning from Production to test scripts before deploying them to production environments.
  • Daily Exports/Imports of database objects from Production to UAT and TEST environments.
  • Worked extensively with APP DBA’S and Developer.
  • Supported Applications like EBS, PEOPLESOFT, SEIBAL.
  • Worked in deploying scripts to PROD, CAT, DEV and TEST environment.
  • Monitored applications in doing backup and recovery, performance, upgrade, schema refresh,

Confidential, Dearborn, MI

Oracle DBA

Responsibilities:

  • Configured 10gR2/11gR2 12cR2 RAC with ASM on AIX/ RHEL servers and GPFS/Oracle cluster files systems and also configured workload management (both server side and client side Load Balancing).
  • Implemented the MAA (Maximum Availability Architecture) having 11g Physical Standby Data Guard for 2 Node RAC System.
  • Implemented the Oracle 10.2.0.4 Physical Data Guard in Maximum Performance Mode for re hosting of data center using Data Guard.
  • Implementing GOLDEN GATE(Bidirectional) for replication, real time analysis, migration, upgrade without down time.
  • Configuration, installation and administration on 2 NODE RAC,
  • Experience in migrating large databases up to 800 GB
  • Proactive database monitoring using 10g/ 11g/12c grid monitoring tool.
  • De - fragmentation/Reorganizing of database using Export/Import, Rebuild Index and move table.
  • Management of schemas, objects partitioning the tables & indexes.
  • Restructuring database performance by writing pl/sql code, Rebuilding indexes
  • Responsible for setting and managing user accounts, Granting required privileges to users.
  • Implement backup and recovery procedures using RMAN for Oracle databases and test regularly in conjunction with Operations. Configuring scripts for backups (hot, cold and incremental).
  • Writing Shell scripts for Alerts for ORA- errors, backup and recovery, Import and export procedure, Unix Shell scripting in csh, ksh to be controlled from Crontab.
  • Used Oracle streams for Data replication, Data warehouse loading, Event notification as well as business event mgt.
  • Installation and Configuration of Oracle Advanced Security Option (ASO).
  • Involved in Data Warehousing, Data Modeling, Database Design and Creation
  • Troubleshoot Database performance (tuning) issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
  • Involved in upgradation of more than 20 Databases each sizing at least 500GB to 800GB from 9i to 10g and 10g to 11g & also involved in migration oracle databases from windows to Linux and 32-bit to 64-bit.
  • Designed and developed logical and physical data models using CASE tools such as ERWin and Oracle Designer 10g and using manual methods as well.
  • Setup backup and recovery procedures using RMAN and Net backup. Used hot backups and cold backups, incremental and full backups. Performed database cloning to setup test and development databases.
  • Used Flashback technology to recover (Point-in-Time-Recovery) accidentally dropped or modified database objects.
  • Perform other regular DBA activities including space management and performance monitoring.
  • Oracle Database monitoring, troubleshoot and resolve the issues.

Environment: Windows NT / 2000, HPUX, AIX 6.1, 5.3 and Linux, ESX, MS SQL Server, Oracle 9i and 10gR2/11gR2, TOAD 7.5.0.0/7.6 Database Tools/Utilities, Enterprise Manager

We'd love your feedback!