SUMMARY:

An accomplished IT professional with 8+ years of experience in the full life cycle of Oracle database administration and helping companies (both federal and private) gain the maximum benefit from their technology investments. Hoping to secure a full - time position that will allow me to utilize my expertise in database security, performance tuning, backup/recovery, and schema object management.

TECHNICAL EXPERTISE:

• Installed Oracle software (11g, 12c) on Windows/UNIX/Linux
• Monitored, reported, and tuned Oracle 12c and SQL Server 12.0 databases
• Created Oracle Database and Listener (DBCA, NETCA)
• Skilled in designing and implementing complete life cycle client servers and database apps/ DBLC Methodology
• Managed internal databases, from planning and testing stages through implementation and support
• In-depth understanding of security and backup procedures to ensure database integrity (RMAN, Oracle Wallet, etc)
• Set up standby databases using Data Guard for high database availability
• Database monitoring tools (OEM/Grid Control/AWR)
• High instance availability - Real Application Cluster (RAC)
• Strong PL/SQL knowledge (functions, stored procedures, triggers, etc)

TECHNICAL SKILLS:

Databases: Oracle 10g/11g/12c, Microsoft SQL Server

Operating Systems: Windows 2000/2003/NT/XP, OS X, Solaris Unix, Linux (CentOS, RHEL)

CPU Languages: XHTML/HTML5, Bootstrap/3, CSS/CSS3, Wordpress PHP, Python, batch, shell, Powershell, JavaScript, AngularJS, Java, JQuery, JSON, XML, T/SQL, PL/SQL

Other: Microsoft Visual Studio, Microsoft Office Suite 2010, Adobe CS5/6, Bower, Grunt/Git Hub, iMIS, WordPress, CMS, Sitecore, Remedy, Cherwell

WORK EXPERIENCE:

Senior Oracle DBA

Confidential

Responsibilities:

• Responsible for monitoring, reporting, and tuning of Oracle 9i, 11g, and 12c and SQL Server 12.0 databases
• Configured Java applications using JDeveloper to pair with Oracle databases
• Created functions, stored procedures, and triggers for production databases
• Created schema objects (tablespaces/tables/views) for data storage
• Scaled resources horizontally/vertically for high database and instance availability
• Installed Grid Infrastructure and created ASM disk groups for high disk availability
• Configured RAC nodes and Data Guard DBs for high instance/database availability
• Set up and configured physical standby databases using Data Guard
• Performed regular database backups and restores using RMAN and DATAPUMP
• Performed large data migrations using transportable tablespaces and datapump
• Restricted user access security for databases (LDAP, OID)
• Automated/scheduled overnight jobs using CRON
• Monitored databases using (OEM Cloud Control 12c/AWR)
• Created SHELL scripts to run against databases
• Maintained/updated RESOLVER/PERSPECTIVE Security application

Senior Oracle/ SQL DBA

Confidential

Responsibilities:

• Responsible for performance monitoring, reporting, and tuning of Oracle 12c and SQL Server 12.0 databases
• Performed regular database backups and restores to improve overall database availability
• Created database indexes as needed to boost database performance
• Configured SQL Server monitoring utilities to minimize false alarms
• Performed data analysis, SQL optimization, database tuning, and provided general database reliability analysis
• Performed quarterly patch analysis and applied patches as needed
• Ran Control-M against databases/servers for automated jobs
• Created Batch scripts to run against databases
• Managed and supported existing ETL processes (Procedures, Jobs, Views, etc.)
• Validated Execution Forms, Cycle Changes, and Configuration Change Requests for multiple applications

Application Developer

Confidential

Responsibilities:

• Developed web-based applications for United States Navy Systems that analyze and display critical information from enterprise information systems (e.g., SAP ERP)
• Translated application requirements into clean and efficient PHP and JavaScript code
• Used HTML, jQuery, and Ajax to implement responsive, dynamic user interfaces in the web browser
• Translated UI designs, mockups, and detailed specifications into functional user interfaces, ensuring cross-browser compatibility, performance and robustness, security, and adherence to best practices and current web standards
• Maintained version control of all software code and artifacts using Git
• Created Shell scripts to assist DBA’s with exp/imp

Oracle DBA

Confidential

Responsibilities:

• Responsible for installing, creating, and designing Oracle database systems on Windows/UNIX/Linux platforms
• Monitored databases using OEM Cloud Control 12c
• Installed and configured OEM Cloud Control to pair with Oracle databases
• Managed multiple internal databases, from planning and testing stages through implementation and support
• Performed weekly backups using RMAN; Developed backup/disaster recovery plans for nationwide offices
• Performed quarterly patch analysis and applied patches as needed
• Created documentation for key deployment procedures
• Performed various migrations and upgraded Oracle databases from 11g to 12c
• Installed Oracle Grid Infrastructure (GI) and configured ASM stack; performed ASM migration
• Performed database refreshes by utilizing data pump (import/export) in different Oracle versions
• Responsible for reviewing and tuning PL/SQL code