Senior Oracle Database Administrator Resume
Alexandria, VA
SUMMARY
- Oracle Certified Professional offering experience in providing mission - critical database solutions to clients.
- Background experience involves working with technical teams and clients to determine data design and requirements, data storage, data and performance analysis, data integrity, high availability, security in both transactional and data warehouse environments.
TECHNICAL SKILLS
Engineered Systems: Exadata V2
Operating Systems: Linux, Solaris, Microsoft Windows
Database Software: Oracle Enterprise Edition 12c/11g/10g, MySQL 5.6
High Availability: Oracle RAC, ASM, RMAN, Flashback, Restart, MySQL Replication
Database Management: Oracle Enterprise Manager 12c/11g/10g, MySQL Workbench
Utilities: Data Pump, SQL*Loader, External Tables
Database Languages: SQL. PL/SQL
Shell Scripting: Bash, Linux
Application Server: WebLogic Server
Middleware: Fusion Middleware
Business Intelligence: SAP Business Objects
Virtualization: Oracle VM Virtual Box
Security: Oracle Label Security, Oracle Wallet, Virtual Private Database
PROFESSIONAL EXPERIENCE
Confidential, Alexandria, VA
Senior Oracle Database Administrator
Responsibilities:
- Database Administrator on a data ingestion system which processes and collects data from a variety of sources including streams, web services and web sites.
- Install, configure, manage, upgrade and patch Oracle and MySQL databases in an Amazon Web Services (AWS), Red Hat Enterprise Linux (RHEL), and Red Hat Enterprise Virtualization environment.
- Design, implement and maintain MySQL replication on AWS GovCloud and RHEL servers.
- Create buckets and transfer data between AWS Reduced Redundancy Storage (RRS) and Amazon S3 standard storage.
- Migration of legacy data into current databases using import/export and data pump.
- Administer all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
- Apply DISA database STIGs and address vulnerabilities.
Confidential, Alexandria, VA
Senior Oracle Database Administrator
Responsibilities:
- Database Administrator on a system consisting of an Exadata half-rack, a 4-node cluster, 7 storage servers, multi-terabyte databases, a data warehouse and data mart.
- Installed, configured and administered Oracle Clusterware, Oracle Database, Oracle ASM, Oracle RAC and Grid Infrastructure.
- Applied recommended patches to the Exadata stack and standalone databases.
- Implemented Recovery Manager (RMAN) backup and recovery strategies.
- Met service level agreements by proactively maintaining large production systems and achieving high-availability percentages.
- Provided database support to application development team and analysts.
- Assisted in an engineering analysis to determine the feasibility of transitioning the Exadata databases to Amazon Web Services. Exported 6.6 billion records from the data warehouse for import into a six-node Redshift Cluster.
- Instrumental in the database security posture including accreditation support, readiness reviews, STIGs, auditing and critical patch installations.
- Documented database standards and procedures including database naming conventions, roles and responsibilities, administration standards, security standards and application migration.
- Executed health checks, performance monitoring and tuning of the database environment.
- Repositioned critical DBA resources for more value-added roles by automating routine maintenance and administrative tasks.
Confidential, Sterling, VA
Senior Oracle Database Administrator
Responsibilities:
- Key player in the migration of a data warehouse to Oracle Exadata. This significantly improved ad-hoc query performance and reports rendering against billions of records in the data mart.
- Developed procedures to monitor database activity and identify potential performance issues before they could impact production applications.
- Provided database support services to over 100 remote and local end users.
- Collaborated with developers and the change management team to ensure smooth life cycle progress from development through testing and production.
- Contributed to the lifecycle development of the data warehouse, data mart and ETL.
- Proposed and developed strategic improvements for database implementation, support and enhancement.
- Deployed a backup and recovery strategy for all major production systems utilizing shell scripting and Recovery Manager.
- Centralized management and monitoring of databases via Oracle Enterprise Manager.
Confidential, Washington, DC
Oracle Database Administrator
Responsibilities:
- Accountable for the design, configuration and installation of production, development and test Oracle database environments on Solaris and Windows platforms.
- Major activities entailed Oracle logical and physical database design, capacity planning, performance enhancement, database security, database administration, disaster recovery, installation and ongoing maintenance.