Divya S (career re-starter)

Email: admxx0@r.postjobfree.com

Phn.No - +91-801*******

Summary

Total 5 Years of Information Technology experience.

* ***** ** *************** *********** and architectural experience on Oracle Database Administration, design and architecture, proficient in installation, database migration, security, upgrades, patching, backup and recovery, performance tuning on Solaris, Linux and Windows environments.

2 years as SQL Server database administrator focused on Installation, administration, database security on 2008 and 2012 on Windows server 2008/2012 R2and NT environments.

Expertise in Oracle 10g/11g/12c, Data Guard, RMAN, OEM, Precise i3, Solaris, SQL/PLSQL, DB Artisan, Data Pump, Import/export and SQL Loader.

Successfully implemented Database Upgrades from oracle 10g/11g to 12c on Solaris/Windows.

Expertise in installation of Oracle 10g/11g/12c and Oracle 12c grid Installation on Windows and Solaris environments.

Configured OEM and set Rules and Notifications for threshold values and maintenance.

Setup Physical Standby databases for maximum performance in a Data Guard environment.

Experience in Service Now and Change Management process, worked with development team creating Knowledge Articles, Catalogs, Share point Pages on Wiki.

Database Refreshes using RMAN and Net App Snapshots

Experience with RMAN backup policies, Export, Data pump, Import.

Worked with Crisis Service Management team and managed Bridge Calls, support MIR3, Service Now updates on company Dashboard pages and trouble shooting skills

Ensuring compliance related task on regulatory policies and procedures.

Applied and documented oracle patches using Opatch Utility

Highly organized and trained to work on multiple databases environments on different platforms of the work.

Part of Data center movement, Disaster recovery, business recovery testing, network maintenance activities

Strong interpersonal, time management and organizational skills with willingness and ability to prioritize multiple projects/initiatives at the same time.

Proven team player with strong ability to multitask.24x7 on-call Production support for database activities.

Technical Skills

Operating Systems Solaris, Windows NT/2000/XP/2008/2012, Red Hat Linux

ERP Oracle EBS Release 11.5.10, R12 and Discoverer 10g Plus/Viewer

Databases Oracle 10g/11g/12c, SQL Server Enterprise 2008/12, Sybase ASE 15

Tools AD utilities, Precise, SQL backtrack, RMAN, OEM, Putty, Toad, DB Artisan SQL Developer, Export, Import, DATA Pump, SQL Loader, SQL tuning advisor, Crontab, Jill checker, Grid control, CyberArk.

Skills Installation, Patching, Cloning, Performance, Backup & Troubleshooting

Languages C, SQL, PL/SQL, T-SQL and Shell Scripting

Hardware Sparc M4000/5000 T series servers, Sun Fire R 270

Storage SAN, NAS –Net Apps, VERITAS Cluster Volume.

Academic Qualifications

Master in MSITM from Campbellsville University, USA in 2020

Bachelor’s in Computer Science from VR Siddhartha Engineering College, India in 2013

Professional Experience

Intern for 6 months at Ameri Cloud Solutions Chicago, USA

Invesco Houston, TX Dec 2013-Apr 2018

Project-1 :

Position: Oracle Database Administrator

OS: Linux, Solaris, Windows

Databases: Oracle 10g,11g,12C RAC and Oracle E-Business R12.1.3

Invesco is an independent investment management firm, internally handles various projects and assists in the coordination of assigned projects for the maintenance, development and as DBA, responsible for implementation of database management systems and operating systems in assigned areas. Worked on over 120 Production and non-production databases spread across the HKG, US & UK.

Key Responsibilities handled:

Oracle Database support 24/7 ON-CALL Production support for NA, UK and APAC regions and ensuring minimum downtime.

Set up of New production server’s and database upgrades from Oracle 10.2.0.3 to 11.2.0.4 and to 12.1.0.2 on Solaris and Windows environment.

SQL Server 2008/12 Installation and server setup, User Administration, security, Database refreshes, monitoring jobs, Clearing Transaction log, performance and maintenance.

Installation, Configuration, Designing and Maintaining of Oracle 11g/12c grid databases on Solaris 11 and Windows 2008 and 2012 Versions.

Implemented High Availability on single and multiple node RAC for Prod and DR instances and configured Physical Standby database (Data Guard)

Build OEM12c Cloud Control to configure and monitor 200 targets on Dev, Test and Production.

Configured Physical Standby Databases for Business Recovery on windows 2008 R2 for critical applications.

Accountable for ensuring the smooth operation of all business applications and Secures database by developing policies, procedures, and controls.

Implemented backup policy for the Enterprise databases as per business/compliance needs.

Automated and scheduled RMAN backups for all databases using Autosys Scheduler Monitoring.

Database Refresh for UAT/Test/Dev from production databases on a regular basis using RMAN duplicate database and snapshot (NetApp) Technology.

Monitored Production Database using Oracle OEM and Precise I3. Configured New Agents and adding databases and enabling blackouts of servers/databases.

Monitor, prioritize and resolve incidents and change requests via Service Now.

Experience with Fixed Income, Portia, Eagle and Charles River vendor applications.

