Junior Oracle Dba Resume
SUMMARY:
- More than 5 years of experience working on Building and deploying database servers.
- Document development and production database environments.
- Implement, maintain and document software packages as needed.
- Update and create ER Diagrams as needed.
- Create and test database build documentation.
- Perform quality assurance activities against database code.
- Support the database needs of various development application support teams
- Ensure the availability, performance and security of Oracle databases.
- Optimize database resources by identifying potential resource bottlenecks and rectifying them.
- Monitor database systems and proactively address issues as they arise.
- Responsible for configuration management, performance tuning and administration of mission critical production databases
- Design and code database batch jobs
TECHNICAL SKILLS:
Operating Systems: Sun Solaris, Linux, UNIX, Windows 2000, Windows XP.
Programming Languages: Oracle SQL, PL/SQL, T - SQL, MySQL, MSAccess
Database Tools: RMAN, Toad, Replication, Data Migration, Export-Import, Procedures, Backup &Recovery, Performance Tuning, SQL-Loader, Real Application Clusters, Oracle 9i, Data Guard, Data Oracle Warehouse, oracle R12 and Oracle Discoverer, putty, Oracle enterprise manager, oracle management server
Web Design Tools: Html, Java Script, Active Server Page, IIS
Reporting Tools: Crystal Reports, Oracle
PROFESSIONAL EXPERIENCE:
Junior Oracle DBA
Confidential
Responsibilities:
- Trouble Shoot Hardware/Software /Mapping Network Drives for Backups,
- Manage the Footprint databases for ticketing services used by the Service Desks personnel and Surgical Production Database for Radiology, E.R, Neurology departments.
- Manage Oracle Discoverer for the Help Desk Team.
- Installed the Oracle client and server software & configuration settings, applying patches and migrate databases
- Create/Run Batch scripts (For Joining Domain, Renaming, Backups, etc.)
- Application lifecycle management (test and quality management, Configuration, Issue Defect management)
- Use DBCA to create Oracle databases according to physical and logical database design based on Oracle's recommended Optimal Flexible Architecture (OFA) standards)
- Analysis Queries and Objects for Optimization
- Performed database refreshes on Test and Development life cycle.
- Load and transfer data using Data pump and SQL Loader utilities
- Automate database administration routines in backup and recovery using Recovery Manager (RMAN), routine import/export activities, schema creation and disk usage monitoring
- Experience in, database cloning, flashback technology, DataGuard
- Enterprise Manager and Oracle OEM Grid Control and using TOAD, SQL Developer
Technical Analyst/ Jr. DBA
Confidential
Responsibilities:
- I was responsible for integration and production databases consolidation
- Worked on several web based application (WordPress, DreamWeaver, HTML5, Zohocreator) using PHP as well.
- Performed backups - full and incremental backups using Oracle's RMAN backup utility.
- Load and transfer data using Data pump and SQL Loader utilities.
- Used DBCA/Scripts to create Oracle databases according to physical and logical database design based on Oracle's recommended Optimal Flexible Architecture (OFA) standards
- Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development and production environments for implementation and maintenance of user security experience in disaster recovery, routine maintenance for Oracle databases
- Designed Database ER - Diagrams Prior to database creation (Microsoft Visio, Design for database 7, Erwin)
Inventory Database Management
Confidential
Responsibilities:
- Performed user account management such as account lockouts, password resets, account creation, role and profile assignment.
- Creating standards for operation documentation. (Oracle Reports, Crystal Reports)
- Implemented ER-Diagrams for database development (Microsoft Visio)
- Performed constant and proactive database monitoring and support.