Home

Sai Naresh - Oracle DBA Administrator

[email protected]

Location: Atlanta, Georgia, USA

Relocation: Yes

Visa: H1b

Resume file: Sai_Naresh_Oracle_DBA_1752499661380.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

Sai Naresh Chanamolu Sr. Oracle Database Administrator Email: [email protected] Mobile: 470-480-1899 Professional Summary: Over 8 years of professional experience as Oracle Database Administrator having good experience in Database Administration, Database Installation, Upgradation, Migration, Patching, Performance Tuning, RAC installation and Maintenance, setting up and Configuring Data Guard, performing all kinds of backups and recoveries, Cloning Databases, Migrating Databases to Cloud using AWS, Automated RMAN backups, replication using GoldenGate and Shareplex, Advanced Security, Auditing and Production Support. Experience Synopsis: Proficient and experienced on Oracle (10g/11gR1/11gR2/12c/19c), installing, configuring and maintaining Oracle databases on different operating systems like UNIX (RHEL 4/5/7/8/9, AIX 6.1, OEL 5/6/7/8, Solaris10, HP-UX 7) for OLTP & OLAP environment. Experience in configuring high availability systems like Real Application Cluster 10g/11g/12c/19c on RHEL 4/5.8/7/8, OEL 6.1, Solaris 11.4. Good Experience in performing health checks of RAC components ocr, voting files and backups using OCRCONFIG and troubleshooting issues using clusterware logs in 19c/12c and 11g RAC Environments and handy in using utilities SRVCTL and CRSCTL. Having good experience in 10g/11g/12c/19c database administration in Real Application Cluster, Standalone and ASM databases. Installed patches using OPatch utility and upgraded databases on 9i/10g/11gR2/12c and expertise in applying Oracle PSU and CPU patches. Experience in applying Oracle rolling patches on RAC 11g/12c/19c environment using response file. Implemented GoldenGate Replication 11g/12c/19c on ACFS and configured for Automatic failover of GoldenGate process and handy in upgrading GoldenGate from v11 to 12c and 12c to 19c Expertise in migrating databases with zero downtime using GoldenGate, Shareplex & Data Guard. Good experience in Installing, Configuring and Replicating databases using Oracle GoldenGate, implemented unidirectional and bi-directional replication. Experience in upgrading databases from 10g to 11gR2 , 11gR2 to 12c and 12c to 19c on Solaris, AIX, Linux and Windows platforms and Performed upgradation of grid infrastructure from 11.2.0.x to 11.2.0.4,11.2.0.4 to 12.1.0.2, 12.1.0.2 to 12.2.0.1 and 12.1.0.2/12.2.0.1 to 19.x Versions. Good Experience in migrating databases across platforms and migrated databases from Solaris, AIX to Linux. Experience in managing RAC and Standalone environment 11g/12c/19c databases, Installing, monitoring and managing of Oracle instances using Enterprise Manager Grid Control 10g/11g/12c/13c. Hands on experience in Planning and Implementing Disaster Recovery databases using Data Guard and configuring, managing, troubleshooting and monitoring Physical standby using Data Guard 10g/11g/12c/19c. Good experience in 11g new features Active Data Guard & snapshot standby. Miigrated several large-scale line-of-business applications to the cloud using AWS. Good Experience in Table partitioning using List, Range, Hash, System and Interval partitioning techniques. Hands on experience in disaster recovery, database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental, cumulative backup and implementing backup and recovery strategies. Implemented User managed cloning and Flashback Technology, Performance Tuning, Experience in SQL tuning using Explain Plans and Hints, Performance Tuning for better performance and Monitoring and Optimizing. Performance Tuning of the database (I/O Tuning, Tuning Contentions) using Oracle 11g tools like AWR, ADDM, ASH, Advisories, TKPROF, EXPLAIN PLAN for achieving better performance. Good Experience in Transparent Data Encryption Operations, Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems. Good Experience in writing SQL Queries, PLSQL Procedures, functions, packages and used SQL hints to improve the SQL performance and implemented SQL profiles and SQL baselines. Experience in implementation of enterprise databases on enterprise storage solutions using Storage Area Networks (SAN) / Network Attached Storage (NAS). Experience using Erwin as a Data Modelling tool & Designing the ETL processes. Good knowledge on Oracle support process for technical requests using MetaLink and other support features. Good written and verbal communication skills, self-motivated team player and good analytical thinking. 24 X 7 Production database administration, support and monitoring to ensure Proactive problem recognition and resolution of database issues. TECHNICAL SKILLS: Databases Oracle 19c/12c/11gR2/11gR1/10gR2/9i, SQL 2012/2008R2, Aurora PostgreSQL, MySQL 5.6, Oracle Products Oracle Real Application Cluster 19c/12c/11g/10g, GoldenGate, Data Guard, Import and Export, Data pump, Oracle Wallet Management, Automatic Storage Management, Recovery Manager, Oracle 10g/11g/12c/13c (Grid Control), Oracle EXADATA, Oracle APEX, RMAN, Oracle Wallet, Transparent Data Encryption, Oracle Virtual Private Database (VPD), Oracle Label Security (OLS). Operating System Oracle Linux, HP UNIX 11i, Red Hat Enterprise Linux (RHEL) 4.x, 5.x, 6.x, AIX 6.1, Sun Solaris 5.8, 5.9, 5.10, Windows XP/2003/2008/2012. Languages SQL, PL/SQL, Unix shell scripting. Tools & Utilities SQL Trace and SQL tuning Advisory, SQL* plus, ADDM, DBCA, Log Miner, TKPROF, AWR, ASH, Toad, Oracle SQL Developer, DB Artisan Putty, ERWIN, ETL. PROFESSIONAL EXPERIENCE: Client: Verizon, Alpharetta, GA Sep 2018 Till Date Role: Sr. Oracle DBA / DBRE Responsibilities: Worked on Oracle Real Application Cluster RAC and ASM, building and supporting 11gR2, 12c and 19c RAC clusters using ASM storage. Performed health checks of RAC Clusterware components ocr, voting files and backups using ocrconfig and troubleshooting issues using Clusterware logs in 19c/12c and 11g RAC. Tuning Node evictions using disk timeout, reboot time, miscount and finding Query s involved in clustered wait events and tuning queries to avoid clustered waits in the environment. Adding New Nodes to 19c RAC cluster and Installed Oracle RDBMS software on a new node of the cluster, Created ASM Volume using ASMCA and Created ACFS for GoldenGate 12c/19c. Configured Physical Standby databases using data guard for maximum performance & availability and Converted Physical standby to Snapshot Standby 11g, 12c,19c. Configured Active Dataguard 19c,12c,11g Troubleshooting Out of sync issues in Data Guard environment and Configured Dataguard Broker, fast-start failover and used for switchover and stopping and Starting Media recovery process and Performed Disaster Recovery testing. Implemented Data Guard with maximum availability and performance configurations for production databases and Performed switchover and monitor using DGMGRL. Configured SLA for Query s accessing standby database and managed Active Dataguard. Worked with VMWARE team in building new servers, performed Clusterware installation, RAC RDBMS installation, RAC Database creation, Grid Control installation, Oracle 11g,12c,19c Dataguard Standby, GoldenGate v11/12c/19c. Upgradation of GRID infrastructure from 11g to 12c and 12c to 19c. Migration of large number of databases from 11g to 12c/19c and 12c to 19c and implemented ASM on RAC and stand-alone databases and Applying PSU Patch and Migration of non ASM database to ASM database. Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for issues and validating disk space. Using list partitions for large tables and bitmap indexes for the OLAP databases. Installed Quest Shareplex 8.6 and 9.2 and performed Shareplex upgrade from 8.6 to 9.2 on Sun Solaris RAC and Non-RAC Clusters for Oracle 11g/12c Databases. Resolved lot of issues in Shareplex for Bi-direction and Uni-directional replication. Installed and Configured GoldenGate 12c/19c on ACFS for RAC Configuration and Configured GoldenGate for RDS databases on AWS EC2 Jump instances. Fixed the out-of-sync table issues for the tables in replication by GoldenGate and Shareplex. Installed WebLogic server 12c and Installed Oracle GoldenGate Veridata and Agents and created jobs compare data between instances. Oracle Enterprise Manager, Installed OEM 13c on database 12.1.0.2 and Monitoring databases using Grid Control 10g/11g/12c and 13c for Configuration of error notifications. Data masking sensitive data in production databases using OEM 12c and Scheduled Oracle Jobs using DBMS_SCHEDULER and enabled oracle vault features from OEM. Performed Database Maintenance Tasks, Rebuilding Fragmented tables, gathering statistics, refreshing materialized views, created partition tables and maintaining indexes. Enabled Flashback for the database to create restore points and supporting DDL changes. Applied PSU quarterly on the 11g/12c/19c GRID & RDBMS homes using opatch auto and Up-gradation of 11g/12c databases and Implementing catalog backup from RMAN. Worked with Agile and Waterfall methodologies and Analyzing functional requirement and implement the workflow of establishing a CDN service on various providers using Python. Implemented fine-grained access to the database using Oracle Virtual Private Database (VPD) and Oracle Label Security (OLS). Installed and Configured Oracle Label Security Components in the database. Created Levels, Compartments, Groups, Labels to enforce row level security on the databases. Set levels based on their roles to restrict the data access for functional, application and dev users in the database. Created VPD functions, Policies to implement row level security in the database. Setup & Maintenance of Oracle 12c Database on AWS EC2. Implemented and provisioned AWS services. Hands on experience with services like EC2, RDS, Cloud Formation. Setup Database in AWS using RDS, Storage using S3 bucket and Configuring instance backups to S3 bucket and Migrated applications to AWS Cloud. Implementing infrastructure on new AWS systems and migration of existing Solaris and Windows based systems to AWS. Worked on migrating Oracle databases to AWS RDS using utility AWS Database Migration Service (DMS). Created Jenkins automation scripts using shell and Ansible to create new AWS Oracle RDS and Aurora PostgreSQL Database instances. Defined AWS Security Groups, which acted as virtual firewalls that controlled the traffic, allowed reaching one or more AWS EC2 instances. Designed and Implemented scalable, Secure cloud Architecture based on Amazon WEB Services (AWS) and Managed EC2 Instances utilizing Auto scaling, Elastic Load Balancing. Installed and Configured Kerberos, Zookeeper, HBase and Hadoop data nodes ad name nodes on Docker on AWS EC2 Instances. Troubleshoot and analyze the logs of Hbase and Hadoop servers when the nodes went down. Perform rehydration of AWS EC2 servers containing Docker containers with latest AMI quarterly. Installed and Configured Couchbase 6.0/6.6/7.0 on a single node and 5 Node Clusters with data and index nodes. Upgraded existing Couchbase cluster from 6.0 to 6.6 ad 6.6 to 7.0 versions. Created indexes and buckets in the Couchbase cluster and setup Two-way Replication (XDCR) for the buckets from one cluster to another cluster. Created Jenkins automated script to build a single node Couchbase cluster using Ansible. Setup monitoring for Couchbase, Oracle and Aurora PostgreSQL clusters using Newrelic monitoring tool and Grafana. Developed application using Oracle Application Express (APEX) to monitor database performance like tablespace usage, active sessions, disk group status, database status, CPU stats. Created PL/SQL procedures to call from Oracle APEX using On-Demand application process. Installed, Implemented and worked on Oracle APEX 4.1/18.1 (Oracle Application Express). Installing and monitoring PostgreSQL database using the standard monitoring tools like Newrelic, Nagios etc. Configuring and fixing the database Issues with Pgadmin-III client application. Experience in upgrading and migrating various versions of Aurora PostgreSQL database on different platforms. Responsible for backup and recovery of the PostgreSQL databases. Worked closed with PL/SQL developers to tune TOP SQL running queries, Procedures, functions, and packages using AWR, ADDM, and TKPROF. Daily Health Check-Up of the Database and SQL Queries and Performed large batch jobs and tuning of SQL queries and database systems. Monitored the production Oracle alert logs for database errors and data issues. Involved in all phases of application development and assessment to QA/QC, design and support. Experience in an agile development environment and Worked with Query tools like Toad. Responsible for database administration and worked in all phases of Software Development Life Cycle (SDLC), and systems analysis procedures. Extensively used Jira and Service now,24x7 production support Database Maintenance and on-call Support. Environment: RAC, GoldenGate v11 /12c/19c, Shareplex 8.6/9.2, Grid Control 10g/11g/12c and 13c, MYSQL, OEM13c, Dataguard 11g/12c/19c, Veridata, Oracle Wallet, APEX, VMWARE, Cloud Migration, OEL 6.7/7/8, WebLogic server 12c, Python, WebSphere application, Advanced security 12c, AWS, Patching, AWR, ADDM and TKPROF, Toad, Transparent Data Encryption. Client: United Missouri Bank, Kansas City, MO Aug 2015 Aug 2018 Role: Sr. Oracle DBA Responsibilities: Worked in Datacenter migration project and worked in Infrastructure team and designed new environment to Install Oracle and GRID infrastructure on Linux. Performed cross platform Migration from Solaris to Linux as apart of datacenter migration using Golden Gate with Zero downtime. Installed new RDBMS versions 12.1.0.2 and applied patches by the Patch management. Upgraded Oracle databases from 11g to 12c and performed cross platform upgrade using datapump and GoldenGate. Performed database upgrades from 11g to 12c and applied patches in Dev, QA, UAT and production environments. Configured DR databases using Data Guard, Implemented Data Guard Broker and performed various operations like Switchover, Stop and Start MRP. Monitored DR (Data Guard) implementations regarding connectivity issues and "log shipping" to failover site. Converted physical standby to snapshot standby and Active Data Guard 11g and 12c Installed GoldenGate v11 on Solaris 9, AIX 6.1 and RHEL 7.3 from scratch and used Goldengate for database replication during migration. Upgraded GoldenGate from v11 to 12c & also applied patches to GoldenGate environment. Configured Uni-directional and Bi-directional topologies to support datacenter migration. Investigate replication failures using ggserr.log, report files and LogDump utility. Replaced Materialized views with GoldenGate replication and monitoring queries on tables. Planned and implemented DR & high availability solutions using Oracle 12c Standby Database, Oracle Data Guard, 11g/12c RAC. Installed, configured 3 node RAC for the 12c database and administered the 12c databases on the RAC servers. Added a new node to RAC cluster 11.2.0.4 for load balancing, Performance tuning of Interconnect and resolved contention wait types (gc blocks lost, gc buffer busy, grant 2-way) in RAC environment. Applied patches in Cluster environment using Opatch auto in rolling fashion Created disk groups with different redundancy levels and Created ASM volume using ASMCA and created ACFS for GoldenGate 12c. Implemented GoldenGate heartbeat table for lag monitoring. Configured repository database for setting up OEM 12c, used 11g,12c for monitoring databases, created administration group, template design, Black out, Database Administration, AWR, ASH, ADDM, SQL Tuning Advisor, monitoring performance of databases etc. using OEM 11g, 12c. Creation of Materialized views and partitioned the database tables to improve reporting performance. Creating and managing database objects such as tables, indexes, partition tables and views. Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups, manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager. Refreshing of databases using DataPump Export and Import utilities (expdp/impdp). Configuration of Listener and TNS names using NETCA and NETMGR. Done exports and imports of tables, schemas and tablespaces with Data Pump. Developed and enforced both database and OS-level security policies for data protection. Monitored all the databases in the areas of maintenance, tuning, performance, and troubleshooting. Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases and Involved in Mass Agent Deployment using Oracle Enterprise Manager 12c. Proficient in Hot/Cold Backup, Recovery and Cloning of databases using RMAN and shell scripts with VERITAS Net Backup, Export and Import database schema. Performing day-to-day activities of Production database such as monitoring its growth and performance and performed maintenance tasks, rebuilding indexes, gathering statistics, refreshing materialized views etc. Using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF. Performed SQL tuning, System tuning, Database and Instance tuning by analyzing root causes. Configuring and Handling Oracle Network files like Listener.ora, TNSNames.ora and SQLNET.ora. Managed data security and integrity using DB Vault, Wallet, Transparent Data Encryption (TDE) and Data Masking. Created tables that contain Encrypted Columns and Oracle Wallet Management for Transparent Data Encryption (TDE) 11g,12c and installed Database Audit vault server and database firewall and protected realms. Written Stored Procedure and Triggers for database maintenance and management using PL/SQL and Involved in gathering requirements from end users. Provided on-call support regarding production-related database problems. Performed Database and SQL tuning by using various Tools like AWR, ADDR, ASH, TKPROF, Explain Plan, SQL Advisor and optimizer hints. Developed Scripts for transferring data from production server to testing/development servers. Developed table structures, PL*SQL stored procedures and database triggers to implement business rules. Cloning of databases using RMAN and User managed techniques and Involved in scheduling incremental, cumulative and full backups and configured retention policy using RMAN. Configured GoldenGate Classic and Integrated components for Active-Passive and Active-Active replication between heterogeneous environments (Oracle/ Microsoft SQL Server/ Sybase) and maintain data synchronization. Developed and configured GoldenGate macros for data conflict resolution, filtering and transformation, exception handlers. Created SQL Loader scripts using Unix shell scripting and PL/SQL. Worked with Java Developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code of optimizations and indexes. Managing and providing 24X7 supports for various versions of databases. Environment: Oracle 11gR2,12C, MySQL, SQL 2012, Linux 6.3 AIX 6.1, Oracle Enterprise Manager, Grid Control, RHEL 7.3, Solaris 9, HP-UX, OEM Database control, PL/SQL, Oracle SQL Developer, Autosys, Shell Scripting, TOAD, ASM, RAC, GoldenGate, Data Guard. Education: Bachelor of Technology, JNTU, India Keywords: quality analyst user experience business intelligence sthree database active directory hewlett packard green card procedural language Georgia Missouri