Description
Summary * 2+ years of experience as an Oracle DBA with administration & maintenance of Oracle 12c/11g/10g on operating systems such as Red Hat Linux, Sun Solaris, UNIX and Windows. * 24 7 production database support to developers & end-users. * Worked on installation and configuration of Oracle 11g and 12c. * Worked on Oracle Client Installation on Windows and setting up DNS for access * Installed, Configured Oracle 11g Golden gate on Oracle 11g Database. * Worked with projects/operations/professional services team and coordinated multiple tasks at hand with expertise and solid plan. * Contributed as an efficient/reliable team member for all business-critical releases and changes. * Worked under high stress situations multiple times and handled the situation very effectively. * Performed the code reviews for all the database code coming into the database and fine-tuned it for optimized performance. * Handled Vendor applications and interacted with vendors regularly to understand and optimize database operations. * Participated in requirements gathering meetings with customer while building out new database environments. * Effectively communicated with PM'S while working on project related tasks. * Involved in migration of MySQL Database from on premise to AWS cloud. * Experience in installing and configuring Golden Gate 11g/12c and using replication procedures to support data replication in the Oracle database environment. * Worked with Installing and maintaining of a five node NoSQL Cassandra Cluster. * Experience with Cassandra Query Language (CQL) and backing up of Cassandra nodes. * Have extensive knowledge of Cassandra Architecture and was involved in training internal team on the basics of Cassandra Administration. * Experience with working on basic Cassandra query tuning. * Implemented efficient methods for Maintenance, Monitoring, Backup/Recovery, Growth Management, contention Resolution, and block corruption across diverse environments. * Experience in using utilities like SQL Developer, SQL*Plus, SQL*Loader, MySQL Workbench, data Migrations using export/import as well as traditional UNIX command that requires for Oracle DBA. * Extensive experience in Data Compression, Table Compression, OLTP Compression, Health Check Monitoring, and Flashback Data Archive. * Experienced in day-to-day DBA activities including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (tablespace, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, basic UNIX Shell Scripting. * Experience working with various AWS services like Ec2, S3, Redshift, EMR, RDS, Schema Conversion Tool, Database Migration Service, VPC, IAM and ELB. * Worked with the installation, upgradation and migration of MySQL from on premise MySQL 5.1 to Amazon RDS 5.6. * Worked with the setting up and configuration of Apache Kafka, Apache Zookeeper and Apache Storm clusters on AWS Ec2 instances for fast ingestion of data.
Accomplishments
Highlights:
Keywords
