We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Richmond, VA

SUMMARY:

Highly skilled, analytical, and multifaceted professional, with comprehensive skills in technical operations, desktop support, troubleshooting, as well as data and project management. Commended for proven track record of success in managing in oracle database operations and completing large scale projects while ensuring on - time delivery. Armed with strong dedication to leverage well-rounded skills to drive organizations toward business growth and development. Expert at utilizing technical proficiency and keen eye for detail in identifying improvement needs and responding to clients’ requirements. Effective at multitasking in a fast-paced environment.

TECHNICAL SKILLS:

Databases: Oracle Database (9i, 10, 11g and 12C)

Software/Tools: Oracle (RMAN, Statspack, GoldenGate, RAC, DataGuard, and Grid Control)| DBMS STATS | Data Pump, SQL TRACE| TKPROF| EXPLAIN PLAN | SQL | PL/SQL | TOAD | Automatic Database Diagnostic Monitor (ADDM) |Automatic Workload Repository (AWR) |Active Session History (ASH) |SQL-Tuning Advisor | DBVERIFY

Operating Systems: VMS | Sun Solaris | Windows Server 2003 | Red Hat Linux | SQL Server | Oracle Enterprise Manager

Web Tools: HTML and XML.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Oracle Database Administrator

Responsibilities:

  • Rendered effectual support in the execution of database configuration, upgrade, patch migrations, backup and recovery, performance tuning, and cloning efforts
  • Handle the cloning of non-multitenant container database to pluggable database in 12c through PDB Metadata Cloning, PDB Remote Cloning, and PDB Snapshot Cloning features
  • Reorganize databases and refresh of schema using import and export processes
  • Design different databases with table spaces, tables, indexes, setting privileges, and user logins, as well as physical databases with multiple table spaces from logical and physical data model
  • Created partitioning strategies for very large tables, while deploying range, list, hash and various sub partitions as well as structure of logical and physical database through logical and physical data modeling
  • Perform database sizing, table space management, rollback table space management, transaction management, and security administration
  • Monitor physical standby databases and high-volume production databases ranging to 25 TB in size
  • Serve as an effective member of the team providing 24/7 technical support with on-call rotation for all production, quality assurance (QA), and development environments, while managing multitenant databases, such as Oracle 12c Container and pluggable databases
  • Act as point of contact on 12c new features, such as redaction policy, adaptive query optimization, multiple indexes on single column, and restoration table using RMAN
  • Assist developers in improving SQL, PL, and SQL codes, while generating new user accounts and executing schema and related user administrative tasks
  • Served as integral part of the team that led the configuration of Golden Gate for real-time replication and data guard for disaster recovery and RAC for high availability
  • Strategically utilize Oracle Enterprise Manager (OEM) for database monitoring maintenance, replication and performance tuning as well as Oracle Data Pump (expdp and impdp) for high-speed, parallel, bulk data, and metadata movement for all Oracle database contents
  • Implemented a 11g databases on both IBM-AIX and Linux environments using OLTP, decision support system and data warehousing environment
  • Modified databases from 9i to 10g, 10g to 11g, 11g to 12c using DBUA and scripts along with 10g and 11g standalone databases to 11g and 12c 2-node RAC respectively
  • Configured Oracle 12c Enterprise Manager to keep track and generate accurate condition report for more than 500 databases
  • Secured physical standby database in Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5RAC databases
  • Enforced proactive monitoring database through Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace, TKPROF, and EXPLAIN PLAN
  • Rolled out a variety of advanced security measures as per service level agreement (SLA), such as Transparent Data Encryption (TDE), data masking, and data redaction
  • Developed OEM database control for single databases and OEM Grid control for multiple databases
  • Earned the Employee of the Year Award in recognition for outstanding leadership in the successful execution and completion of various projects

Confidential, Richmond, VA

Oracle Database Administrator

Responsibilities:

  • Installed 9g, 10g, 11g, 12c, along with 12c container databases (CDB) on standalone servers and cluster on UNIX, LINUX, and Windows platforms
  • Launched physical standby databases on 2-node 11gR2 Real Application Cluster, while automating scripts to clear already applied archive logs on standby databases
  • Implemented Oracle Wallets and Tablespace level TDE security
  • Created different backup strategies, such as Cold, Hot, and RMAN with flash recovery area and logical backups (expdp and impdp)
  • Devised a PSU on standalone test environment and production cluster through OPatch Auto
  • Modified multiple standalone databases and grid infrastructure from 11gR2 to 12cR1
  • Made use of DBMS Confidential in redefining and partitioning tables and columns data types, as well as placing LOBS to different table space
  • Performed hot and cold backup, recovery, and cloning of databases using RMAN with VERITAS Net Backup and Commvault
  • Initiated detailed recommendations and implementation of SQL access and tuning advisors, while handling chained rows and row migration
  • Made use of SAN level storage mirroring in improving environments for the data refreshing of large production data warehouse environment
  • Closely worked with the Application Team in enhancing application performance within clustered environment
  • Contributed in the migration of large size database in multiple platforms, along with the SQL Query tuning to issue tuning recommendations for application jobs, time and CPU consuming queries
  • Assisted the development teams in addressing and solving all database related issues, including network failures, ASM DISK group errors, and node failures in the RAC cluster
  • Assisted in configuring and installing Golden Gate, while administering pumps and trail files through removal of old extract and log files
  • Guaranteed proper production, security, and performance of all application design in accordance with standards
  • Analyzed the release of Oracle tools and third-party products to secure accurate operation of products and site in alignment with client’s requirements
  • Led the successful upgrade of databases from 11g to non CDB 12c, along with the migration of 12c Non CDB databases to pluggable databases
  • Administered the implementation and maintenance of Oracle 11g Data Guard and standby databases for fail-over purposes, along with Oracle TDE to deliver transparent encryption of stored data to support release of Oracle 11g R2
  • Brought significant security improvements by through effective network data encryption and implementation of SSL wallet, thus safeguarding the network connection
  • Dispatched applications across multiple nodes by creating database services using all command line utilities server control utility (SRVCTL), cluster ware control (CRSCTL) utility, automatic diagnostic repository (ADR), and ASM command-line utility (ASMCMD)

Hire Now