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.
Copyright© Cosette Network Private Limited All Rights Reserved