SUMMARY:

I am an Oracle Database Administrator with more than 15yrs experience in healthcare sector. Designing, implementing, monitoring and tuning high availability RAC database clusters using RMAN, DATAGUARD, OEM in UNIX servers. My experience is broad and includes application/database and infrastructure support and administration in all areas of Oracle RDBMS stack.

PROFESSIONAL EXPERIENCE:

SR. DATABASE ENGINEER

Confidential, Tempe, AZ

Responsibilities:

• Provision, build and patch servers and database infrastructure, 11gR2 and 12c databases, HA, RAC, Data Guard, Linux and VM including kernel, luns, storage, CPu, memory.
• Create/Migrate/Refresh all Oracle DB environments using ADG, RMAN and data pump during all phases of migration.
• Perform capacity planning and ensure performance optimization and scalability of RDBMS and physical storage.
• Oracle 12c, 11gR2 RDBMS, MS - SQL 2016, T-SQL, SQL, PL/SQL, ASM, RAC, Data Guard, OEM12c Cloud Control, RMAN backup/recovery/clone, Linux and VM.

SENIOR DBA

Confidential, Phoenix, AZ

Responsibilities:

• Provide 24/7 on-call support for production database environments to ensure the highest level of availability.
• Maintain development, Test and QA environments and test application release upgrades and database patch releases on monthly schedule or as required.
• Use OEM to monitor alerts and proactively determine future resource needs and contention and tune RDBMS and examine performance bottlenecks and take corrective measures to maximize performance.
• Build, patch 11gR2 and 12i databases, using RAC, Data Guard, on Linux and AIX.
• Work closely with application development teams to maintain standards and review all DDL/DML and sql code for turnover and deployment in production environments.
• Create/Refresh all Oracle DB environments as requested to support development efforts.
• Gather metrics daily, weekly and monthly on growth and resource utilization to enable DBA group to perform capacity planning and ensure performance optimization and scalability of RDBMS and physical storage.
• Oracle 12i, 11gR2, 10g, 9i, RDBMS, MS-SQL 2008 R/2012/2014, DB2 8/9 UDB/LUW, RAC, Data Guard and Golden Gate replication, OEM12c Cloud Control, TSM, RMAN backup/recovery/clone,T-SQL, SSMS, Linux, AIX, Solaris, HP-UX, CRS, ASM, CFS, AWR, ADDM, ASH, Shell, CRON, SQL, PL/SQL, LPAR, VM.

SENIOR DBA

Confidential, Phoenix, AZ

Responsibilities:

• Provide 24/7 hour operations support on rotational basis, of all Oracle environments.
• Provide DBA resource to project development, for wide range of financial and medical systems.
• Assist in application design with schema development and normalization using data modeling techniques.
• Determine necessary hardware and software configurations/resources for databases and the applications they support.
• Review all changes to the database as requested by development teams, to ensure consistent standards are followed, and make recommendations when appropriate.
• Create/Refresh all Oracle DB environments as requested to support development efforts.
• Implemented monitoring scripts to proactively provide alerts for space usage exceeding predefined threshold to ensure database availability.
• Investigate performance bottlenecks and tune database memory structures and initialization parameters as well as contention and physical storage.
• Oracle 10G RAC v. 10.2.0.4 RDBMS multi-node, CRS, ASM, OCFS, Clusterware, OEM Database-Grid Control, RMAN and Replication technologies on Solaris, AIX, Linux, WinX
• Oracle 9i RAC v. 9.2.0.5 RDBMS, RAW, RMAN, Oracle Enterprise Manager, AIX 5.2(64bit), P-series, ERWin, ER/Studio, Confidential -Shark, BMC-patrol, SQL Backtrack, Quest-Spotlight.

SENIOR DBA

Confidential, Phoenix, AZ

Responsibilities:

• Provide leadership in database technology and assist in systems development for a wide range of research projects.
• Implemented Oracle Collaboration Suite, Oracle Files and Ultra search tools for storing research data in a commonly accessible data warehouse.
• Presented, research information through oracle web portal to hundreds of researchers and scientists.
• Implemented DB2 UDB database for research and data warehouse applications in support of the many biomedical research initiatives being under taken.
• Created a fail-over environment where by all databases could be run from anyone of the multiple P-series servers.
• Installed oracle 10g RAC 10.2 multiple node cluster on linux X-series servers.
• Oracle Application Server (OAS), Oracle Collaboration Suite (OCS) (Release 2) 9.0.4.2, Oracle10gRAC, Oracle 10g, 9i, RAC, Partitioning, Oracle Files, Oracle9iAS Portal
• DB2-UDB 8.2, Sybase ASE 12.5, SQL Server 2005, Replication, AIX 5.1 (64bit), Linux, MS2000, Confidential -GPFS, P-series, Confidential System x Beowulf 1,048 Intel Xeon CPUs.

SENIOR DBA

Confidential, Scottsdale, AZ

Responsibilities:

• Worked closely with development teams on a regular basis to ensure successful code promotions to production environment as planned.
• Reviewed all proposed changes before they went into production environment and made recommendations if appropriate.
• Administered a 145GB Inventory and 110GB Order Entry, for this emerging division of United Parcel Service.
• Instrumental member in the development and deployment of Oracle 11i, Manufacturing and Finance ERP project.
• Migrated 120 GB Oracle 7.3.4.4 Inventory Database (Data General) to HP V2600 Oracle 8.1.6.1.
• Tuned and stabilized 110GB Order Entry Database and application code.
• Increased Overall system availability to 99.5 which enabled Organization to meet its SLA's with customer base and regain profitability.
• Oracle 9i,8i,7, Oracle 11i Finance and Manufacturing, HP-UX 11.02 (64bit), EMC, Netapp.

SENIOR DBA

Confidential, Scottsdale, AZ

Responsibilities:

• Engineered, and ported Java enterprise applications database objects to be deployed in Oracle 8i (8.1.6) database as well as MS SQL.
• Architected and designed a distributed database environment to support development, and hosting web applications.
• Worked Closely with development and assisted in schema development and normalization using data modeling techniques
• Oracle RDBMS 8.0.5, 8.1.7, OEM Performance and Tuning, SQL/PLSQL, NET8/SQLnet, Onames, MS SQL Server, Solaris 2.7, Linux RHD 5.2 - 6.1, NT 4.0, EMC, ERWin, ER/Studio, Visio.