We provide IT Staff Augmentation Services!

Senior Database Engineer Resume

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.

Hire Now