DATABASE PROFESSIONAL PROFILE

• Oracle Database Administrator with over 5 years of working experience and over 10 years of IT experience. Possesses extensive experience in Administration, Application, Installation, Configuration, Performance tuning, Proactive Monitoring, Troubleshooting, documentation in Oracle and MS SQL servers with strong Interpretation, written and verbal communication skills..
• Provided support for Full Product Lifecycle environments in Development, Testing, Application and Production environments with strong problem analysis and resolution skills from O/S to database perspective.
• Have Extensive experience in administration, management of oracle 9i, 10g, 11g, R12, SQL, PL/SQL, Perl, RMAN, Datapump, ASM, RAC, Exadata, Dataguard, Oracle Goldengate, Stream, T-SQL, OEM Grid Control, 12c, OBIEE, various platforms: AIX, LINUX RedHat , FreeBSD, Solaris, HP-UX, Tru64, FreeBSD, Sybase, MS Windows.

PROFESSIONAL EXPERIENCE

Confidential

Title: Sr. Oracle Database Administrator

Confidential

Title: Oracle Architect Principal Oracle MS SQL Server DBA

Responsibilities include but not limited to Daily Backup, Proactive Monitoring, performance Tuning, Checking: Alerts, Trace files, Space Management, Configuration, Installation, Administration, Troubleshooting database instances and O/S on various platforms

INSTALLATION CONFIGURATION

• Installed and Configured Oracle, Oracle Software, 9i, 10g 11g on various Operating systems
• Installed Configured Databases following Optimal Flexible Architecture using DBCA, Grid Control, Db Console, RMAN and Manually with Scripts.
• Configured RAID on local file system to improve disk performance datafiles protection.
• Collaborated with SYS Admins to configure Software for Database functionality.
• Installed, Configured Oracle Grid control, OEM dbconsole, OBIEE, ASM, RAC, Dataguard, Oracle Client Oracle 12c for Remedy 3 tier standard uses.
• Installed, Configured sqldeveloper and External Tables, ETL, to load flat files.

BACKUP AND RECOVERY

• Configured and implemented Backup and Recovery using RMAN for physical backups and Datapump for Logical Backups.
• Turned On Block Change Tracking BCT to speed up RMAN Merged incremental updatable backups
• Automated daily tasks / jobs at O/S level using Crontab, AT command and Oracle SCHEDULER DBMS procedures at the Database level
• Configured and Implemented Archiving, Flash Recovery for Flashback and Backup with SQLP PLUS, RMAN, OEM dbconsole, LogMiner, Datapump
• Configured RMAN retention Undo Flash back Retentions in OLTP to hold data long enough for recovery.

DATABASE REORGANIZATION

Reorganized and Restructured existing Databases to meet Oracle OFA standards, improve performance and moved databases using Datapump Export Import, SQL Loader, External Tables, and The Move Command

• Reorganized databases using backup controlfiles to trace
• Resized, relocated datafiles and duplexed redo logs to reduced log Switching
• Organized and shrank segments eliminating Chained, Migrated Rows resumable space allocation
• Replicated data, Partitioned tables, and stripped tablespaces for protection and availability.
• Moved Databases and file systems to ASM and managed them with RAC

DATABASE OBJECTS CREATION

• Created Database links, views, synonyms, functions, Schema Objects, Tablespaces, Application Users, profiles, and Granted, Revoke privileges and roles.
• Created Databases from scripts, export dump files for development and test use by Developers
• Created, Altered and Managed databases, schemas, Sequences, Constraints, and supported Oracle 9i, 10g, 11g and databases on SSMS, veritas clusters.

SQL, PL/SQL, SQL Plus and Datatypes

• Managed databases using Oracle utilities: SQL, SQL Plus, PL/SQL and Datatypes
• Compiled PL/SQL blocks, Packages, Procedures, Functions, Triggers and used WRAP to encrypt PL/SQL application.
• Used SQLCODE and SQLERRM in exception to handle reports and store errors in log table with code
• Extensive knowledge of clustering, b-tree, and bitmap indexes
• Generated Debugging output from PL/SQL using the SHOW Error command, the DBMS OUTPUT package and UTL FILE package

DATABASE REFRESHMENT

• Refresh the database using Export/Import, Datapump, the Create Table As Select statement data copying , Database link Functions with the Group By Clause
• Used SQL Joins to Select, ordered, Sort Access data from multiple tables.

DATABASE MIGRATION

• Designed, tested, corrected, documented, implemented, migrated, unload/offload, moved Data from one database to another, locations, sites, using Export Import Datapump, SQL loader, External tables, Golden Gate, Oracle Streams, ETL, RMAN, database links.
• Used Oracle Migration Workbench OMWB to migrate third party databases Sybase, Informix, DB2 to Oracle platforms
• Migrated databases, schemas, tables, Data from windows to Unix using Export Import, Datapump Utilities.
• Migrated Oracle databases from 9i to 10g to 11g using Datapump, Transportable Tablespaces, RMAN, Data copying via CTAS and Table movement via database link.
• Moved, unload/offload data using Import/Export, datapump, SQL loader, External tables, Golden Gate, Oracle Streams, ETL, database links.

