Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Shwetha Thippeswamy

Tonbridge

Summary

Professional, detail-oriented Database  Administrator motivated to ensure high availability and optimum performance  of a database system as part of a dynamic team. Always strive to learn and implement cutting edge technology and best practices.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Database Support Engineer

Imagine Communications
Thames Ditton
01.2014 - 04.2019


  • Provided DBA support for Oracle/Sql server production databases.
  • Responsible for Installation, Administration and Maintenance of Oracle/SQL Server Instances.
  • Setup Test, Dev, Staging and Production Environments.
  • Created Users and assign permissions based on the level of database access the user would need.Worked with developers in development of the database schema design using the Entity-relationship model as per user requirements
  • wrote and reviewed T-SQL Scripts for creating tables, constraints, triggers, stored procedures, views and functions for critical business applications
  • Established backup of SQL server 2012 by using SQL Server Agent Jobs for periodic backups
  • Updated statistics with full scan on a weekly basis to make sure that the query optimizer uses the most recent statistics
  • Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands to find the slow running queries to get the performance metrics .
  • Installation and implementation of the Oracle 11R2 on Windows
  • Upgrading from Oracle 10.2.0.3. to Oracle 11.2.0.4.
  • Implement Production control and change management. Identify, monitor, recommend and implement changes under change control in production environment.
  • Advanced Backup and Recovery using Oracle’s RMAN software; used offline/online for recovery in a production environment via shell scripting.
  • Implemented and maintained Oracle 10g/11g Data Guard/standby databases.
  • Experience in Data Guard using Enterprise Manager, Data Guard Broker and also manually via sqlplus
  • Propagation from primary to standby via automated scripts, and sometimes use standby databases to immediately restore primary database. As its standard edition automatic standby maintenance is not available.
  • Mentor other DBA in effective use of RMAN software, and my scripts.
  • Experience with ‘graceful’ switchover and switchback between primary and standby databases by using Enterprise Manager, Data Guard Broker and also manually via sqlplus .


Database Support Analyst

Robert Walters London (Head Office)
London
10.2013 - 11.2014
  • · Installation and implementation of the Oracle 11R2 on Redhat 5.
  • Advanced Backup and Recovery using Oracle’s RMAN software; used offline/online for recovery in a production environment via shell scripting.
  • Implemented and maintained Oracle 10g/11g Data Guard/standby databases. Experience in Data Guard using Enterprise Manager, Data Guard Broker and also manually via sqlplus
  • Propagation from primary to standby via automated scripts, and sometimes use standby databases to immediately restore primary database. As its standard edition automatic standby maintenance is not available.
  • Mentor other DBA in effective use of RMAN software, and my scripts.
  • Experience with ‘graceful’ switchover and switchback between primary and standby databases by using Enterprise Manager, Data Guard Broker and also manually via sqlplus.
  • Replicated to a disaster recovery site for increased server manageability and availability.
  • Create and maintain materialized views.
  • Implementing and maintaining database security (create and maintain users, roles and assign privileges)
  • Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
  • Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
  • Monitored the production Oracle alert logs for database errors.
  • Monitored system resource availability and responded to system memory and data issues.
  • Configured OEM on all the database and Mentor other DBA in effective use of OEM.
  • Implemented dashboard to display all the backup by using power shell scripting.
  • Create various Stored Procedures and Database triggers.
  • Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
  • Use Oracle scheduler to schedule database backup job, analyze specific schema job, maintain schema related data jobs and monitor schemas related data growth job. Schedule database statistics gathering jobs.
  • Restoring development/test databases for month end activities and testing.
  • Creating Service Request and monitoring Service request to resolve issues faced in production server. Performing root cause analysis of issues faced in production environment.
  • Experience with Oracle client Installation and upgrade.
  • Experience in working ITIL process to raise Change Requests, Resolving the incident example Cherwell Service management, HP Service manager.
  • Developed and implemented performance improvement strategies and plans to promote continuous improvement.

Education

Bachelor of Computer Science -

Visvesvaraya Technological University
India
10.2008

Skills

  • Database Design and Development
  • Installing, Configuring and Harding SQL Server/Oracle Instances
  • Implementing Oracle/MS SQL server security practices
  • Database Backup and Restores
  • Database Mirroring, LogShipping & Replication
  • Scheduling and monitoring SQL server jobs and maintenance plan
  • AlwaysOn Availability groups and Failover Clustering installation and Configuration
  • Index creation and rebuilding
  • Update statistics
  • Knowledge of Azure cloud services
  • PerformanceMonitoring and Tuning
  • Query optimization
  • event log and Server error log troubleshooting
  • Database migration

Certification

● Oracle Database 11g Administrator Certified Professional (Oracle 11g OCP DBA)

● Oracle Database 10g Administrator Certified Professional (Oracle 10g OCP DBA)

Timeline

Database Support Engineer

Imagine Communications
01.2014 - 04.2019

Database Support Analyst

Robert Walters London (Head Office)
10.2013 - 11.2014

Bachelor of Computer Science -

Visvesvaraya Technological University

Similar Profiles

CREATE PROFILE
Shwetha Thippeswamy