Oracle Dba Resume
4.00/5 (Submit Your Rating)
Chantilly, VA
SUMMARY
- Hands - on experience in system analysis and design, quantitative methods, database and quality assurance.
- Oracle production database administrator with 5+ years supporting a complex government environment.
- Information technology professional with extensive experience in software testing, data conversion and data quality assurance practice in research companies.
- Experienced in database front end interface design and coding utilizing standard VB, MS Access tables /queries logical and physical design and practice.
TECHNICAL SKILLS
Languages: Linux shell script, Oracle SQL/SQL*plus, VB .NET, Python, Java;
Database: Oracle10g, MS-Access, MS-SQL Server;
Applications: MS-Office, MS-Visio, Firebug, QTP/UFT, Selenium IDE/Webdriver, Loadrunner
Networking Protocols: TCP/IP, SSL, Voip, SIP, SOAP, XML
PROFESSIONAL EXPERIENCE
Confidential,Chantilly, VAOracle DBA
- Support FAA national databases and database applications at the FAA Command Center
- FAA.GOV, eSTMP, PLAYBOOK, OIS. Provide level II and III operations support.
- Plan and implement Database upgrades (9i to 10g) along with Physical migration to remote facilities for transition related activities
- Database patch management and application upgrade assistance for operations and development communities.
- Installation OEM grid control Maintain primary standby databases, import/exports, backups (hot and cold )
- Developed and maintained of all in-house database and shell scripts that perform hourly and daily database and system checks. Alerts sent to appropriate support staff.
- Research production and development ORA errors using MetaLink service requests, external research and provide support staff with results and recommendations
Confidential,Reston, VA
QA Engineer
- Tested Linux system security patch with PCI compliance. Trustwave P2P encryption using Agile development methodologies.
- Confidential QTP/UFT web and application based testing. Selenium IDE testing.
- Responsible for configuring and validating network applications to monitor and trace secured transaction in production.
- Created QA test automation plan, drive test automation efforts and work on a test automation framework.
- Hands-on testing of financial credit authorization systems using TCP/IP, XML, SSL protocols.
- Write Test Plans, Test Cases and Traceability Matrix from System Requirement Documents.
- Work directly with customers during customer acceptance testing.
Oracle DBA
- Daily Database administration on FAA production databases with supporting National Traffic Management Log databases with message servers.
- Apply database change requests on production database and recompile invalid objects with load java & sql loader on message server. Develop Linux shell scripts for monitoring database activities and stabilities.
- Use database statspack/AWR tools for monitoring database performance.
QA Analyst
- Managed data quality and identified data faults by querying Nexus Database, manipulating database, preventing duplicate data, reviewing client complaints, and researching data categories and attributes to determine reasons for faults.
- Performed internal data globe change and re-mapped wrong matched data to assure integrity of quality data.
Software Developer
- SDLC experienced with developed/tested “Skuing Tool” database application with Class Module and multiple forms using Visual Basic 6 interface at front end and SQL Server as back end for data processing including data search, updating, analysis and summarizing. ADO, OLEDB, ODBC, Active X and COM Component had been used with the project.
- Designed and coded “Data Search Tools” in Visual Basic using SQL and Stored Procedure to substantially improve speed and performance of current applications.
- Maintained, implemented and modified HW Department Database for accuracy and custom query.
- Using MS-Access created Data Converting Tool to convert raw data to standard table format, including raw data tables Query at back end, GUI creating and coding at front end, software testing and training end users throughout whole develop life cycle.
Information Specialist
- Designed, coded, tested, maintained and modified MS-Access 97 customized “Transaction Log” database.
- Trained manger levels in searching and updating the database. Automated custom report printing system and accelerated the whole printing procedure while avoiding numerous manual-operating mistakes.