DATABASE UPGRADE

• Upgraded Oracle Software 9 10g version releases from 10.2.0.1 to 10.2.0.3, to 10.2.0.5 to 11g on Oracle Solaris, Windows platforms, Linux Red Hat, CentOS, ..
• In-place upgrades of Oracle 9 to 10g to 11g using DBUA Out-place upgrades using SQL scripts, Datapump
• Upgraded existing databases by applying Patches to various versions of Oracle.
• Performed database Refreshes to update data from production to Development and test environments.
• Applied and patched Oracle CPU, PSU, Interim Patchset using OUI OPatch.

CAPACITY PLANNING

• Planned software release, upgrades to implement in development, test and production environments.
• Participated in Database Change Control meetings, reviews and suggestions
• Supported 3 tier architecture, planning for tables, indexes, tablespaces and databases to allow for growth potential and analyzed data growth trends for future growth and Memory MMAN .
• Evaluated Recommended tools for database monitoring and remote administration
• Reviewed Storage needs, Security Authentication needs and objects growth for monthly and/or annual budget

ORACLE NETWORKING

• Configured and managed ODBC Data Source , SQL Net/Net8 utilities, Oracle Shared and Dedicated Servers using Net manager, NETCA
• Setup Oracle Stream and database links
• Configured TCP/IP, resolved DNS issues for users, updated configuration files and remedy action request system on Windows servers.
• Supported IT infrastructure as Windows System Support Engineer using Acronis for systems backup support tasks, Windows 2003 Active Directory and general user support roles.

MONITORING TROUBLESHOOTING

• Monitored table fragmentation using Scripts on Data Dictionary views, to avoid performance degradation
• Monitored system access memory by performing routine checks on the SGA, CPU, logical and physical I/Os, Alerts, free space, lock contention, disk utilization, poor connection.
• Gathered Statistics System information using Remote Diagnostic monitor RDA to troubleshoot and document systems performance and Audit users activity
• Troubleshoot issues arising within the Remedy systems and/or within the databases using OEM Grid Control, dbconsole, scripts on Remedy's Ticketing system.
• Write SQL shell batch scripts to fix errors, problems, incidents within databases O/S
• Troubleshoot resolved database issues for Clients/Users using Oracle Advisors, AWR, ADDR, ADDM, RDA

DATABASE STATISTICS

• Gathered and managed AWR statistics, set Baseline, Metric Thresholds used OERR Utility to extract error messages and recommended solutions
• Analyzed Tables, Indexes and Clusters against Chained and Migrated Rows using dbms stats, analyzed statement, Cost Base Optimizer, dbms workload repository package, TKPROF, EXPLAIN PLAN,
• Automated, managed, Diagnosed databases and O/S using RDA, Server-Generated Alerts, ADDM, AWR, Advisors, ADDR, Toad Captured, ADRCI, ASH, Shell Scripts, SQL PL/SQL scripts, Autotrace, DBMS SQL Tune package, Shrink command to reclaim free space and improve performance
• Configured, Analyzed the system using OBIEE and Worked with user base to provide analytical and operational tools used in market operation and also Contributed to both product development and process improvement using RDA, Oracle 12c and OBIEE outputs

MANAGEMENT PERFORMANCE TUNING

• Automated memory management, Self Troubleshoot and resolved Oracle and system errors using scripts, Metalink MOSC , SQL Tuning and SQL Access Advisors via OEM, DBMS SQLTUNE Package, DB control, alerts, trace files, dynamic performance views, data dictionary, DBMS Advisor.
• Partitioned Partition pruning : Very Large Databases to avoid entire database corruption, shorten backup time, increased queries performance , and Tables to improve performance, security and easy manageability of data load using SQL Plus, Sqldeveloper, External Tables and OEM Grid control, 12c
• Used Graphical tools, dbconsole and queries to resolved locks, identify and fix invalid objects and unusable Indexes
• Created synonyms and views to ease object access, enhance security, prevent errors and improve performance
• Directed transfer of ascii and binary files at Command line interface using FTP client, telnet, SSHSecureShell, WinSCP439, FileZilla, TightVNC
• Checked Sort area and Stackspace for performance
• Managed User and Consumer groups, execution time and Resources
• Tuned Oracle database objects using Oracle Hints, dbms redefinition, initialization parameters and SQL statements with Explain Plan
• Excellent knowledge shell scripting, batch jobs, and Automatic job scheduling.
• Automatic Storage Management
• Installed, configured and administered ASM on Windows, Linux and Unix Servers in Test, Development and production environments for logical volume management.
• Used ASMCMD utility, ASMLIB RMAN to manage ASM disk groups
• Created ASM Disks, Raw Devices, ADVM, ACFS, Mounted/Dismounted, Added and/or dropped Disk groups.
• Configured CSS, Set ASM Disk group attributes Monitored running operations on ASM instance.
• Migrated Datafiles from Local File Systems to ASM and moved Tablespaces, datafiles, databases, to ASM.
• Implemented RAID levels for local file systems management and datafile protection

