Oracle Dba Resume
Austin, TexaS
SUMMARY:
- Total of 8 years in relevant IT field
- 7 years of experience in Oracle DBA
- Over 2 years in other IT related fields.
- Build and configured RAC
- Worked on Confidential .
- Worked on ASM builds
- Implemented Various RMAN backup methods.
- Worked on Data Movement using Export Import and Data Pump
- Build Data Guard.
- Worked on Materialize Views
- Strong Administrative skills on Linux
- Worked on SQL Server Database Management.
- Vast experience on Linux, AIX, HPUX, Solaris and Windows.
- Installed 12c Database
- Familiar with container and pluggable databases concept.
- Upgrade databases from 10g to 11g
- Restored and recovered the databases
- Load data using SQL loader.
- Taken different type of backups on SQL Server.
- Experience in installing patches for upgrades and for various problems.
- Experience working with 24x7 production support.
- In - depth knowledge of Oracle internals and architecture.
- Experience in installing, configuring and maintaining Standalone and RAC databases
- Experience administering database architecture, building database and backup & restores
- Creating roles, profiles, privileges and assigning roles to users.
- Extensively worked on monitoring and optimizing the database by performance tuning
- Monitor usage of the databases and perform database tuning.
- Experience in SQL TRACE and TKPROF.
- Extensive experience in Oracle Partitioning.
- Involved in database monitoring activities using STATSPACK.
- Worked heavily with 10g, 11g and 12c Grid control.
- Troubleshooting of networking issues.
- Good understanding of Indexes and statistics, Dictionary tables and views.
- Analyzed Tables, Indexes periodically to optimize the SQL queries.
- Developing UNIX shell scripts and Perl scripts and SQL scripts to carry out routine checks on databases.
- Have knowledge in Exadata.
- Monitored indexes and analyzed their status for performance tuning and query optimization.
- Experience in Oracle Server installation, configuration, performance tuning, client/server connectivity, query optimization, backup/recovery.
- Worked extensively with ASM builds and disk group management.
- Implemented proactive monitoring scripts for production databases.
- Troubleshoot performance issues using ASH, AWR and ADDM,
- Worked on Golden Gate replication
TECHNICAL SKILLS:
Languages: SQL, PL/SQL
Script and Markup Languages: Unix bash shell programming, HTML, Windows Batch files
OS & Administration: Linux, Windows, Solaris, AIX, Confidential -UX
Database: Oracle 9i, 10g, 11g, 12c / SQL Server 2005, 2008
Concepts and Administration: Data Guard (Standby), Real Application Cluster (RAC), Automatic Storage Management (ASM), Golden Gate, Data Guard, OCF, Grid Control, MS SQL Server
PROFESSIONAL EXPERIENCE:
Confidential, Austin, Texas
Oracle DBA
Environment: Oracle 10g, 11g RAC, ASM, Linux, Solaris, Data Guard
Responsibilities:
- Involved in 24x7 support for production RAC databases with on-call pager
- Build 2 node RAC clusters
- Supported production, development and testing databases of Multi Terabytes DB sizes.
- Installation of 11g and 12c clients/databases on Solaris and Linux.
- Worked with Storage team to allocated SAN to RAC
- Installed RHEL from scratch.
- Worked with offshore team.
- Worked on 12c cloud control.
- Worked on monitoring shell scripts.
- Worked on uni-directional golden gate setup.
- Migrated 10g database to 11g R2.
- Skilled with stats pack, AWR, ADDM, SAR to check health of database & hardware.
- Used Performance tuning tools such as tkprof, explain plans, oradebug and trace files to tune SQL Queries.
- Performed database cloning to setup test and development database.
- Migrated databases to different data datacenter.
- Handled RAC Node hangs and node eviction issues.
- Maintaining schemas and partitioning tables.
- Worked on DB Monitoring scripts
- Configured Alerts using 12c Cloud Control.
- Index management for better performance, maintenance of Oracle Database
- Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
- Responsible for administration and supporting oracle 11g, 10g and 9i databases
- Created, upgraded, and cloned Oracle databases for Development and testing databases.
- Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
- Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
- Performed large batch jobs, and tuning of SQL queries and database systems.
- Created indexes to facilitate easy user interface implementation and tuning.
- Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic
- Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
- Performed administrative maintenance, monitoring on Oracle database systems in a global
- Provided 24x7 operational environments.
- Involved in gathering requirements from end users.
Confidential, Chicago, IL
Oracle DBA
Environment: Oracle 9i, 10g, 11g RAC, ASM, Linux, Solaris, Data Guard, Golden Gate
Responsibilities:
- Installing ASM environment and migrating database from NON-ASM to ASM.
- Configure and manage tablespaces, tables, and users for custom applications.
- Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area
- Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
- Experienced with Space Management and Security.
- Experienced with GUI and CLI to manage database farm house.
- Rebuilding of Indexes for better performance and maintenance of Oracle Database.
- Tuning high - resource queries introducing hints and creating indexes/parturitions, changing the query if necessary
- Configured and Maintenance of SQL Server databases
- Implemented 10g, 11g Physical Data Guard.
- Implemented Oracle high availability solution using oracle RAC, Physical Standby and Golden Gate.
- Importing data from flat files into database using SQL loader and External Tables
- Written shell scripts to automate the tasks
- Physical and Logical database design.
- Database sizing, Capacity Planning.
- Worked on relational modeling using ERWIN.
- Worked very closely with development team
- Perform capacity planning required to create and maintain database environments.
- Supported 24/7 on-call pager support for mission critical financial databases.
- Involved in designing new structures/procedures/views/functions for development and Confidential from production to reports.
- Created users, roles and granted privileges according to the business requirements.
- Data Modeling, Database Design and creation using Erwin.
- Database performance monitoring, Application performance monitoring, tuning database and application with efficient database parameters..
- Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
- Automated the replication process using materialized views for reporting databases.
- Plan and acquire the new technologies for and implementation, suitable for the applications in regard to the specific future requirements of the company's business projections and growth.
- Applied latest patches as per evaluation requirement.
Confidential, Naperville, IL
Jr. Oracle DBA
Environment: Oracle 10g RAC, ASM, AIX, Linux, Solaris, Windows, RMAN, SQL*Plus
Responsibilities:
- Installed database using dbca
- Installed listener using netca
- Setup tnsnames.ora
- Troubleshoot networking issues.
- Install database using silent install.
- Ran scripts
- Helped in deployments
- Worked on user management.
- Configure and manage tablespaces, tables, and users for custom applications.
- Developed views,
- Worked on materialized views
- Worked on building DB Console.
- Installed Grid control agents
- Export and imported Data
- Worked on SQL Developer
- Worked on TOAD.
- Worked on Data Modeling using Erwin.