SUMMARY:

• A vast amount of experience as a Data professional working for government agencies (US, State, and local), banks, fortune 500 companies, health care, Telecom, and small start - ups
• A professional who demonstrates a commitment to ensuring client success and satisfaction
• Clear concise planning and excellent analytical abilities
• Flavors of Linux I have worked with Centos 7, Oracle Enterprise Linux 6 & 7, Ubuntu
• Coming up to speed on as many DevOps software components
• Managed Dev, test, & Production VLDB, OLTP, & Real Time databases
• Installed, and managed Oracle high availability Data Guard (11G & 12c)
• Know how to configure Oracle Golden Gate using Classic and Integrated Capture/Replicat
• Proactive Oracle infrastructure and capacity planning
• Performed upgrades & patching, SQL and index tuning
• Installed mysql, Apache and PHP Lampstack on AWS EC2 instance
• Installed configured Oracle DBA training app using Wordpress
• Configured and brought up Oracle instance using Amazon web services RDS
• Connected in-house clients to AWS Oracle RDS over the internet
• Installed several Amazon Linux on EC2 instance AMIs Private and Public
• Extensive knowledge of subnetting, CIDR blocks and DNS records And am able to apply this to Amazon VPC subnets, VPC routing and Route 53.
• Working knowledge of Docker 1.12 containers on Centos 7, Oracle Linux 7 and Ubuntu 14.04
• Used CloudFormation to build EC2/VPC environments using JSON AWS resource types
• Configured S3 buckets versioning and assign URL public read permissions on objects
• Built a self healing application using AWS Auto-scaling that responded to spikes in demand with elasticity to increase the size of the architecture by spinning up new EC2 instances.
• Created VPCs from scratch without using the wizard, adding both private and public subnets. Assigned an Internet gateway to the public subnets. Configured the routing for public access.
• Set up a web farm using Nginx and apache within several Docker containers
• Know how to configure ports, mount host to container file systems and commit changes to Docker containers.
• Setup AWS S3 buckets and assigned permissions to access content over the web
• Working knowledge of Ansible version 2.1.1 including setting up SSH
• Deployed a Master/Slave replication mysql database for high availability.
• I am part of the Seattle DevOps community making frequently meetings at Chef Software, Ansible and Puppet Meetups.
• Working towards certification on AWS Certified Solutions Architect - Associate Level
• One year experience support mysql on the AWS EC2 lamp stack
• Created a NAT EC2 instance to allow database servers to download security and package updates.
• Setup Oracle 11g Enterprise Edition on EC2 instances. Configured Security Group port 1521 inbound rules to allow on-premise Internet access via the Oracle Listener remote access.
• Created a Bastion host in place of a VPN to harden security access to private EC2 instances.
• Configure DNS with Elastic IPs using the Amazon Management Console
• Wrote the code using Wordpress for the oraocp.com testing web site on EC2
• Created the Schemas, permissions and data in mysql running on AWS
• Created IAM security for Mutifactor logins using Google Authenticator

TECHNICAL SKILLS:

• Oracle RDBMS Versions 5, 6, 7, 8,8i, 9i 10g, 11g and 12c database administration and management.
• Oracle11g R2 Real Application Clusters. Data Guard Physical Standby and Golden Gate replication Active-Active
• Oracle Linux and UNIX SYSTEMS (HP/UX, Solaris, AIX) administration. Confidential Shell scripting.
• Have worked with various flavors of Linux: Oracle, Centos 6/7, Ubuntu, Redhat, SUSE, Amazon AMI
• Linux systems admin adding users and assigning responsibilities
• AWS EC2, S3, Elastic Load Balancer and Auto Scaling Groups
• Working knowledge of Ansible and Docker containers.
• SQL*Plus and PL/SQL programming and development.
• JAVA, JDBC, Apache, Oracle Fusion.
• Oracle*Net and TCP/IP.

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential, Seattle, Washington

Responsibilities:

