oracle DBA
Resume:
STACY NGUYEN
Certified Oracle **g DBA
*******.******@*****.***
**** ********** ******, ***********, ** 22151
PROFESSIONAL DETAIL:
A self-motivated, self-starter, team player and pro-active Oracle Database Administrator, who can rapidly identify problems and propose alternative solutions and formulate plans to obtain goals. Served as an Oracle DBA for different clients such as Department of State, Department of Defense and private sectors over 4 years. Have demonstrated success in administering all single instances and databases on RAC on various UNIX/LINUX and Windows platforms. Responsible for installation, configuration, manage, upgrades, patches, database tuning, cloning and Oracle SYSADMIN functions. Duties included database creation, database tuning/performance tuning, backup/recovery, general troubleshooting, script development and documentation.
CLEARANCE STATUS:
• Active DoD Secret Clearance
AREA OF EXPERTISE:
• 4+ yrs of Database Administering: Install, configure, operation and maintenance Oracle 9i/10g databases for single instances and on RAC environment on Solaris SPARC, HP-UX, Linux and Window server platforms
• Full life cycle experience on software projects with a strong process oriented approach
• 4+ yrs of experience in configuring database Archivelog/Noarchivelog mode, auditing, flashback technologies, restore and tune databases and Recovery Manager (RMAN) backup and recovery
• Aptitude for analyzing, identifying problems, and propose alternative solutions, devise plans to eradicate problems
• 2+ yrs of experience with Real Application Cluster (RAC)
• 4+ yrs of experience with ORACLE Automatic Storage Management (ASM), DataGuard, upgrade 9i to 10g
• 4+ yrs of experience with GRID
• Experience in using SQL*Loader, Oracle native Export/Import, and new features Data Pump Export/Import utilities
• Knowledge of the Oracle GoldenGate installation, configuration, troubleshooting GG issues
• Experience in using SQL*Loader, Oracle native Export/Import, and new features Data Pump Export/Import utilities
• Experience in using TOAD 9.x and Oracle SQL Developer 1.2 tools
• Capable of implementing Oracle procedures, functions, and triggers
• Experience in applying family, critical patch update (CPU), and individual patchsets software upgrade for Oracle database server and Application server
• Ability to response quickly, clearly and work accurately under pressure
• Thorough understanding of IT with focus on delivering business solutions
• Highly motivate, team player, self-starter, and fast learner
• Outstanding communication and interpersonal capabilities
TECHNOLOGY SNAPSHOT:
Extensive use and knowledge of databases including ORACLE running on mutilple platforms such as: LINUX, UNIX, SUN SOLARIS, and WINDOWS 2003
• Database: Oracle 8i/9i/10g and Microsoft SQL Server 2000, Oracle GoldenGate Reposistory database
• Software/Tools: Oracle GoldenGate 10x, Oracle GoldenGate Veridata v2x/3.0, TOAD 7.x/9.x, F-secure, Oracle Enterprise Manager (OEM), Recovery Manager (RMAN), Grid Control, RAC, ERStudio 7.5, Humingbird , SiteScope 8.5 and Froglight, Oracle SQL Developer 1.2, X-Win32, NetBackup Enterprise Server 6.0, OPatch, Domain Name Server (DNS) Bind 9, SSH Secure/Xming/XLaunch/Secure CRT/Secure FX, FTP/SFTP, Microsoft Office 2000/2003/2007
• Operating Systems: UNIX Sun Solaris 10/SPARC 10, Linux Redhat 5, HP-UX 11, Suse Linux 2.6.5, Window 2000/XP workstation and Windows 2000/2003 Enterprise Server
• Programming Languages: SQL, PL/SQL, UNIX shell, DOS BAT scripting
PROFESSIONAL EXPERIENCE:
IMC INC , ROCKVILLE MD ~ 11/2009 TO PRESENT
Oracle Database Administrator
• On site contractor for Food and Drugs Administration (FDA)
• Provide technical advices and act as a liaison between the two worlds (business and technical gap)
• Demonstrate and facilitate more formalized business functionality requests
• Focus on delivering business value as quickly as possible
• Analyze, design, development techniques needed to meet organization standards
• Install and configure Oracle GoldenGate and Veridata
• Debugging GG issues such as abend
• Working with rest of the team members, sharing knowledge
• Document of all the work
• Volumetric analysis
• Tune databases performance using OEM(Grid Control)
• Schedule backup, jobs using OEM(Grid Control)
• Recovery database using OEM (Grid Control)
• Check availability of the database using OEM(Grid Control)
• Check storage size using OEM(Grid Control)
• Work with other DBAs to create DataPump
ACI GROUP, ROSSLYN VA ~ 5/2009 TO 10/2009
Oracle Database Administrator
• On site independent contractor for Department of State
• Work in a team environment where providing support of 30 instances for Oracle 9.2.0.8, 10.2.0.3 and 6nodes RAC on ASM on Windows environment
• Daily and intraday monitoring of database health includes availability, reliability, performance, capacity planning, server clustering, replications, and connectivity, with timely production issue remediation
• Performance tuning includes indexing, compression, drive distribution, load-balancing, replication
• Setup and maintain accounts, access levels, and security, with monthly/quarterly security auditing of terminated/non-current users
• Translate technical database issues, requirements, limitations and parameters for management and staff, and understand business work processes and business impact
• Coordinate with and provide support for applications programmers, system programmers, users, administrators, and IT personnel where databases are concerned
• Develop and maintain build standards and procedures for the database environment
• Providing consultation support to development teams and systems administrators
• Providing consultation and development support for the physical database design for database applications in production and development environments
• Providing consultation support for logical database design for database applications in production and development environments
• Responsible for monitoring physical capacity
• Monitoring informational/error logs for messages specific to system operation (share responsibility for monitoring with Systems Administration and Production Control)
• Providing database device configuration data (hardware and software) for systems administration, such as disk usage, memory, etc
• Performing database modification function against production applications, such as altering table support for non-production status applications as requested
• Created a standby database on 10gR2
• Set up, configured and managed standby database on ASM
• Recovered database per requests
• Add new database onto 6 nodes RAC using ASM
• Monitoring databases and backup daily
• Use ASMCMD to delete archivelogs weekly in the prod, test/dev environment
• Deploying scripts to dev/test/prod successfully
• Create database using dbca and netca to create listener
• Rotating 24x7 on-call responsibilities
• Troubleshoot oracle errors using Metalink and any other resource available
TECHNIK INC., ALEXANDRIA VA ~ 12/2007 TO 4/2009
Oracle Database Administrator
• On site contractor for Department of Defense
• Provide support of 83 instances for Oracle 9.2.0.8, 10.2.0.3 and RAC on HP Unix 11, Redhat Linux 5, Suse Linux 2.6.5 and Wintel platforms
• Work with system administrator to build a brand new server from scratch and configured all the parameters and installed RAC 10g/database 10g on Linux-x86 RedHat 5.3 with 6 nodes
• Migrate databases/schemas from development to production using export/import with sftp tools, dbca, netca and dbua utilities
• Create cron jobs for automatic RMAN backup, RMAN purge backup, clean listener logs, clean sqlnet.ora logs and clean alert logs
• Configure RMAN backup using catalog
• Use sqlldr to upgrade database data
• Coordinated and led multi-teams environment on patching CPUJan2009
• Apply databases charactersets upgrade WE8MSWIN1525 on various platforms such as: UNIX/LINUX/WINDOW
• Use Vizio 2003 to create environment charts for all databases
• Create public/private database links for cloned/recreated databases/instances
• Create constraints, public/private synonyms, triggers and sequences to auto populate columns
• Use ERStudio to generate DDL from physical database model
• Advise clients to use CLOB instead of using LONG for datatype and create tables using CLOB datatype
• Monitor and tune several retailer applications using TOAD 9.x, SiteScope 8.5 and Froglight
• Run the Statspack reports and use it to tune the database performance
• Backed up binary files before applied CPU patches using sudo dbasnap
• Applied IAVA patches on Oracle 9.2.0.8, 10.2.0.3 and RAC on HP Unix 11, Redhat Linux 5 and Suse Linux 2.6.5 platforms
• Create, grant, and maintain users, roles and object privileges
• Unlock users account and reset password
• Pin SQL to improve database performance
• Work with other teams in order to solve the performance issues such as unix administrators, developers, system administrators and clients
• Work with another team member in filling a SCR form to request for certain database to be removed from the current environment
• Troubleshoot using Metalink and any other resource available
JUMPTREE INC., COLUMBIA, MD ~ 6/2005 TO 12/2007
Graphic Designer/ Oracle Database Administrator
Interacted closely with the development team. Responsibilities included but not limited to:
• Design company identity logo and brochures, flyers and letterhead…etc
• Create development/testing databases
• Import/export database schemas/tables
• Reset users accounts and change password
• Configured, administered and maintenance Oracle 9i /10g database on Unix and Windows environments including supported Oracle Server software installation, configuration, and development
• Created, granted and maintained users, roles, profiles, system and object privileges
• Monitored relational database to optimize database performance including tuning, sizing of tablespaces, and managing resource usage using Oracle Enterprise Manager (OEM)
• Performed weekly full and daily incremental backups to tapes using RMAN scripts and NetBackup system to schedule automatically RMAN backup
• Wrote programs and create PL/SQL objects such as procedures, triggers, and functions
• Used TOAD and Oracle SQL Developer to import data from the excel files, create tables, and add new columns to the existing table
• Applied the latest family and critical patch update (CPU) patchsets for Oracle 9i/10g
• Troubleshoot using Metalink and any other resource available
CERTIFICATIONS, TRAINING & EDUCATION :
Oracle Certified Professional 10g (OCP)
Oracle Certified Associate 10g (OCA)
Security +
UNIX Shell Programming
Oracle Database Administration II 10g
Oracle Database Administration I 10g
Advanced Oracle SQL and PL/SQL 10g
Introduction to Oracle SQL and PL/SQL 10g
B.A. Graphic Design, Marymount University, Arlington VA
CETIZENSHIP:
U.S. Citizen
Contact this candidate