Senior Oracle Dba Resume Profile
PROFESSIONAL SUMMARY
- 6 years of experience as Oracle DBA using 8x, 9x, 10G and 11G database versions.
- One year of experience as SQL server DBA using 2008 version.
- Manage and support databases using Grid control, enterprise manager OEM , TOAD, Space Manager, Foglight, SQLPLUS, Net Manager, net configuration assistant, RMAN and DBCA.
- Experience in real application cluster databases RAC and ASM storage.
- Extensive experience in planning, installing, configuring, and administering multiple Oracle databases in a Sun Solaris UNIX , LINUX and Windows server 2003 and 2008. environment.
- 1 year of experience as a MS. SQL 2005 DBA and SQL server 2008.
- Experienced in data modeling and complete SDLC.
- Experience in handling database in On Line Transaction Processing system and Decision Support Systems.
- Experience in database optimization.
- Experience in upgrading Oracle databases to latest patch sets.
- Tuned data load process to reduce time from 16 to 4 hours.
- Tuned database for fast refresh of web screens.
- Tuned Materialized view creation from 10 hours to less than 3 hours.
- Having good skills in UNIX system administration. Have installed Linux operating system and configured network LAN for connecting multiple Linux servers.
- Extensive Performance Tuning of oracle queries.
- Ability to communicate clearly to all levels of project contributors from executives and project sponsors to development and implementation team members.
- Providing 24 7 support for all production and development environments.
- Managing Database jobs, scheduler jobs and materialized views etc.
- Managed DBA teams and services since 2007. Managed outsourced resources
- Worked on hardware starting from PC to mainframe.
- Reviewed alert logs daily provide good performance test, development production databases.
- Proactive, hardworking, fast learner, team player with positive attitude.
- Dedicated and Motivated Individual who delivers quality products on time.
- Good Communication and Interpersonal Skills.
AREAS OF EXPERTISE
- Solid Oracle architecture experience
- Database design, modification, development, security, backup, tuning, and maintenance.
- Troubleshoot and Resolve failed Tasks.
- Supporting RMAN backups.
- Providing 24 7 support for all production and development environments.
- Creating Stored program units and database triggers.
SKILL SET
DBMS/RDBMS | Oracle 7.x/8.0/8i/9i/10g/11g, SQL Server,RAC |
DBA Tools | Export/Import, SQL Loader, RMAN, OEM, Grid Control |
Operating Systems | Windows NT/2000/2003, UNIX, Sun Solaris, AIX, Linux. |
Languages | SQL, PL/SQL, Shell script/Perl Script, VB 6.0, Java. |
Development Tools | Developer/2000, Forms 4.5/6i, Reports 2.5/6i. |
Tuning Tools | AWR, ADDM and TKPROF |
Third Party Tools | SQLLAB, TOAD, Erwin, Informatica |
Web | HTML, XML, JavaScript |
PROFESSIONAL EXPERIENCE
CONFIDENTAIL
Senior Oracle DBA
Responsibilities:
- Solely responsible for the development work and production support of four databases.
- Responsible for multiple RAC and non RAC databases
- Responsible for partnering with application architects, developers and end users, to collect and define database requirements, and implement database solutions.
- Responsible for the implementation of DataGuard, in support of the company's DR solution.
- Lead DBA on 5TB data warehouse. Tested and implemented the use of ASM. Tested and implemented the use of RMAN to migrate a database from file systems to ASM.
- Leveraged the use of partition exchange, to reduce the time needed by the ETL team to load new data. Performed SQL tuning, ensuring all the needed structures PK, FK and bit map indexes , were in place to allow the Oracle optimizer to choose a star transformation. Implemented the use of Resource Manager, working with the application and business to define the proper resource plans and consumer groups.
- Responsible for the implementation of Transparent Data Encryption, to meet client requirements for encryption at rest.
- Technical and project lead for the Oracle 10g upgrade project. Responsible for the planning and coordination of the 10g upgrade across multiple applications and supporting the application DBAs on the actual implementation.
- Conducted the first Oracle 10g install and database upgrade. Evaluated different methodologies up upgrading using dbua vs running manual scripts . Produced step by step documentation for standardized procedures.
- Evaluated 10g new features and made recommendations to management and DBA team on what new functionality to go live with.
- Performed 9i vs 10g performance tests, to evaluate the impact to application top SQLs.
- Responsible for the planning, coordinating, and implementation of application required database changes across all database environments, as well as the installation and patching of Oracle 11g databases.
- Part of an Oracle triage team, called in help assess the database health, and identify any performance impacting issues, during all application slowdowns. Improved database performance by tuning SQL rewrites, use of profiles and hints, new indexes , and database parameters, based on an analysis of AWR reports.
- Introduced to the DBA group the use of Oracle Log Miner to track both DML and DDL database changes
CONFIDENTAIL
Senior Oracle DBA
Supported and maintained a VLDB very large database about 53 TB for the development and test databases for the federal government Medicare/Medicaid. Performed database consolidation, database capacity planning, database backup plans and recovery plans, CPU/SPU quarterly patches installation, database deployment and testing and Data loads. Enforced database security standards from CMS. Scanned database for vulnerabilities and security violations and fix them.
Responsibilities:
- Designing, developing, testing, and debugging complex new software products.
- Made significant enhancements to existing software.
- Researches and integrates design strategies, product specifications, development schedules, and user expectations into product capabilities.
- Resolves complex hardware/software compatibility and interface design considerations.
- Support new development work from design through implementation with regards to Oracle - this includes emergency work as well as planned.
- Leading in implementing major Oracle Applications including design, system integration, upgrade, migration, and performance optimization from 11.5.x to 12 using Oracle 10g/11g, RAC and MAA
- Assess and propose the full cycle of new Oracle Apps implementations including hardware and software architecture, system configurations, backup and restore, RAC/HA setup, embedded Oracle data warehouse with Oracle Business Intelligence, ETL, ASM on AIX, Solaris and Linux servers
- Handling severity 1 TARs and critical patches Troubleshooting and performance tuning.
- Cloning Apps instances and refresh/replicate schema data via Database Control and Grip Control
- Fine-tune workflow mailing.
- Promoting new features of Oracle Apps 12, Fusion and Oracle 10g/11g Checklist and roadmap the upgrade and migration from Apps 11i to 12 Design and document each Apps-specific build Provide the Apps DBA runbook Transfer knowledge to onsite and offshore data centers.
- Assess and propose the full cycle of new Oracle Apps implementations including hardware and software architecture, system configurations, backup and restore, RAC/HA setup, embedded Oracle data warehouse with Oracle Business Intelligence.
- Development and production support for 15 productions and 20 QA/testing databases.
- Dealing with High CPU utilization, Disk utilization and Memory utilization issues. Monitoring long running full table scans SQL queries.
- Handling refresh from production to UAT environments.
- Creation and Management of users, profiles, roles, privileges and temp tables.
- Back up and restore of all production and QA systems using EBU, RMAN, logical and physical standby, and cloning Data access and usage securities and auditing.
- Evaluated the resource i.e. memory, disk , impact of upgrading to Oracle 10g.
CONFIDENTAIL
Oracle DBA
CONFIDENTAIL is an American company that designs and makes semiconductors, which it sells to electronics designers and manufacturers globally. Headquartered at Dallas, Texas, United States, TI is among the Top 20 Semiconductor producing companies in the world.
Responsibilities:
- Providing 12 7 support for all production and non-production databases of all versions from Oracle 9i to Oracle 11g.
- Capacity planning, Space management of more than 1000 databases.
- Creation and Management of users, profiles, roles, privileges and temp tables.
- Reorganizing the database: That is to eliminate excessive database fragmentation and to move data between different databases.
- Establish, coordinate and maintain database and database environments for testing, production, training and user demonstration.
- Controlling and monitoring user access to the database.
- Dealing with High CPU utilization, Disk utilization and Memory utilization issues.
- Handling refresh from RMAN backups for production to non-production environments.
- Deploying CMARs Change management Activities for database upgrades, Listener vulnerability fix, memory parameters change to fix ORA-4031.
- Supporting SQL Server environment for Space issues.
- Handling all user accounts related issues, account lock unlock, passwords complexities and Risk Assessments.
- Handling all backups issues, archive backup failures issues and netbackup related errors.
- Handling all day to day issues in production environment.
- Supporting VCS cluster resource failure issues.
- Support during scheduled maintenance issues for entire physical site.
- Managing environment through home grown scripts
- Supporting RMAN backups.
- Moved databases from one RMAN catalog to new RMAN Catalogs.
- Restored old RMAN backups on new server for customer to recover old data.
- Worked on Rebuilt ADF zone requests on adhoc basis.
- Perform data management tasks as required loading, editing, restoring and removing data objects such as procedures, packages, functions, tables, indexes, synonyms, sequence, materialized views etc requested by the development/application teams.
- Identify, plan, test Oracle patches and CPU Critical Patch Updates available on metalink for database servers in the current setup and coordinate the implementation of relevant patches.
- Analyzing and providing solutions to performance problems of databases.
- Handled Temp Tablespace related issues.
- Worked on Database creation from scratch with UNIX Team.
- Help support testing and development team issues with each development release - this includes performing advance queries.
- Interact with Oracle support to resolve issues.
- Maintain database models and enforce CMS standards when applying changes.
CONFIDENTAIL
Oracle DBA
Responsibilities:
- Worked as production DBA for Internet telephony solutions Business Company.
- Managed, supported 24 X 7 production database for Oracle 9i/8i on Sun Solaris 2.6/2.9 and Window 2000 and provide full DBA support for production database as well as standby database, replication Database.
- Installed, configured and built Oracle 10g/11gR2 2 to 3 nodes RAC databases with ASM on Unix/Linux operating systems to improve application scalability.
- Upgraded/migrated RAC database from 10g to 11gR2 and platform from AIX to Linux.
- Installed, configured and built oracle 10g/11gR1/11gR2 active/passive OS cluster databases which provided high availability of application.
- Designed and implemented RMAN, SQL Backtrack backup/recovery strategy to prevent data loss.
- Performed flashback database to point in time per business requirement
- Set up physical standby database with dataguard broker for data protection and disaster recovery on both single and RAC database.
- Tested disaster recovery strategy with dataguard switchover or flashback
- Controlled and monitored user access to the databases which maintained system security
- Restored Oracle 10g/11g databases from Solaris to AIX with RMAN restoration which minimized downtime during the server migration.
- Migrated Oracle 10g/11g RAC databases from file system to ASM with RMAN restoration.
- Used OEM grid, SQLTrace, AWR report, ADDM, ASH, EXPLAIN PLAN and various SQL scripts to monitor database performance and identify problematic SQL statements
- Wrote shell scripts that proactively monitored database and server space usage, alert log for Oracle errors, database activity and server load
- Provided daily support to application development team which kept team more productive
- Worked with system administrators in the planning and configuring of new hardware ensuring requirements were met.
- Documented system problems, database errors, and their solutions for future reference
- Upgraded databases from 9i, 10g to 11g R1, 11g R2.
- Installed, configured and maintained GoldenGate on oracle 10g database.
- Research and install Oracle CPU Quarterly Critical Patch Upgrade .
- Upgrade databases from oracle 9i to 10.2.0.3 and perform data migration from 9i to 10G.
- Perform Database Configuration Management Tasks.
- Plan Perform Oracle Application and Database Upgrades.
- Establishes procedures and guidelines and recommends policy to create, modify, delete, purge, achieve and recover files.
- Backup Databases Transaction Logs / Archives Logs.
- Periodic Testing Review of Backup and Recovery Strategies.
- Perform Database Back Up, Repairs Recovery.