We provide IT Staff Augmentation Services!

Senior Oracle Database Administrator Resume

0/5 (Submit Your Rating)

MarylanD

SUMMARY

  • Have 13+ years of extensive IT experience as Senior Database Administrator, with hands on experience in database administration, production support, installation, configuration, upgrades, patching, performance tuning, backups, space management, database security, auditing, and database development in Oracle, Oracle Apps DBA activities, SQL Server DBA activities and Tableau Administration as well.
  • Having 8 years of experience as an Oracle Database Administrator
  • Good exposure on Oracle 9i,10g/11g/12C/19C Database Administration and Oracle Architecture
  • Having experience in Installation of Oracle 11g, 12c, 19C in UNIX/LINUX environment.
  • Analyzed, developed, and executed plan to migrate oracle on prem database to AWS cloud. worked on AWS DMS for Migrating Oracle databases from on Prem to AWS Cloud.
  • Worked on S3 buckets and Cloud trails to monitor logs and backups.
  • Worked on AWS Schema Conversion Tool
  • Creating user accounts, created profiles, roles and assigned them to different users.
  • Creating and monitoring table spaces according to their growth, allocating table spaces for users.
  • Expertise on handling all application issues pertaining to databases.
  • Application - level user management like user accounts creation, creating profiles, roles and assigning them to different users.
  • Performing exporting of database, schema, table, and row level backups and importing using regular Exp, imp and expdp and impdp tools.
  • Database tuning, Application Tuning & performance monitoring, Memory, Trace, SQLT tool, TKPROF Reports, AWR, Explain Plans and monitor the database performance on daily basis.
  • Having experience on managing Materialized views and Database links.
  • Applying database patches using Opatch Utility, applying quarterly security patches.
  • Creating users with restricted access with required privileges.
  • Having experience to raising SR’s whenever required with Oracle Support to find out the root cause or in case of any issue identified
  • Having good co-ordination with supporting teams like UNIX, Backup, Monitoring, Application, and storage.
  • Monitoring and resolving database alerts (like Job failures, blocking sessions, materialized view refresh issues, table space alerts, disk space alerts etc.,)
  • Configuration of listener and DB in OEM and Monitoring of it.
  • Worked on creating Clone databases using Cold, Hot & RMAN backups.
  • Experience in managing RAC databases.
  • Installed and configured GoldenGate on 11g/12C databases for data replication.
  • Involved in database troubleshooting and maintenance activities and solve Goldengate issues like abended, lagging, long transaction issues.
  • Resolved issues and conflicts between the target and source database in GoldenGate.
  • Experience in DATAGUARD configuration and creating and maintaining Physical standby Databases.
  • Experience in working with Oracle databases Switchover, Failover, Activating the Standby to Primary (DR and HA test).
  • Expertise on Toad, SSMS, JIRA, eHelp, Change management, OpsGenie and Service cloud tool.
  • Oracle Certified Associate on Oracle Database 11g Administrator, PostgreSQL, Tableau Administrator, Amazon RDS.

TECHNICAL SKILLS

Oracle Databases: 10g, 11g, 12C and 19C

Sql Server Databases: 2008, 2008 R2, 2012, 2016, 2019

PostgreSQL databases: 12, 13 & 14

Ticketing Tools: Jira, Jira Cloud, eHelp, Pathfinder and Service cloud

Operating systems: Red hat Linux, HP-UNIX, Windows Server 2003/2008/2009/2012/2016/2019

Cloud Services: AWS, Azure, EC2, S3

PROFESSIONAL EXPERIENCE

Confidential - Maryland

Senior Oracle Database Administrator

Responsibilities:

  • Database tuning, Application Tuning & performance monitoring, Memory, Trace, SQLT tool, TKPROF Reports, AWR, Explain Plans and monitor the database performance on daily basis.
  • User Management
  • Tablespace Management
  • Scheduler jobs
  • Database links
  • Monitoring production Database alerts
  • Applying Quarterly patches
  • Partitioning
  • Export/Import data using Data pump utility

Confidential

Senior Database Engineer

