Occupation:Database Administrator |
Location:New Castle, DE |
Education Level:Master |
Will Relocate:YES |
Description
Professional Summary * Over 6 years of strong experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows, supporting a variety of mission critical applications with Oracle 10g and 11g. * Experience in upgrading databases from 10g to 11g and 11g to 12c using DBUA (oracle database upgrade assistant) and manual method. * Management of database security with managing users, grant user privileges on data dictionaries, schemas, tables and table spaces, creating roles and profiles, password authentication, table partitioning, indexes, grant quotas for users. * Experience in application and memory tuning with explain plan, TKPROF, STATSPACK, SQL trace, SQL optimization utilities, SQL tuning advisor, SQL access advisor and SQL planned management. * Experience in using tools like AWR (automatic workload repository), ADDM (automatic database diagnostic monitor) and ASH (active session history) for database performance reports * Proven technical knowledge of infrastructure management (network, systems), combined with outstanding leadership ability and creative problem solving skills in both strategic and tactical areas as well as excellent communication /documentation skills and strong aptitude to analyze and resolve problems. * Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC. * Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant (ASMCA) * Experience in installation, upgrade and maintenance of RAC (Real Application Cluster) 10g and 11g databases to support online applications. * Configuring Automatic Storage Management (ASM) which includes creating disks and disk groups for oracle 10g and 11gR2 RAC databases. * Experience in monitoring oracle instances and maintaining databases, performance using OEM (Oracle Enterprise Manager), Oracle GRID-control and database monitoring using 11g Grid monitoring tool. * Responsible for RMAN backups, and improvement to backup with incremental back by adding block change tracking feature of Oracle 11gR2. * Maintaining and scheduling Cold Backups, Hot Backups, and Export Dumps. Maintaining backups of Archive logs and automating cleaning of archive logs. Deploying RMAN to automate backup and maintaining scripts in recovery catalog. * Data transferring with export/import utilities and Data Pump and SQL* Loader. * Performing complete and incomplete recovery during disasters, failures and user errors. * Configuring user creation, their roles and privileges profiles to control access over database objects. Experienced with Space Management and Security. * Management of table space growth, monitoring data files additions, extent growth * Performed Database, OS and application tuning. * Monitoring Growth of tables and undertaking necessary re-organization of database as and when required. * Monitoring Scheduled jobs of the daily activities for the performance of all the databases. * Prepare the documents of the process and knowledge transferring about the project to the new team members. * Used Database export/import using exp and imp utilities to take logical backups. * Performed Data loads using SQL loader utilities. * Contact to the development team to solve the issues with the new enhancement releases. * Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.
Accomplishments
Highlights:
Keywords
