Senior Oracle Dba/aws Cloud Engineer Resume
SUMMARY
- Oracle DBA Consultant with 17+ years of experience in Analysis, Design, Development and maintenance of database applications primarily Oracle on Solaris, AIX, Linux and Windows environment
- Strong Database Management skills including analysis, development, administration and maintenance of database projects in retail and warehousing.
- End to end data design: from conceptual data modeling to implementation for both the OLTP and Data Warehouse environments & SAP systems
- Strong Enterprise Production Oracle DBA, Expert level skills to on different Oracle Versions 9.x/10GR2/11gR2,12c Oracle Ebiz Suit R12
- Hands on experience Designing, tuning and implementing very large databases, 24x7 availability and high transaction volume.
- Experience in database recovery and Oracle disaster planning: Investigate review, apply and test all patched and bug fixes in database environment
- Hands on experience in data setup, Installs upgrades and Patches & Migration
- Configuring monitoring and proactively reviewing statistics for errors, capacity and performance issues
- Solid skills in database performance factors, monitoring tools and tuning procedures
- Hands on daily back - ups, recovery, security, query tuning, and automation and implementation of database related functions. Knowledge of fault detection and resolution processes
- Experience and Working Knowledge with various RDBMS. Knowledge of databases, application software as well as their capacity and technical limitations
- Query optimization and tuning skills including cross database and cross server queries, analysis and troubleshooting interactions between databases, operating systems and applications with regard to performance and resources usage. Experience in creating database tables, setting up indexes, data constraints and database views and SQL queries.
- Database Migration Experience from oracle 9i to 10g, 11.1.0 to 11.2,11.2.0 to 12c
- Strong knowledge of Oracle internals, tools including DBMS jobs, RMAN, SQLPlus, export/import, Toad, Oracle Enterprise Manager (OEM13c)
- Strong in Disaster Recovery (DR) planning and testing & Maintenance, RAC familiarity and configuration, Standby database
- Knowledge of Unix/Linux system administration, Shell Scripting, AWS(IaaS & PaaS), Container Fabrics, Networking, Alerting and Monitoring
- Solid Database Migration (Heterogeneous/Homogeneous) Experience from On-PRIM to AWS Cloud.
- Participates in projects as assigned providing expertise related to AWS Cloud Database Architecture. Analyzes database and information needs of projects and applications in order to recommend and implement cost-effective solutions
- Design complex solutions which integrate AWS cloud, on premise physical and Virtual server, EC2, S3 storage, networking and security. Conduct systems design, feasibility and cost studies and recommend cost-effective cloud solutions.
- Develop standardized AMI images and Cloud formation automation scripts for building non-prod and prod environments on AWS.
- Experience Migrating Oracle database to AWS RDS Oracle,Postgres, MariaDB,Mysql
- Experience working with high availability, disaster recovery and server tuning strategies including parameters, resources, contention, etc.
- Experience with using a broad range of AWS technologies (e.g. EC2,RDS, ELB, EBD, S3, VPC, Glacier, IAM, CloudWatch, KMS) with an emphasis on best practice cloud security.
- Experience in database tuning & optimizing, RMAN backup / restore / recovery, database resizing & de-fragmentation activities
- Understanding and ability to participate in all phases of the SDLC including requirements gathering, business analysis, configuration management and quality control desired
- Experience High volume mission critical OLTP/OLAP environments, batch data processing, designing and deploying large scale data warehouse service and building & designing configurations AWS EC2,AWS RDS for open source DB like PostgreSQL, MySQL, Aurora, DynamoDB.
- Producing and updating documentation and Standard Operating Procedures (SOPs).
- Excellent written, communication, presentation and interpersonal skills.
- A very good team player with the ability to work independently.
TECHNICAL SKILLS
Knowledge Domains: Database and systems administration, design and development
DBMS: Oracle 9i/10g/11gR1, 11gR2,12c MS SQL,Sybase,Mysql,UDB,Nosql, Mongo DB, PostgreSQL. Aurora, DynamoDB, Cassandra
Technologies: Oracle 9i, 10g, 11gR1, 11gR2,RAC,12c DB2/UDB 7.2, 8.1 and 8.2, EEE, federated databases, and UNIX, Linux and Windows, SAP ECC6, NW2004 and NW2004s, Oracle Ebiz Suit R12,Exadata,GoldenGate
Languages: SQL, PL/SQL
Platforms: Solaris, AIX 5.X, HP-UX, Linux ES 5, Oracle Linux 5, Windows 32/64-bit.,Oracle Linux, Amazon EC2, Hadoop Cloudera Distribution cloud
Servers: Web Logic, Web Sphere, Oracle AS, Apache.
Other tools: ERWin, Power Designer,VMWare,TOAD, SQL Navigator, Data Stage, RMAN,Remedy,SQL Developer, Data Domain,AWS CLI,AWS Lambda
Monitoring Tools: AWS Cloudwatch. OEM13c,Nagios
PROFESSIONAL EXPERIENCE
Confidential
Senior Oracle DBA/AWS Cloud Engineer
Responsibilities:
- Managing 200+ Oracle RAC Database administrator support and responsible to provide 24x7 database including patching, upgrading Mission critical server i.e. TOFEL/GRE
- Participate and Define best practices around migrating applications and required Databases to AWS and other Cloud providers. Used AWS Storage Gateway & AWS EFS for Data Transfer on Premises to AWS.
- Data center migration from on premise to AWS Cloud. Data Guard setup for Multiple Database for 10+TB large Data Warehouse to migrate AWS Cloud from on -premise Databases.
- Created EBS Volume’s using GP2/High Performance Provisioned IOPS for Oracle EC2 database servers in different VPC
- Created EC2 server using AMI & Database on EC2 server using cloud formation template & Post DB Creation script
- Data Guard/DG Broker setup for AWS HA environment in Different AWS Availability Zone
- Configure Rman backup setup on AWS S3 storage & S3 bucket replication to the DR site
- Performance Tuning Oracle Databases using ADDM,AWR Reports,SQLT
- Used Datapump and UTL FILE for file transfer to migrate schemas to RDS/EC2
- Configure Goldendale Hub on AWS & enable Replication for migration
- Migrated AWS EC2 Oracle instance to Postgres Instance using AWS Schema conversion tool and DMS.
- Configured Pganalyze tool to monitor Postgres SQL.
- Knowledge and support for PostgreSQL,DynamoDB,Microsoft SQL Server, Mongo DB,Mysql,Cassandra
- Configure AWS CloudWatch Metrics & OEM Alert Metrics threshold and parameter
Environment: and Tools: Oracle 11gR2, 12c, Oracle ASM, RHEL 7, DataGuard, RMAN, SQL PLUS, Shell Scripts, Mongo DB,AWS Cloud EC2/RDS,EBS,EFS,AWS Storage Gateway, AWS S3, PostgreSQL, Aurora, DynamoDB, GitLab,AWS CLI,AWS Lambda, Jenkins
Confidential
Senior Oracle DBA
Responsibilities:
- Data Guard setup for 60TB Warehouse PWARE, Converted EMC storage replication to be DG as High Availability during EMC to XIV storage ASM Migration
- Database RAC Grid & DB Upgrade from 11.2.0.3 to 11.2.0.4
- Performance Tuning using AWR, ADDM, ASH reports, SQLT for 11gR2,10046 tracing
- Troubleshooting DB issue using TFA, OSWatcher,TRUSS,ORadebug,ORACHK,Kfod
- Research & Resolve RAC Node Startup issue Reducing Power path where worked with internal and External Vendor team ensuring PCDS upgrade success
- Actively Participate in ASM IO issue on IBM XIV/Disk Latency Performance issue Troubleshoot
- Applied PSU Patch to Mission Critical Database for the bank
- Build New Server for PWARE Restore Exercise & configure RMAN setup
- Troubleshooting for CPU High Usage/ Various Hardware Failure along with System Admin
- SRDF DR Standup and support for quarterly exercise
- Oracle Golden Gate Install and configure replication for Migration
- Support for Mongo DB/ Cassandra/Hadoop Environment Data migration
- Documented OEM Alert Metrics threshold and parameter, Good at SOP Development
Environment: and Tools: Oracle 11gR2, 12c, Oracle ASM, RHEL 5 & 6, AIX, DataGuard, RMAN, SQL PLUS, Shell Scripts, Mongo DB
Confidential
Senior Oracle DBA
Responsibilities:
- Peoplesoft Database Migration using TTS from 11.2.0.3 to 12c.
- Used Full export with Transportable tablespace, Migrated 1 TB size database from 11.2.03 to 12c.
- Setup RMAN backup and Data Pump backup and Dataguard
- Resolved space issue for more than 500 database mount point on os, developed dynamic script to add new datafile as per requirement, Performance Tuning using AWR, ADDM, ASH reports, SQLT for 11gR2
- 24/7 support for OLPT/DW 200+ database RAC environment
Environment: and Tools: Oracle 11gR2,12c, Web logic 10, Cognos, Oracle ASM, RHEL 5,Solaris10,DataGuard, RMAN, SQL PLUS, Shell Scripts,Hadoop,Hive,Pig,Nosql, AWS
Confidential
Senior Oracle DBA
Responsibilities:
- Deploy and manage mission critical Databases for BXchange Reporting, BXchange Bxcore
- Support for 100+ Prod/QA/Dev DB instance including Monitor, Troubleshoot and fix issues & work with different team for new changes rollout & PSU
- Used Transportable tablespace, TTS copy for schema refresh for TB size data.
- Performance Tuning using AWR, ADDM, ASH reports, SQLT for 11gR2,Setup RMAN backup and Data Pump backup
- Worked on Hortonworks & Cloudera HADOOP Cluster POC for Data Lake of BCBSA data.
- ETL Data Loading, Data Cleansing and Staging for Data Warehouse and Data Mart
- Build POC environment of Hive, Pig and NoSQL for large Data
Environment: and Tools: Oracle 11gR2,12c, Web logic 10, Cognos, Data Stage, Oracle ASM, RHEL 5,Solaris10,DataGuard, RMAN, SQL PLUS, Shell Scripts,Hadoop,Hive,Pig,Nosql, AWS