SUMMARY

Results - producing database architect, database administrator and aws cloud solution architect with over 18 years of progressive experience designing and implementing databases. Expert in Implementation Oracle 10g/11g/12c RAC, ASM, Dataguard Database and Configuration for High Performance and High Availability with latest Cluster Technology. Leverage exceptional strategic planning and leadership skills to optimize technical project outcomes. Expertise in Oracle performance tuning, RAC tuning, and SQL optimization. Additional skills in AWS cloud solutions, big data and NoSQL databases.

TECHNICAL SKILLS

Operating Systems: UNIX - Solaris, HP UX, AIX, Red Hat Linux, Windows, VMS

RDBMS: Oracle Enterprise, V6.X, V7.X, V8.0.X, V8i, V9i, 10g Releases 1 and 2, 11g, 12c (12.1-12.2) SQL, MS Access, PostreSQL, MySQL, SQL Server 2000 - 2016, Cassandra, MongoDB, AWS DynamoDB, AWS Auroa,Redshift

Hardware: HP 9000 Series, HP Superdome, Sun Ultra 4500/6500/10 K, HP DL585/AMD

Tools: SQL*Plus, OEM 11/12c/13c, SQL*Loader, ERwin, RMAN, tkprof, StatsPack, Explain-Plan, AWR, Scheduler,SQL Server Management Studio, Visual Studio, Data Pump, ASH, ADDM, TOAD, DBArtisan, Oracle Apps 11i, R12, Oracle Interconnect 9i/10g,Weblogic 6.x/8.x

Programming: C/C++; SQL; PL/SQL, HTML, Perl, Korn, Bash, DOS, CMD Shell Scripting, Powershell, Python, java

Oracle Real Application Cluster Skills: Determining the Oracle RAC Architecture, Choosing the best RAC server Hardware, Installing Oracle RAC software, Performance tuning for Oracle Real Application Clusters

