We provide IT Staff Augmentation Services!

Sr. Oracle Pl/sql Developer Resume

Arlington, VA

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

Hire Now