Database Analyst Resume
Charlotte, NC
PROFESSIONAL SUMMARY:
- 10 years of experience in handling and administering numerous databases and servers in distributed and complex environments. Expertise in system architecture design, database installation, upgrading, patching, migrating, and cloning. Extensive experience in implementing high availability technologies, database security, sox auditing, capacity planning, database backup and recovery, data replication, and performance tuning.
- Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 12c, 11gR2 Grid and 10g on ASM, ACFS and OCSF2 file systems including the engineered systems ODA and Exadata.
- Expertise in configuring and maintaining Oracle Database Appliance (ODA V1, X 3 - 2, X5-2) through ILOM.
- Highly experienced in Oracle 12c, 11g, 10g Automatic Storage Management (ASM), Flex ASM, ACFS required to fulfill the storage and high availability needs.
- Proficient in using the Snapshot technique in the ACFS environment on the ODA’s for refreshing the multi-terabyte databases within minutes.
- Expertise in configuring and maintaining Physical, Logical standby databases supported by Data guard on Oracle 12c, 11g, 10g RAC servers for high availability and disaster recovery.
- Installed and configured Oracle Golden Gate 12c, 11g application for active-active replication between datacenters for high availability on RHEL 6 platform.
- Expertise in implementing data replication using materialized views to make the data available between databases.
- Configured Oracle Enterprise Manager (OEM) Grid Control (in Oracle 12c, 11g, 10g) for monitoring multiple databases and application servers and experienced in using standard management, diagnostic, tuning, and change management packs to perform various administrative tasks.
- Expertise in attaining performance tuning for Oracle database using utilities like STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
- Achieved SQL tuning using SQL Tuning Advisor, SQL Access Advisor, SQL Profiler and SQL Optimizer.
- Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN with VERITAS Net Backup & IBM TSM.
- Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 12c, 11g, 10g) allowing users to quickly move a user Tablespace across Oracle database.
- Proficient in complete, incomplete recovery of the database, Point in Time Recovery (PITR), and Tablespace Point in Time Recovery (TSPITR) using RMAN utility.
- Experienced in installation and configuration of Oracle Database (12c, 11g, 10g, 9i) on Redhat Enterprise Linux, IBM AIX, HP-UX, Sun Solaris, and Windows environment.
- Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11gR2, and Oracle 11g to Oracle 12c through manual procedure and also using DBUA.
- Extensively implemented Datapump, conventional Export/Import (Oracle 12c, 11g, 10g) for migration and logical backup of database.
- Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
- Expertise in implementing data refreshes ( Confidential database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 12c, 11g, 10g.
- Expertise in implementing partitioning methodologies (Range partitioning, List partitioning, Hash partitioning, Composite partitioning) on tables and indexes for high performance.
- Strong skills in maintaining Database Security using security compliance auditing and expertise in loading data from flat files using external tables, SQL*LOADER.
- Having good exposure in user security, network configuration through TCP/IP, Listeners, TNSnames.ora and SQLNET.ora.
- Experienced in implementing scripts using bash, k-shell, backup purposes and writing procedures, functions, packages and triggers using PL/SQL.
- Highly experienced in job scheduling utilities like AUTOSYS (r4.5/11/11.3), UC4, and Crontab.
- Experienced in handling multiple tasks simultaneously and extended 24 X 7 database support to developers and end users.
- A self-motivated, responsible team player with positive attitude and willingness to learn new concepts coordinating with the Oracle support.
TECHNICAL SKILLS:
RDBMS: Oracle 12c/11g/10g/9i
Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.x, 6.x, Red Hat Linux RHEL 5.x6.x and Windows NT/2000/2003/XP.
Languages: SQL, PL/SQL, C, UNIX Shell Scripting.
Software’s, Applications & Tools: DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, Clusterware, ODA, VCS, Shareplex, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, VERITAS Net Backup, DBArtisan, SAN, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM.
Web Tools: HTML, XML.
PROFESSIONAL EXPERIENCE:
Confidential, Charlotte, NC
Database Analyst
Responsibilities:
- Performed installation, configuration and extended support to Oracle 11g, 12c two and three node RAC with ASM file system on RHEL 6 and RHEL 7 systems and Exadata Platforms.
- Planned and upgraded databases from 11g to 12c with ACFS file system on RHEL 6 platform.
- Migrated 50 11.2.0.4 databases from RHEL 6 to RHEL 7 as part of End of Life Migration project.
- Maintained and monitored Golden Gate 12c Consolidation Datamart environment with Heterogeneous sources (Oracle & SQL Server databases).
- Extended support for Golden Gate replication and troubleshooting extract/replicat ABEND issues.
- Installation of Golden Gate Veridata - Configuring veridata groups, compare pairs, profiles, jobs etc.
- Designed, Implemented and maintained Oracle 11g/12c Data Guard for providing High availability to the critical applications.
- Performed DR activity as a part of corporate policy every half yearly and provided artifacts for audit purposes.
- Implemented and Maintained DBVault and Transparent Data Encryption (TDE).
- Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
- Implementing Datapump, conventional export/import utility of Oracle 11g, 12c for re-organizing Databases/Schemas/Tables to improve the performance.
- Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts and scheduling jobs through Crontab utility.
- Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
- Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 13c Grid Control.
- Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
- 24 X 7 Production & Development database support and administration.
Confidential, Moline, IL
Database Administrator
Responsibilities:
- Performed installation, configuration and extended support to Oracle 12c, 11g 4 node and 3 node RAC (Real Application Cluster) with ASM on RHEL5/6 and Solaris 10.
- Configured Oracle Database Appliance (X 3-2, X 5-2) with 12.1.2.0 version and applied the next patches as per the guidelines provided by Oracle, latest being 12.1.2.6 version and maintained them using ILOM.
- Migrated the databases from ASM environment to ACFS file system on the Oracle Database appliance (ODA).
- Implemented Snapshot technique on the ODA’s with ACFS filesystem to refresh multi-terabyte databases within minutes, saving lot of time for the business.
- Working along with the Oracle Field engineer in the data center to replace the faulty disks and addition of memory/storage in the ODA’s as per the requirement.
- Experienced in Design, implementation and maintenance of Oracle 11g/12c Data Guard for both physical/logical standby databases in high availability mode.
- Performed switchovers on primary and standby databases as a part of DR activity.
- Supported bidirectional replication of real time transactions using Golden Gate 12c, between 3 different sites.
- Performed full & incremental backup (cumulative and differential) using RMAN as per the company policy and implemented recovery strategies using the available backups as per the business requirement.
- Recovered tables/database using Oracle Flashback Technology and Guaranteed restore points.
- Fixed various database performance issues by analyzing Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM), SQLT and Active Session History (ASH) and worked hand-in-hand with the Development team to tune their queries.
- Implementing Datapump, conventional export/import utility of Oracle 11g, 12c for re-organizing Databases/Schemas/Tables to improve the performance.
- Upgraded databases from 11g to 12c and also migrated critical databases from 11g to 12c including Non-
- ASM to ASM and also on the ODA’s.
- Successful in applying RDBMS patches, Grid patches and Infrastructure patches, security patches for improving the security and functionality of the databases/infrastructure.
- Monitored different databases and application servers using Oracle Enterprise Manager 12c for general maintenance and performance tuning and created reports to generate the growth rate and backup summary on monthly/daily basis.
- Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts and scheduling jobs through Crontab utility.
- Implemented scripts using bash, K-shell, Perl for monitoring, backup and patching purposes.
- Performed scheduling of the automated jobs using UC4.
- Working along with the team in AGILE method and providing status updates on daily basis in the standups.
- Performed user account management in the databases (privileges/roles etc.) in compliance with the SOX audit.
- Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace &
- TKPROF, EXPLAIN PLAN.
- Worked with Oracle support for troubleshooting various database issues
- Experienced in working with Database management tools like TOAD, SQL Developer.
- 24 X 7 Production & Development database support and administration.
Confidential, Charlotte, NC
Database Analyst
Responsibilities:
- Efficiently performed installation, configuration RAC/Non-RAC Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5/RHEL 6.
- Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Databases for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
- Involved in performing upgradation of Oracle 9i, 10g to Oracle 11.2.0.3 RAC database.
- Applied PSU/CPU Patches, ASM Patches, Grid Infrastructure Patches and one-off Patches as a part of maintenance activity.
- Successful in configuration/maintenance of Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC/Non-RAC databases.
- Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
- Installed, configured, administered Oracle Golden Gate 11g application for real time transactional change data capture as a part of POC.
- Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.
- Configured and monitored Quest Shareplex replication for Oracle 10g and 11g databases.
- Efficiently worked with developers to optimize the queries and improved the performance of certain system by proactively monitoring the resource utilization.
- Achieved optimal performance tuning by using explain plan, STATSPACK, SQL TRACE, TKPROF utilities and worked on SQL tuning using SQL Tuning Advisor, SQL Access Advisor, SQL Profiler and SQL Optimizer.
- Automated the Data Replication process using Materialized Views for reporting databases.
- Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
- Implemented Oracle Flashback Technology for recovering data Confidential database level and table level data.
- Performed incremental level 1 differential backup on daily basis and incremental level 0 backup on weekends using RMAN utility on scheduled time as a part of backup strategy and monitored the scheduled backups.
- Performed periodic refreshing/cloning of production databases to development & testing databases using RMAN Duplicate database.
- Extensively worked on complete & incomplete recoveries of the databases including Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility.
- Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.
- Effectively involved in tablespace management, database objects, partitioning of tables and re-organizing indexes for avoiding fragmentation and enhancing the performance of the sql queries.
- Implemented scripts using bash, K-shell, Perl for monitoring, backup and patching purposes.
- Fixed database network issues using Oracle Net Configuration Assistant, Oracle Net Manager.
- Performed scheduling of the automated jobs using AUTOSYS r4.5/11/11.3 versions
- Working with project management team to manage project schedules, priorities related database development, production and application implementation.
- Worked with Oracle support for troubleshooting various database issues
- Experienced in working with Database management tools like TOAD, SQL Developer.
- Extended 24 X 7 support to the production databases and prepared documentation of the maintenance and support activities.
Confidential, Richardson, TX
Database Administrator
Responsibilities:
- On-call L-2/3 Production DBA supporting over 1500+ Oracle databases on Unix/Solaris/AIX based platforms.
- Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
- Performed installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
- Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
- Installed ASM environment and migrated databases from NON-ASM to ASM.
- Installation, configuration and maintenance of Physical Standby using Oracle Data Guard for Disaster recovery process on Oracle 11g, 10g.
- Hands on experience managing Oracle Golden Gate including bidirectional replication, troubleshooting and diagnosing golden gate errors
- Use of Materialized Views, high availability technologies such as Oracle Streams in Oracle 11g, 10g for the purpose of data replication.
- Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control & local monitoring setup to troubleshoot and diagnose database problems.
- Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.
- Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
- Refreshed/cloned databases using RMAN utility.
- Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
- Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.
- Performed Database upgradation from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
- Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
- Achieved optimized performance for the databases by rebuilding indexes, implementing portioning methodologies (Range partitioning, List partitioning, Hash partitioning, Composite partitioning) on tables and indexes.
- Loading data from flat files to database using SQL*Loader, External Tables.
- Extensively used AWR, ADDM and explain plan for periodic performance tuning.
- Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
- Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
- Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
- Used TOAD for database management.
- Participate in Staff and technical meetings to discuss any outstanding issues and concerns and work with the team on any new procedures or policies that would improve the work efficiency.
- Made optimal use of Oracle Support in resolving the SRs.
- 24 X 7 Production & Development database support and administration.
Confidential, Dallas, TX
Database Administrator
Responsibilities:
- Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
- Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) Database.
- Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 10g R2.
- Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
- Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
- Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
- Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
- Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.
- Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
- Constantly monitor the performance (V$ dynamic performance views Confidential peak load) of the Databases and viewing Alert log files & Trace files.
- Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
- Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
- Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
- Maintained the data integrity and security using integrity constraints and database triggers.
- Provided 24X7 support for all the production and development databases.
Confidential
Database Administrator
Responsibilities:
- Installation and configuration of Oracle 10.1.0.2 database.
- Performed database upgrades from Oracle 9i to Oracle 10gR1.
- Implemented hot and cold physical backups using RMAN utility in Oracle 10g.
- Used conventional Datapump, conventional export/import for the purpose of logical backup of the database.
- Applied database patches, designed and created databases as per the requirements of the application users.
- Wrote SQL queries to manage database objects.
- Implemented SQL tuning and assisted developers with coding PL/SQL.
- Used PL/SQL for implementing “Stored Procedures and Triggers” based on business plans.
- Extensively used automated scripts based on v$views for proactive monitoring of database.
- Maintained security standards of the database by performing frequent auditing.
- Creating and dropping of users, granting and revoking rights as and when required.
- Continuous monitoring of the alert log file for any abnormal behavior.
- Involved in monitoring of queries, table space allocations, and data striping and troubleshooting issues related to user’s connectivity, permissions and performance problems.
- Used AWR, ADDM, ASH, Explain plan, SQL TRACE & TKPROF for the purpose of tuning and diagnosing of database performance by query optimization and trace facility.
- Worked in a 24 X 7 production database support environment.