• Extensive DBA experience in supporting multiple instances of ORACLE database including Development, written over 100,000 lines of Confidential shell scripting code.
• Managed all Virtual Servers and installed all Enterprise Linux on site. Installed and configured all production databases: mysql and Oracle Enterprise edition 11g and 12c. Setup Dataguard, RAC,
• Well versed with Database Administration, Cloning of Database, Backup and Recovery strategy using RMAN. Used RMAN to backup AWS databases to onsite for disaster recovery, replication and failover.
• Experience in using data pump import/export utility of ORACLE.
• Installed Golden Gate using Zero Time Migration, Integrated and Classic Capture/Extract
• Configured Golden Gate 12c against RAC and non RAC databases using Clusterware Database file system.
• Used Golden Gate in combination with Active Data Guard and RAC 12c Container databases to achieve maximum availability and the Highest Fault tolerant database system.
• Experience in Database Migration by designing and implementing database logical and physical storage structures.
• Migrated several applications and database to AWS EC2 instances, S3, RDS Oracle Databases, Elastic Beanstalk, Cloud Formation, Route 53 DNS, IAM user and group management.
• Rapid deployment of new EC2 AWS AMI instances using AWS Linux image.
• Installation and configuration of Puppet Master on Cent OS 7. Including registration of puppet agents on target nodes.
• Installation and configuration of Ansible on Cent OS 7. Including ssh Equivalence (Key-Based Authentication) Configuration on Linux client nodes. Wrote Ansible YAML playbooks to manage client nodes.
• Installed Windows Server 2012 r2 and configured Active Directory and DHCP services
• Wrote several Ruby, JAVA and Python scripts for server management.
• Move in house intranet (Apache, PHP, mysql, wordpress lampstack) to EC2. Deployed to Amazon Machine Image (linux). Performed all Linux systems Administration. Created all User account, configured kernel parameters, set the file permissions.
• Configured DNS and Amazon’s Elastic IP. Created the pem file for SSH access. Setup system and database backups from AWS EC2 to in house.
• Setup replicated environment mirror image of EC2 instances to onsite instances running Oracle Virtualbox and Linux 6 enterprise edition. Have worked with VMWare and Hyper-V virtual servers as well. Working as the linux systems administrator. Setting up all networking both private and public networks.
• Configured all clustering software and network configurations (virtual ips, scan addresses) to support shared storage (NAS/iSCSI) and mutlinode Real Application Clusters. Performed all clustering configuration (Kernel, file permission, ASM Shared Storage Array, group and user accounts)
• Experience in Optimizing database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.
• Created Dataguard instance in house and applied redo from AWS EC2 RAC database.
• Strong Oracle PL/SQL development background besides DBA skills.
• Experience in database security strategies by creating database Implemented & monitored daily, weekly and monthly batch jobs in database.
• Worked with Automatic Storage Management (ASM) Oracle utility providing a simple storage management interface that is consistent across all server and storage.
• Upgrading and Migrating Databases from lower versions to higher versions.
• Experience in analyzing database & rebuilding indexes to improve database performance.
• Applying oracle patches (CPU, PSU and ONE-OFF), using the OPatch utility and fixing bugs.
• Involved in software upgrades, installations and migration of database as and when required.
• Supported and provided Oracle DBA on-call after hours support for a 24x7 production environment.

Oracle DBA

Confidential, San Francisco, California

Responsibilities:

• Oracle Database Administrator providing 24/7 production support of Oracle 11g RAC
• Proficient in DBA activities such as installation, creation, sizing, backup and recovery, performance tuning and capacity planning.
• Experience in query optimization, cloning, patches, up gradation, migration, troubleshooting, TAR support, space management and UNIX Shell Scripting.
• Excellent experience as an Oracle DBA in various platforms such as Linux, Windows etc.
• Plan, install, configure and perform upgrades of Oracle software on various platforms.
• Implementation of high availability solutions with Oracle 11g RAC, Physical and Logical

Oracle DBA

Confidential, Houston, Texas

Responsibilities:

