SUMMARY:

• Oracle Developer & DBA with extensive software development experience supporting analysis, design, build, testing, implementation, installation, and configuration of Oracle RDBMS systems
• Extensive experience coding in PL/SQL, Stored procedures and function using advanced features; current releases of Oracle RDBMS supported are 9.2.0.6, 10.2.0.4, 11gR2 and 12c.
• Extensive experience providing Oracle DBA support to development, QA and production environment; Database Administrator responsibilities includes installation, upgrade, patch, migration and conversion. Possess strong database and application - side performance tuning skills.
• Some development experience supporting n MS SQL Server 2005, 2008 and 2012.
• Experience as data modeler conducting analysis and design to flush data model requirements through the conceptual, logical and physical database design phase to support scalable systems.
• Experience with supporting functional requirements, CRUD/IRUN, data dictionary, and performance tuning of Oracle (SQL) relational database applications on Windows, UNIX, Linux environments
• Experience leveraging Oracle Designer, Erwin and PowerDesigner to create conceptual, logical and physical database designs for OLTP/OLAP application.
• Experience using Toad, Oracle Developer, RMAN, Export/Import, DataPump, Oracle RDBMS versions 5 through 12c, Pro*C, Java, C/C++, Oracle Web Server, Oracle Enterprise Manager, AWR,

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Oracle Developer & DBA

Responsibilities:

• W2 employee contractor of Veredus serving Confidential as Database Engineer in the Cyber Technology and Information Security Lab ( Confidential ).
• Responsible for writing SQL queries, performance tuning, coding packages, procedure and functions that support new features and/or bug fixes for multiple applications.
• Support DBA task by developing automated solutions and/or researching and utilizing existing Oracle tools that provide a solution once scripted.
• Evaluate code developed by other colleagues and communicate recommendations and potentially decline work.

Confidential, Alpharetta, GA

Oracle Developer & DBA

Responsibilities:

• Responsible for writing PL/SQL queries and stored procedures against production Oracle database environment in response to questions from internal business community and development team.
• Support the role of Oracle DBA in 24X7 environment
• Serve operations and development management team on application and database performance tuning matters.
• Proto-type partitioning scenario against HOPS largest table of 60 Gig and tune all dependency related stored procedure queries.
• As result of tuning analysis and findings on partitioning will help guide management to make more informed decisions regarding the proper use of Oracle

Confidential, Alpharetta, GA

Oracle Developer/DBA

Responsibilities:

• Responsible for providing Oracle PL/SQL development, Stored procedures, and DBA support to multiple scrum teams on HzERM project
• Conduct data analysis of HzERM database structures and develop data integrity clean-up scripts intended for deployment at customer sites.
• Utilize Erwin to review HzERM database design of bed management and other functional areas.
• Provide on-call support on-rotation and supported Oracle database cloning and upgrade request.
• Supported daily database build process and upgrade/patch process internally using Oracle PL/SQL and shell scripts.
• Supported SQL Engineer role on Paragon project. As SQL Engineer I coded database-side using T-SQL to create API layer for the .net and PowerBuilder Web and client-side Hospital systems.
• Supported Rules Engine project which is a customized rules-based product required to support government mandated initiative to facilitate meaningful use throughout patient care process, while utilizing customized rules stored within a BizTalk database.
• Developed SQL Audit approach for Auditing PHI data using Broker Service External Activator to propagate messages from a generic trigger that adapts to any table and ETL stored procedures dynamically interact to changing message propagated by table events.

Confidential, Duluth, GA

Oracle DBA/Database Developer/ Modeler

Responsibilities:

• Provide Oracle DBA/development support for multiple scrum teams at Confidential, coding in PL/SQL and performing stored procedures.
• Support the design, build and unit test phases of AMS Confidential and Confidential utility to facilitate and resolve emergency scenarios that occurred on production AMS servers.
• Both, AMS Confidential and CONVERT DB was coded utilizing a combination of shell scripting and PL/SQL language to extend functional life of black box systems that supported movie-on-demand services.
• Provide emergency production support to Confidential most valued customers like Comcast and Verizon. Support application and database tuning of AMS for production customers and development.

Confidential, Roswell, GA

ORACLE Developer/DBA/ Modeler

Responsibilities:

