SUMMARY:

An accomplished IT professional with 8+ years of experience in the full life cycle of Oracle database administration and helping companies (both federal and private) gain the maximum benefit from their technology investments. Hoping to secure a position that will allow me to utilize my expertise in cloud infrastructure, database security, performance tuning, backup/recovery, and schema object management.

TECHNICAL EXPERTISE:

• Installed Oracle software (11g, 12c, 18c) on Windows/UNIX/Linux
• Monitored, reported, and tuned Oracle 12c and SQL Server 12.0 databases
• Created Oracle Database and Listener (DBCA, NETCA)
• Solid DB security experience (Oracle Wallet, Transparent Data Encryption, Data Redaction, User level security, etc)
• Implemented sound backup, restore, recover practices following OFA guidelines (RMAN, Data Pump, etc)
• Set up standby databases using Data Guard for high database availability
• Database monitoring tools (OEM, Grid Control, AWR, ASH, ADRCI, etc)
• High instance availability - Real Application Cluster (RAC)
• Cloud Engineering - Supported Oracle 12c,18c,19c, on AWS and Oracle Cloud. Supported SQL Server on Azure

TECHNICAL SKILLS:

Databases: Oracle 9i, 10g, 11g, 12c, 18c, 19c, Microsoft SQL Server

Platforms: AWS, Oracle Cloud, Windows 2000/2003/NT/XP, OS X, Solaris Unix, Linux (CentOS, RHEL)

CPU Languages: XHTML/HTML5, CSS/CSS3, Wordpress PHP, Python, Batch, Shell, Powershell, JQuery, XML, T/SQL, PL/SQL

Other: Oracle SQL Developer, Erwin Data Modeler, Microsoft Visual Studio, Microsoft Office, Grunt/Git Hub, Remedy, Cherwell

WORK EXPERIENCE:

Senior Database Engineer

Confidential

Responsibilities:

• Partitioned AWS storage optimized EC2 instances
• Created bucket resources for AWS S3 (Simple Storage Service) storage
• Configured DB inside AWS VPC private subnet
• Created both user defined and default security groups for AWS EC2 instance to restrict firewall access to DB
• Installed VM VirtualBox and stood up virtual servers & Oracle 19c databases on Linux
• Large data transports using Transportable Tablespaces/Data Pump
• Advanced security using Data Redaction, Oracle Wallet, TDE (encryption)
• Created schema objects to enhance DB performance (B-tree/Bitmap/Concatenated Indexes, Materialized Views, etc)
• Used Oracle SQL Developer Data Modeler to compare data accuracy for migrated tables
• Revamped RMAN backup strategy to utilize Merged Incremental Backups using Block Change Tracking feature
• Utilized Grid Infrastructure for disk redundancy and created ASM disk groups/changed redundancy level using ASMCA

Senior Oracle DBA

Confidential

Responsibilities:

• Responsible for monitoring, reporting, and tuning of Oracle 9i, 11g, and 12c and SQL Server 12.0 databases
• Created functions, stored procedures, and triggers for SQL Server and Oracle production databases
• Migrated data from on premise to Cloud using AWS Snowball
• Supported SQL Server on Microsoft Azure cloud
• Deployed Oracle Database into a Multi-AZ configuration on AWS with asynchronous data replication
• Installed Grid Infrastructure and created ASM disk groups for high disk availability
• Configured RAC nodes and Data Guard DBs for high instance/database availability
• Set up and configured physical standby databases using Data Guard
• Performed regular database backups and restores using RMAN and DATAPUMP
• Performed large data migrations using transportable tablespaces
• Restricted user access security for databases (LDAP, OID)
• Automated/scheduled overnight jobs using Windows Task Scheduler & CRON
• Monitored Oracle/SQL Server) databases using SQL Profiler and OEM Cloud Control 12c/AWR
• Created Workload File and tuned SQL DB using Tuning Advisor
• Created BATCH/SHELL scripts to run against databases

Senior Oracle/ SQL DBA

Confidential

Responsibilities:

• Responsible for performance monitoring, reporting, and tuning of Oracle 12c and SQL Server 12.0 databases
• Performed regular database backups and restores to improve overall database availability
• Created database indexes as needed to boost database performance
• Configured SQL Server monitoring utilities to minimize false alarms
• Performed data analysis, SQL optimization, database tuning, and provided general database reliability analysis
• Performed quarterly patch analysis and applied patches as needed
• Ran Control-M against databases/servers for automated jobs
• Created Batch scripts to run against databases
• Managed and supported existing ETL processes (Procedures, Jobs, Views, etc.)
• Validated Execution Forms, Cycle Changes, and Configuration Change Requests for multiple applications

Application Developer

Confidential

Responsibilities:

• Developed web-based applications for Confidential Systems that analyze and display critical information from enterprise information systems (e.g., SAP ERP)
• Translated application requirements into clean and efficient PHP and JavaScript code
• Used HTML, jQuery, and Ajax to implement responsive, dynamic user interfaces in the web browser
• Translated UI designs, mockups, and detailed specifications into functional user interfaces, ensuring cross-browser compatibility, performance and robustness, security, and adherence to best practices and current web standards
• Maintained version control of all software code and artifacts using Git
• Created Shell scripts to assist DBA’s with exp/imp

Oracle DBA

Confidential

Responsibilities:

• I served as an Oracle DBA responsible for RAC OLTP production databases in a 24/7 production environment.