Involved in Performance Tuning, using SQL Profile baselines and AWR reports. Proactive monitoring, locks, blocked sessions, memory and collaborate with Unix/Storage and Server.

Operations team to troubleshoot on NAS filer(NetApp) and memory issues, IO, bottleneck elimination and the wait event interface to identify issues on Unix and windows servers.

Collaborate with development, testing and integration teams to diagnose database related application problems and help to resolve issues in a timely manner.

Diagnosed Oracle bugs and coordinated with Oracle support through Metal ink and applied PSU Patches as advised.

Participate in all Business Recovery process for NA, UK and APAC locations.

Worked with Patch Management team on creating binaries for Oracle 10g /11g/12c.

Created Profiles and implemented user security policy, advanced security and Audit Vault.

Planning & Implementation of Oracle CPU and PSU patches using Opatch utility, in various environments of all regions.

Resolving dataguard DR site sync issues, data Guard Implementation on ASM File System, customizing autoconfig templates according to the environment requirements

Mentored junior Oracle DBA’s and documenting all duties performed.

Followed and established IT / DBA policies and procedures for database security and documented and updated on wiki pages, share point.

Involved in performance tuning of database and various queries using EXPLAIN PLAN and TKPROF.

Gathered statistics for database performance using STATSPACK.

Loading external files using SQL LOADER.

Export and Import of database and Schemas and users

Rewrite and implement backup strategy following company SLA; execution of backup schedule for both physical and logical backups using RMAN and DATAPUMP utilities respectively.

Deploy Database security policy and installation, using passwords, privileges and user profiles, Use Oracle Transparent Data Encryption to encrypt columns, tables and Tablespaces

Manage database security by creating, assigning appropriate roles & privileges to users depending on user activity, auditing, & performing other security related tasks including Transparent Data Encryption.

Clone databases using RMAN and DATAPUMP utilities for all database sizes.

Extensively using AWR, ADDM, ASH, and Explain plan for periodic Performance tuning.

Perform database Refresh from production environments.

Implementing table and index partitioning to Minimize DB time, increase disk load balancing improving query speed and enable faster parallel query.

Strong time management skills with willingness and ability to prioritize multiple projects/initiatives at the same time.

Performing data Clean-up/System/ Requirement Analysis and Audit Support

Providing enterprise preventive database maintenance

Providing preventative and proactive database disk management on usage, sizing, and performance

Environment: Solaris, Oracle 10g/11i/12c, SQL Server2008/12. RAC, Data Guard, Linux 7.X, Toad, SQL*Loader, PL/SQL, OEM, Net backup, Middleware – WebLogic

As level-1 Oracle Apps DBA:

Having Knowledge and understanding on Apps concepts.

Worked on administering Concurrent managers for Application databases, OMS patches to Oracle management service home, application patches on Application software/homes and fixing bugs using Adpatch, Opatch utilities.

Apache bounce along with form server’s basic administration.

Performing Health checkups to the Oracle Applications & Databases.

Level-1 troubleshooting Apache and Concurrent manager issues and after patching and Autoconfigurations

Project 2:

Position: MSSQL Database Administrator

OS: Windows

Servers: windows server 2003/2008/2008 R2/2012

Tools: SQL server management studio

Responsibilities handled:

2 years of Experience on MSSQL servers Installation and Configuration in different versions like SQL Server 2005 and 2008 and 2008R2 and 2012.

Troubleshooting and Resolving the Disk space, blocking issues, CPU, memory, I/O disk issue, performance monitoring.

Creating and Administering the SQL Server Databases like data and log file placements and managing the growth parameters and database options, databases migration from SQL2008 to SQL2012

Good Knowledge in implementing SQL Server security and Object permissions like maintaining creation of users, configuring permissions, and assigning roles to users.

Establishing weekly, monthly maintenance plans, Rebuilding indexes, Update statistics to run the databases efficiently.

Good knowledge in using Activity Monitor, Performance Monitor, tracing long running queries and deadlocks.

Configuring database roles, application roles, contained users, database level and object level permissions, handling security issues, Server level triggers, audits, linked servers, server roles, logins and handling security issues and resolving orphan uses

Creating and migrating jobs, alerts, operators, credentials, proxy from one instance to another instance

Upgrading SSIS packages from 2008 to 2012 using upgrade wizard and SQL Server data tools and deploying SSIS Packages in SSISDB using SQL Server data tools

Monitoring the jobs, system resources, troubleshooting issues like blockings, deadlocks, performance tuning, query tuning, SIS package tuning, execution plans and system resources using Activity monitor and troubleshooting long running jobs.

Monitors day to day operations and overall performance of SQL server environment and systems. Manages the environment using tools such as SSMS, Microsoft SQL Backup, Commvault and SCOM

Install, configure and support SQL Server environment including SSRS, SSIS, SSAS, Replication and AlwaysOn HA.

Work closely with other DBAs, Infrastructure team, application development team, business analysts and IT vendors to ensure high availability and proper functioning of databases.

Experience in Performance Tuning and Optimization using native monitoring and monitoring tools.

Experience in Upgrade/migration of new releases from Development to QA, UAT and Production including inbuilt custom and vendor applications with standard procedures.

Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools

Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server

Experience working with Windows server, including Active Directory

Contact this candidate