• Standby database (Data Guard), Materialized views, Streams Replication.
• Database administration of OLTP and Data Warehousing applications.
• Experience with Systems Analysis and Design
• Backup and recovery with RMAN.
• Recovery of Databases (Recovering from Media failure, Recovering Tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.).
• Excellence in Performance Tuning using TKPROF, EXPLAIN PLAN, SQL TRACE
• Proactive monitoring, identifying areas that need to be improved in the application and database using OEM Grid Control.
• Experience with writing PL/SQL Packages, Stored Procedures, Functions and Triggers.
• Proficient in SQL, PL/SQL Programming, Shell Scripting and analyzed Batch programs.

Oracle DBA

Confidential, California

Responsibilities:

• Cloned/Refreshed Oracle Databases and Oracle Applications for development
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implement Hot, Cold and Logical backup plans.
• Involved in taking Backups using Oracle Recovery Manager
• Development of Korn shell scripts.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using Korn shell scripting and SQL*Loader.

Oracle DBA

Confidential, Las Vegas, Nevada

Responsibilities:

• 24x7 production database and applications support.
• Installation, Configuration and Administration of Oracle 9i, 10g RAC and 11g RAC databases for Testing, Development and Production.
• Converted single instance to RAC Added nodes to RAC
• Involved in Capacity Planning and Optimal setting of Storage Parameters.
• Performed Database administration activities like user and roles administration, schema management and checking alert log of all the databases.
• Involved in database cloning, tuning, patching and monitoring
• Performing Backup/Recovery of Oracle databases.
• Implemented RAC and Standby databases for high availability/ disaster recovery purpose.

Oracle DBA

Confidential, California

Responsibilities:

• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, data files, and Block Corruption.
• Developed stored procedures, packages and database triggers.
• Proactive analysis of systems using various monitor shell scripts.
• Experience in monitoring and tuning system resources associated with the database performance.
• Create tablespaces, tables and indexes, sizing the tablespaces, allocating default table space for users.
• Creating and dropping of users, granting and revoking permissions to users/roles.

Oracle DBA

Confidential, New York, NY

Responsibilities:

• Experience in replication using golden gate, materialized views.
• Replication and Extracting data and applying on production using Golden Gate.
• Extracting, Transforming and Loading (ETL) data using SQL loader, External Tables and PL/SQL.
• Working with Materialized views with Query Rewrite, Bitmapped Indexes, etc
• Involved in the migration of databases from Windows to Linux
• Automation of Startup, Shutdown on all production and development databases.

Oracle DBA

Confidential, New York, NY

Responsibilities:

• Installation of Oracle on HPUX and AIX.
• Load data into Oracle using SQL *Loader, RMAN backups, Export/Import database objects/schema, Enforce database accuracy and integrity.
• Monitor the scheduled oracle jobs, manage data feeds, verify the log tables and tune the performance of the database.
• Provide user account administration:
• Backup and Recovery via RMAN scripts and troubleshooting.
• Cleanup demographic Data Warehouse tables, develop PL/SQL scripts, monitor data feed and data replication, address/resolve data issues.
• Handle service requests from the business using Helpdesk Service Management.

Oracle DBA

Confidential, Princeton, New Jersey

Responsibilities:

• Upgrade of Database from 9i and to 10.2.0.2.
• Partitioned large table spaces to increase the performance of the database.
• Converted dictionary based table spaces to locally managed table spaces to eliminate fragmentation, better performance and reduced maintenance.
• Performed Tuning of various SQL queries to improve the performance of the database.
• Logical and Physical data modeling.
• Hard disk and Database space monitoring.
• Migrated file systems to ASM (Automatic Storage Management).
• General database administration including the management of instances, redo logs, temp space, rollback/undo segments and schema management.

Oracle DBA

Confidential, Madison, Wisconsin

Responsibilities:

• Create table spaces, tables, and users for custom applications.
• Creating and dropping of users, granting and revoking permissions to users/roles
• Performance Tuning of the database: Memory Allocation Tuning, I/O Tuning, Tuning
• Performance monitoring and tuning using TKPROF, EXPLAIN PLAN, STATSPACK.
• Taking Backups on scheduled time and monitoring scheduled Backups
• Performing backups and recoveries using RMAN conventional hot backups.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Partitioning Strategies for very large tables.