Sandhya K

Around 5.8 years of experience as an Oracle Database Administrator, supporting Production, Staging, Development and Test environments. Hands-on experience with Oracle 10g/11g database administration, backup and recovery, RMAN, database/schema refreshes, user and space management, monitoring and troubleshooting.

Experience working with enterprise ticketing tools including ServiceNow and BMC Remedy for logging, updating, tracking and resolving incidents/service requests and coordinating escalations. Experienced in monitoring production issues, analyzing alerts and logs, documenting troubleshooting steps, providing resolution updates, and closing tickets after validation. Worked with application/system teams to troubleshoot database access, connectivity, backup, space and availability-related issues within support timelines.

Working knowledge of SQL, PL/SQL and Unix/Linux, with exposure to RAC concepts, OEM monitoring and performance-tuning activities.

Oracle Database Administrator - Wipro Technologies (Ltd)

(2012-03 - 2017-11)

Database Administrator - Carillion Plc

(2014-06 - 2015-12)

Production database administration and operational support for enterprise database environments.

• Monitored databases through daily/weekly health checks, object growth checks and performance monitoring.
• Refreshed database schemas using Export/Import and supported database refresh activities.
• Performed daily hot and weekly cold backups for production/non-production databases using RMAN.
• Performed restore and recovery activities using Export/Import, RMAN, cold and hot backups.
• Monitored production Oracle alert logs and investigated database errors.
• Maintained standby databases at local and remote locations for failover purposes.
• Used OEM Event and Job Managers and worked with Change Manager and Diagnostics/Tuning Packs.
• Worked on support tickets related to database incidents, access, monitoring, backup and operational requests using enterprise ticketing processes.

Database Administrator (Oracle DBA L1 & L2) - Electricity North West

(2014-03 - 2015-06)

Database administration and L1/L2 production support for production and development environments.

• Created and maintained Production and Development databases.
• Checked alert logs and trace files on a daily basis and investigated database warnings/errors.
• Performed database health checks, object-growth checks and basic performance monitoring.
• Handled user administration including user creation, roles, profiles, password management and account-lock issues.
• Performed hot and cold backups using shell scripts and RMAN.
• Troubleshot snapshot-too-old errors, user access issues and tablespace/space issues.
• Performed backup and recovery activities using Export/Import, Data Pump, cold/hot backups and RMAN.
• Worked with system administrators to resolve backup disk-space and infrastructure-related issues.
• Created/tested high-availability services for load balancing and failover scenarios.
• Configured listeners and troubleshot database connectivity issues.
• Supported database refresh activities using RMAN and prepared monthly capacity and daily health-check reports.
• Worked on incidents and service requests through ticketing workflows, documenting actions and coordinating escalations when required.

L1 Resource as Oracle DBA - Southern Water

(2012-06 - 2014-02)

L1 database support for Production and Development databases, including Oracle and SQL support activities.

• Created and supported Production and Development databases.
• Provided L1 support for SQL and Oracle database environments.
• Performed database health checks and monitored alert logs and archive destinations.
• Handled user access, account creation and account-unlock activities.
• Performed replication activities in SQL and Oracle environments.
• Configured servers in Nagios and scheduled cron jobs.
• Prepared monthly capacity reports and daily health-check reports for customer review.
• Performed proactive space monitoring and investigated backup issues.
• Handled tablespace and user-management activities.
• Performed RMAN backups including incremental, cumulative and complete backups on disk.
• Performed database/schema refreshes from Production to Preproduction, Test and Development environments.
• Moved data across databases using Export/Import and supported listener configuration/connectivity troubleshooting.
• Used ticketing processes to record incidents/requests, track progress, document resolutions and coordinate with L2/L3 teams when necessary.

M.Sc - Osmania University (2011)

B.Sc - Osmania University (2009)