Oracle Database Administration: 15 years (7.3.x, 8.0.x, 8.1.x, 9.x, 10g, 11g, 12c (12.1 - 12.2) databases.10g/11g/12c RAC, 11g/12c DataGuard (Physical and logical).

PROFESSIONAL EXPERIENCE

Senior DBA / Architect (Consultant)

Confidential, Berlin, CT

Responsibilities:

• Manage and support of over 550 Oracle databases running on AIX, Linux, Windows, and Solaris and over 500 MSSQL server instances. Most of these databases runs critical applications that needs to be highly available.
• Lead strategic planning to improve and fine tune databases, servers, and applications.
• Managing team of offshore DBAs involved in Production support and Development activities and providing necessary support.
• Involved in supporting day to day activities in 24 7 Production environment.
• Oracle Data Centre Migrations, Consolidation and Upgrade/Migrations of Oracle Databases for different Oracle Versions and platforms.
• Patching and Cloning of Oracle databases and Oracle Apps Instances.
• Logical Physical DB Design involving Change Management process with ITIL Oriented framework with adherence to business SLA depending on the business environment.
• Spearhead design, installation, configuration, performance evaluation, and upgrade activities for Oracle server software and related products.
• Monitor and ensure optimal delivery of 24-7 technical support services.
• Mitigate data loss or security risks by implementing sound backup and recovery policies and procedures.
• Maximize database safety by developing and maintaining users and roles and assigning privileges.
• Successfully installed and configured RAC databases and Dataguard databases for critical systems like Outage Management system, EDI. Focalpoint, Oracle EBS(Galaxy).
• Create Oracle 12c multi-site RAC database between production data center and non-production data center. This serves as HA and also a DR database.
• Performance tuning of queries, Database Performance improvements on Critical production Environment.
• Performance tuning of SQL, PL/SQL Queries, tuning using dbms profiler, sqlt, Trace analyzer, ash reports, AWR report, AWR SQL Reports. Analysis of Wait events and analysis of trace files using tkprof.
• Upgraded databases of different sizes database sizes from 1 gig to 5 Terabyte support on different OS Environment.
• Raising TAR and solving issues as part of bugs arising during Production issues. Preparing Key -Reports, Metrics, RCA's etc. for the management.
• Logical Physical DB Design involving Change Management process with ITIL Oriented framework with adherence to business SLA depending on the business environment.
• Planning Implementation of Backup using traditional RMAN, RMAN with Netbackup, TSM, DDBoost and SOX restoration including recovery scenarios based on the operational issues.
• Modifying, creating of various shell Scripts for Services management, Process monitoring, Clearing logs, setting environmental variables.
• Setting up of Oracle Best Practice's Tools like OSWatcher for monitoring and analysis of the database servers.
• Implementation of the database objects in Productions through change management procedures.
• Troubleshoot, fix regular issues arising in Production and development including performance issues arising in Production and Development databases.
• Schedule and perform database backup frequencies and initiation procedures that conform to the application's data maintenance design and the physical constraints of the production platform.
• Installed and configure Oracle Enterprise Manager 12C, 13c for monitoring of databases.
• Performance tuning, Dataguard operations using Oracle Enterprise Manager.
• Capacity planning and space management at Database level and adding Disk Space at ASM with rebalance.
• Coordinate with cross functional to perform root cause analysis of problem/incident tickets related to database.
• Perform tablespace and table compression using oracle advance compression feature.
• Involved in the ITIL process and used ITSM ticketing software to resolved database related tickets.
• Responsible for managing critical database related incidents, root cause analysis, communication and preventative actions.
• Make complete analysis on database environment and provide recommendations to improve processes like patching, automating database creation and automating common operation tasks.
• Cloning and refresh of the database from production to lower levels and between lower levels using database utilities like RMAN, datapump.
• Monitoring Memory, CPU and IO activities periodically tuning them.
• Performance Tuning of Queries SQL,PL/SQL and Databases on adhoc basis based on operational activity.
• Configuration of Oracle Standby Databases(Active Data Guard) for high availability/Disaster Recovery Solution from Production Server to the DR Server
• Addition of new nodes on 2 clusters 11g and 12c.
• Use of Cloud Control to monitor and support several components including: Grid Infrastructure, RDBMS, ASM, Listener, SCAN, RAC, queries, tablespaces and datafiles.
• Tuning of DML's statements on Oracle RDBMS 10g, 11g and 12c.
• Configuration and implementation of AUDIT security on oracle databases for each transaction
• Installation, configuration and upgrades (patches apply and rollback) experience with Oracle RDBMS versions 10.2.0.4, 10.2.0.5, 11.2.0.3, 11.2.0.4, 12.1.0 and 12.2.0 and tools including: TOAD, ASM, Cloud Control 12, Oracle Grid, Database Cluster RAC 11g and 12c, PGAdmin.

ORACLE DATABASE ADMINISTRATOR

Confidential, Chesapeake, VA

Responsibilities:

• Optimized performance of data warehouse, data mart, and OLTP repository databases for pharmaceutical clients supporting over 200 Oracle and SQL Server databases.
• Served as subject matter expert for SQL, database installs, database logical and physical structure, and storage allocation areas.
• Managed and improved database software upgrades, security and patching, capacity analysis, and documentation procedures.
• Increased operational efficiency by automating many common tasks including backups, exports, imports, record archiving, and verification of such processes.
• Standardized database software releases and install procedures.
• Led Oracle upgrades and managed 9g/10g/11g logical and physical database design, implementation, and maintenance on UNIX and NT.
• Worked with the client's personnel in setting up and upgrading standards and best practices on software, database and application server installation, upgrading, and configurations.
• Mentored Client's DBAs on installing and upgrading Oracle databases and application servers.
• Prepared Project Plan for developing global enterprise application. Create Test Plan and review with QA Team for the Product Test Environment.
• Write UNIX/ Linux shell scripts as per requirement. Schedule CrontJob as per requirement.
• Application Performance & Tuning for SQL and PL/SQL code.
• Experience of Extraction Transformation and Loading (ETL) processes using UNIX Shell scripting, SQL, PL/SQL and SQL Loader.
• Application performance & Tuning using TKPROF generating report from Sql trace file.
• Compiled cost-based optimizer (CBO) statistics for tables with stale statistics (performance tuning).
• Configured Oracle 11g/12c RAC databases.
• Analyzed AWR, ASH and ADDM reports for resolving DB performance issues.
• Cloned oracle production databases for development and testing
• Cross platform Migration of databases using export/import and datapump
• Resolution of day to day related issues, documentation of Oracle DBA routine tasks.
• Creating documentation during project planning, project execution and project maintenance.
• Replicate and Extract data from Cegidim data centre to external pharmaceutical companies like Confidential, Confidential, Meda using materialize views for snapshot replications.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Architected, Designed, Installed and configured Oracle 9i,10g and 11g Databases on Solaris, UNIX and Linux platforms
• Automated many common tasks using crontab including Backups, exports and imports, archiving old records and verification of such processes.
• Established, tested and documented RMAN backups and recovery policies
• Upgraded production and all test databases from Oracle 9i to 10g to 11g.
• Automation of Startup, Shutdown on all production and development databases using UNIX/Linux scripts.
• Apply Oracle patches and PSU's and CPU's
• Monitor trace files and log files for errors and database corruption.
• Maintained and created database user accounts and oracle roles with appropriate privileges
• Creation, maintenance and management of all database objects, including tables, clusters, indexes, views, sequences, packages and procedures for Development, Testing and Production's environments.
• Database migration from 10 to 11g using cloning for storage, tablespaces transportable and duplicate database using RMAN.
• Configuration single and RAC databases in archivelog mode
• Troubleshooting of SQL Server day by day issues related with disk, I/O, CPU and memory.