Oracle Data
Resume:
**** ***** **** ****. ************ OH ***** Ph. 440-***-**** (cell)
Email: ************@*****.***
Kishore Nalla
Professional Summary
• 15+ Years IT experience including RDBMS management and support of database applications.
• Successful migrations to Gen 2 OCI & Cloud@Customer and Microsoft Azure. Extensive experience as a Customer Success/Technical Account Manager in helping enterprise customers successfully use Oracle and Microsoft products and services. Successful projects as a DBA managing/advising Fortune 500 clients on Oracle and Microsoft Technologies.
• Created collaborative working relationships with Product Management, DEV, Operations. Led & directed virtual global teams to accomplish successful migrations to Cloud & resolve customer technical issues.
• Hands-on Experience in Oracle 8i/9i/10g/11g/12c/18c/19c and SQL Server 2000/2005/2008/2012/2016 Architecture and Management.
• 15+ years extensive Oracle8i/9i/10g/11g/12c/19c DBA hands on experience (Unix/NT) and 10+ years extensive SQL Server 2000/2005/2008/2012/2016 DBA hands on experience in database upgrading, creating, replicating and performance tuning as well as backup & recovery. Good at tuning and troubleshooting including SQL statement tuning, Database/Data Warehouse logical/Physical partition, System memory and I/O tuning, and MV for report tuning
• Solid working experience and extensive knowledge of Oracle /SQL server HA and DR solutions, such as Oracle RAC and Data Guard. SQL server 2005 Database Mirroring, Log Shipping, and Replication, SQL Server Always ON, working experience of data distribution technology such as oracle DB link and SQL server Linked server. Extensive experience in database problem determination and resolution.
• Solid working experience and extensive knowledge of very large databases migration cross different platform.
• Working experience in management very large OLTP database and OLAP data warehouse with Oracle RAC 10g/11g/12c
• Perform critical data recovery with all means and knowledge. Very strong analytical ability
• 10+ years Unix/Linux/Windows and Storage work experience in Sun Solaris/AIX/HP- UX/Redhat/SUSE, strong working experience and extensive knowledge of server level HA solutions such as HACMP, VCS, Service Guard as well as Storage technology such as Disk RAID, oracle ASM, SAN and NAS
• 2 year experience in VMware administrate, good working experience and extensive knowledge of windows server level HA solutions such as MSCS as well as windows NT Architecture such as Active Directory, Domain Controller, OU etc concept.
• Certified Oracle 10g Database Administrator and SQL server 2005 IT Technical Specialist
• Dedicate team player and internal commutation skills . Faster learner and organize skills EDUCATION
Bachelor’s Degree in Computer Science UTKAL UNIVERSITY, INDIA SKILLS
• Strong ability to work independently and manage one's time. Strong knowledge of computer software, such as SQL Server (2005-2016), Oracle (7 – 19c) etc. 6793 Great Oaks Pkwy. Independence OH 44131 Ph. 440-***-**** (cell) Email: ************@*****.***
• Knowledge of Replication & High Availability products (Oracle Dataguard, Oracle RAC etc) is desirable
• Good troubleshooting skills and ability to resolve issues quickly and effectively
• Strong working knowledge of Oracle high availability solutions (i.e., RAC, DataGuard)
• Proficient knowledge of Oracle Database 11g,12c,18c and 19c technologies including RAC and ASM, RMAN, and Data Guard
• Knowledge on SSRS, SSIS and SSAS
• Strong working knowledge of server hardware and OS technologies including Linux, and Windows
• Ability to build strong relationships with clients and team member
• Is detail-oriented with good organizational skills Professional Experience
Cuyahoga County Cleveland OH
Sr. Database Administrator Jul 2020 – Dec 2020
Worked as a Senior DBA. Provided support for Database migration from legacy systems to SOLIX cloud environment.
• Migrated and supported the SQL Server databases into SOLIX environment in cloud. This is used for archiving the data.
• Installed Tableau and administered in DEV/TEST/PROD environments. Created data driven and interactive visual analytics reports.
• Created reports using SQL in buyspeed application and used them to create interactive visual analytics reports in Tableau.
NCCI, Boca Raton FL February 2019 – Jul 2020
Database Administrator
Worked as an Oracle/SQL Server DBA maintaining and supporting various database applications on Windows and Linux platforms.
• Responsible for installing, configuring and maintaining Oracle and SQL Server database supported applications.
• Responsible for disaster recovery and high availability solutions and large scale database migrations from SQL Server 2012 to 2016 and Oracle 12c to 19c.
• Created automation of day to day operations, critical Oracle and SQL server alerts and repetitive tasks.
• Monitored the health and performance of SQL server instances and home grown applications using extended events, SQL Server profiler, perfmon and third party tools.
• Successful migrations to Gen 2 OCI & Cloud@Customer and Microsoft Azure. Upgrade SQL databases from 2012 to 2016.
• Experience working with Azure SQL Database Import and Export Service and experience in deploying SQL Databases in Microsoft CLOUD AZURE.
• High level understanding of RDBMS concepts as well as Data Modeling and Azure SQL concepts.
• Extensively used tools like SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for monitoring and tuning MS SQL Server performance. CGI Inc March, 2008 to February 2019
Senior Consultant/DBA
Worked as an Oracle/SQL Server DBA of this consulting and outsourcing Company.
• More than 7 years worked for a Cloud Multitenant Database As a Service Provider at CGI which is the Top Tier 1 Cloud Service provider for US Federal Govt Databases As a Service
6793 Great Oaks Pkwy. Independence OH 44131 Ph. 440-***-**** (cell) Email: ************@*****.***
• Senior Oracle DBA supporting the IT systems of many extremely dynamic clients including Federal Government departments, both Cloud and non-Cloud in Oracle RAC and stand-alone databases
• Supporting large database environments (Terabyte +),
• Supporting Cloud Infrastructure Databases
• Installation, setup, administration, maintenance of Quest Shareplex (versions 6.0.1, 7.5.2 and versions in between)
• Oracle Database Replication, architecture (Includes Storage (ASM), Unix, Network Architecture), and maintenance of Oracle 10g and 11g RAC, 12c RAC and Cloud DBs
• Setup, administration, and maintenance of Oracle 10g and 11g/12c Data Guard
• Upgrade of Oracle RAC and stand-alone databases from 10g to 11g and from 11g
(version 2.0.1) to 12c (version 2.0.2)
• Installation, administration, and setup of 12c and 13c OEM Grid Control, RAC and Data Guard Disaster Recovery
• Backing up, restoring and recovering databases using RMAN
• Performed SQL and PL/SQL stored procedure development
• Involved in requirements gathering and implementation of database design and development Involved in Production DBA support for both Cloud and Non-Cloud Databases and troubleshooting and backup and recovery
• Involved in tuning SQL queries, Capacity Planning for new server additions and database growth
• Senior Oracle DBA supporting around 175 productions and overall around 400 databases, of all kinds and sizes
• Provided production Database Support for SQL Server 2005, 2008, 2012, 2016
• SQL Server 2005, 2008, 2012, 2016 installations, upgrades and migrations
• Supporting large database environments (Terabyte +), Technical Environment:
Hardware: IBM AIX, Linux and Windows
Software: Oracle 10g, Oracle 11g, 12C
OS: IBM AIX (UNIX), Linux, Windows
Languages: SQL, PL/SQL, UNIX Shell Scripting
Tools: Quest Toad (Database Tuning and Monitoring), Oracle Grid Control 13c, Quest Tools (Database Tuning and Monitoring)
Penske Logistics 07/07 to 02/08
Senior Oracle Database Administrator
• Senior Oracle DBA whose responsibilities included managing day to day DBA activities
• Supported an extremely dynamic environment
• Acted as SARBANES-OXLEY (SOX) Oracle DBA
• Administration of Oracle 10g database environment
• SQL Server support 2005
• Participated in disaster recovery efforts
Technical Environment:
Hardware: HP-UNIX and Windows 2000
Software: Oracle 8.1.7.2 and Oracle 9i (9.2.0.6) and 10G OS: HP-UNIX
Languages: SQL, PL/SQL, UNIX shell Scripting
Tools: OEM, Quest Tools
Safeguard Properties 05/07 to 07/07
Senior Oracle Database Administrator
6793 Great Oaks Pkwy. Independence OH 44131 Ph. 440-***-**** (cell) Email: ************@*****.***
• Senior Oracle DBA who provided centralized DBA support to over 500 projects using Windows 2000, HP-UX and Tru 64 platforms
• Tuned the database by monitoring and tweaking various memory parameters to provide well-oiled performance
• Provided SQL Tuning, Kernel Tuning, SQL and PL/SQL stored procedures development Involved in requirements gathering and implementation of the database design and development
Technical Environment:
Hardware: Windows XP, 2000, NT, HP-UX and Tru 64
Software: Oracle 8.1.7.2 and Oracle 9i and Oracle 7.3.4 OS: Windows XP, 2000, Tru 64 and HP-UX
Languages: PL/SQL, UNIX Shell Scripts
Tools: OEM (Database Tuning and Monitoring), Designer, Quest Tools (Database Tuning and Monitoring), Toad, Embarcadero DBArtisan, ERWIN
Invacare Corporation 01/07 to 05/07
Senior Database Administrator
• Senior Oracle DBA performing SQL Tuning, Oracle 8i database administration, data modeling and design, SQL and PL/SQL stored procedures development, Java database programming support and database design
Technical Environment:
Hardware: Windows XP, 2000, NT, IBM AIX, HP-UX and Tru 64 Software: Oracle 8.1.7.2 and Oracle 9i and Oracle 7.3.4 OS: Windows XP, 2000, Tru 64, AIX and HP-UX
Languages: PL/SQL, UNIX Shell Scripts
Tools: OEM (Database Tuning and Monitoring), Designer, Quest Tools (Database Tuning and Monitoring), Toad, Embarcadero DBArtisan, ERWIN
HNI Corp 05/00 to 12/06
Database Administrator
• As a Oracle/SQL Server DBA, performed physical design and layout of databases, SQL Tuning, data warehouse administration, Oracle 8i and 9i database administration, data modeling and design, and SQL and PL/SQL stored procedures development, Technical Environment:
Hardware: SUN Ultra Sparc Enterprise E10K, AIX RS/6000 Software: Oracle 8.1.7.2, 9i and SQL Server
OS: SUN Sparc Solaris 2.8, HP unix and Windows
Languages: PL/SQL, UNIX Shell Scripts, and Perl
EDUCATION
B.E. Computer Science – Utkal University, Bhubaneswar, India, 1993
Contact this candidate