Uday Kiran

Experience Summary:

Seeking DBA assignments for Production & Technical support for Oracle 19c, 12c, 11g, 10g, 9i and 8i and MS SQL SERVER 2012, 2014, 2016 & 2017 with a high growth-oriented organization where my skills can contribute towards achieving organizational goals, show Excellent Technical & Communication Skills, and a zest for teamwork & having Ability to develop & implement ideas with creativity and persistence.

Professional Summary: •

Working in INVEST BANK, Sharjah, UAE as Oracle and MS SQL DBA from Dec-2017 to till date • Worked for Abu Dhabi Commercial Bank, Abu Dhabi, UAE as Oracle and MS SQL DBA from APR-2016 to nov-2017. • Worked for CTS Pvt Ltd, Bangalore as Sr. Oracle DBA from SEP-2014 to FEB-2016 • Worked for IBM India Pvt Ltd, Bangalore as Oracle DBA from FEB-2014 to SEP-2014.

SKILL SET: •

Having 8 Years of experience in ORACLE and MS SQL database Administration with Hands on Experience on multiple OS PLATFORMS (WINDOWS, LINUX, AIX...)

• Ability to handle different versions of Oracle databases 9i, 10g, 11g ,12c and 19c.

• Hands on experience in pluggable database creation and maintenance

• Supporting for GUARDIUM and INFORMATICA data masking tool

• Install Guardium agent on database server and providing the masking rules to security team

• Implementing data masking and data security for oracle and MS SQL databases

• Hands on experience in DATA MASKING, IBM Gaurdium and informatica tool

• Creating REDACT & ADVANCED SECURITY Policies to mask critical data

• Hands on experience in shell scripting and batch scripting, created many scripts for database monitoring

• Experience in ORACLE DATAGUARD

• Hands on experience on physical standby and active data guard and snapshot database creation • Daily Monitoring and resolving data guard archive sync with primary and standby databases

• Creating materialized view and refresh MVIEW based on nature of data

• Hands on experience on MS sql server database 2012, 2014 and 2016

• Configure MS SQLserver ALWAYS ON and cluster configuration

• Configuring the Database mirroring MSSQL SERVER 2016

• Backup & restore in sql server and recovery of databases

• Experience in configuring the SQL server Failover cluster and ALWAYSON AVAILIBILITY GROUPS

• Hands on experience on SQLserver database patching and upgrades and service pack upgrades

• Experience in performance tuning of MS SQL server

• Full Index rebuilding and index fragmentation in MS SQL SERVER

• Configure security policies as per the standards for SQL SERVER database

• Hardening the databases with security guidelines

• Hands on experience on configuration and support for Golden Gate 2 | P a g e

• Monitoring, troubleshooting and Resolving the golden gate issues by raising SR with ORACLE support

Projects Handled: INVEST BANK –

ORACLE & MS SQL Database Administrator – Dec 2017 to Present:

• Installing and configuring Oracle & MS SQL databases Windows, Linux and AIX servers

• Installing and configuring the OEM 13c in windows server

• Configuring SQL SERVER Failover cluster and Always On groups

• Patch and SQL SERVER Service Pack apply update for the databases

• Regularly patch database with security compliance

• Resolving performance issues in ORACLE and MS SQL SERVER databases

• Installing Oracle 11g and 12c client installation of Linux and AIX and Windows platforms

• Upgrading the oracle databases (ORACLE & MSSQL) to latest versions

• Database restores from PROD to TEST as per user request

• Configure RMAN backups, LOGICAL backups and SQL SERVER Backups

• Configure schedule jobs for database monitoring ORACLE and MSSQL

• Prepared scripts for the database monitoring on windows and AIX for the daily alerts

• Prepared scripts for the backups and monitoring and resolving issues

• Regularly monitoring Alert log file & Database logs on day to day basis and resolving problems.

• Monitoring CPU and memory utilization, space utilization and add data files to tablespaces when needed.

• Database Refresh on UAT and DEV Database, Schema Refresh, Table refresh.

• Monitoring archived logs generation archived log disk partition and archived log backup

. • Monitor SQL log files growth and take action accordingly

• Resolving the performance related issues face by application users

• Performing User managed backup and RMAN backup as planned. 4 | P a g e

• Performing user managed backups for MS SQL server

• Configured automated scripts for DR SWITCHOVER activity for MSSQL & ORACLE databases

• Experience in configuring the SQL server Failover cluster and ALWAYSON AVAILIBILITY GROUPS

• Configuring the Failover cluster instances for MS SQL SERVER

• Crosschecking and validating the database backup.

• Performed Dataguard switchover and Failover to DR database

• Monitoring Table space and Data files growth on regular basis.

• Creating database Objects like Table, View, Index as per user requests and also for DB health checks.

• Monitoring Undo Table space usage/ Index usage in ORACLE & MS SQL databases

• Creation of Schema/User, Grant of necessary Roles/ Privileges • Written nightly scripts and scheduled using CRONTAB.

• Automation of regular jobs and activities.

• Troubleshooting server and network configuration files such as tnsnames.ora and listener.ora.