PROFESSIONAL SUMMARY:

• A Certified Oracle Database Administrator with a track record of implementing database services geared at optimizing RDBMS functionality and productivity across heterogeneous environments. With over 6 plus years’ experience in improving and optimizing the performances of Oracle 10g, 11g and 12c databases, and 10 plus years in the IT field. Successfully demonstrated high skills in accomplishing various oracle environment expectations; database installations and upgrades, troubleshooting, advance backup and recovery operations, performance tuning, enforcing database security procedures, and performing other related database services. Heavy hand - on experience in:
• Database administration on Oracle databases version (10g, 11g, and 12c) as well as Oracle Virtual Machine(OVM)
• Establishing and maintaining sound backup and recovery policies and procedures.
• Database and application proactive level tuning and monitoring and Performance tuning using OEM/Grid Control/Manually.
• Installation, configuration and administration of Oracle 12C, 11g, 10g, Standby Databases for High Availability and Disaster Recovery purpose.
• Troubleshooting and resolving oracle environment issues and providing timely interventions: slow running queries.
• Extensive and advance knowledge on RMAN backup and recovery operations.
• Performing frequent refreshing/cloning of production databases to development & testing databases using RMAN, and DATAPUMP expdp and impdp utilities. .
• Some exposure to migration from 10g to 11gR2, 11gR2 to 12 and from non RAC to RAC environment.
• Applying CPU/PSU patches using the OPatch utility.
• Installing and managing Automatic Storage Management environment (ASM) on single instances and on RAC environments.
• In building DR (disaster recovery): - standby databases (physical and logical) on UNIX, LINUX, and Window platforms for Oracle High Availability involving Oracle RAC and Active Dataguard.
• Some exposure to TDE, GoldenGate, Oracle 12c Multitenant Environment and SQL Server.

TECHNICAL SKILLS:

Operating Systems: Linux, UNIX, Windows 7, 8, 10, windows server, and l inux & UNIX on Oracle Virtual Machine

Databases: OLTP, DSS and WAREHOUSE databases

Tools: Oracle Enterprise Manager (OEM) Grid Control, Oracle Expert RMAN, Datapump, SQL LoaderSQL*Plus

Languages: SQL, MYSQL, PL/SQL, Shell scripting, HTML

3 rd Party Tools: SQL Developer, Toad.

Networking: LAN/WAN (TCP/IP, DNS, DHCP) SAN, Subnetting.

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Oracle Database Administrator

Responsibilities:

• Part of a of nine-man DBA team maintaining and supporting several multi-terabyte databases of up to 10TB in production, test/development environments across different platforms (UNIX, AIX, Linux & Windows ), achieving the set goal of 99.99% uptime and at an acceptable level of performance.
• Work together with my team in planning, implementing and supporting database backup & recovery strategies and disaster recovery policies of databases in a highly availability environment using Oracle data pump and the RMAN tool.
• Work together with our developers from the development stage through deployment, performing schema/database refresh as needed and other forms of data movement from production to development & test databases using RMAN and DATAPUMP EXPDP & IMPDP utilities.
• Scheduling various forms of RMAN backup using CRON or via the scheduler on OEM Grid control, and automating hourly, daily, weekly system health reporting using Crontab, PL/SQL and shell scripts.
• Frequently monitoring resource utilization at both database and O/S level making suggestions to our system administrators for upgrades of software and hardware (memory, CPU, disk) which have always resulted in higher overall system performance.
• Frequently using Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configuring EM agents on multiple database servers.
• Creating database objects as needed conforming to best practices recommended by oracle, and also managing appropriate use of free space within tablespaces, reclaimed space whenever possible and reorganizing tables and indexes within databases when needed.
• Frequently running diagnostic tools to identify database performance bottlenecks, and taking appropriate corrective actions to improve performance using best known performance tuning tools such as Explain Plan, SQL TRACE, TKPROF, STATSPACK/AWR, ADDM, ASH Reports, SQL tuning advisors etc.
• Excellent in database creation, Upgradation and migration of Oracle database releases ranging from 10g to 11g, 11g to 12c, and apply various patches as needed (interim patches, patch sets, CPU, and PSU).
• Expertise in Data Guard (disaster recovery): - creating standby databases (physical and logical) on UNIX, LINUX, and Window platform, and actively involved in Data guard switchover and failover.
• Together with other team members been involved in implementing ASM with RAC 2 nodes high availability environment on oracle 11g and 12c environment. And some exposure to Oracle 12c Multi-tenancy RAC database with 2 node cluster and instances using ASM storage.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges)
• Collaborate with developers, application experts, and other On/Offside team members to investigate and resolve performance problems.
• Provides 24x7 production and non-production DBA on-call support.

Confidential, Austin, Texas

Oracle Database Administrator

Responsibilities:

• A member of the DBA team that manages several production and development databases in diverse environments for a multitude of clients, managing about 250 databases (Oracle on Sun Solaris (UNIX), Linux Red hat & Centos) platforms, with sizes ranging from 1GB to about 2 terabytes.
• Create and configure Oracle Databases 10g and 11g databases in production, development and test environments using both the DBCA and manually using database creation scripts.
• Create primary database storage structures (tablespaces) and objects (tables, views, indexes etc.).
• Schedule and perform various modes of backups using RMAN
• Monitored database performance while generating report through AWR, ASH and ADDM using OEM and Grid Control, generated reports as needed.
• Monitor and proactively tuned Oracle databases via the OEM 10g and RAC platforms 11g or using the Advisors (SQL Access Advisor, SQL Tuning advisor, and SQL Repair Advisor) or using scripts.
• Enhanced existing database designs for improved longevity, reduced maintenance, and improved performance.
• Assist with the development and implementation of database architectures for new projects.
• Perform database migrations, conversions and upgrades.
• Design, build, test, and deploy new databases.
• Maintain and administer databases and supporting automation (e.g. database objects, security roles, capacity, performance tuning, import/export, alert rules)
• Migrated databases from Windows to Linux using transportable tablespaces.
• Resolve database issues (incident and problem management)
• Establish database standards and best practices
• Work on High Availability, Backup and Recovery options and help to implement solutions
• Design, implement and maintain database security procedures
• Automate routine database support tasks
• Apply various patches( interim patches, patch sets, CPU, and PSU)
• Monitor and optimize the performance of the database.

Confidential

Oracle Database Administrator

Responsibilities:

• Installation and upgrade of Oracle DBMS instances
• Allocated system storage and planning for future storage requirements for the database and related functions.
• Created primary database storage structures and objects once application developers have designed an application.
• Modified database structure as necessary per directions given by the application developers.
• Designed, implemented and maintained database security procedures. Also ensured compliance with Oracle License agreement.
• Controlled and monitored user access to the database.
• Planned and executed backup and recovery activities (Control Files, Redo Logs, Rollback Segments, System Data Files, etc.) to ensure timely and complete recoverability. Maintained archived data on disk or other media as defined. Backup and restore the database (Online and Complete) to assure restoral capability.
• Planned and performed set up, maintenance, and troubleshooting of replication tools. Advised development staff of “best practices” in this area.
• Completed software readiness review checklists (took action as required).
• Monitored the production Oracle alert logs for database errors.
• Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
• Completely eliminated space errors by implementing proactive space monitoring and effective space allocation.