• Oracle PL/SQL developer, DBA and data Modeler for Confidential StaffSuite product
• Support rapid-iterative development environment, support QA deployment and provide database production support
• Support and maintained server-side PL/SQL coding of Vertex, GL packages, GL Predictability, Eligibility, Nightly Processes and Lockbox.
• Maintain and develop database server-side installer software that is used to support New Install, Upgrade, and Patch process used for development, QA and customer production environments.
• Develop database-side installer software and appropriate documentation used by Confidential support team to upgrade and migrate StaffSuite customers from Oracle RDBMS 9i to 10g 10.2.0.28. Develop and document Oracle backup and recovery procedures leveraging Oracle Export/Import, Oracle Data Pump and RMAN in support of multiple Oracle homes.
• Pursued best practices and guidelines to identify and improve StaffSuite performance. Significant performance improvements realized through a combination of tuning high cost SQL, re-normalization, indexing, code re-engineering, and proper Oracle database installation and configuration.
• Support conversion of Oracle PL/SQL to SQL Server T-SQL
• Provide development support for SQL Server 2000/2005 and code control process for Pointwing.
• Participant in loadrunner testing effort to performance tune database by identifying high cost SPROCS and tuning.
• Identified duplicative SPROC calls generated by application during pre/post phase of update.
• Refactored anonymous calls generated by application and converted to tuned sprocs based on dynamic SQL.
• Support database-modeling task using Power Designer
• Power Designer and utilized for generating DDL for physical database and generate application-side persistence layer.
• DDL is generated for new install, upgrade and patch releases of StaffSuite. Both, DDL and data changes for StaffSuite is carefully managed under software control and well defined proven processes that guarantee consistent and accurate back-end deployment.
• Support Confidential support teams in troubleshooting Oracle database production issues and develop Hot Fixes.
• Support physical database conversion of StaffSuite from Oracle to SQL Server 2005 and reverse engineering tasks

Confidential

ORACLE PL/SQL Developer / DBA/Data Modeler

Responsibilities:

• Provide part-time support as Oracle Database Administrator/Data Modeler to Confidential PA)

Confidential

Oracle Consultant

Responsibilities:

• Supported Oracle database migration from Oracle 8i and 9i RDBMS servers operating on Solaris and Windows to Oracle 10g RDBMS release 2.
• Maintain Oracle Forms/Reports applications that support operations for Confidential Office of Public Affairs.

Confidential, VA

Oracle Consultant

Responsibilities:

• Provide support for Confidential /VA My HealtheVet project as an Oracle Database Administrator/Data Modeler.
• Supported 8 instances of Oracle 9i that serve development, system test and user acceptance and test environment.
• Provided routine database maintenance responsibilities, installation, configuration and patching as required.
• As database Developer/ modeler, produced logical and physical database design to support information requirements for My HealtheVet project.
• Supported 100% of back-end development of API using PL/SQL, cron job initiated reporting and synchronization between Oracle and LDAP Directory Server. Facilitated data modeling and JAD sessions; provided estimates and supported design and build scripts.

Confidential

Oracle Developer/ DBA

Responsibilities:

• Database Engineer to produce conceptual, logical and physical database design to support information requirements for Confidential project through ProObject.

Confidential

Oracle Developer/ DBA

Responsibilities:

• Provided Development /DBA/data modeling support to multiple projects associated with Telco Data Warehouse.
• Utilized Oracle Designer to create conceptual, logical and physical database design for multiple data warehousing projects.
• Engaged on sideline projects installing Oracle 8.1.7 and Oracle 9i RDBMS, Oracle Designer and Oracle Application Server on Windows and Red Hat Linux 2.1 AS.

Confidential

Oracle Developer/ DBA

Responsibilities:

• Support Oracle development using Oracle CASE technology and DBA support with Confidential to support BASIS+ project.
• Responsible for day-to-day operations related to achieving software maintenance deliverable goals and customer guidance. Hands-on experience with performance-tuning Application and Database, enhancing PL/SQL Web Modules to satisfy performance objectives, troubleshooting Application, Middle Tier and Database issues, streamline procedures to improve quality control and improve efficiency. application is based on Oracle PL/SQL Web technology, generated using Oracle Designer, hosted via 9iAS and Oracle 8i RDBMS.

Confidential

Oracle Database Consultant

Responsibilities:

• Provide Oracle database development, DBA and database design support for NFR Security project.
• Supported installation, configuration and maintenance of Oracle RDBMS version 8.1.7 and Oracle 9i AS operating on Red Hat Linux, Solaris and Windows 2000 Server.
• Installed, configured, and maintained Oracle Designer 6i and Developer 6i tools utilized for analysis, design and build of Rosie, Vulnerability and Confidential Enterprise system.
• Sole responsibility for conceptual, logical and physical database design of Rosie, Vulnerability, and Confidential Enterprise system.
• Designed, built and hosted Rosie and Vulnerability web-enabled application; 100% generated applications using Designer 6i.
• Created installation and tuning documentation for Confidential Enterprise system. Supported typical Oracle DBA responsibilities.
• Support to Nuclear Power customers
• Supported Oracle RDBMS installation and configuration to four servers, two Reader servers, and client workstations
• Supported installation, configuration of Oracle SQL Net and proprietary application software, and supported performance-tuning responsibilities of database and on-going support to RADOS.