Oracle Manager
Resume:
Siddartha
*****************@*****.***
Professional Summary:
Oracle and MS SQL Server Certified professional with 8 years of experience as a Database Administrator having hands on experience in database design, administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, Disk space management, database security, database cloning, database migration, data encryption, shell scripting and documenting best practices and support procedures.
Technical Skills:
RDBMS: Oracle, PostgreSQL Non-RDBMS: Hadoop & MongoDB, AWS Redshift
(Oracle 19c/18c/12c/11g/10g/9i, PostgreSQL 12.0 and 11.5, MySQL 5.7, MS SQL server 2005 to 2017, Cloudera Hadoop 5.x&6.x, MongoDB 3.x, 4.0 &4.2.)
Cloud Infrastructure: AWS, VPC(VRA)
Fusion Middleware: Golden Gate, WebLogic Engineered Systems: EXADATA, Veritas
Operating Systems: Red Hat Linux, Oracle Linux, HP-UX 10.x, 11.x, Sun Solaris, IBM AIX, and Windows 2003/2008/2012.
Languages’, PL/SQL, NOSQL, T-SQL, Shell Scripting(bash) and Python
SOFTWARES, APPLICATIONS & TOOLS: Oracle RAC, Data Guard, OEM (12c &13c), DGMGRL, RMAN, ASM, VERITAS Net Backup, Data Domain (EMC), AWR, ASH & ADDM, TKPROF, EXPLAIN PLAN, SQL*TRACE, Oracle TDE, Oracle IDM, OBIEE12, Oracle APEX 5.1.4 and 18.1, Oracle ZFS Storage, SQL Developer, Toad, SQL*Loader, Data pump, PowerBuilder, SolarWinds DPA, Mongo OPS manager, AWS CLI, Netcool, SNMP, Authentication (LDAP, Kerberos)
DevOps & Tools: GitLab, Jira, Ansible, Terraform, Jenkins, Atlassian, SVN, Flyway, Agile Scrum/Kanban, BMC, SWIFT, ServiceNow, Confluence, SharePoint.
Domains Experience: Financial, Banking and Telecommunications
Personal Attributes: Flexible, Adaptable, Ownership, Knowledge sharing attitude, Solution oriented.
Professional experience:
ORACLE:
Extensive knowledge and Experience in database administration for Oracle 19c/18c/12c/11g/10g&9i with experience within very large-scale database environment and mission critical large OLTP and VLDB Data warehouse systems. Including experience in Oracle Multitenant architecture (CDB&PDB), RAC, Data guard, Golden Gate replication, Database security, Data encryption.
MONGODB:
Experienced in installing, configuring, managing, maintaining, and troubleshooting MongoDB environments and databases by gathering requirements for design, performance considerations, security and recovery needs adhering to database standards.
Experience in configure and maintain backup, restore, full and incremental Backups, Point in Time Recovery, Oplog backups, Hot Backups using tools like mongo dump, mongo export, Percona Backup for MongoDB, and Ops Manager.
POSTGRESQL:
Experience in installation, configuration, architecture and monitor of PostgreSQL 12.0 and 11.5 on RHEL O.S.
Detailed understanding of Postgres database server architecture, concepts, features, and high-availability technologies.
Experience in configuring, maintaining, and monitoring PostgreSQL High Availability and replication between Primary and secondary nodes using patroni, etcd and pgMonitor tools. pgAdmin, patroni, etcd, barman, ora2Pg, pgMonitor
BIG DATA (Hadoop):
Installation and Administration of Cloudera Hadoop
Hadoop Ecosystem: Cloudera BDR, Impala, Hive, Kudu, Hue, YARN, Zookeeper, Kerberos, Sqoop, Oozie, Kafka, Stream sets.
AWS:
Worked on AWS DMS and AWS (SCT) for Migrating Oracle databases to Amazon Redshift.
Worked on S3 buckets and Cloud trails to monitor logs and backups.
RELEVANT WORK EXPERIENCE
Farmers Insurance, Woodland Hills, CA – DBA Aug 2019 – Current
Responsibilities:
Administered Oracle Database Infrastructure by installing Oracle 19c/18c/12c and 11g databases using RAC, ASM, Data Guard instances and Golden Gate Infrastructure to increase high availability, scalability, and disaster recovery on Red Hat 7 and OEL 7.
Created and maintained Oracle 19c/18c/12c CDB and PDB’s. Multiple databases clones/duplicates in multi-tenant architecture.
Exadata: Working Knowledge and Experience of Oracle 11g/12c & 18c environments on Linux and Exadata with features for data partitioning, RAC, Data Guard, Golden Gate Replication.
Good knowledge and experience in using Oracle ZFS storage appliances for backups and date transfers.
Upgraded databases from 12c/18c to 19c. And applied Oracle Patches and patch sets in Server side and Client side.
Performance Tuning: Worked closely with Application Team/Developers, troubleshooting with various monitoring tools and scripts, generate various Reports, Explain Plan, create SQL Profile and baselines – administer them.
Working experience with developers and application testing teams to ensure application design as efficient and avoid any reactive performance issues, resource contention and any bottlenecks.
Expert in Database, application, O.S and network level performance Tuning and Optimization skills, including SQL re-write for optimum performance, ASH, ADDM, OEM, SQL tracing and TKPROF.
Resolved database performance, capacity, replication, and other distributed data issues.
RAC/RAC One Node: Installations, adding/deleting nodes, Upgrade, create/delete databases, Administration, troubleshooting and Patching.ASM: Administration, maintenance, troubleshooting, Storage Migrations.
Data guard: Physical/Logical/Snapshot Standby and ADG databases creations, administration, troubleshooting, DR Tests: (Switchover/Switchback & Snapshot/Activate DR database in R-W for Bubble testing).
OEM: Install, Configure, Administer, Security, Patch and Complete Upgrade Experience from OEM 12c to OEM 13c.
Goldengate: Installation, Setup & Configurations, Upgrade, Administration, troubleshooting, Patching and migrations.
Data Refresh: Performed database refreshes between environments using Datapump and RMAN.
Migrations and GO Lives: Several migrations experience from file system/standalone/RAC to ASM/RAC/Engineered systems using RMAN/Datapump.
RMAN: Configuring Backups strategies for both Target and catalog databases, Administration, troubleshooting, Restore and Recover in case of disaster incidents.
Expert in designing and documenting database backup and restore, data redundancy, data auditing and disaster recovery strategies and database cloning, database duplication and data pump.
Flashback, Database Re-Org, Security, Day to day DBA activities like Prod, Non-Prod Support, Work on Tickets/CRQs/Incident tickets/Violations.
Security: Experience in Database Security Policies, User Management, Auditing, Profiling, Authentication and Oracle advances security features like TDE.
Experienced in VMware and Virtual environments on AWS and private cloud servers (VPC).
Collaborated closely with application and infrastructure teams (Finance/Application/Storage/SA/Network/Offshore) on several issues and day to day support.
Expert in design, configure and administering distributed databases along with batch loading and data reporting.
Extensively involved in logical design, physical design, capacity planning, and user account management.
Worked as great Collaborator, support each other, do smooth handoff on any work to shift people, do share knowledge document and presentation.
Expert in automating database tasks like schema refreshes, log monitoring, SQL change deployments using Flyway, Jenkins, ansible and shell scripting.
Experience in configure and setup Oracle Identity Management (IDM) to manage user privileges in enterprise level.
Hands on experience in Amazon Web Services (AWS) provisioning and good knowledge of AWS services like EC2, S3, RDS, VPC, Direct Connect, Route53, Cloud Watch, Cloud Formation, IAM, SNS etc.
Installed the application on AWS EC2 instances and configured the storage on S3 buckets.
Worked on converting schema from one DB engine to AWS RDS using AWS Schema Conversion Tool (SCT).
Worked on AWS Database Migration Services for migrating data from Oracle to Amazon Redshift.
Environment: Oracle 19c/18c/12c/11g, OEM (GC) 13c, Data-Guard, RAC, ASM, Golden Gate, RMAN, Exadata X8, X7, X6-2, Oracle ZFS storage, ODA, PCA, Oracle APEX 5.1.4 and 18.1, RHEL 7, 6, Oracle Linux 7, SolarWinds DPA, Service NOW, Flyway, Jenkins, IBM DB2
Illinois Courts, Springfield, IL – Sr. DBA Feb 2018 – Aug 2019
Responsibilities:
Oracle: Organize, Install, configure, maintain and tuning of Oracle 12c and 11g databases on Red Hat 7.x, Oracle Linux 6.x and AIX 7.x environments.
Experience in upgrading databases from Oracle 9i,10g,11g to Oracle 12c on RHEL, Oracle Linux, Sun Solaris, and AIX platforms.
Applied Oracle Patches and patch sets in Server side and Client side.
Experience in replication like Oracle Golden Gate, clustering, and Data guard of Oracle databases.
Experience in creating and Maintaining both Physical and Logical standby databases for 9i,10g,11g and 12c databases.
Experience in Design, implementation and generating documentation of Oracle 11g & 12c Data Guard on both physical/logical standby databases in high availability mode.
Proficient with using Oracle Enterprise Manager and monitoring databases effectively with Netcool Incident Management tool.
Experience in the data analysis, design, development, testing, project planning and implementing of major Database structures.
Experience in Develop and Implement database maintenance plans, including performing integrity checks, updating statistics and monitoring security and hardware resource utilization.
Experience in Creating & Managing Database Structures and Storage Allocations.
Experience in Database Security User Management, Database Access, Roles, Privileges, Auditing, Profiling and Authentication.
Experience in Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups with Data pump utilities.
24x7 On Call Production database support and provided support for database developers & end-users whenever needed.
Experienced in using diagnostic tools (ADR, ADRCI and RDA) to submit diagnostic information to Oracle Support to resolve the database issues.
Good experience in UNIX shell scripts to manage Oracle environments and for Backend Oracle Processes.
Proven ability to effectively manage multiple priorities and meet deadlines.
Experience in Configure database server to work with middleware, web server and Online Analytical Processing (OLAP) tools.
Good understanding of business requirements of a large organization and reflect those needs in proposed IT solutions.
Good experience in working with onshore/offshore teams and junior DBA's as team lead.
PostgreSQL: Experience in installation, configuration and monitor of PostgreSQL 12.0 and 11.5 on Red Hat Linux 6&7.
Migrated databases from Oracle 11g to PostgreSQL using ‘Ora2Pg’ opensource tool.
Experience in configuring, maintaining, and monitoring PostgreSQL High Availability and replication between Primary and secondary nodes using patroni, etcd and pgMonitor tools.pgAdmin, patroni, etcd, barman, ora2Pg, pgMonitor.
Hadoop: Installation and Administration of Cloudera Hadoop(5.x&6.x). Impala, Hive, Kudu, Hue, Kerberos, Sqoop, Cloudera BDR, Oozie.
Deployed and managed 4 large clusters across various global datacenters with a total of around 100 servers and more including dev environments.
Directly involved with migration of existing RDBMS platforms into Hadoop data lakes via various tools of the Hadoop ecosystem.
MongoDB: Administered MongoDB by installing MongoDB 4.2/4.0/3.6 using Replication, Sharding, Partitioning, Performance Tuning, Wired Tiger and OPS Manager on Red Hat Linux 7 and 6.
Experienced in using MongoDB tools like, mongostat, mongotop, mongoexport, mongoimport, mongodump, mongo restore etc.
Environment: RHEL 7, 6 OEL 6,5AIX 5.3, 6.1,7.1 Solaris 5.10 and Windows 2003, Oracle 9i,10g,11g&12c, OEM (12c), Data-Guard, RAC, ASM, Golden Gate, Data Domain (EMC), OBIEE 12.2.1.0.0, Big Data (Hadoop), Kafka, Stream sets, MongoDB 4.2, PostgreSQL 12.0 and 11.5, MySQL 5.7,5.6&5.1, Gitlab, Jira, SVN, Agile, Dev OPS
DXC Technologies., India – Oracle DBA Aug 2014 – Dec 2016
Responsibilities:
Organize, Install, configure, maintain and tuning of Oracle 11g, 10g and 9i databases on Red Hat 5.x, Oracle Linux 6.x, AIX 6.x & Solaris 5.10 environments.
Advanced knowledge of working in Unix/Linux environments.
Experienced in upgrading databases from Oracle 9i, 10g (10.2.0.4) to Oracle 11g (11.2.0.2.0) on RHEL, Sun Solaris and AIX platforms.
Experienced in installation of Oracle Grid Control Agents in all environments for production, test and development databases and configuring them for monitoring.
Experienced in Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Constraints and Rollback segments.
Experienced in Database Security User Management, Database Access, Roles, Privileges, Auditing, Profiling and Authentication.
Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
Implemented VERITAS Net Backup and Data Domain backups using RMAN as a media management layer.
Environment: Red Hat Linux 5.1, 5.2,5.3,5.8AIX 5.3, 6.1, Solaris 5.10 and Windows 2003, Oracle 9i,10g and 11g, Oracle Enterprise Manager (GC), Data-Guard, RAC, ASM & Cluster ware, VCS, RMAN, Net Backup, FRA
Avida Technologies., India – Oracle DBA Jul’2011 – Aug’2014
Client: Sprint Nextel Communications Inc, Reston, VA (Contract)
Responsibilities:
Installation, configuration, maintenance and tuning of Oracle 11g,10g and 9i on Red hat 5.0, IBM-AIX 5.3.
Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.1.0.7) on IBM-AIX nodes.
Installed and configured Oracle 10g RAC using Cluster ware and ASM.
Created Oracle 9i, 10g Data Guard on both physical/logical standby databases in high availability mode.
Worked closely with ETL developers and tuned data loading techniques and SQL queries.
Environment 5.2/5.3 and Red Hat Linux 5.0, Windows 2003, Oracle 10g and 11g, Microsoft SQL Server 2005, TOAD 9.0, Oracle Enterprise Manager (GC), RMAN, Net Backup, 10g RAC &ASM, Data Guard, SCP/SFTP, Erwin 4.1, SQL* Loader.
CERTIFICATIONS COMPLETED:
Oracle Certified Associate 11g, ID: OC1038547, Reg: 245233744
Oracle PL/SQL Developer 11g, ID: OC1038547, Reg: 245755080
Oracle Database Administration 11g, ID: OC1038547, Reg:275708356
Oracle Autonomous Cloud Specialist, ID: OC1038547, Reg: 373844437
Microsoft SQL Server 2005 – Implementation and Maintenance.
TRAININGS COMPLETED:
Oracle Database 11g: Managing Oracle on Linux
Oracle Grid Infrastructure 11g: Manage Cluster ware and ASM
Oracle Database 11g: RAC administration
Oracle Golden Gate 11g: Advanced Configuration for Oracle
Cloudera Administrator Training for Apache Hadoop.
ACADEMIC CREDENTIALS:
Master’s Degree in Computer Science – University of Illinois, Springfield
Bachelor’s Degree in Information Technology- Osmania, Hyderabad, India
Reference: Available upon request
Contact this candidate