REAL APPLICATION CLUSTER

• Configured Workload Distribution client server sides in RAC, Cluster Interconnect, Cache Fusion, Network Interface and Oracle Agents
• Configured Transparent Application Failure TAF , Fast notification failover FCF , Fast Connection Failover FNF . Administered Database services in RAC environment, Set up load balancing for RAC databases.
• Configured and managed RAC installations using OUI, DBCA, NETCA, SRVCTL, CRSCTL, OIFCFG

DATA GUARD

• Configured, documented, Tested Primary and Standby databases Dataguard on servers remote sites for Maximum performance, protection, and availability.
• Managed physical and logical standby databases with dataguard Broker utility, dataguard manager, OEM, Log Transport Services, Log Apply and Role management services for performance and reporting
• Carried out test plans on primary database' switchover and failover Role for disaster recovery and reporting in new environments.
• DATABASE CLONING DISTRIBUTED SYSTEMS ARCHITECTURE
• Cloned databases from one server to another using RMAN, Datapump, Export/Import, OEM, CTAS, Copy, SQLPLUS/SVRMGR, to use for testing refreshment in development environments by Application teams
• Experienced with GOLDEN GATE to replicate and distribute data from one database location to another in Test and development environment.
• Created Materialized view snapshots to backup critical data to remote location, send data directly to data warehouse used for reporting
• Configured and managed Oracle Stream for fault tolerance and performance
• Used Extract Transform Load ETL tool to pull data out of one database and place it into another database.

DATABASE SECURITY

• Created and managed database User Accounts, Profiles, Roles, by enabling Data dictionary protection with 07 dictionary accessibility True
• Limited and Restricted users from accessing O/S/database via vendor with Standard Database Auditing Triggers
• Encrypted sensitive data and backup media using Transparent, Password and Dual encryptions
• Authenticate clients string, passwords and system resources to meet companies SLAs and corporate password expiration policy standards by ensuring Principle of Least Privilege.

PATCHING

• Planned, implemented and applied database CPU patches Quarterly as recommended by Oracle to enhance system security and functionality
• Installed Patchsets using OUI and Oracle CPU, PSU Interim installed using OPatch.

DATABASE SYSTEM DESIGNS

• Worked ask Senior Data Architect with other Data Architects to improve Oracle design, implementation, monitoring, availability, performance, and cost-effectiveness using CASE Tools, RDA output, OBIEE CBO statistics
• Used crous foot to defined relationship between entities in tables
• Created Entity Relational diagrams via Forward Reverse Engineering using Erwin, Oracle Data Modeler requested by Developers for Normalizing/ Denormalizing systems
• Configured, Analyzed system and Worked with user to provide analytical operational tools used in market operation using Agile Data Method of Refactoring to Evaluation Enterprise Models
• Implemented Agile Data Method strategies to support organization using database Refactoring Techniques to improve database quality, programming DSDM fixing legacy database.
• Stripped tablespaces at database level to increased performance and protection
• Analyzed and Contributed to both product development and process improvement

MS SQL SERVER, 2003, 2008, 2010

• Installed and Configured Enterprise, Evaluated, Express and Compact SQL Server Editions.
• Configured and managed SQL Server Management Studio SSMS , created databases, Functions, Schemas objects, tables and Designed Diagrams,
• Configured, Managed, Recovered, Restored Backup databases using Full T SQL Differential backups
• Scheduled Backup Jobs using Maintenance Plan Wizard

Other IMPLEMENTATIONs INCLUDES

• Implemented change requests, database structure modifications and/or data changes via coordinated Change Request meetings with supported Team Leads.
• Investigated, designed, tested and implemented database Security procedures following Oracle recommendations.
• Coordinated, supported and managed DBA tasks on Projects for new Test, development production
• Provided technical support, Guidelines, and assisted System Administrators, programmers, IT Support Staffs developers in system designs using Erwin, Oracle Data Modeler,
• Compiled, Documented procedures, standards and guidelines provided technical support directions for database system enhancements, basic configuration, administration and maintenance of existing projects.
• Support the team of software engineers in an ongoing full product development lifecycle.
• Prepared Participated in meetings, cut-over steps, checklists and procedures of new sites requested by Client sites.
• Provided weekend support during time sensitive projects, stayed late at night to deliver to customers on time and effective.

OTHER SOFTWARE OPERATING SYSTEMS:

Oracle Applications, OLTP, OLAP, Oracle Warehouse, Oracle Designer, BMC, Remedy Application Management systems, Sharepoint, ETL, PVCS, MS-Excel, MS Access, SQL Servers, Tivoli Desktop, Spotlight on Oracle, SQL lab vision HP 9000, SunFire, Dell Power Edge, HPUX, Exadata, Tru64 UNIX 4.0 Alpha, AIX 5L Version 5.1, Windows 2003, 2008, 2010, XP/NT4.0.