Home

Suneel T - Senior Oracle Exadata DMA/Engineer

[email protected]

Location: Orlando, Florida, USA

Relocation: No

Visa: H-1B

Suneel T Sr. Oracle Exadata Admin/Engineer E-mail: [email protected] Mobile: 585-490-7865 Career Objective: Seeking a challenging position as an Oracle DBA & Exadata DMA in an esteemed organization with good knowledge on Oracle 11g/12c/18/19c/21c and working experience on production and development environments, willing to make a significant contribution both as a team member and as an individual. Professional Summary: Over 14+ years of diversified experience in administration of production databases which includes 12c,19c (RAC with ASM), Standalone database, Replication options known as Data Guard, Golden Gate; In all of this expertise in Installation, configuration, Administration tuning, design, patches, upgrade, migration, capacity planning, OEM Grid Control, Flashback, RMAN backup and recovery, cloning, auditing, troubleshooting and documentation. Extensive hands on experience of database performance tuning including RAC and SQL tuning experience with 12c and 19c RAC scalability, HA, EXACS, EXACC, RAC performance tuning, instance availability and background processes monitoring, waiting events and log and trace files investigation for troubleshooting. Extensive working experience with 12c and 19c RAC database installation, building, configuration and administration, ASM installation, configuration and monitoring and oracle CRS administration. Extensive working experience with 12g, 18 and 19c DATAGUARD/active DG to administrate both standby databases including installation, configuration, run-time monitoring and administration, performance tuning and trouble shooting. Good Knowledge in MongoDB and PostgreSQL administrative activities including Mongo shell and Sql shell Commands Focusing on Exadata Administration. With nodes ranging from 2 to 8 and Incorporating data guarded Exadata clusters for maximum availability Worked on ESM Battery and disk replacement activities on Exadata servers. Experienced on Adding a Node and Deleting Node in 12c and 19c Upgraded RAC Databases from 12.2 to 18 and 19c Worked On cross platform migrations using Golden Gate and Delphix tools . Experience in oracle GoldenGate Installation,configuration,troubleshooting Golden Gate issues Perform Query tuning, Instance/Memory tuning by using various performance tools TKProf, Explain Plan, Statspack, ADDM, AWR, etc Experienced of managing and administering 24X7 running databases. prepared standard operating procedure(sop) documents for frequently used databases tasks and process Good Analytical and Strong interpersonal and excellent communication skills EDUCATION: BSC Computers, from S.V.University Master Of Computer Applications , from Osmania University TECHNICAL CERTIFICATIONS: Oracle Certified Associate (OCA) Oracle 11g AWS Certified Solution Architect-Associate level TECHNICAL SKILLS: Operating SystemsRed Hat Linux RHEL 4.x ,5.x, 6.x, HP-UX 10.x, 11.x, Sun Solaris 9,10,11 AIX 5.1, 5.2 Data Bases Oracle 19c/18/12c/11g, Oracle 12c, 11g/10g Real Application Cluster (RAC), Exadata ASM, Mysql, SQL SERVER 2008/2012, NoSQL, Mongo, AWS-RDS,EC2,EXACS and EXACC Languages SQL, PL/SQL, UNIX Shell Scripting Tools/ Utilities RAC,BladeLogic OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, NETCA, DBCA, TOAD, Exadata, CyberArk, Patch Management, SQLNET, ODBC Export/Import, Data pump, Data-Guard, VERITAS Net Backup, OEL, BMC remedy, Pac 2000, VMware, Log-miner, Cron-Tab, Erwin,ETL,BLADE LOGIC Tuning Tools TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR Terminal Emulation Putty, Telnet, FTP, TOAD EMPLOYMENT: Keysoft IT Ally Financial , Orlando USA Apr- 2018 to Tilldate Principal Technical Support Engineer Engage with customers to help resolve complex issues affecting production database systems on Exadata platform across all problem types Performance, Scalability, Storage, Security, Administration, EXACS and OCI Cloud Migrations etc. The role entails collecting trace files for specific problem types / issues and analyzing them for known issues. Engage with customer on web conferences and calls to explain the findings / analysis Engage with customers to explain the product lifecycle , maintenance methods / cadence, Patching policies, health checks , proactive tasks etc so the database systems and environments perform optimally and without issues. Engage with Development team to identify and resolve defects encountered by customers. The process involves setting up the testcase internally to reproduce the issue and diagnose the issue. Use and test on latest versions of the software to determine if the issue is new. Work with customers to obtain all the relevant traces to get the defect resolved and fix delivered. Engage with Platinum Exadata customers to troubleshoot and address issues in real time. Select a few engineers are trained and accredited to log into customer systems to debug and diagnose problems. Implemented robust security measures, including the utilization of CyberArk, to manage privileged accounts and secure sensitive data within Oracle databases. Configured and managed CyberArk's Privileged Access Security Solution to enforce strong access controls and protect against unauthorized access to critical database assets. Collaborated with the security team to develop and implement security policies and procedures, aligning with industry best practices and compliance requirements. Conducted regular audits and vulnerability assessments to identify and mitigate potential security risks within Oracle database systems. Provided technical support and guidance to the team regarding CyberArk integration and security-related matters. Tools and Technologies applied : Database, Network layers, Storage, Grid, Clusterware, CyberArk, Real application clusters (RAC) , OSWatcher, Networking stack, Storage concepts ( SAN, WAN, LAN, VLAN ) Linux, Unix, Windows OS Automated Storage Management ( ASM ) , Scripting Knowledge ( Shell, Java, Python, C, C++), Enterprise Manager, DBCA, DBUA, Opatch, OUI Cognizant -TIAA-CREF, Charlotte ,USA Jan- 2017 to Apr-2018 Sr. Oracle Exadata Admin/Engineer Environment: Oracle Exadata Database 12c, 11g, Golden Gate, Delphix C3 cloud , AIX, Amazon RDS, Oracle Linux 6,OEM, Emc Storage, AWS RDS,ETL,Erwin,Data Warehouse Responsibilities: Architected ,Designed, Installed and configured Oracle 11g/12c RAC Database on Solaris,AIX , and Linux platforms Administration of Oracle 11g/12c RAC (2 Nodes and 3 Nodes) databases. Analyzing AWR, ASH and ADDM reports for resolving DB performance issues. Monitoring of databases using OEM 12c Grid Control. Closely Worked with Oracle support in identifying some long standing issues. Also extensively used oracle Metalink. Migrating databases from Aix to Exadata and c3 cloud Migrating on premises databases to Amazon RDS and EC2 using AWS DMS Monitoring AWS RDS databases using AWS cloud watcher and SNS Skills in Network technologies as they relate to AWS, including: DNS, Load Balancing, Amazon Virtual Private Cloud (VPC), AWS Direct Connect,AWS Storage Gateway Cross platform Migration of databases using datapump,GG and Delphix tools Performing RAT test before and After migrations. Experienced in Oracle SOX databases Upgraded production and all test databases from Oracle 9.2.0.8 to 10.2.0.3 to 11.2.0.4 to 12.1.0.2 Configuration of Oracle Standby Databases(Active Data Guard) for high availability/Disaster Recovery Solution from Production Server to the DR Server Experience on Oracle GoldenGate for data replication for enterprise data centers including installation, configuration, administration, performance monitoring. Avani technology solution -TIAA-CREF, Charlotte ,USA Jan- 2016 to Jan-2017 Sr. Oracle Exadata Admin/Engineer Environment: Oracle Exadata Database 12c, 11g, Golden Gate, Delphix C3 cloud , AIX, Amazon RDS, Oracle Linux 6,OEM, Emc Storage, AWS RDS,ETL,Erwin,Data Warehouse Responsibilities: Architected ,Designed, Installed and configured Oracle 11g/12c RAC Database on Solaris,AIX , and Linux platforms Administration of Oracle 11g/12c RAC (2 Nodes and 3 Nodes) databases. Analyzing AWR, ASH and ADDM reports for resolving DB performance issues. Monitoring of databases using OEM 12c Grid Control. Closely Worked with Oracle support in identifying some long standing issues. Also extensively used oracle Metalink. Migrating databases from Aix to Exadata and c3 cloud Migrating on premises databases to Amazon RDS and EC2 using AWS DMS Monitoring AWS RDS databases using AWS cloud watcher and SNS Experience in working with Sql Queries and PL/SQL(Stored Procedues,Triggers,Packages/Functions) Design, development, testing, performance tuning, deployment, and support in Data warehouse system. Define and implement ETL development standards and procedures for data warehouse environment. Cross platform Migration of databases using datapump,GG and Delphix tools Performing RAT test before and After migrations. Experienced in Oracle SOX databases Upgraded production and all test databases from Oracle 9.2.0.8 to 10.2.0.3 to 11.2.0.4 to 12.1.0.2 Configuration of Oracle Standby Databases(Active Data Guard) for high availability/Disaster Recovery Solution from Production Server to the DR Server Experience on Oracle GoldenGate for data replication for enterprise data centers including installation, configuration, administration, performance monitoring. Worked on Active Standby Database and snapshot standby database Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research. Database refresh, schema refresh, database creation, Implement table partitioning Co-ordinate with application team and developers in resolving issues andprepare deployment plans Configured and tested backup and recovery using RMAN Cloning of production database to the test environment using Recovery Manager (RMAN). Restoring the databases on the test server with the backed up files of live server. Provide support on production server to the clients after the live upgrade till the transition. Hcl Mexico ,Merck & CO, USA June 2012 to Jan 2016 Oracle Exadata Admin Environment: Oracle Exadata Database 12c, 11g, 10g,AIX, Golden Gate, Oracle Linux 6, Hitachi Storage Project Description: Merck & Co., Inc. is a global research-driven pharmaceutical company dedicated to putting patients first. Established in 1891, Merck discovers, develops, manufactures and markets vaccines and medicines to address unmet medical needs. The company devotes extensive efforts to increase access to medicines through far-reaching programs that not only donate Merck medicines but help deliver them to the people who need them. Merck also publishes unbiased health information as a not-for-profit service Responsibilities: Focusing on Exadata administration. with nodes ranging from 2 to 8 and incorporating dataguarded eaxdata clusters for maximum availability Migrated Databases from X3-8 to X5-8 Exadata Machines Supporting customers for resolving their Critical Production Issues. Very strong Production Support (24X7) experience Involved in all aspects of Database Administration in MS-SQL Server 2005 and 2008. Knowledge of MongoDB performance/scaling/sharding concepts and best practices. Managing lifecycle of MongoDB database including database sizing, deployment automation, monitoring and tuning Installation, configuration, patching and upgrades of Oracle RAC. Experienced in Oracle SOX databases Implementing Change controls in production environment Upgrade/Migration of Databases from Oracle 10g to 11g. OEM Gridcontrol to monitor all databases. Planned and implemented high availability solutions using Oracle 11g RAC, Standby Database using Oracle Data Guard Worked on Active Standby Database and snapshot standby database Experience in oracle GoldenGate installation,configuration,troubleshooting Golden Gate issues Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research. Database Tuning, PL/SQL tuning using explain plan and used HINTS extensively to optimize the SQL statements, used cost based approach extensively and also used rule based methods to tune the SQL Database refresh, schema refresh, database creation, Implement table partitioning Co-ordinate with application team and developers in resolving issues andprepare deployment plans Installed Oracle Apex components Configured and tested backup and recovery using RMAN Cloning of production database to the test environment using Recovery Manager (RMAN). Restoring the databases on the test server with the backed up files of live server. Provide support on production server to the clients after the live upgrade till the transition. Upgrades exadata databases from 11.2.0.3.26 to 11.2.0.4.16 Supported Disk and ESM Battery replacement Activities on X3 and X5 Exadata machines Converted Flash cache from Write-Through to Write-Back Applied the interim and Bundle patches for RAC and Exadata Databases Configured and tested backup and recovery using RMAN Worked with Oracle Support through TAR to resolve issues Building standby database for the replication of the primary database Restoring the databases on the test server with the backed up files of live server. Provide support on production server to the clients after the live upgrade till the transition. Implanted Uni-directional replication using golden gate Appreciation: Received best employee award from client HDFC Bank Datacenter, Wipro Infotech Sep 2011 to Jun 2012 Oracle RAC DBA Environment: Oracle 11g RAC ,OEM, RHEL 5, 6, IBM AIX, Hitachi Storage Responsibilities: Installed and configured of Oracle 11gR2 (11.2.1 and 11.2.0.3)Real Application Clusters on Production database. Installed & Configured of Oracle Cluster Software s (11.2.0.3) (Placed OCR & Voting disk in Raw ASM file systems). Upgraded RAC servers from 11.2.0.1 to 11.2.0.3 Installed and configured of OEM(11g grid control) Converted single instance database to cluster database. Configured ASM Instances and Migrated Non-ASM Databases to ASM databases Using RMAN Managing RAC instances using srvctl. Support Production, QA, DEV, UAT databases. Cross platform Migration of databases using export/import and datapump Applying rolling patches in RAC environment using Opatch AUTO Applying oracle PSU,Memory patches(CPU) Converted single instance database to cluster database. Worked on Active Standby Database and snapshot standby database Capacity Planning, Minimize the database down time. Configured and tested backup and recovery using RMAN Worked with Oracle Support through TAR to resolve issues Building standby database for the replication of the primary database Restoring the databases on the test server with the backed up files of live server. Provide support on production server to the clients after the live upgrade till the transition. Performed Database Reorg for faster Performance. Simplex System LTD ,Hyderabad Sep 2009 to Sep 2011 Oracle DBA Environment: Oracle 11g, 10g ,Solaris 10,11, Rhel, 5, 6 Responsibilities: Involved in installation and configuration of Oracle 10g Real Application Clusters on Test database. Responsible For Installation & Configuration of Oracle Cluster Software (Placed OCR & Voting disk in Raw devices) Converted single instance database to cluster database. Managing the oracle clusterware using: crsctl, crs_stat, ocrconfig, ocrdump utilities. Configured and tested backup and recovery using RMAN Installed and Configured Oracle RDBMS software on various platforms. Cloning of production database to the test environment using Recovery Manager (RMAN). Tuned the database for better performance using Explain Plan and AWR Interaction and Co-ordination with clients. Resolving the problems like resize tablespace, Session lock/Killed, Deadlock, Schemas Refresh on Client request Uploaded the data between the databases using Export and Import Data pump Utilities Creating Database objects, Users, Roles, Profiles for the databases. Involved in reorganizing the tables and Rebuilding the Indexes that are highly fragmented to improve the performance. Monitoring performance Issues with AWR, ADDM & ASH Reports. Vernion Solutions ,Hyderabad Mar 2008 to aug 2009 Oracle DBA Environment: Oracle 11g, 10g ,Solaris 10,11, Rhel, 5, 6 Responsibilities: Daily monitoring the performance of database Performing oracle installations Performing Export and Import operations. Performing backup and recovery operations if needed Database Creation Managing Tablespaces, Datafiles, Control files, Redo Log files. Creating Databases, Creating table spaces with storage parameters. Creating Database objects, Users, Roles, Profiles for the databases.. Checking alert log file. Cleaning up unused spaces from the server for backup process. Monitoring Space and Index usage Checking database locks and clearing the blocking sessions. Keywords: cprogramm cplusplus quality analyst user experience database information technology hewlett packard microsoft procedural language Colorado