SUMMARY:

Experienced IT professional with in - depth working experience in database management and development in Windows and Linux environments with have hands on experience working in Amazon Cloud (AWS). I leverage my strong background in system administration, hardware maintenance, cloud infrastructure and database administration to provide a holistic and proactive approach in supporting and adding value to any environment I manage. My experience and in the business field has given me the knowledge I need to expertly transfer business needs to software/database requirements.

TECHNICAL SKILLS:

Language: PL/SQL, SQL, Shell, Batch, C#, HTML, CSS, XML, JavaScript

OS: Linux, UNIX, Windows

Cloud: AWS

RDBMS: Oracle 11g, Oracle 12c, MS SQL Server 2014, MySQL

Utilities: OEM, AWR, Explain Plan, RMAN, Oracle impdp/expdp, SQL Developer, SQL Loader, ASH, OEM 12 cloud, Remedy Ticketing, CLM, Atlassian (Jira)

IDE: Visual Studios, Toad

PROFESSIONAL EXPERIENCE:

Sr. Oracle PL/SQL Developer

Confidential, Arlington, VA

Technical Skills: Agile, PL/SQL Development (procedures, functions, triggers), JavaScript, HTML, CSS, Oracle Admin, Debugging, Unit Testing, Creating Test Cases, Code Enhancements, SVN, CLM, Shell Scripting

Responsibilities:

• Research and implement security fixes to address application vulnerabilities
• Worked closely with business analysts/scrum masters to develop application releases that exceed client’s time/presentation/functionality expectations
• Worked extensively on PL/SQL performance tuning enhancements.
• Develop and maintain PL/SQL web pages in conjunction with HTML/CSS and JavaScript
• Implement SQL Injection fixes in current PL/SQL code using bind variables, enquote literals or query rearranging (cursors etc.)
• Implement Cross-site scripting fixes in PL/SQL packages
• Define and create data structures for schemas including tables, views, indexes etc.
• Write packages, stored procedures, functions and triggers
• Unit test PL/SQL code through the UI to identify and fix bugs and aesthetics
• Read, understand and improve upon (refactor) existing SQL and PL/SQL code
• Track projects using Confidential Collaborative Lifecycle Management (CLM)

Lead Oracle Database Administrator/Architect

Confidential, Rockville, MD

Technical Skills: Agile, AWS, Production Database Design/Administration, PL/SQL Development, Bug Fixes, Database Patch & Upgrade, Backup and Recovery, ETL, Data Migration, Oracle 11g/12c, Oracle Data Guard/ASM/OEM/RMAN/impdp/expdp, Atlassian (Jira)

Responsibilities:

• Documented and presented environment recommendations to Project Manager
• Develop guidelines to create Testing-on-Demand environments on Amazon AWS EC2 Instances
• Presented findings that showed a lack of fault tolerance in backup and restore procedures
• Designed and documented tailored RMAN backup and restore strategies for each production environment (data warehouse and transactional)
• Brought non-compliant environment to OFA compliant standards through patching, upgrading and tuning specific database parameters
• Leverage the utilities of the Cloud to developed documentation for producing on-demand test environments in less than 30 minutes, from the current production databases
• Maintained and design Oracle 12c VLDB databases in AWS EC2 instances
• Managed multiple Oracle 12c VLDBs with ASM storage hosted on AWS EC2 instances
• Maintained and developed new PL/SQL scripts for a variety of procedures and functions

Oracle ETL Developer/Engineer

Confidential, McLean, VA

Technical Skills: PL/SQL Development, ETL, Data Migration, Oracle 11g, Testing Database Administration, Bug Fixes, Code Enhancements, MS SQL Server, T/SQL, Batch Scripting, impdp/expdp

Responsibilities:

• Decreased transformation in the data ETL process by half the time through the development SQL scripts that managed tedious portions of the ETL process
• Decreased turnover time of data to testers by writing batch scripts to automate and streamline all steps in the loading process
• Decreased manual data restoration on SQL Server by automating the process via T-SQL scripts
• Develop PL/SQL scripts for data extraction, data transfer and data load.
• Build and update existing scripts, PL/SQL procedures, functions, triggers
• Work directly with testers through the ETL life cycle in order to adhere to data integrity rules
• Build new and update existing SQL and PL/SQL packages while leveraging OEM for SQL tuning
• Perform testing after data load to ensure data integrity

Oracle DBA

Confidential, Bowie, MD

Technical Skills: Production Database Design/Administration, PL/SQL Development, Bug Fixes, Database Patch & Upgrade, Backup and Recovery, Oracle 11g, Oracle RMAN/OEM/impdp/expdp, Shell Scripting

Responsibilities:

• Proactive approach to monitoring database environment performance by utilizing OEM and OS level scripts
• Successfully migrated Oracle 11gR2 on Red Hat Linux files system to Oracle 11gR2 on Red Hat Linux in an Oracle ASM environment
• Provisioned Oracle environments across multiple platforms (installation and configuration) to comply with OFA standards
• Successfully deployed Oracle OVS/OVM in a OEL Linux environment
• Actively involved in T2P (test-2-production) migration of OFM software’s
• Responsible for capacity/resource planning and resource recommendation
• Experienced in installing GI and configuring software features (such as ASM and ACFS)
• Implement backup strategies based on SLA by utilizing RMAN and supplemental exports
• Performed routine database refresh from production to lower level environments via export/import utility

Data Center Systems Administrator

Confidential, Richmond, VA

Technical Skills: Linux Admin, Server Build, Data Center Server Installing/Decommissioning, Server Hardware Break Fix

Responsibilities:

• Troubleshoot hardware problems on Confidential, HP and Lenovo servers and storage systems resulting in the minimization of downtime
• Maintained a 90 percent first-time fix average
• Worked daily in data centers on time sensitive individual and team projects
• Successfully deployed and configured 200 servers one month ahead of schedule allowing the customer to integrate their hardware and perform early testing
• Coordinated the setup of multiple small data center hardware infrastructure
• Repaired and maintained Confidential Servers and Storage systems hardware

High School Mathematics Teacher/Resource Developer

Confidential, Richmond, VA

Responsibilities:

• By implementing strategic teaching method, I prepared more than 150 failing students to retake the Virginia mathematics SOL. 50 percent obtained a passing score.
• Designed and created graphical aids and other mathematics materials that assisted in an overall 18 percent increase in the mathematics department SOL pass rate