SUMMARY:

• Remote Oracle DBA/Developer with extensive experience in data quality, business operations and quality assurance within the global technology industry.
• Proven abilities in utilizing industry best practices resulting in increased ROI and operational efficiency.
• Expertise in database administration including configuration, space management, user access, auditing, bulk data loading, backup and recovery.
• Experience in customer relationship building and requirements management for on - time on-budget deliverables.
• Adept as a multi-disciplinary team lead, training, mentoring and cross functional team building.
• Excellent leadership, communication, problem resolution and team collaboration skills.
• Oracle Certified Professional (OCP)

TECHNICAL SKILLS:

Languages: SQL, Oracle SQL PL/SQL Shell scripting, C Shell, Korn Shell, Bourne Shell

Databases: Oracle 8 -12C, MySQL 4.5 -5.6, SQL Server 2005 -2012, DB2

Tools: /Suites: Quest TOAD, SQL Developer, SSIS, SSMS, Microsoft Visio, ExcelVM player, Oracle Virtual Box, SOURCESAFE, TFS, Netbackup, BMC Protrol, Eclipse, Visio, Microsoft Office Suite Oracle Client, Sybase Client, Golden Gate

Environment: s: SUN Solaris, UNIX, LINUX, HP, IBM, JAVA, Apache, HTML, Windows, Windows NT, IBM

Applications: ArcSight, NMAP, Cygwin

EXPERIENCE:

Confidential, New Cumberland, PA

LeadSenior Specialist

Responsibilities:

• Manage over 10 mission critical financial databases in a cloud environment, from planning and testing stages through implementation and support.
• Supported an audit readiness intuitive on DLA inventory reconciliation and metrics.
• Responsible for translating Business requirements/logic in to technical code.
• Responsible for maintaining and manipulating financial algorithms.
• Responsible for day to day management of DLA Financial applications.
• Reviewed complex PL/SQL codes for other developers when they have performance issues.
• Managed code and database versions using Team Foundation Server (TFS).
• Responsible for writing executable statements/programs, pl/sql development.
• Responsible for ensuring Federal Security requirements (STIGS) are met.
• Created and enhanced reports for our financial website per client request
• Addressed performance issues in the application by implementing Oracle partitioning and indexing.
• Responsible for creating procedures and functions in packages to automate bulk data loading.
• Ensure Oracle databases systems operate efficiently and securely.
• Continually built and maintained technical Documentation.
• Responsible for Attending and participating in weekly meetings with DLA Financial Management Office personnel
• Participates in monthly bulk data loads while interacting with external tables
• Strong knowledge and experience with PL/SQL, SQL Loader, and all aspects of data ETL into Oracle database on HP-UX and Windows systems.
• Strong knowledge and experience with physical database design.
• Participated in full project life cycle development experience in code migration, database change management and data management.
• Responsible for consulting with DLA Financial Management users about development areas and assist in the design and implementation of small to large projects.
• I provide direction, guidance, and technical support to the DLA Financial Management Office users and the DLA Financial Management Office Financial Web Site Application.

ORACLE APPLICATION DBA/Financial Database Developer

Responsibilities:

• Manage over 15 mission critical financial databases on HP-UX and Windows servers, from planning and testing stages through implementation and support.
• Reviewed complex PL/SQL codes for other developers when they have performance issues.
• Managed code and database using SOURCESAFE.
• Created and enhanced reports for our financial website per client request
• Addressed performance issues in the application by implementing Oracle partitioning and indexing.
• Responsible for creating procedures and functions in packages to automate bulk data loading.
• Ensure Oracle databases systems operate efficiently and securely.
• Responsible for Migration of a Single instance to RAC..
• Document configuration and functional designs for Oracle processes.
• Responsible for envisioning, shaping, designing and architecting data warehouse solution individually or with the project team to develop complex and business-critical BI/DW solutions
• Created new Windows Server-based OBIEE or Oracle BI Publisher Suite environment based on customer priorities.
• Created and maintained new reports as well as data access provisioning and credentials related to the OBIEE environment.
• Provide architectural recommendations and attain approvals for major enhancements to existing systems.
• Consolidate and virtualize environments; lead the installation, configuration, backup and recovery of Middleware tools and technologies.
• Testing new enhancements and changes as a part of our OBIEE test bed environment
• Evaluated ODI/OBIEE technology use and needs and recommend improvements, such as software upgrades and other supporting tools.
• Analyzed the existing EUL layer of Discoverer from Discoverer Admin Edition and helped in migrating Discoverer EUL to OBIEE and performed Dimensional modeling in Physical and BMM layer of OBIEE in order to refine the Star and snow flake schema and created Different Subject areas in order to fulfill the Business and Data Security needs
• Expertise in Oracle Discoverer in Creating various business areas, user views, custom folders and joins for reporting.
• Lead development team-members on aspects related to solution architecture, technical best practices, standards, and other aspects of application development life cycle. continually analyze, develop, and build tables, procedures, and scripts to be used in supporting all finance related applications
• Developed, tested and implemented the organization's physical databases across multiple platforms, technologies and computing environments.
• Responsible for Planning, documenting and executing 11.2.0.4 to 12.1.0.2 upgrade successfully.
• Assisted developers and architects with physical data design to meet the performance requirements of application.
• Installed and configured 12C Cloud control and deployed agent to centralize administration.
• Responsible for Attending and participating in weekly meetings with DLA Financial Management Office personnel
• Participates in monthly bulk data loads while interacting with external tables
• Strong knowledge and experience with PL/SQL, SQL Loader, and all aspects of data ETL into Oracle database on HP-UX and Windows systems.
• Strong knowledge and experience with physical database design.
• Participated in full project life cycle development experience in code migration, database change management and data management.
• Responsible for consulting with DLA Financial Management users about development areas and assist in the design and implementation of small to large projects.
• I provide direction, guidance, and technical support to the DLA Financial Management Office users and the DLA Financial Management Office Financial Web Site Application.
• Implemented RMAN backup strategies using catalog database schema.
• Take lead role in administrative task such as database migrations.
• Inform and address concerns that will impact progress and/or completion to the COR immediately when known providing all historical information..
• Work with Oracle support to resolve escalated issues.
• Continually perform Database Object creation and Performance Tuning.

ORACLE DBA/SQL Server

Responsibilities:

• Manage over 40 internal databases on Linux and Windows servers, through their full life cycle
• Ensure Oracle databases operate efficiently and securely.
• Responsible for performance tuning of Oracle databases. - Analyze and maintain performance requirements.
• Install and configure OBIEE
• Assisted developers and architects with physical data design to meet the performance requirements of application.
• Install and configure 12C Cloud control and deploy agent to centralize administration.
• Configure ASM using raw devices
• Use SQL Loader and external tables for bulk data loads.
• Maintain user accounts, space and backups for over 100 SQL Server databases.
• In-depth understanding of security and RMAN backup procedures--Create and apply backup Strategies.
• Refresh test and Dev databases on a weekly base.
• Used PL/SQL to create Oracle fine grained ACL, triggers, functions packages ect.
• Work with Oracle support to resolve escalated issues. hands on experience in Oracle Real Application Clusters (RAC)
• Successfully install oracle Software and configure databases on Windows and Linux
• Install and configured Oracle APEX application to support internal application
• Monitored job execution in production and staging environments.
• Worked closely with the development team on database modifications
• Monitor cron jobs for successful completion of logical and physical backups
• Documented database environments by creating data dictionaries.
• Worked closely with application developers and middleware developers to produce specific environments