Responsibilities:

  • Analyzed, developed, and executed plan to migrate oracle on prem database to AWS cloud.
  • Worked on AWS DMS for Migrating Oracle databases from on Prem to AWS Cloud.
  • Worked on S3 buckets and Cloud trails to monitor logs and backups.
  • Worked on AWS Schema Conversion Tool.
  • Ability to design high availability applications on AWS across availability zones and availability regions.
  • Implement systems that are highly available & scalable on AWS platform.
  • Deploying, managing, and operating RDS instances on AWS.
  • Cloud Amazon Web services like EC2, S3, IAM, Cloud watch.
  • Installing and configuring various versions of PostgreSQL clusters as per customer's request.
  • Version upgrades
  • Ensure night corn jobs for backups, re-Indexing & vacuuming & materialized views executed properly on 24/7 high availability Postgres production and development databases.
  • Optimize postgresql.conf for performance improvement.
  • Review all PostgreSQL logs for problems.
  • Worked on AWS DMS for Migrating Oracle databases from on Prem to AWS Cloud.
  • Assist engineering team in the design of appropriate DB Schema and indexing strategy for performance and scalability.
  • Experience supporting a mission-critical database environment with 24x7 On-Call Support including weekends.
  • Identifying and resolving incidents and address to user problems/concerns. Trouble shooting database issues.
  • Monitoring of system logs, OS logs, database logs, trace files, database alert files to detect and troubleshoot runtime problems.

Confidential

SQL Administrator

Responsibilities:

  • SqlServer Software installation and Maintenance.
  • Installing SQL server 2012 R2 instances
  • Applying patches.
  • Installing Confidential ERP
  • Database creation.
  • User management.
  • Security.
  • Database Backup and Recovery
  • Server level space monitoring.
  • Creation/scheduling of Jobs.

Confidential

Oracle DBA and Oracle Applications DBA

Responsibilities:

  • Installation and Configuration of Oracle 10g, 11g, 12C,19C databases on Linux.
  • Export and import of the database objects like schemas, tables, and statistics. using Import/export, data pump (expdp/impdp).
  • Loading data using SQL* loader.
  • Capacity Planning: Plan & Administer Database environment, Database size, Storage space usage management, Database Performance Monitoring and Tuning of Oracle Production/Development databases.
  • Complete ownership on Oracle Code migration from DEV to TEST and PROD environments.
  • Working closely with development team for any performance related issues in the application.
  • Providing recommendations for improving application performance.
  • Created new user accounts, created profiles, roles and assigned them to different users.
  • Database tuning, Application Tuning & performance monitoring, Memory, Trace, SQLT tool, TKPROF Reports, AWR, Explain Plans and monitor the database performance on daily basis.
  • Enabling database audit, providing audit reports for external auditors on quarterly basis.
  • Applying quarterly PSU Patches on Databases when released by Oracle.
  • Creating ACL’s for sending emails from applications.
  • Enabling/Disabling Archive Log Mode.
  • Regular monitoring of alert log file for solving the issues and provide root cause of the issue.
  • Worked on creation of Mviews and solving the Mview issues.
  • Scheduler jobs for refreshing MV’s, executing procedures.
  • Database monitoring through OS scripts, EM Alert, Alert log tracking and Troubleshooting.
  • Creating and managing public and private database links.
  • On-call support with customers.
  • Raised service requests with Oracle Support to find out the root cause or in case of any issue identified.
  • Performed database restore and recovery from the RMAN tape backups.
  • Wrote UNIX shell scripting to automate tasks and crontab and dbms scheduler for scheduling jobs.
  • Created SOP’s and established the process for tickets/access, this way I could save 200 person hours on each new team member.
  • Installed and configured GoldenGate on 11g/12C databases for data replication.
  • Involved in database troubleshooting and maintenance activities and solve Golden gate issues like abended, lagging, long transaction issues.
  • Resolved issues and conflicts between the target and source database in GoldenGate.
  • Experience in managing RAC databases.
  • Code Migration Support to Functional Consultants.
  • E-Business suit user management.
  • Handling tickets raised by functional/technical/business users.
  • Handling Alerts raised by alert monitoring system from Database and applications.
  • Application middle tier bounce in Development, Test and Production databases.
  • EBS application user creation, termination and Adding responsibilities.
  • Query response time and other Performance Issues.
  • Application patching using ADPATCH.
  • Work with Oracle Support by raising SRs on several issue.

Confidential

SQL Administrator

Responsibilities:

  • SqlServer Software installation and Maintenance.
  • Installing different flavors SQL server instances.
  • Applying patches.
  • Database creation.
  • User management.
  • Security.
  • Performance Tuning using SQL profiler
  • Capacity Planning.
  • Performance Monitoring.
  • Database Backup and Recovery
  • Server level space monitoring.
  • Creation/scheduling of Jobs.

We'd love your feedback!